提交

username@email.com

2021-12-09 d14b82fec13361486c49165371b5dee1b7089c09

 zhengcaioa/Services/CooperOrderService.cs

@@ -930,6 +930,34 @@
            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;
        }

@@ -978,7 +1006,7 @@
                    updateproject.RequestInfo = entity.RequestInfo;

                    updateproject.IsReply = entity.IsReply;
                
                    updateproject.Status = entity.Status; 

                    updateproject.Respondent = entity.Respondent;
                    updateproject.RespondDate = entity.RespondDate;
@@ -1012,6 +1040,84 @@


            var result = _mapper.Map<List<TChallengeItemDTO>>(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 challengeItemDTO in result)
            {
                var codeDataEntity = question.Where(x => x.CodeSn == challengeItemDTO.Question).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    challengeItemDTO.QuestionName = codeDataEntity.Comments;
                }

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

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


            return result;
@@ -1071,6 +1177,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;
        }
@@ -1143,12 +1288,13 @@

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

                   
                    updateproject.Status = entity.Status;


                  
                   






                    updateproject.Modifier = entity.Modifier;
@@ -1179,6 +1325,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;
        }
@@ -1568,6 +1790,13 @@
                         into lsss
                          from lll in lsss.DefaultIfEmpty()


                      //    join d in listCode.Where(x => x.CodeTable == "t_challengeletter" && x.CodeField == "status")
                      //on b.Status equals int.Parse(d.CodeSn)
                      //into dsss
                      //    from ddd in dsss.DefaultIfEmpty()


                          where a.RecStatus == "A" && a.OrderType1 == "代拟质疑函"
                          && (string.IsNullOrWhiteSpace(searchEntity.XdTime) || (b.Createtime >= XdTimestart && b.Createtime <= XdTimeend))
                            && (string.IsNullOrWhiteSpace(searchEntity.Wenshuleixing) || a.OrderType1 == searchEntity.Wenshuleixing.Trim())
@@ -1596,12 +1825,15 @@
                              YishouMoney = lll.YishouMoney ?? 0,
                              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


@@ -1648,11 +1880,13 @@
                           YishouMoney = lll.YishouMoney ?? 0,
                           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();


        
@@ -1670,6 +1904,15 @@
            //if (searchEntity.totalrows == 0)
            searchEntity.totalrows = query.Count();
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            foreach (var cooperOrderDTO in lianlist)
            {
              var  codeDataEntity  =  listCode.Where(x => x.CodeTable == "t_challengeletter" && x.CodeField == "status" && x.CodeSn == cooperOrderDTO.Status.ToString()).FirstOrDefault();
                if (codeDataEntity != null) {
                    cooperOrderDTO.StatusName = codeDataEntity.Comments;
                }
            }


            data.LoadData(searchEntity, lianlist);
            return data;
        }