DocumentServiceAPI.Application/DocumentServiceAPI.Application.xml
@@ -494,11 +494,309 @@ <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetDelegatePersonInfo(System.Int32)"> <summary> 获取项目GetDelegatePersonInfo <param name="ID"></param> </summary> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.SaveDocumentProjectOppugnInfo(DocumentServiceAPI.Model.cyDocumentModel.Document_ProjectOppugnInfo)"> <summary> 修改项目SaveDocumentProjectOppugnInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetAllDelegatePerson"> <summary> 获取项目GetAllDelegatePerson </summary> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.SaveDocumentProjectComplainInfo(DocumentServiceAPI.Model.cyDocumentModel.Document_ProjectComplainInfo)"> <summary> 修改项目SaveDocumentProjectComplainInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.SaveDocumentProjectReviewInfo(DocumentServiceAPI.Model.cyDocumentModel.Document_ProjectReviewInfo)"> <summary> 修改项目SaveDocumentProjectReviewInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetPreUnit(System.String)"> <summary> 查询项目GetPreUnit </summary> <param name="childName"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.SaveDocumentProjectLitigationInfo(DocumentServiceAPI.Model.cyDocumentModel.Document_ProjectLitigationInfo)"> <summary> 修改项目SaveDocumentProjectLitigationInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.SaveDocumentAdviseInfo(DocumentServiceAPI.Model.cyDocumentModel.Document_AdviseInfo)"> <summary> 修改项目SaveDocumentAdviseInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetTempletModel(System.Int32)"> <summary> 获取项目GetTempletModel <param name="templetId"></param> </summary> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetDocumentTempletList"> <summary> 获取项目GetDocumentTempletList </summary> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.postDocumentZhaobiaoFileList(DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentProjectInfoPageSearch)"> <summary> 获取招标文件列表postDocumentZhaobiaoFileList </summary> <param name="page"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.SaveDocumentZhaobiaoFileInfo(DocumentServiceAPI.Model.cyDocumentModel.Document_ZhaobiaoFile)"> <summary> 修改招标文件SaveDocumentZhaobiaoFileInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetDeleteDocumentZhaobiaoFile(System.Int32)"> <summary> 删除项目GetDeleteDocumentZhaobiaoFile </summary> <param name="ID"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetDocumentZhaobiaoFileInfo(System.Int32)"> <summary> 获取项目GetDocumentZhaobiaoFileInfo <param name="ID"></param> </summary> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.postDocumentTBXYFileList(DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentProjectInfoPageSearch)"> <summary> 获取响应文件列表postDocumentTBXYFileList </summary> <param name="page"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.SaveDocumentTBXYFileInfo(DocumentServiceAPI.Model.cyDocumentModel.Document_TBXYFile)"> <summary> 修改响应文件SaveDocumentTBXYFileInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetDeleteDocumentTBXYFile(System.Int32)"> <summary> 删除响应文件GetDeleteDocumentTBXYFile </summary> <param name="ID"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetDocumentTBXYFileInfo(System.Int32)"> <summary> 获取响应文件GetDocumentTBXYFileInfo <param name="ID"></param> </summary> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetDocumentTBXYFileList(System.Int32,System.Int32)"> <summary> 获取响应文件GetDocumentTBXYFileInfo <param name="ID"></param> </summary> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.GetDocumentTBXYFileByFileName(System.Int32,System.Int32,System.String)"> <summary> 获取响应文件GetDocumentTBXYFileInfo <param name="ID"></param> </summary> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.SaveDocInfo(DocumentServiceAPI.Model.cyDocumentModel.Doc_Info)"> <summary> 修改响应文件SaveDocumentTBXYFileInfo </summary> <param name="dp"></param> <returns>int</returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.ProjectInfoController.SaveFileInfo(DocumentServiceAPI.Model.cyDocumentModel.File_Info)"> <summary> 修改响应文件SaveDocumentTBXYFileInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.Services.ProjectInfoService.GetJwtInfo"> <summary> 获取Jwt相关信息 </summary> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.Services.SheZhiService.GetJwtInfo"> <summary> 获取Jwt相关信息 </summary> </member> <member name="T:DocumentServiceAPI.Application.ProjectInfo.SheZhiController"> <summary> 登录控制器 </summary> </member> <!-- Badly formed XML comment ignored for member "M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.postDelegatePersonList(DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentProjectInfoPageSearch)" --> <member name="M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.GetDelDocumentDelegatePersonInfo(System.Int32)"> <summary> 删除项目GetDelDocumentDelegatePersonInfo </summary> <param name="Id"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.SaveDocumentDelegatePersonInfo(DocumentServiceAPI.Model.cyDocumentModel.Document_DelegatePersonInfo)"> <summary> 修改项目SaveDocumentDelegatePersonInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.GetDocumentDelegatePersonInfo(System.Int32)"> <summary> 获取项目GetDocumentDelegatePersonInfo <param name="ID"></param> </summary> </member> <!-- Badly formed XML comment ignored for member "M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.postDocumentTenderUnitList(DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentProjectInfoPageSearch)" --> <member name="M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.SaveDocumentTenderUnitInfo(DocumentServiceAPI.Model.cyDocumentModel.Document_TenderUnit)"> <summary> 修改公司SaveDocumentTenderUnitInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.GetDocumentTenderUnitInfo(System.Int32)"> <summary> 获取公司GetDocumentTenderUnitInfo <param name="ID"></param> </summary> </member> <!-- Badly formed XML comment ignored for member "M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.postDocumentEmployeeInfoList(DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentProjectInfoPageSearch)" --> <member name="M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.GetDelDocumentEmployeeInfoInfo(System.Int32)"> <summary> 删除员工GetDelDocumentEmployeeInfoInfo </summary> <param name="ID"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.SaveDocumentEmployeeInfoInfo(DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO)"> <summary> 修改员工SaveDocumentEmployeeInfoInfo </summary> <param name="dp"></param> <returns></returns> </member> <member name="M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.GetDocumentEmployeeInfoInfo(System.Int32)"> <summary> 获取员工GetDocumentEmployeeInfoInfo <param name="ID"></param> </summary> </member> <!-- Badly formed XML comment ignored for member "M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.GetDocumentEmployeeInfoByName(System.String)" --> <!-- Badly formed XML comment ignored for member "M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.GetDocumentEmployeeInfoByLoginName(System.String)" --> <!-- Badly formed XML comment ignored for member "M:DocumentServiceAPI.Application.ProjectInfo.SheZhiController.postDocumentPerformanceInfoListByPaper(DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentProjectInfoPageSearch)" --> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.EmployeeId"> <summary> 员工ID </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.EmployeeName"> <summary> 员工名称 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.Job"> <summary> 工作职位 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.Phone"> <summary> 电话 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.IsWork"> <summary> 是否在工作 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.LeaveTime"> <summary> 离开时间 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.CardPositive"> <summary> 证件正面 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.CardPositiveVersionNo"> <summary> 证件正面版本号 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.CardPositiveSize"> <summary> 证件正面大小 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.LastUpdateTime"> <summary> 最后更新时间 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.LastUpdateName"> <summary> 最后更新人 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.UserName"> <summary> 用户名 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.UserPassWord"> <summary> 用户密码 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.LoginTime"> <summary> 登录时间 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.IsLogin"> <summary> 是否登录 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.AdviseFlag"> <summary> 建议标志 </summary> </member> <member name="P:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO.UserId"> <summary> 用户ID </summary> </member> <member name="T:DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentProjectInfoPageSearch"> <summary> 项目搜索 参数 DocumentServiceAPI.Application/ProjectInfo/ProjectInfoController.cs
@@ -318,5 +318,237 @@ { return _projectInfoService.SaveDocumentProjectDocumentInfo(dp); } /// <summary> /// 获取项目GetDelegatePersonInfo /// <param name="ID"></param> /// </summary> public Document_DelegatePersonInfo GetDelegatePersonInfo(int ID) { return _projectInfoService.GetDelegatePersonInfo(ID); } /// <summary> /// 修改项目SaveDocumentProjectOppugnInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentProjectOppugnInfo(Document_ProjectOppugnInfo dp) { return _projectInfoService.SaveDocumentProjectOppugnInfo(dp); } /// <summary> /// 获取项目GetAllDelegatePerson /// </summary> public List<Document_DelegatePersonInfo> GetAllDelegatePerson() { return _projectInfoService.GetAllDelegatePerson(); } /// <summary> /// 修改项目SaveDocumentProjectComplainInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentProjectComplainInfo(Document_ProjectComplainInfo dp) { return _projectInfoService.SaveDocumentProjectComplainInfo(dp); } /// <summary> /// 修改项目SaveDocumentProjectReviewInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentProjectReviewInfo(Document_ProjectReviewInfo dp) { return _projectInfoService.SaveDocumentProjectReviewInfo(dp); } /// <summary> /// 查询项目GetPreUnit /// </summary> /// <param name="childName"></param> /// <returns></returns> public string GetPreUnit(string childName) { return _projectInfoService.GetPreUnit(childName); } /// <summary> /// 修改项目SaveDocumentProjectLitigationInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentProjectLitigationInfo(Document_ProjectLitigationInfo dp) { return _projectInfoService.SaveDocumentProjectLitigationInfo(dp); } /// <summary> /// 修改项目SaveDocumentAdviseInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentAdviseInfo(Document_AdviseInfo dp) { return _projectInfoService.SaveDocumentAdviseInfo(dp); } /// <summary> /// 获取项目GetTempletModel /// <param name="templetId"></param> /// </summary> public Document_DocumentTempletInfo GetTempletModel(int templetId) { return _projectInfoService.GetTempletModel(templetId); } /// <summary> /// 获取项目GetDocumentTempletList /// </summary> public List<Document_DocumentTempletInfo> GetDocumentTempletList() { return _projectInfoService.GetDocumentTempletList(); } /// <summary> /// 获取招标文件列表postDocumentZhaobiaoFileList /// </summary> /// <param name="page"></param> /// <returns></returns> public PageResult<Document_ZhaobiaoFile> postDocumentZhaobiaoFileList(DocumentProjectInfoPageSearch page) { return _projectInfoService.postDocumentZhaobiaoFileList(page); } /// <summary> /// 修改招标文件SaveDocumentZhaobiaoFileInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentZhaobiaoFileInfo(Document_ZhaobiaoFile dp) { return _projectInfoService.SaveDocumentZhaobiaoFileInfo(dp); } /// <summary> /// 删除项目GetDeleteDocumentZhaobiaoFile /// </summary> /// <param name="ID"></param> /// <returns></returns> public bool GetDeleteDocumentZhaobiaoFile(int ID) { return _projectInfoService.GetDeleteDocumentZhaobiaoFile(ID); } /// <summary> /// 获取项目GetDocumentZhaobiaoFileInfo /// <param name="ID"></param> /// </summary> public Document_ZhaobiaoFile GetDocumentZhaobiaoFileInfo(int ID) { return _projectInfoService.GetDocumentZhaobiaoFileInfo(ID); } /// <summary> /// 获取响应文件列表postDocumentTBXYFileList /// </summary> /// <param name="page"></param> /// <returns></returns> public PageResult<Document_TBXYFile> postDocumentTBXYFileList(DocumentProjectInfoPageSearch page) { return _projectInfoService.postDocumentTBXYFileList(page); } /// <summary> /// 修改响应文件SaveDocumentTBXYFileInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentTBXYFileInfo(Document_TBXYFile dp) { return _projectInfoService.SaveDocumentTBXYFileInfo(dp); } /// <summary> /// 删除响应文件GetDeleteDocumentTBXYFile /// </summary> /// <param name="ID"></param> /// <returns></returns> public bool GetDeleteDocumentTBXYFile(int ID) { return _projectInfoService.GetDeleteDocumentTBXYFile(ID); } /// <summary> /// 获取响应文件GetDocumentTBXYFileInfo /// <param name="ID"></param> /// </summary> public Document_TBXYFile GetDocumentTBXYFileInfo(int ID) { return _projectInfoService.GetDocumentTBXYFileInfo(ID); } /// <summary> /// 获取响应文件GetDocumentTBXYFileInfo /// <param name="ID"></param> /// </summary> public List<Document_TBXYFile> GetDocumentTBXYFileList(int projectId, int unitId) { return _projectInfoService.GetDocumentTBXYFileList(projectId, unitId); } /// <summary> /// 获取响应文件GetDocumentTBXYFileInfo /// <param name="ID"></param> /// </summary> public Document_TBXYFile GetDocumentTBXYFileByFileName(int projectId, int unitId, string FileName) { return _projectInfoService.GetDocumentTBXYFileByFileName(projectId, unitId, FileName); } /// <summary> /// 修改响应文件SaveDocumentTBXYFileInfo /// </summary> /// <param name="dp"></param> /// <returns>int</returns> public int SaveDocInfo(Doc_Info dp) { return _projectInfoService.SaveDocInfo(dp); } /// <summary> /// 修改响应文件SaveDocumentTBXYFileInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveFileInfo(File_Info dp) { return _projectInfoService.SaveFileInfo(dp); } } } DocumentServiceAPI.Application/ProjectInfo/Services/Interfaces/IProjectInfoService.cs
@@ -70,6 +70,51 @@ public bool SaveDocumentProjectDocumentInfo(Document_ProjectDocumentInfo dp); public Document_DelegatePersonInfo GetDelegatePersonInfo(int ID); public bool SaveDocumentProjectOppugnInfo(Document_ProjectOppugnInfo dp); public List<Document_DelegatePersonInfo> GetAllDelegatePerson(); public bool SaveDocumentProjectComplainInfo(Document_ProjectComplainInfo dp); public bool SaveDocumentProjectReviewInfo(Document_ProjectReviewInfo dp); public string GetPreUnit(string childName); public bool SaveDocumentProjectLitigationInfo(Document_ProjectLitigationInfo dp); public bool SaveDocumentAdviseInfo(Document_AdviseInfo dp); public Document_DocumentTempletInfo GetTempletModel(int templetId); public List<Document_DocumentTempletInfo> GetDocumentTempletList(); public PageResult<Document_ZhaobiaoFile> postDocumentZhaobiaoFileList(DocumentProjectInfoPageSearch page); public Document_ZhaobiaoFile GetDocumentZhaobiaoFileInfo(int ID); public bool GetDeleteDocumentZhaobiaoFile(int ID); public bool SaveDocumentZhaobiaoFileInfo(Document_ZhaobiaoFile dp); public PageResult<Document_TBXYFile> postDocumentTBXYFileList(DocumentProjectInfoPageSearch page); public Document_TBXYFile GetDocumentTBXYFileInfo(int ID); public bool GetDeleteDocumentTBXYFile(int ID); public bool SaveDocumentTBXYFileInfo(Document_TBXYFile dp); public List<Document_TBXYFile> GetDocumentTBXYFileList(int projectId, int unitId); public Document_TBXYFile GetDocumentTBXYFileByFileName(int projectId, int unitId,string FileName); public int SaveDocInfo(Doc_Info dp); public bool SaveFileInfo(File_Info dp); } } DocumentServiceAPI.Application/ProjectInfo/Services/Interfaces/ISheZhiService.cs
New file @@ -0,0 +1,48 @@ using DocumentServiceAPI.Application.ProjectInfo.ViewMode; using DocumentServiceAPI.Model.cyDocumentModel; using DocumentServiceAPI.Utility; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace DocumentServiceAPI.Application.ProjectInfo.Services.Interfaces { public interface ISheZhiService { public PageResult<Document_DelegatePersonInfo> postDelegatePersonList(DocumentProjectInfoPageSearch page); public bool GetDelDocumentDelegatePersonInfo(int ID); public bool SaveDocumentDelegatePersonInfo(Document_DelegatePersonInfo dp); public Document_DelegatePersonInfo GetDocumentDelegatePersonInfo(int ID); public PageResult<Document_TenderUnit> postDocumentTenderUnitList(DocumentProjectInfoPageSearch page); public bool SaveDocumentTenderUnitInfo(Document_TenderUnit dp); public Document_TenderUnit GetDocumentTenderUnitInfo(int ID); public PageResult<DocumentEmployeeInfoDTO> postDocumentEmployeeInfoList(DocumentProjectInfoPageSearch page); public bool GetDelDocumentEmployeeInfoInfo(int ID); public bool SaveDocumentEmployeeInfoInfo(DocumentEmployeeInfoDTO dp); public DocumentEmployeeInfoDTO GetDocumentEmployeeInfoInfo(int ID); public Document_EmployeeInfo GetDocumentEmployeeInfoByName(string EmployeeName); public Document_EmployeeInfo GetDocumentEmployeeInfoByLoginName(string textUserName); public PageResult<Document_PerformanceInfo> GetDocumentPerformanceInfoListByPaper(DocumentProjectInfoPageSearch page); } } DocumentServiceAPI.Application/ProjectInfo/Services/ProjectInfoService.cs
@@ -24,6 +24,7 @@ using SqlSugar.Extensions; using System; using System.Collections.Generic; using System.Data; using System.Diagnostics.Metrics; using System.Linq; using System.Reflection.Metadata; @@ -818,11 +819,11 @@ if (documentProjectInfoDTO.IsAdvise == 1) { documentProjectInfoDTO.Advise = "√"; documentProjectInfoDTO.Advise = "方案保存";// "√"; } else { documentProjectInfoDTO.Advise = ""; documentProjectInfoDTO.Advise = "方案保存"; } if (!string.IsNullOrEmpty(documentProjectInfoDTO.FilePathzy)) @@ -957,7 +958,117 @@ public Document_WinInfo GetDocument_WinInfo(int ID, int UnitId) { var aaa = GetJwtInfo(); var ret = _db.Queryable<Document_WinInfo>().Where(x => x.ProjectId == ID && x.UnitId == UnitId ).First(); if (ret == null || string.IsNullOrEmpty(ret.FirstWinCompany)) { var projectInfo = _db.Queryable<Document_ProjectInfo>().Where(x => x.ProjectId == ID && x.TenantID == aaa.TEID).First(); if (projectInfo != null) { _db.AsTenant().ChangeDatabase("zhengcaioa"); var sss = _db.Ado.GetDataTable("select [Id] ,[start_time] ,[sheng] ,[city] ,[area_id] ,[cgfs] ,[number] ,[name] from Project where number=@number", new { number = projectInfo.ProjectCode }); if(sss!=null && sss.Rows.Count > 0) { ret = new Document_WinInfo(); ret.ProjectId = ID; ret.UnitId = UnitId; ret.IsWin = 0; foreach (DataRow row in sss.Rows) { var aaaaaaaa = _db.Ado.GetDataTable("select [zhongbiaoId] ,[ProjectId] ,[names] ,[price] ,[defen] ,[zb_zhiyistatus] ,[zb_zhiyishijian] ,[zb_zhiyichengli] ,[zb_tousustatus] ,[zb_tousushijian] ,[zb_tousuchengli] from Projectzhongbiao where ProjectId=@ProjectId", new { ProjectId = Convert.ToString(row["Id"]).Trim() }); if (aaaaaaaa != null && aaaaaaaa.Rows.Count > 0) { int i = 0; foreach (DataRow row0 in aaaaaaaa.Rows) { if (i == 0) { ret.FirstWinCompany = Convert.ToString(row0["names"]).Trim(); if(row0["price"]!=null && !string.IsNullOrEmpty(row0["price"].ToString())) { string price = row0["price"].ToString().Trim().Replace("元", "").Replace("万", ""); decimal priceprice = 0; if(decimal.TryParse(price,out priceprice)) { ret.FirstPrice = priceprice; } } ret.FirstWinDefen = Convert.ToString(row0["defen"]).Trim(); } if (i == 1) { ret.SecondWinCompany = Convert.ToString(row0["names"]).Trim(); if (row0["price"] != null && !string.IsNullOrEmpty(row0["price"].ToString())) { string price = row0["price"].ToString().Trim().Replace("元", "").Replace("万", ""); decimal priceprice = 0; if (decimal.TryParse(price, out priceprice)) { ret.SecondPrice = priceprice; } } ret.SecondWinDefen = Convert.ToString(row0["defen"]).Trim(); } if (i == 2) { ret.ThirdCompany = Convert.ToString(row0["names"]).Trim(); if (row0["price"] != null && !string.IsNullOrEmpty(row0["price"].ToString())) { string price = row0["price"].ToString().Trim().Replace("元", "").Replace("万", ""); decimal priceprice = 0; if (decimal.TryParse(price, out priceprice)) { ret.ThirdPrice = priceprice; } } ret.ThirdWinDefen = Convert.ToString(row0["defen"]).Trim(); } i += 1; } //if (aaaaaaaa.Rows.Count > 0) //{ // DataRow row0 = aaaaaaaa.Rows[0]; // ret.FirstWinCompany = Convert.ToString(row0.ItemArray[2]).Trim(); // ret.FirstPrice = Convert.ToDecimal(row0.ItemArray[3]); // ret.FirstWinDefen = Convert.ToString(row0.ItemArray[4]).Trim(); //} //if (aaaaaaaa.Rows.Count > 1) //{ // DataRow row1 = aaaaaaaa.Rows[1]; // ret.SecondWinCompany = Convert.ToString(row1.ItemArray[2]).Trim(); // ret.SecondPrice = Convert.ToDecimal(row1.ItemArray[3]); // ret.SecondWinDefen = Convert.ToString(row1.ItemArray[4]).Trim(); //} //if (aaaaaaaa.Rows.Count > 2) //{ // DataRow row2 = aaaaaaaa.Rows[2]; // ret.ThirdCompany = Convert.ToString(row2.ItemArray[2]).Trim(); // ret.ThirdPrice = Convert.ToDecimal(row2.ItemArray[3]); // ret.ThirdWinDefen = Convert.ToString(row2.ItemArray[4]).Trim(); //} break; } } } } } return ret; } @@ -993,7 +1104,52 @@ public List<Document_OtherCompanyTenderInfo> GetOtherCompanyTenderInfoList(int ID, int TenantID) { var aaa = GetJwtInfo(); var ret = _db.Queryable<Document_OtherCompanyTenderInfo>().Where(x => x.ProjectId == ID && x.TenantID == TenantID).ToList(); if (ret == null || ret.Count==0) { var projectInfo = _db.Queryable<Document_ProjectInfo>().Where(x => x.ProjectId == ID && x.TenantID == TenantID).First(); if (projectInfo != null) { _db.AsTenant().ChangeDatabase("zhengcaioa"); var sss = _db.Ado.GetDataTable("select [Id] ,[start_time] ,[sheng] ,[city] ,[area_id] ,[cgfs] ,[number] ,[name] from Project where number=@number", new { number = projectInfo.ProjectCode }); if (sss != null && sss.Rows.Count > 0) { ret = new List<Document_OtherCompanyTenderInfo>(); foreach (DataRow row in sss.Rows) { var aaaaaaaa = _db.Ado.GetDataTable("select [youxiaoId] ,[ProjectId] ,[namesyouxiao] ,[priceyouxiao] ,[yx_zhiyistatus] ,[yx_zhiyishijian] ,[yx_zhiyichengli] ,[yx_tousustatus] ,[yx_tousushijian] ,[yx_tousuchengli] from Projectyouxiao where ProjectId=@ProjectId", new { ProjectId = Convert.ToString(row["Id"]).Trim() }); if (aaaaaaaa != null && aaaaaaaa.Rows.Count > 0) { foreach (DataRow row0 in aaaaaaaa.Rows) { Document_OtherCompanyTenderInfo document_OtherCompanyTenderInfo = new Document_OtherCompanyTenderInfo(); document_OtherCompanyTenderInfo.ProjectId = ID; document_OtherCompanyTenderInfo.CompanyName = Convert.ToString(row0["namesyouxiao"]).Trim(); if (row0["priceyouxiao"] != null && !string.IsNullOrEmpty(row0["priceyouxiao"].ToString())) { string price = row0["priceyouxiao"].ToString().Trim().Replace("元", "").Replace("万", ""); decimal priceprice = 0; if (decimal.TryParse(price, out priceprice)) { document_OtherCompanyTenderInfo.TenderPrice = priceprice; } } document_OtherCompanyTenderInfo.TenantID = TenantID; ret.Add(document_OtherCompanyTenderInfo); } break; } } } } } return ret; } public Document_OtherCompanyTenderInfo GetOtherCompanyTenderInfo(int ID, string companyName) @@ -1109,9 +1265,54 @@ public List<Document_AptitudeInfo> GetAptitudeInfoByUnitId(int UnitId) { var result = _db.Queryable<Document_AptitudeInfo>().Where( x=> x.UnitId == UnitId).ToList() ;//执行查询 var result = _db.Queryable<Doc_Info>().Where( x=>x.is_del == false && x.org_id == UnitId).ToList() ;//执行查询 return result; var ids = result.Select(x => x.id).ToArray(); var file = _db.Queryable<File_Info>().Where(x => ids.Contains(x.doc_id)).ToList();//执行查询 var document_AptitudeInfos = new List<Document_AptitudeInfo>(); foreach (var doc_Info in result) { var document_AptitudeInfo = new Document_AptitudeInfo(); var filesss = file.Where(x => x.doc_id == doc_Info.id).ToList(); if(filesss!=null && filesss.Count > 0) { document_AptitudeInfo.FilePath = ""; document_AptitudeInfo.FileName = ""; document_AptitudeInfo.FileSize = 0; for (int i=0;i< filesss.Count; i++) { document_AptitudeInfo.FilePath += filesss[i].filepath; document_AptitudeInfo.FileName += filesss[i].filenewname; document_AptitudeInfo.FileSize += filesss[i].filesize; ; if (i!= filesss.Count - 1) { document_AptitudeInfo.FilePath += ";"; document_AptitudeInfo.FileName += ";"; } } } document_AptitudeInfo.AptitudeId = doc_Info.id; document_AptitudeInfo.AptitudeName = doc_Info.doc_name; document_AptitudeInfo.AptitudeType = doc_Info.classification_id; document_AptitudeInfo.IsUsed = doc_Info.status; document_AptitudeInfo.FileVersionNo = ""; document_AptitudeInfo.SendTime = doc_Info.add_time.ToShortDateString(); document_AptitudeInfo.UnitId = doc_Info.org_id.HasValue ? doc_Info.org_id.Value : 0; ; document_AptitudeInfo.LastUpdateTime = doc_Info.add_time; document_AptitudeInfo.LastUpdateName = ""; document_AptitudeInfo.AdviseFlag = 1; document_AptitudeInfo.UserId = doc_Info.tenant_code; document_AptitudeInfos.Add(document_AptitudeInfo); } return document_AptitudeInfos; } @@ -1231,5 +1432,358 @@ return true; } public Document_DelegatePersonInfo GetDelegatePersonInfo(int ID) { var ret = _db.Queryable<Document_DelegatePersonInfo>().Where(x => x.DelegateId == ID).First(); return ret; } public bool SaveDocumentProjectOppugnInfo(Document_ProjectOppugnInfo dp) { if (dp.ID > 0) { _db.Updateable<Document_ProjectOppugnInfo>(dp).ExecuteCommand(); } else { _db.Insertable<Document_ProjectOppugnInfo>(dp).ExecuteCommand(); } return true; } public List<Document_DelegatePersonInfo> GetAllDelegatePerson() { var a = GetJwtInfo(); var result = _db.Queryable<Document_DelegatePersonInfo>().Where(x => x.IsUse == 1 && x.TenantID == a.TEID ).ToList();//执行查询 return result; } public bool SaveDocumentProjectComplainInfo(Document_ProjectComplainInfo dp) { if (dp.ID > 0) { _db.Updateable<Document_ProjectComplainInfo>(dp).ExecuteCommand(); } else { _db.Insertable<Document_ProjectComplainInfo>(dp).ExecuteCommand(); } return true; } public bool SaveDocumentProjectReviewInfo(Document_ProjectReviewInfo dp) { if (dp.ID > 0) { _db.Updateable<Document_ProjectReviewInfo>(dp).ExecuteCommand(); } else { _db.Insertable<Document_ProjectReviewInfo>(dp).ExecuteCommand(); } return true; } public string GetPreUnit(string childName) { string preUnit = ""; Sys_CitySite preModel = null; var m_Sys_CitySite = _db.Queryable<Sys_CitySite>().Where(x => x.Name == childName).First();//执行查询 if (m_Sys_CitySite != null) { if (m_Sys_CitySite.CityLevel == 3) { preModel = _db.Queryable<Sys_CitySite>().Where(x=>x.Keyid == m_Sys_CitySite.CityId).First(); } else if (m_Sys_CitySite.CityLevel == 2) { preModel = _db.Queryable<Sys_CitySite>().Where(x => x.Keyid == m_Sys_CitySite.ProvinceId).First(); } else { preModel = m_Sys_CitySite; } } if (preModel != null) { preUnit = preModel.Name; } return preUnit; } public bool SaveDocumentProjectLitigationInfo(Document_ProjectLitigationInfo dp) { if (dp.ID > 0) { _db.Updateable<Document_ProjectLitigationInfo>(dp).ExecuteCommand(); } else { _db.Insertable<Document_ProjectLitigationInfo>(dp).ExecuteCommand(); } return true; } public bool SaveDocumentAdviseInfo(Document_AdviseInfo dp) { { if (dp.Id > 0) { _db.Updateable<Document_AdviseInfo>(dp).ExecuteCommand(); } else { _db.Insertable<Document_AdviseInfo>(dp).ExecuteCommand(); } return true; } } public Document_DocumentTempletInfo GetTempletModel(int templetId) { var ret = _db.Queryable<Document_DocumentTempletInfo>().Where(x => x.TempletId == templetId).First(); return ret; } public List<Document_DocumentTempletInfo> GetDocumentTempletList() { var result = _db.Queryable<Document_DocumentTempletInfo>().Where(x => x.IsUsed == 1).ToList();//执行查询 return result; } public PageResult<Document_ZhaobiaoFile> postDocumentZhaobiaoFileList(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_ZhaobiaoFile> result = new PageResult<Document_ZhaobiaoFile>(); result.Items = _db.Queryable<Document_ZhaobiaoFile>() .Where(a => a.UnitId == page.UnitId && a.ProjectId == page.ProjectId) //文件名称 .WhereIF(!string.IsNullOrEmpty(page.FileName), a=>a.FileName.Contains(page.FileName)) .Select(a => new Document_ZhaobiaoFile { Id = a.Id, FileName = a.FileName, FilePath = a.FilePath, FileVersionNo = a.FileVersionNo, FileSize = a.FileSize, UnitId = a.UnitId, LastUpdateTime = a.LastUpdateTime, LastUpdateName = a.LastUpdateName, AdviseFlag = a.AdviseFlag, UserId = a.UserId, } ) .OrderByDescending(a => a.LastUpdateTime).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 Document_ZhaobiaoFile GetDocumentZhaobiaoFileInfo(int ID) { var result = _db.Queryable<Document_ZhaobiaoFile>().Where(x => x.Id == ID).First();//执行查询 return result; } public bool GetDeleteDocumentZhaobiaoFile(int ID) { _db.Deleteable<Document_ZhaobiaoFile>().Where(x => x.Id == ID).ExecuteCommand(); return true; } public bool SaveDocumentZhaobiaoFileInfo(Document_ZhaobiaoFile dp) { if (dp.Id > 0) { _db.Updateable<Document_ZhaobiaoFile>(dp).ExecuteCommand(); } else { _db.Insertable<Document_ZhaobiaoFile>(dp).ExecuteCommand(); } return true; } public PageResult<Document_TBXYFile> postDocumentTBXYFileList(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_TBXYFile> result = new PageResult<Document_TBXYFile>(); result.Items = _db.Queryable<Document_TBXYFile>() .Where(a => a.UnitId == page.UnitId && a.ProjectId == page.ProjectId) //文件名称 .WhereIF(!string.IsNullOrEmpty(page.FileName), a => a.FileName.Contains(page.FileName)) .Select(a => new Document_TBXYFile { Id = a.Id, FileName = a.FileName, FilePath = a.FilePath, FileVersionNo = a.FileVersionNo, FileSize = a.FileSize, UnitId = a.UnitId, LastUpdateTime = a.LastUpdateTime, LastUpdateName = a.LastUpdateName, AdviseFlag = a.AdviseFlag, UserId = a.UserId, Sort = a.Sort, } ) .OrderBy(a => a.Sort).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 Document_TBXYFile GetDocumentTBXYFileInfo(int ID) { var result = _db.Queryable<Document_TBXYFile>().Where(x => x.Id == ID).First();//执行查询 return result; } public bool GetDeleteDocumentTBXYFile(int ID) { _db.Deleteable<Document_TBXYFile>().Where(x => x.Id == ID).ExecuteCommand(); return true; } public bool SaveDocumentTBXYFileInfo(Document_TBXYFile dp) { var result = _db.Queryable<Document_ProjectDocumentInfo>().Where(x => x.ProjectId == dp.ProjectId && x.UnitId == dp.UnitId).First();//执行查询 if (result != null) { result.LastUpdateTime = dp.LastUpdateTime; _db.Updateable<Document_ProjectDocumentInfo>(result).ExecuteCommand(); } if (dp.Id > 0) { _db.Updateable<Document_TBXYFile>(dp).ExecuteCommand(); } else { _db.Insertable<Document_TBXYFile>(dp).ExecuteCommand(); } return true; } public List<Document_TBXYFile> GetDocumentTBXYFileList(int projectId, int unitId) { var ret = _db.Queryable<Document_TBXYFile>() .Where(x => x.ProjectId == projectId && x.UnitId == unitId) .Select(a => new Document_TBXYFile { Id = a.Id, FileName = a.FileName, FilePath = a.FilePath, FileVersionNo = a.FileVersionNo, FileSize = a.FileSize, UnitId = a.UnitId, LastUpdateTime = a.LastUpdateTime, LastUpdateName = a.LastUpdateName, AdviseFlag = a.AdviseFlag, UserId = a.UserId, Sort = a.Sort, SaveFlag = a.SaveFlag, }).OrderBy(a => a.Sort).ToList(); return ret; } public Document_TBXYFile GetDocumentTBXYFileByFileName(int projectId, int unitId, string FileName) { var ret = _db.Queryable<Document_TBXYFile>().Where(x => x.ProjectId == projectId && x.UnitId == unitId && x.FileName == FileName ).First(); return ret; } public int SaveDocInfo(Doc_Info dp) { if (dp.id > 0) { _db.Updateable<Doc_Info>(dp).ExecuteCommand(); } else { dp.id = _db.Insertable<Doc_Info>(dp).ExecuteReturnIdentity(); } return dp.id; } public bool SaveFileInfo(File_Info dp) { if (dp.id > 0) { _db.Updateable<File_Info>(dp).ExecuteCommand(); } else { _db.Insertable<File_Info>(dp).ExecuteCommand(); } return true; } } } DocumentServiceAPI.Application/ProjectInfo/Services/SheZhiService.cs
New file @@ -0,0 +1,613 @@ using DocumentServiceAPI.Application.ProjectInfo.Services.Interfaces; using DocumentServiceAPI.Application.ProjectInfo.ViewMode; using DocumentServiceAPI.Application.Repository; using DocumentServiceAPI.Model.cyDocumentModel; using DocumentServiceAPI.Model.UserInfoModel; using DocumentServiceAPI.Utility; using MapsterMapper; using Microsoft.AspNetCore.Mvc.RazorPages; using NetTaste; using SqlSugar.Extensions; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Runtime.Intrinsics.Arm; using System.Security.Claims; using System.Text; using System.Threading.Tasks; namespace DocumentServiceAPI.Application.ProjectInfo.Services { public class SheZhiService : ISheZhiService, IScoped { private ISqlSugarClient _db { get; set; } private ProjectInfoRepository _projectInfoRepository { get; set; } private IMapper _mapper { get; set; } public SheZhiService(ISqlSugarClient db, ProjectInfoRepository projectInfoRepository, IMapper mapper) { _db = db; _projectInfoRepository = projectInfoRepository; _mapper = mapper; } public PageResult<Document_DelegatePersonInfo> postDelegatePersonList(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_DelegatePersonInfo> result = new PageResult<Document_DelegatePersonInfo>(); result.Items = _db.Queryable<Document_DelegatePersonInfo>() .Where(a => a.TenantID == aaa.TEID) //文件名称 .WhereIF(!string.IsNullOrEmpty(page.delegateName), a => a.DelegateName.Contains(page.delegateName)) .WhereIF(page.isUse > 0, a => a.IsUse == page.isUse) .OrderByDescending(a => a.DelegateId).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 GetDelDocumentDelegatePersonInfo(int ID) { _db.Deleteable<Document_DelegatePersonInfo>().Where(x => x.DelegateId == ID).ExecuteCommand(); return true; } public bool SaveDocumentDelegatePersonInfo(Document_DelegatePersonInfo dp) { if (dp.DelegateId > 0) { _db.Updateable<Document_DelegatePersonInfo>(dp).ExecuteCommand(); } else { _db.Insertable<Document_DelegatePersonInfo>(dp).ExecuteCommand(); } return true; } public Document_DelegatePersonInfo GetDocumentDelegatePersonInfo(int ID) { var result = _db.Queryable<Document_DelegatePersonInfo>().Where(x => x.DelegateId == ID).First();//执行查询 return result; } public PageResult<Document_TenderUnit> postDocumentTenderUnitList(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_TenderUnit> result = new PageResult<Document_TenderUnit>(); result.Items = _db.Queryable<Document_TenderUnit>() .Where(a => a.TenantId == aaa.TEID) //文件名称 .WhereIF(!string.IsNullOrEmpty(page.delegateName), a => a.UnitName.Contains(page.delegateName)) .WhereIF(page.isUse > 0, a => a.IsUsed == page.isUse) .OrderByDescending(a => a.UnitId).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 SaveDocumentTenderUnitInfo(Document_TenderUnit dp) { if (dp.UnitId > 0) { _db.Updateable<Document_TenderUnit>(dp).ExecuteCommand(); } else { _db.Insertable<Document_TenderUnit>(dp).ExecuteCommand(); } return true; } public Document_TenderUnit GetDocumentTenderUnitInfo(int ID) { var result = _db.Queryable<Document_TenderUnit>().Where(x => x.UnitId == ID).First();//执行查询 return result; } public PageResult<DocumentEmployeeInfoDTO> postDocumentEmployeeInfoList(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<DocumentEmployeeInfoDTO> result = new PageResult<DocumentEmployeeInfoDTO>(); var document_EmployeeInfos = _db.Queryable<Document_EmployeeInfo, EmployeeAtTenant>((a, b) => new JoinQueryInfos ( JoinType.Inner, a.EmployeeId == b.EmployeeID && b.TenantID == aaa.TEID ) ) //文件名称 .WhereIF(!string.IsNullOrEmpty(page.txtName), (a, b) => a.EmployeeName.Contains(page.txtName)) .OrderByDescending((a, b) => a.EmployeeId).ToPageList(page.PageIndex, page.PageSize, ref total); var documentEmployeeInfoDTOs = _mapper.Map<List<DocumentEmployeeInfoDTO>>(document_EmployeeInfos); if (documentEmployeeInfoDTOs != null && documentEmployeeInfoDTOs.Count > 0) { var ret = _db.Queryable<Document_EmployeeRole>().ToList(); foreach (var documentEmployeeInfoDTO in documentEmployeeInfoDTOs) { if (documentEmployeeInfoDTO.IsWork.HasValue && documentEmployeeInfoDTO.IsWork.Value>0) { documentEmployeeInfoDTO.IsWorkName = "在职"; } else { documentEmployeeInfoDTO.IsWorkName = "离职"; } if (documentEmployeeInfoDTO.IsWork.HasValue && documentEmployeeInfoDTO.IsWork.Value == 1) { documentEmployeeInfoDTO.LeaveTimeName = ""; } else { if (documentEmployeeInfoDTO.LeaveTime.HasValue) { documentEmployeeInfoDTO.LeaveTimeName = documentEmployeeInfoDTO.LeaveTime.Value.ToString("yyyy-MM-dd"); } else { documentEmployeeInfoDTO.LeaveTimeName = ""; } } var document_EmployeeRole = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 1).FirstOrDefault(); if(document_EmployeeRole != null) { documentEmployeeInfoDTO.BMRID = "是"; } else { documentEmployeeInfoDTO.BMRID = "否"; } var document_EmployeeRole1 = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 2).FirstOrDefault(); if (document_EmployeeRole1 != null) { documentEmployeeInfoDTO.BSZZRID = "是"; } else { documentEmployeeInfoDTO.BSZZRID = "否"; } var document_EmployeeRole2 = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 3).FirstOrDefault(); if (document_EmployeeRole2 != null) { documentEmployeeInfoDTO.TBRID = "是"; } else { documentEmployeeInfoDTO.TBRID = "否"; } } } result.Items = documentEmployeeInfoDTOs; result.TotalCount = total; result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1; return result; } public bool GetDelDocumentEmployeeInfoInfo(int ID) { _db.Deleteable<EmployeeAtTenant>().Where(x => x.EmployeeID == ID).ExecuteCommand(); _db.Deleteable<Document_EmployeeRole>().Where(x => x.EmployeeId == ID).ExecuteCommand(); _db.Deleteable<Document_EmployeeInfo>().Where(x => x.EmployeeId == ID).ExecuteCommand(); return true; } public bool SaveDocumentEmployeeInfoInfo(DocumentEmployeeInfoDTO dp) { var document_EmployeeInfo = _mapper.Map<Document_EmployeeInfo>(dp); if (dp.EmployeeId > 0) { _db.Updateable<Document_EmployeeInfo>(document_EmployeeInfo).ExecuteCommand(); } else { var aaa = GetJwtInfo(); dp.EmployeeId = _db.Insertable<Document_EmployeeInfo>(document_EmployeeInfo).ExecuteReturnIdentity(); EmployeeAtTenant employeeAtTenant = new EmployeeAtTenant(); employeeAtTenant.EmployeeID = dp.EmployeeId; employeeAtTenant.TenantID = aaa.TEID.Value; _db.Insertable<EmployeeAtTenant>(employeeAtTenant).ExecuteCommand(); } if (!string.IsNullOrEmpty(dp.BMRID) && !string.IsNullOrEmpty(dp.BSZZRID) && !string.IsNullOrEmpty(dp.TBRID)) { _db.Deleteable<Document_EmployeeRole>().Where(x => x.EmployeeId == dp.EmployeeId).ExecuteCommand(); if (dp.BMRID == "是") { Document_EmployeeRole document_EmployeeRole = new Document_EmployeeRole(); document_EmployeeRole.EmployeeId = dp.EmployeeId; document_EmployeeRole.RoleType = 1; _db.Insertable<Document_EmployeeRole>(document_EmployeeRole).ExecuteCommand(); } if (dp.BSZZRID == "是") { Document_EmployeeRole document_EmployeeRole = new Document_EmployeeRole(); document_EmployeeRole.EmployeeId = dp.EmployeeId; document_EmployeeRole.RoleType = 2; _db.Insertable<Document_EmployeeRole>(document_EmployeeRole).ExecuteCommand(); } if (dp.TBRID == "是") { Document_EmployeeRole document_EmployeeRole = new Document_EmployeeRole(); document_EmployeeRole.EmployeeId = dp.EmployeeId; document_EmployeeRole.RoleType = 3; _db.Insertable<Document_EmployeeRole>(document_EmployeeRole).ExecuteCommand(); } } return true; } public DocumentEmployeeInfoDTO GetDocumentEmployeeInfoInfo(int ID) { var result = _db.Queryable<Document_EmployeeInfo>().Where(x => x.EmployeeId == ID).First();//执行查询 var documentEmployeeInfoDTO = _mapper.Map<DocumentEmployeeInfoDTO>(result); if (documentEmployeeInfoDTO != null ) { var ret = _db.Queryable<Document_EmployeeRole>().ToList(); if (documentEmployeeInfoDTO.IsWork.HasValue && documentEmployeeInfoDTO.IsWork.Value > 0) { documentEmployeeInfoDTO.IsWorkName = "在职"; } else { documentEmployeeInfoDTO.IsWorkName = "离职"; } if (documentEmployeeInfoDTO.IsWork.HasValue && documentEmployeeInfoDTO.IsWork.Value == 1) { documentEmployeeInfoDTO.LeaveTimeName = ""; } else { if (documentEmployeeInfoDTO.LeaveTime.HasValue) { documentEmployeeInfoDTO.LeaveTimeName = documentEmployeeInfoDTO.LeaveTime.Value.ToString("yyyy-MM-dd"); } else { documentEmployeeInfoDTO.LeaveTimeName = ""; } } var document_EmployeeRole = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 1).FirstOrDefault(); if (document_EmployeeRole != null) { documentEmployeeInfoDTO.BMRID = "是"; } else { documentEmployeeInfoDTO.BMRID = "否"; } var document_EmployeeRole1 = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 2).FirstOrDefault(); if (document_EmployeeRole1 != null) { documentEmployeeInfoDTO.BSZZRID = "是"; } else { documentEmployeeInfoDTO.BSZZRID = "否"; } var document_EmployeeRole2 = ret.Where(x => x.EmployeeId == documentEmployeeInfoDTO.EmployeeId && x.RoleType == 3).FirstOrDefault(); if (document_EmployeeRole2 != null) { documentEmployeeInfoDTO.TBRID = "是"; } else { documentEmployeeInfoDTO.TBRID = "否"; } } return documentEmployeeInfoDTO; } public Document_EmployeeInfo GetDocumentEmployeeInfoByName(string EmployeeName) { var aaa = GetJwtInfo(); var documentEmployeeInfoDTO = _db.Queryable<Document_EmployeeInfo, EmployeeAtTenant>((a, b) => new JoinQueryInfos ( JoinType.Inner, a.EmployeeId == b.EmployeeID && b.TenantID == aaa.TEID ) ) //文件名称 .Where((a, b) => a.EmployeeName == EmployeeName).First(); return documentEmployeeInfoDTO; } public Document_EmployeeInfo GetDocumentEmployeeInfoByLoginName(string textUserName) { var aaa = GetJwtInfo(); var documentEmployeeInfoDTO = _db.Queryable<Document_EmployeeInfo, EmployeeAtTenant>((a, b) => new JoinQueryInfos ( JoinType.Inner, a.EmployeeId == b.EmployeeID && b.TenantID == aaa.TEID ) ) //文件名称 .Where((a, b) => a.UserName == textUserName).First(); return documentEmployeeInfoDTO; } public PageResult<Document_PerformanceInfo> GetDocumentPerformanceInfoListByPaper(DocumentProjectInfoPageSearch page) { var aaa = GetJwtInfo(); List<Document_PerformanceInfo> m_Document_PerformanceInfoList = new List<Document_PerformanceInfo>(); SqlSugar.PageModel pg = new SqlSugar.PageModel(); pg.PageSize = page.PageSize; pg.PageIndex = page.PageIndex; //page.ToEmployeeId = a.EID; int total = 0; PageResult<Document_PerformanceInfo> result = new PageResult<Document_PerformanceInfo>(); DateTime txtWorkStartTime = string.IsNullOrEmpty(page.txtWorkStartTime) ? DateTime.MinValue : DateTime.Parse(page.txtWorkStartTime); DateTime txtWorkEndTime = string.IsNullOrEmpty(page.txtWorkEndTime) ? DateTime.MaxValue : DateTime.Parse(page.txtWorkEndTime); var dt_Signup = _db.Queryable<Document_ProjectExpand, Document_ProjectInfo>((a, b) => new JoinQueryInfos ( JoinType.Inner, a.ProjectId == b.ProjectId && b.TenantID == aaa.TEID ) ) .Where((a, b) => a.IsSignup == 1) //文件名称 .WhereIF(!string.IsNullOrEmpty(page.txtWorkStartTime), (a, b) => a.SignupTime >= txtWorkStartTime) .WhereIF(!string.IsNullOrEmpty(page.txtWorkEndTime), (a, b) => a.SignupTime <= txtWorkEndTime) .WhereIF(!string.IsNullOrEmpty(page.txtEmployeeId) && page.txtEmployeeId != "请选择" , (a, b) => a.SignupPerson == page.txtEmployeeId) .WhereIF(!string.IsNullOrEmpty(page.projectName), (a, b) => b.ProjectName.Contains(page.projectName)) .WhereIF(!string.IsNullOrEmpty(page.txtWorkItem), (a, b) => "报名" == page.txtWorkItem) .Select((a, b) =>new Document_PerformanceInfo { WorkTime = a.SignupTime, EmployeeName = a.SignupPerson, Price = a.SignupAllowance, ProjectName = b.ProjectName, WorkItem = "报名", }).ToList() ; var dt_Document = _db.Queryable<Document_ProjectExpand, Document_ProjectInfo, Document_ProjectDocumentInfo>((a, b,c) => new JoinQueryInfos ( JoinType.Inner, a.ProjectId == b.ProjectId && b.TenantID == aaa.TEID, JoinType.Left, a.ProjectId == c.ProjectId ) ) .Where((a, b, c) => a.DocumentStatus == 17) //文件名称 .WhereIF(!string.IsNullOrEmpty(page.txtWorkStartTime), (a, b, c) => c.LastUpdateTime >= txtWorkStartTime) .WhereIF(!string.IsNullOrEmpty(page.txtWorkEndTime), (a, b, c) => c.LastUpdateTime <= txtWorkEndTime) .WhereIF(!string.IsNullOrEmpty(page.txtEmployeeId) && page.txtEmployeeId != "请选择", (a, b) => a.DocumentManager == page.txtEmployeeId) .WhereIF(!string.IsNullOrEmpty(page.projectName), (a, b, c) => b.ProjectName.Contains(page.projectName)) .WhereIF(!string.IsNullOrEmpty(page.txtWorkItem), (a, b, c) => "标书制作" == page.txtWorkItem) .Select((a, b, c) => new Document_PerformanceInfo { WorkTime = c.LastUpdateTime, EmployeeName = a.DocumentManager, Price = a.DocumentPrice, ProjectName = b.ProjectName, WorkItem = "标书制作", }).ToList() ; var dt_Tender = _db.Queryable<Document_ProjectExpand, Document_ProjectInfo>((a, b) => new JoinQueryInfos ( JoinType.Inner, a.ProjectId == b.ProjectId && b.TenantID == aaa.TEID ) ) .Where((a, b) => a.TenderStatus == 1) //文件名称 .WhereIF(!string.IsNullOrEmpty(page.txtWorkStartTime), (a, b) => b.TenderTime >= txtWorkStartTime) .WhereIF(!string.IsNullOrEmpty(page.txtWorkEndTime), (a, b) => b.TenderTime <= txtWorkEndTime) .WhereIF(!string.IsNullOrEmpty(page.txtEmployeeId) && page.txtEmployeeId != "请选择", (a, b) => a.TenderPerson == page.txtEmployeeId) .WhereIF(!string.IsNullOrEmpty(page.projectName), (a, b) => b.ProjectName.Contains(page.projectName)) .WhereIF(!string.IsNullOrEmpty(page.txtWorkItem), (a, b) => "投标" == page.txtWorkItem) .Select((a, b) => new Document_PerformanceInfo { WorkTime = b.TenderTime, EmployeeName = a.DocumentManager, Price = a.DocumentPrice, ProjectName = b.ProjectName, WorkItem = "投标", }).ToList(); var newDataTable = new List<Document_PerformanceInfo>(); object[] obj = new object[newDataTable.Count]; for (int i = 0; i < dt_Signup.Count; i++) { newDataTable.Add(dt_Signup[i]); } for (int i = 0; i < dt_Document.Count; i++) { newDataTable.Add(dt_Document[i]); } for (int i = 0; i < dt_Tender.Count; i++) { newDataTable.Add(dt_Tender[i]); } for (int i = 0; i < newDataTable.Count; i++) { Document_PerformanceInfo m_Document_PerformanceInfo = new Document_PerformanceInfo(); m_Document_PerformanceInfo.EmployeeId = 0; m_Document_PerformanceInfo.Id = 0; m_Document_PerformanceInfo.ProjectName = newDataTable[i].ProjectName; m_Document_PerformanceInfo.WorkItem = newDataTable[i].WorkItem; if (newDataTable[i].Price.HasValue) { m_Document_PerformanceInfo.Price = newDataTable[i].Price; } else { m_Document_PerformanceInfo.Price = 0; } m_Document_PerformanceInfo.EmployeeName = newDataTable[i].EmployeeName; m_Document_PerformanceInfo.WorkTime = newDataTable[i].WorkTime; if (m_Document_PerformanceInfo.Price.HasValue && m_Document_PerformanceInfo.Price.Value>0) { m_Document_PerformanceInfoList.Add(m_Document_PerformanceInfo); result.AllPageMoney += m_Document_PerformanceInfo.Price.Value; } } ; //.ToPageList(page.PageIndex, page.PageSize, ref total); var document_PerformanceInfos = m_Document_PerformanceInfoList.Skip(page.PageIndex - 1).Take(page.PageSize).ToList(); foreach (var item in document_PerformanceInfos) { result.NowPageMoney += item.Price.Value; } result.Items = document_PerformanceInfos; result.TotalCount = total; result.TotalPage = total % page.PageSize == 0 ? total / page.PageSize : total / page.PageSize + 1; return result; } /// <summary> /// 获取Jwt相关信息 /// </summary> public Model.JwtInfo GetJwtInfo() { Model.JwtInfo jwtInfo = new Model.JwtInfo(); jwtInfo.LogInSource = (Model.LogInFrom)(App.User?.FindFirstValue("loginfrom")?.ObjToInt() ?? 0); jwtInfo.EID = App.User?.FindFirstValue("eid")?.ObjToInt(); jwtInfo.UID = App.User?.FindFirstValue("uid")?.ObjToInt(); jwtInfo.TEID = App.User?.FindFirstValue("teid")?.ObjToInt(); var guid = App.User?.FindFirstValue("jid"); jwtInfo.JID = string.IsNullOrEmpty(guid) ? null : new Guid(guid); return jwtInfo; } } } DocumentServiceAPI.Application/ProjectInfo/SheZhiController.cs
New file @@ -0,0 +1,176 @@ using DocumentServiceAPI.Application.ProjectInfo.Services; using DocumentServiceAPI.Application.ProjectInfo.Services.Interfaces; using DocumentServiceAPI.Application.ProjectInfo.ViewMode; using DocumentServiceAPI.Model.cyDocumentModel; using DocumentServiceAPI.Utility; using System; using System.Collections.Generic; using System.Linq; using System.Runtime.Intrinsics.Arm; using System.Text; using System.Threading.Tasks; namespace DocumentServiceAPI.Application.ProjectInfo { /// <summary> /// 登录控制器 /// </summary> [ApiDescriptionSettings("SheZhi")] [DynamicApiController] [Authorize] public class SheZhiController { private readonly ISheZhiService _sheZhiService; public SheZhiController(ISheZhiService sheZhiService) { _sheZhiService = sheZhiService; } // <summary> /// 获取代理列表postDelegatePersonList /// </summary> /// <param name="page"></param> /// <returns></returns> public PageResult<Document_DelegatePersonInfo> postDelegatePersonList(DocumentProjectInfoPageSearch page) { return _sheZhiService.postDelegatePersonList(page); } /// <summary> /// 删除项目GetDelDocumentDelegatePersonInfo /// </summary> /// <param name="Id"></param> /// <returns></returns> public bool GetDelDocumentDelegatePersonInfo(int ID) { return _sheZhiService.GetDelDocumentDelegatePersonInfo(ID); } /// <summary> /// 修改项目SaveDocumentDelegatePersonInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentDelegatePersonInfo(Document_DelegatePersonInfo dp) { return _sheZhiService.SaveDocumentDelegatePersonInfo(dp); } /// <summary> /// 获取项目GetDocumentDelegatePersonInfo /// <param name="ID"></param> /// </summary> public Document_DelegatePersonInfo GetDocumentDelegatePersonInfo(int ID) { return _sheZhiService.GetDocumentDelegatePersonInfo(ID); } // <summary> /// 获取公司postDocumentTenderUnitList /// </summary> /// <param name="page"></param> /// <returns></returns> public PageResult<Document_TenderUnit> postDocumentTenderUnitList(DocumentProjectInfoPageSearch page) { return _sheZhiService.postDocumentTenderUnitList(page); } /// <summary> /// 修改公司SaveDocumentTenderUnitInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentTenderUnitInfo(Document_TenderUnit dp) { return _sheZhiService.SaveDocumentTenderUnitInfo(dp); } /// <summary> /// 获取公司GetDocumentTenderUnitInfo /// <param name="ID"></param> /// </summary> public Document_TenderUnit GetDocumentTenderUnitInfo(int ID) { return _sheZhiService.GetDocumentTenderUnitInfo(ID); } // <summary> /// 获取员工列表postDocumentEmployeeInfoList /// </summary> /// <param name="page"></param> /// <returns></returns> public PageResult<DocumentEmployeeInfoDTO> postDocumentEmployeeInfoList(DocumentProjectInfoPageSearch page) { return _sheZhiService.postDocumentEmployeeInfoList(page); } /// <summary> /// 删除员工GetDelDocumentEmployeeInfoInfo /// </summary> /// <param name="ID"></param> /// <returns></returns> public bool GetDelDocumentEmployeeInfoInfo(int ID) { return _sheZhiService.GetDelDocumentEmployeeInfoInfo(ID); } /// <summary> /// 修改员工SaveDocumentEmployeeInfoInfo /// </summary> /// <param name="dp"></param> /// <returns></returns> public bool SaveDocumentEmployeeInfoInfo(DocumentEmployeeInfoDTO dp) { return _sheZhiService.SaveDocumentEmployeeInfoInfo(dp); } /// <summary> /// 获取员工GetDocumentEmployeeInfoInfo /// <param name="ID"></param> /// </summary> public DocumentEmployeeInfoDTO GetDocumentEmployeeInfoInfo(int ID) { return _sheZhiService.GetDocumentEmployeeInfoInfo(ID); } // <summary> /// 获取员工GetDocumentEmployeeInfoByName /// <param name="EmployeeName"></param> /// </summary> public Document_EmployeeInfo GetDocumentEmployeeInfoByName(string EmployeeName) { return _sheZhiService.GetDocumentEmployeeInfoByName(EmployeeName); } // <summary> /// 获取项目GetDocumentEmployeeInfoInfo /// <param name="textUserName"></param> /// </summary> public Document_EmployeeInfo GetDocumentEmployeeInfoByLoginName(string textUserName) { return _sheZhiService.GetDocumentEmployeeInfoByLoginName(textUserName); } // <summary> /// 获取绩效考核GetDocumentPerformanceInfoListByPaper /// </summary> /// <param name="page"></param> /// <returns></returns> public PageResult<Document_PerformanceInfo> postDocumentPerformanceInfoListByPaper(DocumentProjectInfoPageSearch page) { return _sheZhiService.GetDocumentPerformanceInfoListByPaper(page); } } } DocumentServiceAPI.Application/ProjectInfo/ViewMode/DocumentEmployeeInfoDTO.cs
New file @@ -0,0 +1,92 @@ using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace DocumentServiceAPI.Application.ProjectInfo.ViewMode { public class DocumentEmployeeInfoDTO { /// <summary> /// 员工ID /// </summary> public int EmployeeId { get; set; } /// <summary> /// 员工名称 /// </summary> public string EmployeeName { get; set; } /// <summary> /// 工作职位 /// </summary> public string Job { get; set; } /// <summary> /// 电话 /// </summary> public string Phone { get; set; } /// <summary> /// 是否在工作 /// </summary> public int? IsWork { get; set; } /// <summary> /// 离开时间 /// </summary> public DateTime? LeaveTime { get; set; } /// <summary> /// 证件正面 /// </summary> public string CardPositive { get; set; } /// <summary> /// 证件正面版本号 /// </summary> public string CardPositiveVersionNo { get; set; } /// <summary> /// 证件正面大小 /// </summary> public int? CardPositiveSize { get; set; } /// <summary> /// 最后更新时间 /// </summary> public DateTime? LastUpdateTime { get; set; } /// <summary> /// 最后更新人 /// </summary> public string LastUpdateName { get; set; } /// <summary> /// 用户名 /// </summary> public string UserName { get; set; } /// <summary> /// 用户密码 /// </summary> public string UserPassWord { get; set; } /// <summary> /// 登录时间 /// </summary> public DateTime? LoginTime { get; set; } /// <summary> /// 是否登录 /// </summary> public bool? IsLogin { get; set; } /// <summary> /// 建议标志 /// </summary> public int? AdviseFlag { get; set; } /// <summary> /// 用户ID /// </summary> public int? UserId { get; set; } public string IsWorkName { get; set; } public string LeaveTimeName { get; set; } public string BMRID { get; set; } public string BSZZRID { get; set; } public string TBRID { get; set; } } } DocumentServiceAPI.Application/ProjectInfo/ViewMode/DocumentProjectInfoDTO.cs
@@ -38,6 +38,26 @@ public int ddlLitigationStatus { get; set; } public int UnitId { get; set; } public string Experts { get; set; } public string FileName { get; set; } public int ProjectId { get; set; } public string delegateName { get; set; } public int isUse { get; set; } public string UnitName { get; set; } public int IsUsed { get; set; } public string txtName { get; set; } public string txtWorkStartTime { get; set; } public string txtWorkEndTime { get; set; } public string txtEmployeeId { get; set; } public string projectName { get; set; } public string txtWorkItem { get; set; } } public class DocumentProjectInfoDTO { DocumentServiceAPI.Application/ProjectInfo/dto/Mapper.cs
@@ -1,11 +1,13 @@ using DocumentServiceAPI.Application.ProjectInfo.ViewMode; using DocumentServiceAPI.Application.UserAndLogin.ViewMode; using DocumentServiceAPI.Application.WorkRemind.ViewMode; using DocumentServiceAPI.Model.cyDocumentModel; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using DocumentEmployeeInfoDTO = DocumentServiceAPI.Application.ProjectInfo.ViewMode.DocumentEmployeeInfoDTO; namespace DocumentServiceAPI.Application.ProjectInfo.dto { @@ -15,6 +17,9 @@ { config.ForType<Document_ProjectInfo, DocumentProjectInfoDTO>(); config.ForType<DocumentProjectInfoDTO, Document_ProjectInfo>(); config.ForType<Document_EmployeeInfo, DocumentEmployeeInfoDTO>(); config.ForType<DocumentEmployeeInfoDTO, Document_EmployeeInfo>(); } } } DocumentServiceAPI.Application/WorkRemind/Services/WorkRemindService.cs
@@ -243,7 +243,7 @@ new JoinQueryInfos ( JoinType.Left, ei.EmployeeId == et.EmployeeID, JoinType.Inner, ei.EmployeeId == et.EmployeeID && et.TenantID == a.TEID, JoinType.Left, ei.EmployeeId == er.EmployeeId ) ) DocumentServiceAPI.Model/cyDocumentModel/Document_DelegatePersonInfo.cs
@@ -107,5 +107,12 @@ /// </summary> public int? UserId {get;set;} /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? TenantID { get; set; } } } DocumentServiceAPI.Model/cyDocumentModel/Document_TBXYFile.cs
New file @@ -0,0 +1,132 @@ using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace DocumentServiceAPI.Model.cyDocumentModel { ///<summary> /// ///</summary> [SugarTable("Document_TBXYFile")] public partial class Document_TBXYFile { public Document_TBXYFile() { } /// <summary> /// Desc: /// Default: /// Nullable:False /// </summary> [SugarColumn(IsPrimaryKey = true, IsIdentity = true)] public int Id { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:False /// </summary> public string FileName { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:False /// </summary> public string FilePath { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public string FileVersionNo { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? FileSize { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:False /// </summary> public int UnitId { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public DateTime? LastUpdateTime { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public string LastUpdateName { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? AdviseFlag { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? UserId { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? ProjectId { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public string FileContent { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? Sort { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public string FileContentRTF { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? SaveFlag { get; set; } } } DocumentServiceAPI.Model/cyDocumentModel/Document_WinInfo.cs
@@ -93,5 +93,26 @@ /// </summary> public int UnitId { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public string FirstWinDefen { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public string SecondWinDefen { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public string ThirdWinDefen { get; set; } } } DocumentServiceAPI.Model/cyDocumentModel/Document_ZhaobiaoFile.cs
New file @@ -0,0 +1,99 @@ using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace DocumentServiceAPI.Model.cyDocumentModel { ///<summary> /// ///</summary> [SugarTable("Document_ZhaobiaoFile")] public partial class Document_ZhaobiaoFile { public Document_ZhaobiaoFile() { } /// <summary> /// Desc: /// Default: /// Nullable:False /// </summary> [SugarColumn(IsPrimaryKey = true, IsIdentity = true)] public int Id { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:False /// </summary> public string FileName { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:False /// </summary> public string FilePath { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public string FileVersionNo { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? FileSize { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:False /// </summary> public int UnitId { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public DateTime? LastUpdateTime { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public string LastUpdateName { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? AdviseFlag { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? UserId { get; set; } /// <summary> /// Desc: /// Default: /// Nullable:True /// </summary> public int? ProjectId { get; set; } } } DocumentServiceAPI.Utility/PageBaseSearch.cs
@@ -74,6 +74,14 @@ /// 总页数 /// </summary> public int TotalPage { get; set; } /// <summary> /// 当前页统计 /// </summary> public decimal NowPageMoney { get; set; } /// <summary> /// 所有页统计 /// </summary> public decimal AllPageMoney { get; set; } } } DocumentServiceAPI.Web.Entry/appsettings.json
@@ -12,7 +12,16 @@ { "ConfigId": "default", //多库配置ID "ConnectionString": "Server=.;Database=doc_new;User ID=sa;Password=123456;", "ConnectionString": "Server=.;Database=CY_DocumentSystemOnline;User ID=sa;Password=123456;", "DbType": "SqlServer", "IsAutoCloseConnection": true }, { "ConfigId": "zhengcaioa", //多库配置ID "ConnectionString": "Server=.;Database=zhengcaioa55;User ID=sa;Password=123456;", "DbType": "SqlServer", "IsAutoCloseConnection": true @@ -39,7 +48,7 @@ "ValidateAudience": true, // 是否验证签收方，bool 类型，默认true "ValidAudience": "www.51zhengcai.com", // 签收方，string 类型 "ValidateLifetime": true, // 是否验证过期时间，bool 类型，默认true，建议true "ExpiredTime": 20, // 过期时间，long 类型，单位分钟，默认20分钟 "ExpiredTime": 1440, // 过期时间，long 类型，单位分钟，默认20分钟 "ClockSkew": 5, // 过期时间容错值，long 类型，单位秒，默认 5秒 "Algorithm": "HS256" // 加密算法，string 类型，默认 HS256 }
