提交

username@email.com

2022-08-27 6e2b929cf381e2320ba6e7dec56c0371124d2b51

 zhengcaioa/Services/CooperOrderService.cs

@@ -14,11 +14,13 @@
   public class CooperOrderService: ICooperOrderService
    {
        private readonly zhengcaioaContext _context;
        private readonly zcUserInfoN_dbContext _zcUserInfoN_dbContext;
        private readonly IMapper _mapper;
        public CooperOrderService(zhengcaioaContext context, IMapper mapper)
        public CooperOrderService(zhengcaioaContext context, IMapper mapper, zcUserInfoN_dbContext zcUserInfoN_dbContext)
        {
            _context = context;
            _mapper = mapper;
            _zcUserInfoN_dbContext = zcUserInfoN_dbContext;
        }


@@ -88,6 +90,9 @@
                    updateproject.SonghuoTime1 = entity.SonghuoTime1;
                    updateproject.HuifangJdr = entity.HuifangJdr;
                    updateproject.HuifangKehuyijian = entity.HuifangKehuyijian;
                    updateproject.Xmname = entity.Xmname;
                    updateproject.Xmcode = entity.Xmcode;
                    updateproject.Jichumoney = entity.Jichumoney;

                }

@@ -240,6 +245,11 @@
                   into msssss
                         from mmm in msssss.DefaultIfEmpty()

                         join n in _context.PltUsers
                on a.Creater equals n.Id
                into nsssss
                         from nnn in nsssss.DefaultIfEmpty()

                         where a.RecStatus == "A"
                          && (string.IsNullOrWhiteSpace(searchEntity.XdTime) || (a.XdTime >= XdTimestart && a.XdTime <= XdTimeend))
                                    && (string.IsNullOrWhiteSpace(searchEntity.Ywjl) || ggg.Ywjl == searchEntity.Ywjl.Trim())
@@ -284,7 +294,8 @@
                             Remark = a.Remark,

                             Creater = a.Creater,
                             Createtime = a.Createtime,
            CreaterName = nnn.UserName,
            Createtime = a.Createtime,

                             RecStatus = a.RecStatus,
                             Modifier = a.Modifier,
@@ -336,7 +347,15 @@

            //if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            data.Heji1 = Math.Round(query.Sum(x => x.OrderNum) ?? 0, 2);
            data.Heji2 = Math.Round(query.Sum(x => x.Price) ?? 0, 2);
            data.Heji3 = Math.Round(query.Sum(x => x.Money) ?? 0, 2);
            data.Heji4 = Math.Round(query.Sum(x => x.Youhui) ?? 0, 2);
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            data.DangyeHeji1 = Math.Round(lianlist.Sum(x => x.OrderNum) ?? 0, 2);
            data.DangyeHeji2 = Math.Round(lianlist.Sum(x => x.Price) ?? 0, 2);
            data.DangyeHeji3 = Math.Round(lianlist.Sum(x => x.Money) ?? 0, 2);
            data.DangyeHeji4 = Math.Round(lianlist.Sum(x => x.Youhui) ?? 0, 2);
            data.LoadData(searchEntity, lianlist);
            return data;
        }
