DocumentService.git

			@@ -1,8 +1,12 @@
			using DocumentServiceAPI.Application.DocManage.Dtos;
			using DocumentServiceAPI.Application.DocManage.Services;
			using DocumentServiceAPI.Application.ProjectInfo.Services;
			using DocumentServiceAPI.Application.System.Services;
			using DocumentServiceAPI.Model.cyDocumentModel;
			using DocumentServiceAPI.Services.IService;
			using DocumentServiceAPI.Utility;
			using Microsoft.AspNetCore.Mvc.RazorPages;
			using Microsoft.Extensions.Caching.Memory;
			using System.Linq.Expressions;

			namespace DocumentServiceAPI.Application.DocManage
			@@ -16,15 +20,116 @@
			private readonly DocumentManageService _docManageService;
			private readonly OrganizationService _organizationService;
			private readonly FileManageService _fileManageService;
			private readonly ProjectManageService _projectService;
			private readonly DocAchievementService _achievementService;
			private readonly IRedisCacheService _redisCache;
			private readonly DocShebeinengliService _shebeinengliService;



			public DocumentManageAppService(DocClassificationService classService, DocumentManageService docService, OrganizationService orgService,FileManageService fileManageService)
			public DocumentManageAppService(DocClassificationService classService, DocumentManageService docService, OrganizationService orgService,
			FileManageService fileManageService, ProjectManageService projectService, DocAchievementService achievementService, IRedisCacheService redisCase
			, DocShebeinengliService shebeinengliService)
			{
			_classificationService = classService;
			_docManageService = docService;
			_organizationService = orgService;
			_fileManageService = fileManageService;
			_projectService = projectService;
			_achievementService = achievementService;
			_shebeinengliService = shebeinengliService;

			_redisCache = redisCase;
			}

			/// <summary>
			/// 编辑文档时设置文档锁定状态
			/// </summary>
			/// <param name="model"></param>
			/// <returns>
			/// true:设置锁定成功
			/// false:锁定失败，文档已被锁定
			/// </returns>
			public bool SetDocLockStatus(DocLock_Submit_Dto model)
			{
			bool msg = true;
			string key = model.tenant_id.ToString().PadLeft(4,'0') + "_" + model.id.ToString().PadLeft(8,'0');
			if (_redisCache.Get<Document_Lock_Dto>(key) != null)
			{
			msg = false;
			}
			else
			{
			Document_Lock_Dto lk = new Document_Lock_Dto();
			lk.doc_id = model.id;
			lk.lock_time = DateTime.Now;
			lk.lock_user = model.username;
			lk.lock_user_id = model.userid;
			lk.status = 0;
			lk.tenant_id = model.tenant_id;

			var db= _redisCache.Add<Document_Lock_Dto>(key,lk ,-1);
			}
			return msg;
			}

			/// <summary>
			/// 查询项目信息
			/// </summary>
			/// <param name="search"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostProjectItemList(ProjectItemSearch search)
			{
			var data = await _projectService.GetListAsync();//.GetListAsync(c => c.TenantID == search.tenant_id);
			if (data != null)
			{
			var list = data.Select(c => new ProjectItem_List_Dto()
			{
			pro_id=c.ProjectId,
			pro_name=c.ProjectName
			}).OrderBy(c => c.pro_name).ToList();
			return new JsonResult(list);
			}

			return null;
			}

			/// <summary>
			/// 根据文档类型查询文档列表
			/// </summary>
			/// <param name="search"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostDocumentItemList(DocumentSearch search)
			{
			if(search.Code == "002")
			{
			var data = await _achievementService.GetListAsync(c => c.status == 1 && c.tenant_code == search.TenantID);
			if (search.class_id > 0)
			{
			data = data.Where(c => c.classification_id == search.class_id).ToList();
			}

			return new JsonResult(data.OrderBy(x => x.sort).Select(c => new { name = c.achievement_name, idcode = c.id+ "/002" }).ToList());
			}
			else if (search.Code == "006")
			{
			var data = await _shebeinengliService.GetListAsync(c => c.status == 1 && c.tenant_code == search.TenantID);
			if (search.class_id > 0)
			{
			data = data.Where(c => c.classification_id == search.class_id).ToList();
			}

			return new JsonResult(data.OrderBy(x => x.sort).Select(c => new { name = c.shebeinengli_name, idcode = c.id + "/006" }).ToList());
			}
			else
			{
			var data = await _docManageService.GetListAsync(c => c.status == 1 && c.is_del == false && c.doc_code == search.Code && c.org_id == search.TenantID);
			if (search.class_id > 0)
			{
			data = data.Where(c => c.classification_id == search.class_id).ToList();
			}

			return new JsonResult(data.OrderBy(x => x.sort).Select(c => new { name = c.doc_name , idcode = c.id + "/" + c.doc_code }).ToList());
			}

			}

			/// <summary>
			@@ -35,7 +140,22 @@
			public async Task<bool> CheckNameDuplicate(Document_Submit_Dto model)
			{
			var msg = false;
			var ck =await _docManageService.GetFirstAsync(c=>c.doc_name==model.name && c.doc_code==model.code && c.classification_id==model.class_id && c.id!=model.id);
			Expression<Func<Doc_Info, bool>> expression = t => true;
			expression = expression.And(c => c.tenant_code == model.tenant_id && c.doc_name == model.name && c.doc_code == model.code && c.is_del == false );
			if (model.class_id.HasValue && model.class_id!=0)
			{
			expression = expression.And(t => t.classification_id == model.class_id);
			}
			if (model.project_id.HasValue && model.project_id != 0)
			{
			expression = expression.And(t => t.project_id == model.project_id);
			}

			if (model.id > 0)
			{
			expression = expression.And(t => t.id != model.id);
			}
			var ck =await _docManageService.GetFirstAsync(expression);
			if (ck != null)
			{
			msg = true;
			@@ -56,7 +176,7 @@
			{
			Expression<Func<Doc_Info, bool>> expression = t => true;

			expression = expression.And(t => t.doc_code == page.Code && t.is_del==false);
			expression = expression.And(t =>t.tenant_code==page.TenantID && t.doc_code == page.Code && t.is_del==false);
			if (page.ClassCode.HasValue)
			{
			expression = expression.And(t => t.classification_id == page.ClassCode);
			@@ -77,7 +197,9 @@
			var data = await _docManageService.Context.Queryable<Doc_Info>()
			.Includes(c => c.DocClassification)
			.Includes(c=>c.DocOrganization)
			.Includes(c=>c.DocProject)
			.Where(expression)
			.OrderBy(c=>c.sort)
			.ToPageListAsync(page.PageIndex, page.PageSize, total);

			if (data != null && total > 0)
			@@ -90,10 +212,14 @@
			doc_name = c.doc_name,
			id = c.id,
			org_id = c.org_id,
			org_name = c.DocOrganization.UnitName,
			org_name = c.DocOrganization?.UnitName,
			project_id = c.project_id,
			project_name = "",
			status = c.status
			project_name = c.DocProject?.ProjectName,
			status = c.status,
			sort = c.sort,
			zb_time = c.zb_time.HasValue ? c.zb_time.Value.ToString("yyyy/MM/dd") : "",
			zige_code = c.zige_code,
			zige_code_name = c.document_Dictionary?.Name
			}).ToList();

			}
			@@ -107,6 +233,24 @@
			}

			return new JsonResult(result);
			}

			/// <summary>
			/// 根据文档号查询
			/// </summary>
			/// <param name="search"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostDocumentInfo(DocumentSearch search)
			{
			var data = await _docManageService.GetFirstAsync(c => c.is_del == false && c.id == search.ID && c.tenant_code==search.TenantID);
			if (data != null)
			{
			var list = await _fileManageService.GetListAsync(c =>c.status==1 && c.doc_id == search.ID);
			Document_Info_Dto info = new Document_Info_Dto(data, list.Select(c => new FileInfo_List_Dto(c)).OrderBy(c => c.sort).ToList());
			return new JsonResult(info);
			}

			return null;
			}

			/// <summary>
			@@ -127,13 +271,16 @@
			doc.org_id = info.org_id;
			doc.status = info.status;
			doc.tenant_code = info.tenant_id;

			doc.sort = info.sort;
			doc.zb_time = info.zb_time;
			doc.zige_code = info.zige_code;

			var id =await _docManageService.InsertReturnIdentityAsync(doc);
			if (id > 0)
			{
			if(info.files!=null&& info.files.Count > 0)
			if(info.newfiles!=null&& info.newfiles.Count > 0)
			{
			foreach (var item in info.files)
			foreach (var item in info.newfiles)
			{
			File_Info file = new File_Info();
			file.doc_id = id;
			@@ -148,6 +295,7 @@
			file.uptime = DateTime.Now;
			file.up_userid = item.up_userid;
			file.up_username = item.up_username;
			file.sort = item.sort;
			await _fileManageService.InsertAsync(file);
			}
			}
			@@ -156,45 +304,92 @@
			return msg;
			}





			/// <summary>
			/// 根据类型查询数据
			/// </summary>
			/// <param name="page"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostItemList(DocClassificationSearch page)
			{
			var data = await _classificationService.GetListAsync(c => c.status == 1 && c.parent_code == page.Code);
			return new JsonResult(data);
			}


			/// <summary>
			/// 修改数据
			/// </summary>
			/// <param name="info"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostEdtInfo(Classification_Submit_Dto info)
			public async Task<bool> PostEdtDocumentInfo(Document_Submit_Dto info)
			{
			var msg = false;
			var model = await _classificationService.GetByIdAsync(info.id);
			if (model != null)
			{
			model.add_time = DateTime.Now;
			model.doc_classification = info.name;
			model.status = info.status;
			bool msg = false;

			msg = await _classificationService.UpdateAsync(model);
			var doc= _docManageService.GetById(info.id);
			if (info.tenant_id == doc.tenant_code && doc.is_del==false)
			{
			doc.add_time = DateTime.Now;
			doc.classification_id = info.class_id;
			doc.doc_name = info.name;
			doc.org_id = info.org_id;
			doc.status = info.status;
			doc.sort = info.sort;
			doc.zb_time = info.zb_time;
			doc.zige_code = info.zige_code;
			if (await _docManageService.UpdateAsync(doc))
			{
			//新提交的文件
			if (info.newfiles != null && info.newfiles.Count > 0)
			{
			foreach (var item in info.newfiles)
			{
			File_Info file = new File_Info();
			file.doc_id = doc.id;
			file.filenewname = item.filenewname.Length > 40 ? item.filenewname.Substring(item.filenewname.Length - 40) : item.filenewname;
			file.fileoldname = item.fileoldname.Length > 40 ? item.fileoldname.Substring(item.fileoldname.Length - 40) : item.fileoldname;
			file.filepath = item.filepath;
			file.fileservername = item.fileservername;
			file.filesize = item.filesize;
			file.filetype = item.filetype;
			file.status = 1;
			file.suffix = item.suffix;
			file.uptime = DateTime.Now;
			file.up_userid = item.up_userid;
			file.up_username = item.up_username;
			file.sort = item.sort;
			await _fileManageService.InsertAsync(file);
			}
			}

			//修改资源名称的文件
			if (info.editfiles != null && info.editfiles.Count > 0)
			{
			foreach (var item in info.editfiles)
			{
			var file= _fileManageService.GetById(item.id);
			if (file != null && file.doc_id==doc.id)
			{
			file.fileoldname = file.filenewname;
			file.filenewname = item.filenewname.Length > 40 ? item.filenewname.Substring(item.filenewname.Length - 40) : item.filenewname;
			file.uptime = DateTime.Now;
			file.sort = item.sort;
			await _fileManageService.UpdateAsync(file);
			}
			}
			}

			//删除资源
			if (info.delfiles != null && info.delfiles.Count > 0)
			{
			foreach (var item in info.delfiles)
			{
			var file = _fileManageService.GetById(item);
			if (file != null && file.doc_id == doc.id)
			{
			file.status = 0;
			file.uptime = DateTime.Now;
			await _fileManageService.UpdateAsync(file);
			}
			}
			}

			msg = true;
			}
			}

			return new JsonResult(msg);
			return msg;
			}

			/// <summary>
			/// 删除数据
			/// 删除文档数据
			/// </summary>
			/// <param name="doc"></param>
			/// <returns></returns>
			@@ -214,69 +409,732 @@
			return new JsonResult(msg);
			}

			#region 文档的文件

			/// <summary>
			/// 根据文档号查询文件数据
			/// </summary>
			/// <param name="id"></param>
			/// <returns></returns>
			public async Task<IActionResult> GetDocumentFilesList(int id,string code)
			{
			if (code == "002")
			{
			var data = await _achievementService.GetByIdAsync(id);
			List<FileInfo_List_Dto> list_Dtos = new List<FileInfo_List_Dto> ();
			if (data != null)
			{
			if (!string.IsNullOrEmpty(data.zbtzs_url))
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.zbtzs_url;
			fileInfo_List_Dto.fileNewName = "中标通知书";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.zbtzs_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			if (!string.IsNullOrEmpty(data.ht_url))
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.ht_url;
			fileInfo_List_Dto.fileNewName = "合同";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.ht_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			if (!string.IsNullOrEmpty(data.ysbg_url))
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.ysbg_url;
			fileInfo_List_Dto.fileNewName = "验收报告";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.ysbg_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			if (!string.IsNullOrEmpty(data.fkpz_url))
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.fkpz_url;
			fileInfo_List_Dto.fileNewName = "付款凭证";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.fkpz_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			if (!string.IsNullOrEmpty(data.yhpj_url))
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.yhpj_url;
			fileInfo_List_Dto.fileNewName = "用户评价";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.yhpj_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			if (!string.IsNullOrEmpty(data.hjzs_url))
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.hjzs_url;
			fileInfo_List_Dto.fileNewName = "获奖证书";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.hjzs_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			}



			return new JsonResult(list_Dtos);
			}
			else if (code == "006")
			{
			var data = await _shebeinengliService.GetByIdAsync(id);
			List<FileInfo_List_Dto> list_Dtos = new List<FileInfo_List_Dto>();
			if (data != null)
			{
			if (!string.IsNullOrEmpty(data.sbzp_url) && data.sbzp_fuhe > 0)
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.sbzp_url;
			fileInfo_List_Dto.fileNewName = "设备照片";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.sbzp_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			if (!string.IsNullOrEmpty(data.gmht_url) && data.gmht_fuhe > 0)
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.gmht_url;
			fileInfo_List_Dto.fileNewName = "购买合同";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.gmht_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			if (!string.IsNullOrEmpty(data.fp_url) && data.fp_fuhe > 0)
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.fp_url;
			fileInfo_List_Dto.fileNewName = "发票";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.fp_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			if (!string.IsNullOrEmpty(data.fkpz_url) && data.fkpz_fuhe > 0)
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.fkpz_url;
			fileInfo_List_Dto.fileNewName = "付款凭证";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.fkpz_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}

			if (!string.IsNullOrEmpty(data.csmp_url) && data.csmp_fuhe > 0)
			{
			FileInfo_List_Dto fileInfo_List_Dto = new FileInfo_List_Dto();
			fileInfo_List_Dto.filePath = data.csmp_url;
			fileInfo_List_Dto.fileNewName = "参数（铭牌）";
			fileInfo_List_Dto.suffix = Path.GetExtension(data.csmp_url);
			list_Dtos.Add(fileInfo_List_Dto);
			}
			}



			return new JsonResult(list_Dtos);
			}
			else
			{
			var data = await _fileManageService.GetListAsync(c => c.status == 1 && c.doc_id == id);

			var list = data.Select(c => new FileInfo_List_Dto(c)).OrderBy(c => c.sort).ToList();

			return new JsonResult(list);
			}


			}

			#endregion

			#region 业绩管理

			/// <summary>
			/// 根据分页条件查询分页数据
			/// </summary>
			/// <param name="page"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostAchievementListPage(DocumentPageSearch page)
			{
			PageResult<Achievement_List_Dto> result = new PageResult<Achievement_List_Dto>();

			try
			{
			Expression<Func<Doc_Achievement, bool>> expression = t => true;

			expression = expression.And(t => t.tenant_code == page.TenantID && t.status == 1);
			if (page.ClassCode.HasValue)
			{
			expression = expression.And(t => t.classification_id == page.ClassCode);
			}
			if (!string.IsNullOrEmpty(page.Name))
			{
			expression = expression.And(t => t.achievement_name.Contains(page.Name));
			}
			if (page.zbtzs.HasValue)
			{
			if (page.zbtzs == 1)
			{
			expression = expression.And(t => t.zbtzs_url != null);
			}
			else
			{
			expression = expression.And(t => t.zbtzs_url == null);
			}

			}
			if (page.ht.HasValue)
			{
			if (page.ht == 1)
			{
			expression = expression.And(t => t.ht_url != null);
			}
			else
			{
			expression = expression.And(t => t.ht_url == null);
			}

			}

			if (page.ysbg.HasValue)
			{
			if (page.ysbg == 1)
			{
			expression = expression.And(t => t.ysbg_url != null);
			}
			else
			{
			expression = expression.And(t => t.ysbg_url == null);
			}

			}

			if (page.fkpz.HasValue)
			{
			if (page.fkpz == 1)
			{
			expression = expression.And(t => t.fkpz_url != null);
			}
			else
			{
			expression = expression.And(t => t.fkpz_url == null);
			}

			}

			if (page.yhpj.HasValue)
			{
			if (page.yhpj == 1)
			{
			expression = expression.And(t => t.yhpj_url != null);
			}
			else
			{
			expression = expression.And(t => t.yhpj_url == null);
			}

			}

			if (page.hjzs.HasValue)
			{
			if (page.hjzs == 1)
			{
			expression = expression.And(t => t.hjzs_url != null);
			}
			else
			{
			expression = expression.And(t => t.hjzs_url == null);
			}

			}

			RefAsync<int> total = 0;
			var data = await _achievementService.Context.Queryable<Doc_Achievement>()
			.Includes(c => c.DocClassification)
			.Includes(c => c.DocProject)
			.Where(expression)
			.OrderBy(c => c.sort)
			.ToPageListAsync(page.PageIndex, page.PageSize, total);

			if (data != null && total > 0)
			{
			result.Items = data.Select(c => new Achievement_List_Dto()
			{
			add_time = c.add_time,
			class_id=c.classification_id,
			class_name = c.DocClassification?.doc_classification,
			id = c.id,
			project_id = c.project_id,
			project_name = c.achievement_name,//c.DocProject?.ProjectName,
			fkpz=c.fkpz_url,
			hjzs=c.hjzs_url,
			ht=c.ht_url,
			yhpj=c.yhpj_url,
			ysbg=c.ysbg_url,
			zbtzs=c.zbtzs_url,
			status = c.status,
			sort = c.sort,
			zb_time = c.zb_time.HasValue? c.zb_time.Value.ToString("yyyy/MM/dd") :"",
			}).ToList();

			}
			result.PageIndex = page.PageIndex;
			result.PageSize = page.PageSize;
			result.TotalCount = total;
			}
			catch (Exception er)
			{
			Log.Error(er.Message, er);
			}

			return new JsonResult(result);
			}

			/// <summary>
			/// 检查重复
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public async Task<bool> CheckDocAchievementDuplicate(Document_Submit_Dto model)
			{
			var msg = false;
			var ck = await _achievementService.GetFirstAsync(c=>c.status==1 && c.tenant_code==model.tenant_id
			&& c.achievement_name==model.name && c.classification_id== model.class_id);
			if (ck != null)
			{
			if (model.id <= 0 \|\| (model.id > 0 && model.id != ck.id))
			{
			msg = true;
			}
			else
			{
			msg = false;
			}

			}
			return msg;
			}

			/// <summary>
			/// 添加数据
			/// </summary>
			/// <param name="info"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostAddFilesInfo(Classification_Submit_Dto info)
			public async Task<bool> PostAddDocAchievement(Achievement_Submit_Dto info)
			{
			Doc_Classification doc = new Doc_Classification();
			doc.add_time = DateTime.Now;
			doc.doc_classification = info.name;
			doc.doc_classification_code = "";
			doc.is_system = false;
			doc.parent_code = info.code;
			doc.sort_id = 99;
			doc.status = info.status;
			doc.tenant_code = info.tenant_id;

			var msg = await _classificationService.InsertAsync(doc);
			return new JsonResult(msg);
			}

			/// <summary>
			/// 修改数据
			/// </summary>
			/// <param name="info"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostEdtFileInfo(Classification_Submit_Dto info)
			{
			var msg = false;
			var model = await _classificationService.GetByIdAsync(info.id);
			if (model != null)
			if (info.id > 0)
			{
			model.add_time = DateTime.Now;
			model.doc_classification = info.name;
			model.status = info.status;
			Doc_Achievement doc = new Doc_Achievement();
			doc.id = info.id;
			doc.add_time = DateTime.Now;
			doc.classification_id = info.class_id;
			doc.project_id = info.project_id;
			doc.achievement_name = info.name;

			msg = await _classificationService.UpdateAsync(model);
			doc.fkpz_url = info.fkpz;
			doc.hjzs_url = info.hjzs;
			doc.ht_url = info.ht;
			doc.yhpj_url = info.yhpj;
			doc.ysbg_url = info.ysbg;
			doc.zbtzs_url = info.zbtzs;

			doc.status = 1;
			doc.tenant_code = info.tenant_id;
			doc.sort = info.sort;
			doc.zb_time = info.zb_time;
			return await _achievementService.UpdateAsync(doc);
			}
			else
			{
			Doc_Achievement doc = new Doc_Achievement();
			doc.add_time = DateTime.Now;
			doc.classification_id = info.class_id;
			doc.project_id = info.project_id;
			doc.achievement_name = info.name;

			return new JsonResult(msg);
			doc.fkpz_url = info.fkpz;
			doc.hjzs_url = info.hjzs;
			doc.ht_url = info.ht;
			doc.yhpj_url = info.yhpj;
			doc.ysbg_url = info.ysbg;
			doc.zbtzs_url = info.zbtzs;

			doc.status = 1;
			doc.tenant_code = info.tenant_id;
			doc.sort = info.sort;
			doc.zb_time = info.zb_time;

			return await _achievementService.InsertAsync(doc);
			}

			}



			/// <summary>
			/// 删除数据
			/// 删除文档数据
			/// </summary>
			/// <param name="doc"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostDelFileInfo(Document_Submit_Dto doc)
			public async Task<IActionResult> PostDelAchievement(Achievement_Submit_Dto doc)
			{
			bool msg = false;
			//假删除
			var model = await _docManageService.GetByIdAsync(doc.id);
			if (model != null)
			{
			if (model.tenant_code == doc.tenant_id && !model.is_del)
			{
			model.is_del = true;
			msg = await _docManageService.UpdateAsync(model);
			}
			}
			var sss = new Doc_Achievement();
			sss.id = doc.id;

			msg = await _achievementService.DeleteAsync(sss);
			return new JsonResult(msg);
			}


			/// <summary>
			/// 根据文档号查询
			/// </summary>
			/// <param name="search"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostAchievementInfo(DocumentSearch search)
			{
			var data = await _achievementService.GetFirstAsync(c => c.id == search.ID && c.tenant_code == search.TenantID);
			if (data != null)
			{
			Achievement_Submit_Dto achievement_Submit_Dto = new Achievement_Submit_Dto();
			achievement_Submit_Dto.id = data.id;
			achievement_Submit_Dto.class_id = data.classification_id.Value;
			//achievement_Submit_Dto.project_id = data.project_id.Value;
			achievement_Submit_Dto.name = data.achievement_name;
			achievement_Submit_Dto.zbtzs = data.zbtzs_url;
			achievement_Submit_Dto.ht = data.ht_url;
			achievement_Submit_Dto.ysbg = data.ysbg_url;
			achievement_Submit_Dto.fkpz = data.fkpz_url;
			achievement_Submit_Dto.yhpj = data.yhpj_url;
			achievement_Submit_Dto.hjzs = data.hjzs_url;
			achievement_Submit_Dto.tenant_id = data.tenant_code;
			achievement_Submit_Dto.status = data.status;
			achievement_Submit_Dto.sort = data.sort;
			achievement_Submit_Dto.zb_time = data.zb_time;


			return new JsonResult(achievement_Submit_Dto);
			}

			return null;
			}

			#endregion



			#region 设备能力

			/// <summary>
			/// 根据分页条件查询分页数据
			/// </summary>
			/// <param name="page"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostShebeinengliListPage(DocumentPageSearch page)
			{
			PageResult<Achievement_List_Dto> result = new PageResult<Achievement_List_Dto>();

			try
			{
			Expression<Func<Doc_Shebeinengli, bool>> expression = t => true;

			expression = expression.And(t => t.tenant_code == page.TenantID && t.status == 1);
			if (page.ClassCode.HasValue)
			{
			expression = expression.And(t => t.classification_id == page.ClassCode);
			}
			if (!string.IsNullOrEmpty(page.Name))
			{
			expression = expression.And(t => t.shebeinengli_name.Contains(page.Name));
			}
			if (page.sbzp.HasValue)
			{
			if (page.sbzp == 1)
			{
			expression = expression.And(t => t.sbzp_url != null);
			}
			else
			{
			expression = expression.And(t => t.sbzp_url == null);
			}

			}
			if (page.gmht.HasValue)
			{
			if (page.gmht == 1)
			{
			expression = expression.And(t => t.gmht_url != null);
			}
			else
			{
			expression = expression.And(t => t.gmht_url == null);
			}

			}

			if (page.fp.HasValue)
			{
			if (page.fp == 1)
			{
			expression = expression.And(t => t.fp_url != null);
			}
			else
			{
			expression = expression.And(t => t.fp_url == null);
			}

			}

			if (page.fkpz.HasValue)
			{
			if (page.fkpz == 1)
			{
			expression = expression.And(t => t.fkpz_url != null);
			}
			else
			{
			expression = expression.And(t => t.fkpz_url == null);
			}

			}

			if (page.csmp.HasValue)
			{
			if (page.csmp == 1)
			{
			expression = expression.And(t => t.csmp_url != null);
			}
			else
			{
			expression = expression.And(t => t.csmp_url == null);
			}

			}



			RefAsync<int> total = 0;
			var data = await _shebeinengliService.Context.Queryable<Doc_Shebeinengli>()
			.Includes(c => c.DocClassification)
			//.Includes(c => c.DocProject)
			.Where(expression)
			.OrderBy(c => c.sort)
			.ToPageListAsync(page.PageIndex, page.PageSize, total);

			if (data != null && total > 0)
			{
			result.Items = data.Select(c => new Achievement_List_Dto()
			{
			add_time = c.add_time,
			class_id = c.classification_id,
			class_name = c.DocClassification?.doc_classification,
			id = c.id,
			project_id = c.project_id,
			project_name = c.shebeinengli_name,//c.DocProject?.ProjectName,

			sbzp = c.sbzp_url,
			gmht = c.gmht_url,
			fp = c.fp_url,
			fkpz = c.fkpz_url,
			csmp = c.csmp_url,
			status = c.status,
			sort = c.sort,
			zb_time = c.zb_time.HasValue ? c.zb_time.Value.ToString("yyyy/MM/dd") : "",
			zige_code = (c.sbzp_zige.HasValue&& c.sbzp_zige >0 )
			\|\| (c.gmht_zige.HasValue && c.gmht_zige > 0)
			\|\| (c.fp_zige.HasValue && c.fp_zige > 0)
			\|\| (c.fkpz_zige.HasValue && c.fkpz_zige > 0)
			\|\| (c.csmp_zige.HasValue && c.csmp_zige > 0) ? 1:null,
			}).ToList();

			}
			result.PageIndex = page.PageIndex;
			result.PageSize = page.PageSize;
			result.TotalCount = total;
			}
			catch (Exception er)
			{
			Log.Error(er.Message, er);
			}

			return new JsonResult(result);
			}

			/// <summary>
			/// 检查重复
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public async Task<bool> CheckDocShebeinengliDuplicate(Document_Submit_Dto model)
			{
			var msg = false;
			var ck = await _shebeinengliService.GetFirstAsync(c => c.status == 1 && c.tenant_code == model.tenant_id
			&& c.shebeinengli_name == model.name && c.classification_id == model.class_id);
			if (ck != null)
			{
			if (model.id <= 0 \|\| (model.id > 0 && model.id != ck.id))
			{
			msg = true;
			}
			else
			{
			msg = false;
			}

			}
			return msg;
			}

			/// <summary>
			/// 添加数据
			/// </summary>
			/// <param name="info"></param>
			/// <returns></returns>
			public async Task<bool> PostAddDocShebeinengli(Achievement_Submit_Dto info)
			{
			if (info.id > 0)
			{
			Doc_Shebeinengli doc = new Doc_Shebeinengli();
			doc.id = info.id;
			doc.add_time = DateTime.Now;
			doc.classification_id = info.class_id;
			doc.project_id = info.project_id;
			doc.shebeinengli_name = info.name;


			doc.sbzp_url = info.sbzp;
			doc.gmht_url = info.gmht;
			doc.fp_url = info.fp;
			doc.fkpz_url = info.fkpz;
			doc.csmp_url = info.csmp;

			doc.status = 1;
			doc.tenant_code = info.tenant_id;
			doc.sort = info.sort;
			doc.zb_time = info.zb_time;
			doc.zige_code = info.zige_code;

			doc.sbzp_zige = info.sbzp_zige;
			doc.gmht_zige = info.gmht_zige;
			doc.fp_zige = info.fp_zige;
			doc.fkpz_zige = info.fkpz_zige;
			doc.csmp_zige = info.csmp_zige;

			doc.sbzp_fuhe = info.sbzp_fuhe;
			doc.gmht_fuhe = info.gmht_fuhe;
			doc.fp_fuhe = info.fp_fuhe;
			doc.fkpz_fuhe = info.fkpz_fuhe;
			doc.csmp_fuhe = info.csmp_fuhe;

			return await _shebeinengliService.UpdateAsync(doc);
			}
			else
			{
			Doc_Shebeinengli doc = new Doc_Shebeinengli();
			doc.add_time = DateTime.Now;
			doc.classification_id = info.class_id;
			doc.project_id = info.project_id;
			doc.shebeinengli_name = info.name;

			doc.sbzp_url = info.sbzp;
			doc.gmht_url = info.gmht;
			doc.fp_url = info.fp;
			doc.fkpz_url = info.fkpz;
			doc.csmp_url = info.csmp;

			doc.status = 1;
			doc.tenant_code = info.tenant_id;
			doc.sort = info.sort;
			doc.zb_time = info.zb_time;
			doc.zige_code = info.zige_code;

			doc.sbzp_zige = info.sbzp_zige;
			doc.gmht_zige = info.gmht_zige;
			doc.fp_zige = info.fp_zige;
			doc.fkpz_zige = info.fkpz_zige;
			doc.csmp_zige = info.csmp_zige;

			doc.sbzp_fuhe = info.sbzp_fuhe;
			doc.gmht_fuhe = info.gmht_fuhe;
			doc.fp_fuhe = info.fp_fuhe;
			doc.fkpz_fuhe = info.fkpz_fuhe;
			doc.csmp_fuhe = info.csmp_fuhe;

			return await _shebeinengliService.InsertAsync(doc);
			}

			}



			/// <summary>
			/// 删除文档数据
			/// </summary>
			/// <param name="doc"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostDelShebeinengli(Achievement_Submit_Dto doc)
			{
			bool msg = false;
			var sss = new Doc_Shebeinengli();
			sss.id = doc.id;

			msg = await _shebeinengliService.DeleteAsync(sss);
			return new JsonResult(msg);
			}


			/// <summary>
			/// 根据文档号查询
			/// </summary>
			/// <param name="search"></param>
			/// <returns></returns>
			public async Task<IActionResult> PostShebeinengliInfo(DocumentSearch search)
			{
			var data = await _shebeinengliService.GetFirstAsync(c => c.id == search.ID && c.tenant_code == search.TenantID);
			if (data != null)
			{
			Achievement_Submit_Dto achievement_Submit_Dto = new Achievement_Submit_Dto();
			achievement_Submit_Dto.id = data.id;
			achievement_Submit_Dto.class_id = data.classification_id.Value;
			//achievement_Submit_Dto.project_id = data.project_id.Value;
			achievement_Submit_Dto.name = data.shebeinengli_name;
			achievement_Submit_Dto.sbzp = data.sbzp_url;
			achievement_Submit_Dto.gmht = data.gmht_url;
			achievement_Submit_Dto.fp = data.fp_url;
			achievement_Submit_Dto.fkpz = data.fkpz_url;
			achievement_Submit_Dto.csmp = data.csmp_url;
			achievement_Submit_Dto.tenant_id = data.tenant_code;
			achievement_Submit_Dto.status = data.status;
			achievement_Submit_Dto.sort = data.sort;
			achievement_Submit_Dto.zb_time = data.zb_time;
			achievement_Submit_Dto.zige_code = data.zige_code;

			achievement_Submit_Dto.sbzp_zige = data.sbzp_zige;
			achievement_Submit_Dto.gmht_zige = data.gmht_zige;
			achievement_Submit_Dto.fp_zige = data.fp_zige;
			achievement_Submit_Dto.fkpz_zige = data.fkpz_zige;
			achievement_Submit_Dto.csmp_zige = data.csmp_zige;

			achievement_Submit_Dto.sbzp_fuhe = data.sbzp_fuhe;
			achievement_Submit_Dto.gmht_fuhe = data.gmht_fuhe;
			achievement_Submit_Dto.fp_fuhe = data.fp_fuhe;
			achievement_Submit_Dto.fkpz_fuhe = data.fkpz_fuhe;
			achievement_Submit_Dto.csmp_fuhe = data.csmp_fuhe;

			return new JsonResult(achievement_Submit_Dto);
			}

			return null;
			}

			#endregion
			}
			}