DocumentService.git

			@@ -2,6 +2,7 @@
			using DocumentServiceAPI.Application.ProjectInfo.ViewMode;
			using DocumentServiceAPI.Application.Repository;
			using DocumentServiceAPI.Model.cyDocumentModel;
			using DocumentServiceAPI.Model.Permissions;
			using DocumentServiceAPI.Model.UserInfoModel;
			using DocumentServiceAPI.Utility;
			using MapsterMapper;
			@@ -137,6 +138,18 @@
			}
			else
			{
			var aaa = GetJwtInfo();
			var tenantPermissions = _db.Queryable<TenantPermissions>().Where(x => x.IsDel == false && x.IsEn == true && x.TenantId == aaa.TEID.Value && x.PermissionsType == TenantPermissionsType.Manage).First();
			if (tenantPermissions != null)
			{
			var times = _db.Queryable<Document_TenderUnit>().Count(x => x.IsDeled == false && x.IsEn == true && x.TenantId == aaa.TEID.Value);
			if (tenantPermissions.UnitMaxCount > 0 && tenantPermissions.UnitMaxCount <= times)
			{
			throw new Exception("投标单位数量超出最大值！无法新增");
			}
			}
			dp.IsEn = true;
			dp.IsDeled = false;
			_db.Insertable<Document_TenderUnit>(dp).ExecuteCommand();
			}

			@@ -281,7 +294,15 @@
			{
			var aaa = GetJwtInfo();


			var tenantPermissions = _db.Queryable<TenantPermissions>().Where(x => x.IsDel == false && x.IsEn == true && x.TenantId == aaa.TEID.Value && x.PermissionsType == TenantPermissionsType.Manage).First();
			if (tenantPermissions != null)
			{
			var times = _db.Queryable<EmployeeAtTenant>().Count(x => x.IsDel == false && x.IsEn == true && x.TenantID == aaa.TEID.Value );
			if(tenantPermissions.EmployeeMaxCount>0 && tenantPermissions.EmployeeMaxCount<= times)
			{
			throw new Exception("员工数量超出最大值！无法新增");
			}
			}

			dp.EmployeeId = _db.Insertable<Document_EmployeeInfo>(document_EmployeeInfo).ExecuteReturnIdentity();

			@@ -609,5 +630,338 @@
			return jwtInfo;
			}


			public PageResult<DocumentProjectInfoDTO> postGetFinancialList(DocumentProjectInfoPageSearch page)
			{
			var aaa = GetJwtInfo();

			SqlSugar.PageModel pg = new SqlSugar.PageModel();
			pg.PageSize = page.PageSize;
			pg.PageIndex = page.PageIndex;
			//page.ToEmployeeId = a.EID;
			int total = 0;
			PageResult<DocumentProjectInfoDTO> result = new PageResult<DocumentProjectInfoDTO>();



			result.Items = _db.Queryable<Document_ProjectInfo, Document_ProjectExpand>((a, d) =>
			new JoinQueryInfos
			(
			JoinType.Left, a.ProjectId == d.ProjectId && d.UnitId == page.UnitId

			))
			.Where((a, d) => a.TenantID == aaa.TEID)
			//省
			.WhereIF(!string.IsNullOrEmpty(page.Province) && page.Province != "请选择", (a, d) => (a.Province == page.Province))
			//市
			.WhereIF(!string.IsNullOrEmpty(page.City) && page.City != "请选择", (a, d) => (a.City == page.City))
			//区县
			.WhereIF(!string.IsNullOrEmpty(page.County) && page.County != "请选择", (a, d) => (a.County == page.County))
			//报名时间
			.WhereIF(!string.IsNullOrEmpty(page.ddlSignupStartTime), (a, d) => a.SignupStartTime >= DateTime.Parse(page.ddlSignupStartTime))
			//报名时间
			.WhereIF(!string.IsNullOrEmpty(page.ddlSignupEndTime), (a, d) => a.SignupEndTime <= DateTime.Parse(page.ddlSignupEndTime))
			//开标时间
			.WhereIF(!string.IsNullOrEmpty(page.ddlTenderStartTime), (a, d) => a.TenderTime >= DateTime.Parse(page.ddlTenderStartTime))
			//开标时间
			.WhereIF(!string.IsNullOrEmpty(page.ddlTenderEndTime), (a, d) => a.TenderTime <= DateTime.Parse(page.ddlTenderEndTime))
			//采购方式
			.WhereIF(page.ddlPurchaseMethod > 0, (a, d) => a.PurchaseMethod == page.ddlPurchaseMethod)
			//项目名称
			.WhereIF(!string.IsNullOrEmpty(page.txtProjectName), (a, d) => a.ProjectName.Contains(page.txtProjectName))
			//项目编号
			.WhereIF(!string.IsNullOrEmpty(page.txtProjectCode), (a, d) => a.ProjectCode.Contains(page.txtProjectCode))
			//采购单位
			.WhereIF(!string.IsNullOrEmpty(page.txtPurchaseUnit), (a, d) => a.PurchaseUnit.Contains(page.txtPurchaseUnit))
			//代理机构
			.WhereIF(!string.IsNullOrEmpty(page.txtAgencyUnit), (a, d) => a.AgencyUnit.Contains(page.txtAgencyUnit))
			////投标人
			//.WhereIF(!string.IsNullOrEmpty(page.txtTenderPerson), (a, d) => d.TenderPerson.Contains(page.txtTenderPerson))
			// //专家
			// .WhereIF(!string.IsNullOrEmpty(page.Experts), (a, d) => d.Experts.Contains(page.Experts))
			// //报名状态
			// .WhereIF(page.ddlSignUp > 0 && page.ddlSignUp == 1, (a, d) => (d.IsSignup == 0 \|\| d.IsSignup == null))
			// .WhereIF(page.ddlSignUp > 0 && page.ddlSignUp != 1, (a, d) => d.IsSignup == 1)
			//保证金状态
			.WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit == 12, (a, d) => d.TenderDepositStatus == null)
			.WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit == 36, (a, d) => a.TenderTime < DateTime.Now.AddDays(15) && d.TenderDepositStatus == 13)
			.WhereIF(page.ddlTenderDeposit > 0 && page.ddlTenderDeposit != 12 && page.ddlTenderDeposit != 36, (a, d) => d.TenderDepositStatus == page.ddlTenderDeposit)
			//履约金状态
			.WhereIF(page.ddlBidbond > 0 && page.ddlBidbond == 32, (a, d) => (d.BidbondStatus == null))
			.WhereIF(page.ddlBidbond > 0 && page.ddlBidbond != 32, (a, d) => d.BidbondStatus == page.ddlBidbond)
			// //标书状态
			// .WhereIF(page.ddlDocumentStatus > 0 && page.ddlDocumentStatus == 15, (a, d) => (d.DocumentStatus == null \|\| d.DocumentStatus == 0 \|\| d.DocumentStatus == 15))
			// .WhereIF(page.ddlDocumentStatus > 0 && page.ddlDocumentStatus != 15, (a, d) => d.DocumentStatus == page.ddlDocumentStatus)
			// //投标状态
			// .WhereIF(page.ddlTenderStatus > 0 && page.ddlTenderStatus == 1, (a, d) => (d.TenderStatus == null \|\| d.TenderStatus == 0))
			// .WhereIF(page.ddlTenderStatus > 0 && page.ddlTenderStatus != 1, (a, d) => d.TenderStatus == 1)
			////中标情况
			//.WhereIF(page.ddlWinStatus > 0 && page.ddlWinStatus == 1, (a, d) => n.IsWin == null)
			// .WhereIF(page.ddlWinStatus > 0 && page.ddlWinStatus != 1, (a, d) => n.IsWin == (page.ddlWinStatus - 1))
			////质疑情况
			//.WhereIF(page.ddlOppugnStatus > 0 && page.ddlOppugnStatus == 1, (a, d) => (e.FilePath == null \|\| e.FilePath == ""))
			// .WhereIF(page.ddlOppugnStatus > 0 && page.ddlOppugnStatus != 1, (a, d) => (e.FilePath != null && e.FilePath != ""))
			////投诉情况
			//.WhereIF(page.ddlComplainStatus > 0 && page.ddlComplainStatus == 1, (a, d) => (f.FilePath == null \|\| f.FilePath == ""))
			// .WhereIF(page.ddlComplainStatus > 0 && page.ddlComplainStatus != 1, (a, d) => (f.FilePath != null && f.FilePath != ""))
			// //复议情况
			// .WhereIF(page.ddlReviewStatus > 0 && page.ddlReviewStatus == 1, (a, d) => (g.FilePath == null \|\| g.FilePath == ""))
			// .WhereIF(page.ddlReviewStatus > 0 && page.ddlReviewStatus != 1, (a, d) => (g.FilePath != null && g.FilePath != ""))
			// //诉讼情况
			// .WhereIF(page.ddlLitigationStatus > 0 && page.ddlLitigationStatus == 1, (a, d) => (h.FilePath == null \|\| h.FilePath == ""))
			// .WhereIF(page.ddlLitigationStatus > 0 && page.ddlLitigationStatus != 1, (a, d) => (h.FilePath != null && h.FilePath != ""))
			.Select((a, d) => new DocumentProjectInfoDTO
			{
			ProjectId = a.ProjectId,
			SignupStartTime = a.SignupStartTime,
			Province = a.Province,
			City = a.City,
			County = a.County,
			ProjectName = a.ProjectName,
			PurchaseUnit = a.PurchaseUnit,
			AgencyUnit = a.AgencyUnit,
			TenderTime = a.TenderTime,
			TenderPerson = d.TenderPerson,
			IsSignup = d.IsSignup,
			TenderDepositStatus = d.TenderDepositStatus,
			BidbondStatus = d.BidbondStatus,
			TenderStatus = d.TenderStatus,
			tbqk = "投标情况",
			wj = "",
			NoticeTypeName = "招标公告",
			NoticeType = a.NoticeType,
			PurchaseMethod = a.PurchaseMethod,
			DocumentStatus = d.DocumentStatus,
			TenderDepositStartTime = d.TenderDepositStartTime,
			TenderDeposit = a.TenderDeposit,
			TenderDepositEndTime = d.TenderDepositEndTime,
			BidbondStartTime = d.BidbondStartTime,
			BidbondEndTime = d.BidbondEndTime,
			Bidbond = a.Bidbond,
			}
			)
			.OrderByDescending(a => a.ProjectId).ToPageList(page.PageIndex, page.PageSize, ref total);


			result.TotalCount = total;
			result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1;

			if (result.Items != null && result.Items.Count > 0)
			{
			var ret = _db.Queryable<Document_Dictionary>().ToList();
			foreach (var documentProjectInfoDTO in result.Items)
			{
			if (documentProjectInfoDTO.City == "请选择" && documentProjectInfoDTO.County == "请选择")
			{
			documentProjectInfoDTO.xmqy = documentProjectInfoDTO.Province;
			}
			else if (documentProjectInfoDTO.City == "请选择" && documentProjectInfoDTO.County == "其他")
			{
			documentProjectInfoDTO.xmqy = documentProjectInfoDTO.City;
			}
			else
			{
			documentProjectInfoDTO.xmqy = documentProjectInfoDTO.City + documentProjectInfoDTO.County;
			}

			//if (documentProjectInfoDTO.IsSignup == 1)
			//{
			// documentProjectInfoDTO.bm = "√";
			//}
			//else
			//{
			// documentProjectInfoDTO.bm = "报名";
			//}

			if (!documentProjectInfoDTO.TenderDepositStatus.HasValue \|\| documentProjectInfoDTO.TenderDepositStatus == 0)
			{
			documentProjectInfoDTO.bzj = "缴费";
			}
			else if (documentProjectInfoDTO.TenderDepositStatus == 13)
			{
			documentProjectInfoDTO.bzj = "退款";
			}
			else
			{
			documentProjectInfoDTO.bzj = "√";
			}

			if (!documentProjectInfoDTO.BidbondStatus.HasValue \|\| documentProjectInfoDTO.BidbondStatus == 0)
			{
			documentProjectInfoDTO.lybzj = "缴费";
			}
			else if (documentProjectInfoDTO.BidbondStatus == 33)
			{
			documentProjectInfoDTO.lybzj = "退款";
			}
			else
			{
			documentProjectInfoDTO.lybzj = "√";
			}

			//if (documentProjectInfoDTO.TenderStatus == 1)
			//{
			// documentProjectInfoDTO.tb = "√";
			//}
			//else
			//{
			// documentProjectInfoDTO.tb = "投标";
			//}

			//if (documentProjectInfoDTO.DocumentStatus == 17)
			//{
			// documentProjectInfoDTO.bs = "√";
			//}
			//else if (documentProjectInfoDTO.DocumentStatus == 16)
			//{
			// documentProjectInfoDTO.bs = "制作中";
			//}
			//else
			//{
			// documentProjectInfoDTO.bs = "未制作";
			//}


			//if (!documentProjectInfoDTO.IsWin.HasValue \|\| documentProjectInfoDTO.IsWin <= 0)
			//{
			// documentProjectInfoDTO.zb = "中标";
			//}
			//else if (documentProjectInfoDTO.IsWin == 2)
			//{
			// documentProjectInfoDTO.zb = "√";
			//}
			//else
			//{
			// documentProjectInfoDTO.zb = "×";
			//}

			//if (documentProjectInfoDTO.IsAdvise == 1)
			//{
			// documentProjectInfoDTO.Advise = "方案保存";// "√";
			//}
			//else
			//{
			// documentProjectInfoDTO.Advise = "方案保存";
			//}

			//if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathzy))
			//{
			// documentProjectInfoDTO.zy = "√";
			//}
			//else
			//{
			// documentProjectInfoDTO.zy = "";
			//}

			//if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathts))
			//{
			// documentProjectInfoDTO.ts = "√";
			//}
			//else
			//{
			// documentProjectInfoDTO.ts = "";
			//}


			//if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathfy))
			//{
			// documentProjectInfoDTO.fy = "√";
			//}
			//else
			//{
			// documentProjectInfoDTO.fy = "";
			//}


			//if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathss))
			//{
			// documentProjectInfoDTO.ss = "√";
			//}
			//else
			//{
			// documentProjectInfoDTO.ss = "";
			//}
			//if (documentProjectInfoDTO.PurchaseMethod.HasValue && documentProjectInfoDTO.PurchaseMethod.Value > 0)
			//{
			// var document_Dictionary = ret.Where(x => x.Id == documentProjectInfoDTO.PurchaseMethod).FirstOrDefault();
			// if (document_Dictionary != null)
			// {
			// documentProjectInfoDTO.PurchaseMethodName = document_Dictionary.Name;
			// }
			//}

			}
			}

			return result;
			}



			public PageResult<Document_LayInfo> postDocumentLayInfoList(DocumentProjectInfoPageSearch page)
			{
			var aaa = GetJwtInfo();

			SqlSugar.PageModel pg = new SqlSugar.PageModel();
			pg.PageSize = page.PageSize;
			pg.PageIndex = page.PageIndex;
			//page.ToEmployeeId = a.EID;
			int total = 0;
			PageResult<Document_LayInfo> result = new PageResult<Document_LayInfo>();



			result.Items = _db.Queryable<Document_LayInfo>()
			.Where(a => (a.TenantID == aaa.TEID \|\| a.IsSys == 1))
			//文件名称
			.WhereIF(!string.IsNullOrEmpty(page.LayName), a => a.LayName == page.LayName)
			.WhereIF(!string.IsNullOrEmpty(page.LayType) && page.LayType != "请选择", a => a.LayType == page.LayType)
			.WhereIF(!string.IsNullOrEmpty(page.LayProvince), a => a.LayProvince == page.LayProvince)

			.OrderByDescending(a => a.LayId).ToPageList(page.PageIndex, page.PageSize, ref total);


			result.TotalCount = total;
			result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1;



			return result;
			}

			public bool GetDelDocumentLayInfo(int ID)
			{
			_db.Deleteable<Document_LayInfo>().Where(x => x.LayId == ID).ExecuteCommand();



			return true;
			}

			public bool SaveDocumentLayInfo(Document_LayInfo dp)
			{
			if (dp.LayId > 0)
			{
			_db.Updateable<Document_LayInfo>(dp).ExecuteCommand();
			}
			else
			{
			_db.Insertable<Document_LayInfo>(dp).ExecuteCommand();
			}
			return true;
			}

			public Document_LayInfo GetDocumentLayInfo(int ID)
			{
			var result = _db.Queryable<Document_LayInfo>().Where(x => x.LayId == ID).First();//执行查询
			return result;
			}

			public Document_LayInfo GetDocumentLayInfoByName(string LayName)
			{
			var aaa = GetJwtInfo();
			var result = _db.Queryable<Document_LayInfo>().Where(x => x.LayName == LayName && x.TenantID == aaa.EID).First();//执行查询
			return result;
			}
			}
			}