@@ -962,6 +981,75 @@
        }


        public List<TChallengeletterDTO> GetListChallengelettertousu(string customid, string XmCode)
        {

            var entity = (from a in _context.CooperOrders.Where(x=>x.OrderType1== "代拟质疑函" && x.RecStatus == "A" && x.Khdw == customid)
                          join b in _context.TChallengeletters.Where(x=>x.XmCode == XmCode) on a.Id equals b.OrderId 
                          select b ).ToList();


            //_context.TChallengeletters.Where(x =>/* x.Status == 1 && */x.OrderId == OrderId).ToList();



            var result = _mapper.Map<List<TChallengeletterDTO>>(entity);


            var listCode = (from a in _context.SysCodeDtls
                            join b in _context.SysCodes
                            on a.CodeId equals b.Id
                            where a.RecStatus == "A"
                                          && b.RecStatus == "A"
                            select new CodeDataEntity()
                            {
                                CodeId = b.Id,
                                CodeTable = b.CodeTable,
                                CodeField = b.CodeField,
                                CodeSn = a.CodeSn,
                                Comments = a.Comments,
                                Contents = a.Contents,
                                RecStatus = a.RecStatus,
                                Sort = a.Sort
                            }
                   ).Where(x => x.CodeTable == "t_challengeletter" && x.CodeField == "request_info").ToList();
            foreach (var challengeletterDTO in result)
            {
                var codeDataEntity = listCode.Where(x => x.CodeSn == challengeletterDTO.RequestInfo).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    challengeletterDTO.RequestInfoName = codeDataEntity.Comments;
                }

            }


            return result;
        }


        public List<TChallengeletterDTO> GetListChallengeletterChosen()
        {
            var query = (from a in _context.TChallengeletters
                         join b in _context.CooperOrders.Where(x => x.RecStatus == "A")
                         on a.OrderId equals b.Id

                         select new TChallengeletterDTO
                         {
                             Id = b.Id,
                             OrderId  = b.OrderNo,
                             khid = b.Khdw,
                             Createtime = b.Createtime,
                         }
                         ).OrderByDescending(x=>x.Createtime).ToList();


            

            return query;
        }


        public ResultEntity saveChallengeletter(TChallengeletterDTO dto)
        {
            ResultEntity resultEntity = new ResultEntity();
@@ -1151,6 +1239,7 @@
                    updateproject.Law = entity.Law;
                    updateproject.Sort = entity.Sort;
                    updateproject.Lawcoment = entity.Lawcoment;
                    updateproject.Questionname = entity.Questionname;

                }

@@ -1177,6 +1266,45 @@

            var result = _mapper.Map<List<TComplaintletterDTO>>(entity);

            var listCode = (from a in _context.SysCodeDtls
                            join b in _context.SysCodes
                            on a.CodeId equals b.Id
                            where a.RecStatus == "A"
                                          && b.RecStatus == "A"
                            select new CodeDataEntity()
                            {
                                CodeId = b.Id,
                                CodeTable = b.CodeTable,
                                CodeField = b.CodeField,
                                CodeSn = a.CodeSn,
                                Comments = a.Comments,
                                Contents = a.Contents,
                                RecStatus = a.RecStatus,
                                Sort = a.Sort
                            }
                   ).ToList();

            var request_info = listCode.Where(x => x.CodeTable == "t_challengeletter" && x.CodeField == "request_info").ToList();
            var shifou = listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou").ToList();
            foreach (var complaintletterDTO in result)
            {
                var codeDataEntity = request_info.Where(x => x.CodeSn == complaintletterDTO.RequestInfo).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    complaintletterDTO.RequestInfoName = codeDataEntity.Comments;
                }

                codeDataEntity = shifou.Where(x => x.CodeSn == complaintletterDTO.IsNotice).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    complaintletterDTO.IsNoticeName = codeDataEntity.Comments;
                }
                codeDataEntity = shifou.Where(x => x.CodeSn == complaintletterDTO.IsResultnotice).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    complaintletterDTO.IsResultnoticeName = codeDataEntity.Comments;
                }
            }

            return result;
        }
@@ -1249,12 +1377,13 @@

                    updateproject.DocumentsDate = entity.DocumentsDate;
                    updateproject.RequestInfo = entity.RequestInfo;

                   
                    updateproject.Status = entity.Status;


                  
                   






                    updateproject.Modifier = entity.Modifier;
