zhengcaioa.git - Gitblit

			@@ -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;
			}


			@@ -962,6 +964,28 @@
			}


			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();
			@@ -1177,6 +1201,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 +1312,13 @@

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


			updateproject.Status = entity.Status;










			updateproject.Modifier = entity.Modifier;
			@@ -1285,6 +1349,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;
			}
			@@ -1710,13 +1850,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 +1905,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 +1940,50 @@
			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;
			}
			}
			}