zhengcaioa.git - Gitblit

			@@ -27,6 +27,16 @@
			ResultEntity resultEntity = new ResultEntity();
			try
			{
			var checkUserSn = _context.Projects.Where(x => x.Name == projectDTO.Name && x.RecStatus == "A" && x.Id != projectDTO.Id).FirstOrDefault();
			if (checkUserSn != null && (string.IsNullOrWhiteSpace(projectDTO.Id) \|\| (!string.IsNullOrWhiteSpace(projectDTO.Id) && checkUserSn.Id != projectDTO.Id)))
			{
			resultEntity.Result = false;
			resultEntity.Message = "项目重复";
			return resultEntity;
			}



			var project = _mapper.Map<Project>(projectDTO);
			// var ZhuanjiaList = projectDTO.ZhuanjiaList;
			//if(ZhuanjiaList!=null&& ZhuanjiaList.Length > 0)
			@@ -54,6 +64,9 @@
			updateproject.Name = project.Name;
			updateproject.Drhx = project.Drhx;
			updateproject.DrhxPrice = project.DrhxPrice;
			updateproject.DrhxDefen = project.DrhxDefen;
			updateproject.DshxDefen = project.DshxDefen;
			updateproject.Dshx = project.Dshx;
			updateproject.Dshx = project.Dshx;
			updateproject.DshxPrice = project.DshxPrice;
			updateproject.Zhuanjia = project.Zhuanjia;
			@@ -178,6 +191,7 @@
			}
			projectzhongbiao.Names = projectDTO.Names[i];
			projectzhongbiao.Price = projectDTO.Price[i];
			projectzhongbiao.Defen = projectDTO.Defen[i];
			projectzhongbiao.ProjectId = project.Id;
			_context.Projectzhongbiaos.Add(projectzhongbiao);
			}
			@@ -217,7 +231,9 @@


			var projectDTO = _mapper.Map<ProjectDTO>(entity);
			if(projectreasons!=null && projectreasons.Count>0)
			projectDTO.DrhxDefenName = projectDTO.DrhxDefen.HasValue ? projectDTO.DrhxDefen.Value.ToString("F2") : "";
			projectDTO.DshxDefenName = projectDTO.DshxDefen.HasValue ? projectDTO.DshxDefen.Value.ToString("F2") : "";
			if (projectreasons!=null && projectreasons.Count>0)
			{
			projectDTO.projectreasons = projectreasons;
			}
			@@ -241,12 +257,26 @@

			if (Projectzhongbiaos != null && Projectzhongbiaos.Count > 0)
			{
			projectDTO.Projectzhongbiaos = Projectzhongbiaos;
			List<ProjectzhongbiaoDTO> projectzhongbiaoDTOs = new List<ProjectzhongbiaoDTO>();
			foreach(var projectzhongbiao in Projectzhongbiaos)
			{
			ProjectzhongbiaoDTO projectzhongbiaoDTO = new ProjectzhongbiaoDTO();
			projectzhongbiaoDTO.DefenName = projectzhongbiao.Defen.HasValue ? projectzhongbiao.Defen.Value.ToString("F2") : "";

			projectzhongbiaoDTO.ZhongbiaoId = projectzhongbiao.ZhongbiaoId;
			projectzhongbiaoDTO.ProjectId = projectzhongbiao.ProjectId;
			projectzhongbiaoDTO.Names = projectzhongbiao.Names;
			projectzhongbiaoDTO.Price = projectzhongbiao.Price;
			projectzhongbiaoDTO.Defen = projectzhongbiao.Defen;

			projectzhongbiaoDTOs.Add(projectzhongbiaoDTO);
			}
			projectDTO.Projectzhongbiaos = projectzhongbiaoDTOs;
			}
			else
			{
			var Projectzhongbiaoslist = new List<Projectzhongbiao>();
			Projectzhongbiaoslist.Add(new Projectzhongbiao());
			var Projectzhongbiaoslist = new List<ProjectzhongbiaoDTO>();
			Projectzhongbiaoslist.Add(new ProjectzhongbiaoDTO());
			projectDTO.Projectzhongbiaos = Projectzhongbiaoslist;
			}

			@@ -262,7 +292,7 @@
			List<ProjectDTO> list = new List<ProjectDTO>();
			//筛选
			StringBuilder sql = new StringBuilder();
			sql.Append("SELECT distinct a.[Id],a.[start_time] ,b.[name] +'-'+c.[name]+'-'+d.[name] Sheng ,a.city ,a.[area_id],a.cgfs, a.[name] ,a.[number],a.creater,a.createtime,a.modifier,a.modifytime ,a.[drhx],a.[drhx_price],a.[dshx],a.[dshx_price],a.[remark],a.[rec_status],a.[toubiaocishu] ,a.[question] ,a.[zhongbiaocishu],a.[feibiaocishu],a.[zhongbiaojine],a.[Fblx],a.[Fbyy] , a.[zhuanjia] , a.[caigourenname], a.[caigourenaddress], a.[caigourencontact], a.[dailiname], a.[dailiaddress], a.[dailicontact] "); //zhuanjia = stuff((select ','+name from [Zhuanjia] f where CHARINDEX(f.id,a.[zhuanjia]) >0 for xml path('')), 1,1, '')
			sql.Append("SELECT distinct a.[Id],a.[start_time],a.[drhx_defen],a.[dshx_defen] ,b.[name] +'-'+c.[name]+'-'+d.[name] Sheng ,a.city ,a.[area_id],a.cgfs, a.[name] ,a.[number],a.creater,a.createtime,a.modifier,a.modifytime ,a.[drhx],a.[drhx_price],a.[dshx],a.[dshx_price],a.[remark],a.[rec_status] ,a.[question] ,a.[zhongbiaocishu],a.[feibiaocishu],a.[zhongbiaojine],a.[Fblx],a.[Fbyy] , a.[zhuanjia] , a.[caigourenname], a.[caigourenaddress], a.[caigourencontact], a.[dailiname], a.[dailiaddress], a.[dailicontact] ,toubiaocishu = stuff((select '、'+ f.[names] from [Projectzhongbiao] f where f.[ProjectId] = a.[Id] for xml path('')), 1,1, '') "); //zhuanjia = stuff((select ','+name from [Zhuanjia] f where CHARINDEX(f.id,a.[zhuanjia]) >0 for xml path('')), 1,1, '')
			sql.Append("FROM [Project] a ");
			sql.Append("left join [Area] b on a.[sheng] = b.[codeID] ");
			sql.Append("left join [Area] c on a.[city] = c.[codeID] ");
			@@ -276,16 +306,92 @@

			}

			if (!string.IsNullOrWhiteSpace(searchEntity.StartTimestar))
			if (!string.IsNullOrWhiteSpace(searchEntity.NamesToubiao))
			{
			sql.Append(" and a.start_time >='"+ searchEntity.StartTimestar.Trim().Replace("'","''") + "'");

			}
			if (!string.IsNullOrWhiteSpace(searchEntity.StartTimeend))
			{
			sql.Append(" and a.start_time <='" + DateTime.Parse(searchEntity.StartTimeend.Trim().Replace("'", "''")).AddDays(1).ToString("yyyy-MM-dd") + "'"); ;
			sql.Append(" and ( exists (select b.[ProjectId] from [Projectzhongbiao] b where a.[Id]=b.[ProjectId] and b.[names] like '%" + searchEntity.NamesToubiao + "%') ");

			sql.Append(" or exists (select c.[ProjectId] from [Projectreason] c where a.[Id]=c.[ProjectId] and c.[reasonname] like '%" + searchEntity.NamesToubiao + "%') ");

			sql.Append(" or exists (select d.[ProjectId] from [Projectyouxiao] d where a.[Id]=d.[ProjectId] and d.[namesyouxiao] like '%" + searchEntity.NamesToubiao + "%') ");

			sql.Append(" or a.[drhx] like '%" + searchEntity.NamesToubiao + "%' ");

			sql.Append(" or a.[dshx] like '%" + searchEntity.NamesToubiao + "%' ");

			sql.Append(" )");

			}
			if (!string.IsNullOrWhiteSpace(searchEntity.Fencha))
			{
			decimal aaaa = 0;
			decimal.TryParse(searchEntity.Fencha, out aaaa);
			if (aaaa > 0)
			{
			sql.Append(" and exists ( select b.[ProjectId] from [Projectzhongbiao] b where a.[Id]=b.[ProjectId] and (b.[defen]-a.[drhx_defen]) <= " + aaaa + " ) ");
			}
			}

			if (!string.IsNullOrWhiteSpace(searchEntity.Reasonname))
			{
			sql.Append(" and exists (select b.[ProjectId] from [Projectreason] b where a.[Id]=b.[ProjectId] and b.[reasonname] like '%" + searchEntity.Reasonname + "%') ");

			}

			if (!string.IsNullOrWhiteSpace(searchEntity.ShiFouyReasonname))
			{
			if (searchEntity.ShiFouyReasonname == "A")
			{
			sql.Append(" and exists (select b.[ProjectId] from [Projectreason] b where a.[Id]=b.[ProjectId] ) ");

			}
			else
			{
			sql.Append(" and not exists (select b.[ProjectId] from [Projectreason] b where a.[Id]=b.[ProjectId] ) ");
			}


			}


			if (!string.IsNullOrWhiteSpace(searchEntity.fblx))
			{
			if (searchEntity.fblx == "A")
			{
			sql.Append(" and a.fblx is not null ");
			}
			else
			{
			sql.Append(" and a.fblx is null ");
			}


			}

			DateTime StartTimestarstart = DateTime.Now;
			DateTime StartTimestarend = DateTime.Now;
			if (!string.IsNullOrWhiteSpace(searchEntity.StartTimestar))
			{
			string[] StartTimestars = searchEntity.StartTimestar.Split("\|");
			DateTime.TryParse(StartTimestars[0], out StartTimestarstart);
			DateTime.TryParse(StartTimestars[1], out StartTimestarend);
			//Createtimeend = Createtimeend.AddDays(1);
			}


			if (!string.IsNullOrWhiteSpace(searchEntity.StartTimestar))
			{
			sql.Append(" and a.start_time >='" + StartTimestarstart.ToString("yyyy-MM-dd") + "'");

			}
			if (!string.IsNullOrWhiteSpace(searchEntity.StartTimestar))
			{
			sql.Append(" and a.start_time <='" + StartTimestarend.AddDays(1).ToString("yyyy-MM-dd") + "'");

			}





			if (!string.IsNullOrWhiteSpace(searchEntity.Sheng))
			{