@@ -1285,6 +1414,82 @@

            var result = _mapper.Map<List<TComplaintItemDTO>>(entity);

            var question = (from a in _context.SysCodeDtls
                            join b in _context.SysCodes
                            on a.CodeId equals b.Id
                            where a.RecStatus == "A"
                                          && b.RecStatus == "A"
                            select new CodeDataEntity()
                            {
                                CodeId = b.Id,
                                CodeTable = b.CodeTable,
                                CodeField = b.CodeField,
                                CodeSn = a.CodeSn,
                                Comments = a.Comments,
                                Contents = a.Contents,
                                RecStatus = a.RecStatus,
                                Sort = a.Sort
                            }
                 ).Where(x => x.CodeTable == "t_challenge_items" && x.CodeField == "question").ToList();


            var law = (from a in _context.SysCodeDtls
                       join b in _context.SysCodes
                       on a.CodeId equals b.Id
                       where a.RecStatus == "A"
                                     && b.RecStatus == "A"
                       select new CodeDataEntity()
                       {
                           CodeId = b.Id,
                           CodeTable = b.CodeTable,
                           CodeField = b.CodeField,
                           CodeSn = a.CodeSn,
                           Comments = a.Comments,
                           Contents = a.Contents,
                           RecStatus = a.RecStatus,
                           Sort = a.Sort
                       }
                 ).Where(x => x.CodeTable == "t_complaint_items" && x.CodeField == "law").ToList();

            var falv = (from a in _context.SysCodeDtls
                        join b in _context.SysCodes
                        on a.CodeId equals b.Id
                        where a.RecStatus == "A"
                                      && b.RecStatus == "A"
                        select new CodeDataEntity()
                        {
                            CodeId = b.Id,
                            CodeTable = b.CodeTable,
                            CodeField = b.CodeField,
                            CodeSn = a.CodeSn,
                            Comments = a.Comments,
                            Contents = a.Contents,
                            RecStatus = a.RecStatus,
                            Sort = a.Sort
                        }
               ).Where(x => x.CodeTable == "expert_test_topicjiexi" && x.CodeField == "falv").ToList();

            foreach (var complaintItemDTO in result)
            {
                var codeDataEntity = question.Where(x => x.CodeSn == complaintItemDTO.Question).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    complaintItemDTO.QuestionName = codeDataEntity.Comments;
                }

                codeDataEntity = law.Where(x => x.CodeSn == complaintItemDTO.Law).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    complaintItemDTO.LawName = codeDataEntity.Comments;
                    complaintItemDTO.Lawcoment = codeDataEntity.Contents;

                    codeDataEntity = falv.Where(x => x.CodeSn == complaintItemDTO.LawName).FirstOrDefault();
                    if (codeDataEntity != null)
                    {
                        complaintItemDTO.LawName = codeDataEntity.Comments;
                    }
                }
            }

            return result;
        }
@@ -1317,7 +1522,7 @@
                    updateproject.Law = entity.Law;
                    updateproject.Sort = entity.Sort;
                    updateproject.Lawcoment = entity.Lawcoment;

                    updateproject.Questionname = entity.Questionname;

                }

@@ -1710,13 +1915,14 @@
                              WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney ?? 0),
                              OrderType1 = a.OrderType1,
                              Status = b.Status.ToString(),
                              Modifytime = b.Modifytime.Value,
                              //StatusName = ddd.Comments
                          }
                ).ToList();


               var query1 =(from a in _context.CooperOrders
                       join b in _context.TComplaintletters.Where(x => x.Status == 1)
                       join b in _context.TComplaintletters
                       on a.Id equals b.OrderId


@@ -1764,11 +1970,12 @@
                           WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney ?? 0),
                           OrderType1 = a.OrderType1,
                           Status = b.Status.ToString(),
                           Modifytime = b.Modifytime.Value,
                       }
                ).ToList();

            query2.AddRange(query1);
            var query = query2.Where(x => x.WeishouMoney <= 0).OrderByDescending(x => x.Createtime).ToList();
            var query = query2.Where(x => x.WeishouMoney <= 0).OrderByDescending(x => x.Modifytime).ToList();


        
@@ -1798,5 +2005,160 @@
            data.LoadData(searchEntity, lianlist);
            return data;
        }




        public List<CooperOrderDTO> GetListComplaintsDisputeCount(string huiyuanid)
        {
            var query = (from a in _zcUserInfoN_dbContext.UsergGadeRoles
                         join b in _zcUserInfoN_dbContext.GadeRoles
                         on a.UserGadeRolesId equals b.Id
                         where a.UserId == Guid.Parse(huiyuanid)
                         select new CooperOrderDTO
                         {
                             Id = a.UserId.ToString(),
                             AnswerRoles = b.AnswerRoles,
                             XiaocaiKeTang = b.XiaocaiKeTang,
                             XiaoCaiQandA = b.XiaoCaiQandA,
                             Discount = b.Discount,
                             BiddingDocumentsCount = b.BiddingDocumentsCount,
                             ComplaintsDisputeCount = b.ComplaintsDisputeCount,
                             PerformanceDisputeCount = b.PerformanceDisputeCount,
                             BiddingDocumentsCountused = a.BiddingDocumentsCount,
                             ComplaintsDisputeCountused = a.ComplaintsDisputeCount,
                             PerformanceDisputeCountused = a.PerformanceDisputeCount, 

                         }
                         ).ToList();




            return query;
        }


        public FrameworkUser GetFrameworkUsers(string ID)
        {
             


            var entity = _zcUserInfoN_dbContext.FrameworkUsers.Find(new Guid(ID));

           

            return entity;
        }


        public List<TChallengeRequestInfoDTO> GetListChallengeRequestInfo(string ChallengeId)
        {

            var entity = _context.TChallengeRequestInfos.Where(x => x.ChallengeId == ChallengeId).OrderBy(x => x.Id).ToList();



            var result = _mapper.Map<List<TChallengeRequestInfoDTO>>(entity);


            var request_info = (from a in _context.SysCodeDtls
                            join b in _context.SysCodes
                            on a.CodeId equals b.Id
                            where a.RecStatus == "A"
                                          && b.RecStatus == "A"
                            select new CodeDataEntity()
                            {
                                CodeId = b.Id,
                                CodeTable = b.CodeTable,
                                CodeField = b.CodeField,
                                CodeSn = a.CodeSn,
                                Comments = a.Comments,
                                Contents = a.Contents,
                                RecStatus = a.RecStatus,
                                Sort = a.Sort
                            }
                   ).Where(x => x.CodeTable == "t_challengeletter" && x.CodeField == "request_info").ToList();


           

            foreach (var challengeItemDTO in result)
            {
                var codeDataEntity = request_info.Where(x => x.CodeSn == challengeItemDTO.RequestInfo).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    challengeItemDTO.RequestInfoNameName = codeDataEntity.Comments;
                }

              
            }


            return result;
        }


        public ResultEntity saveChallengeRequestInfo(TChallengeRequestInfoDTO dto)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {


                var entity = _mapper.Map<TChallengeRequestInfo>(dto);


                if (entity.Id <= 0)
                {


                    _context.TChallengeRequestInfos.Add(entity);
                }
                else
                {
                    var updateproject = _context.TChallengeRequestInfos.Find(entity.Id);


                    updateproject.ChallengeId = entity.ChallengeId;
                    updateproject.RequestInfo = entity.RequestInfo;
                    updateproject.RequestInfoname = entity.RequestInfoname;
                    

                }

                _context.SaveChanges();
                resultEntity.ReturnID = entity.Id.ToString();
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";

            }
            return resultEntity;
        }


        /// <summary>
        /// 删除质疑函子表
        /// </summary>
        /// <returns></returns>
        public ResultEntity deleteChallengeRequestInfo(string ChallengeId)
        {
            ResultEntity result = new ResultEntity();
            result.Result = true;

            var models = _context.TChallengeRequestInfos.Where(x => x.ChallengeId == ChallengeId).ToList(); ;

            foreach (var challengeItem in models)
            {
                _context.TChallengeRequestInfos.Remove(challengeItem);
            }
            _context.SaveChanges();
            return result;
        }

    }
}