/// <summary> /// 批量删除电子协议 /// </summary> /// <param name="ids"></param> /// <returns></returns> public Result <int> DeleteProtocoByIds(List <long> ids) { Result <int> result = new Result <int>(); try { var models = DataOperateBasic <Base_Protocol> .Get().GetList(i => ids.Contains(i.Id)).ToList(); var rows = DataOperateBasic <Base_Protocol> .Get().DeleteRange(models); //删除附件 DeleteFilesByTable(models.FirstOrDefault().GetType().Name, ids); result.Data = rows; result.Flag = EResultFlag.Success; #region 写日志 WriteLog(AdminModule.DocTemplete.GetText(), SystemRight.Delete.GetText(), "批量删除电子协议:" + rows); #endregion } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "DeleteProtocoByIds"); } return(result); }
/// <summary> /// 修改电子协议 /// </summary> /// <param name="model"></param> /// <param name="fileList">附件</param> /// <returns></returns> public Result <int> UpdateProtocol(Base_Protocol model, List <Base_Files> fileList = null) { var oldModel = DataOperateBasic <Base_Protocol> .Get().GetModel(model.Id); model = FiterUpdate(oldModel, model); Result <int> result = new Result <int>(); try { var rows = DataOperateBasic <Base_Protocol> .Get().Update(model); if (fileList != null) { //删除之前的附件 DeleteFilesByTable(model.GetType().Name, new List <long>() { model.Id }); //新增附件 AddFilesByTable(model, fileList); } result.Data = rows; result.Flag = EResultFlag.Success; WriteLog(AdminModule.ElectronicAgreement.GetText(), SystemRight.Add.GetText(), "修改电子协议:" + model.Id + ":" + model.Title); } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "UpdateDocTemplete"); } return(result); }
///<summary> ///获取详情: ///</summary> /// <param name="id">数据Id</param> /// <returns>数据详情model</returns> public Result <Epm_TzSupplyMaterialApply> GetTzSupplyMaterialApplyModel(long id) { Result <Epm_TzSupplyMaterialApply> result = new Result <Epm_TzSupplyMaterialApply>(); try { var model = DataOperateBusiness <Epm_TzSupplyMaterialApply> .Get().GetModel(id); if (model != null) { long userId = model.ApprovalNameId; if (userId > 0) { var userInfo = DataOperateBasic <Base_User> .Get().GetList(t => t.ObjeId == userId.ToString()).FirstOrDefault(); if (userInfo != null) { long depId = userInfo.DepartmentId.Value; if (depId > 0) { var companyInfo = DataOperateBasic <Base_Company> .Get().GetModel(depId); if (companyInfo != null) { model.ApprovalDep = companyInfo.Name; } } var fileInfo = DataOperateBasic <Base_Files> .Get().GetList(t => t.TableId == userInfo.Id && t.TableColumn == "QM" && t.ImageType == "small").FirstOrDefault(); if (fileInfo != null) { if (!string.IsNullOrEmpty(fileInfo.Url)) { string path = ConfigurationManager.AppSettings["ResourceUrl"]; model.SignNameUrl = path + fileInfo.Url; } } } } model.TzSupMatApplyList = DataOperateBusiness <Epm_TzSupMatApplyList> .Get().GetList(t => t.SupMatApplyId == id).ToList(); if (model.TzSupMatApplyList.Count > 0) { var list = model.TzSupMatApplyList; model.TotleNum = list.Select(t => t.Number).Sum(); model.TotleMoney = list.Select(t => t.Money).Sum(); } } result.Data = model; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetTzSupplyMaterialApplyModel"); } return(result); }
public Result <int> DeleteFilesByTableIds(string tableName, List <long> tableIds) { Result <int> result = new Result <int>(); try { var models = DataOperateBasic <Base_Files> .Get().GetList(i => tableIds.Contains(i.TableId) && i.TableName == tableName).ToList(); foreach (var item in models) { item.DeleteTime = DateTime.Now; } int rows = DataOperateBasic <Base_Files> .Get().DeleteRange(models); result.Data = rows; result.Flag = EResultFlag.Success; WriteLog(BusinessType.Contract.GetText(), SystemRight.Delete.GetText(), "删除: " + rows); } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "DeleteFilesByTable"); } return(result); }
/// <summary> /// 写审核日志 /// </summary> /// <param name="model"></param> /// <param name="oldState"></param> /// <param name="newState"></param> /// <param name="user"></param> /// <returns></returns> public virtual Result <Base_StatusLog> WriteStateLog(BaseModel model, string oldState, string newState) { Result <Base_StatusLog> result = new Result <Base_StatusLog>(); try { Base_StatusLog log = new Base_StatusLog(); log.OperateUserId = CurrentUserID.ToLongReq(); log.OperateUserName = CurrentUserName; log.OldState = oldState; log.State = newState; log.TableId = model.Id; log.TableName = model.GetType().Name; var rows = DataOperateBasic <Base_StatusLog> .Get().Add(log); result.Data = log; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "WriteStateLog"); } return(result); }
public Result <CompletionAcceptanceView> GetCompletionAcceptanceModelNew(long id) { Result <CompletionAcceptanceView> result = new Result <CompletionAcceptanceView>(); try { var model = DataOperateBusiness <Epm_CompletionAcceptance> .Get().GetModel(id); if (model == null) { throw new Exception("该完工验收详情信息不存在或已被删除!"); } CompletionAcceptanceView view = new CompletionAcceptanceView(); view.CompletionAcceptance = model; view.CompletionRectifyCompanys = DataOperateBusiness <Epm_CompletionRectifyCompany> .Get() .GetList(p => p.AcceptanceId == id).ToList(); string tableName = model.GetType().Name; view.BaseFiles = DataOperateBasic <Base_Files> .Get().GetList(p => p.TableName == tableName && p.TableId == id).ToList(); result.Data = view; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetCompletionAcceptanceModelNew"); } return(result); }
///<summary> ///获取详情: ///</summary> /// <param name="id">数据Id</param> /// <returns>数据详情model</returns> public Result <ProjectApprovalView> GetProjectApprovalModel(long id) { Result <ProjectApprovalView> result = new Result <ProjectApprovalView>(); try { ProjectApprovalView view = new ProjectApprovalView(); var model = DataOperateBusiness <Epm_TzProjectPolit> .Get().GetModel(id); if (model != null) { var attachs = DataOperateBusiness <Epm_TzAttachs> .Get().GetList(i => i.DataId == id && i.TableName == "Epm_TzProjectPolit").OrderBy(p => p.Sort).ToList(); model.TzAttachs = attachs; } view.ProjectPolit = model; view.ProjectAuditRecordList = DataOperateBusiness <Epm_ProjectAuditRecord> .Get().GetList(t => t.ApprovalId == id).ToList(); view.FileList = DataOperateBasic <Base_Files> .Get().GetList(i => i.TableId == id && i.TableName == "Epm_TzProjectPolit").ToList(); result.Data = view; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetProjectApprovalModel"); } return(result); }
/// <summary> /// 类型删除 /// </summary> /// <param name="ids"></param> /// <returns></returns> public Result <int> DeleteTypeByIds(List <long> ids) { Result <int> result = new Result <int>(); try { var models = DataOperateBasic <Base_TypeDictionary> .Get().GetList(i => ids.Contains(i.Id)).ToList(); foreach (var model in models) { var list = GetTypeListByPId(model.Id); //删除对应子类型 DataOperateBasic <Base_TypeDictionary> .Get().DeleteRange(list.Data); } var rows = DataOperateBasic <Base_TypeDictionary> .Get().DeleteRange(models); result.Data = rows; result.Flag = EResultFlag.Success; #region 写日志 WriteLog(AdminModule.TypeDictionary.GetText(), SystemRight.Delete.GetText(), "批量删除类型:" + rows); #endregion } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "DeleteTypeByIds"); } return(result); }
/// <summary> /// 加载区域列表,有缓存 /// </summary> /// <param name="parentCode"></param> /// <returns></returns> public Result <List <Base_Region> > LoadRegionList(string parentCode = "") { Result <List <Base_Region> > result = new Result <List <Base_Region> >(); try { List <Base_Region> list = new List <Base_Region>(); if (!string.IsNullOrEmpty(parentCode)) { list = DataOperateBasic <Base_Region> .Get().GetList(i => i.ParentCode == parentCode).ToList(); } else { list = DataOperateBasic <Base_Region> .Get().GetList().ToList(); } result.Data = list.OrderBy(i => i.Id).ToList(); result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "LoadRegionList"); } return(result); }
/// <summary> /// 添加类型 /// </summary> /// <param name="model"></param> /// <returns></returns> public Result <int> AddType(Base_TypeDictionary model) { model = base.SetCurrentUser(model); Result <int> result = new Result <int>(); try { var rows = DataOperateBasic <Base_TypeDictionary> .Get().Add(model); if (model.Type == "MilepostType") { var list = DataOperateBusiness <Epm_Milepost> .Get().GetList(i => i.ParentId == 0 && i.IsDelete == false).ToList(); Epm_Milepost mil = new Epm_Milepost(); mil.ParentId = 0; mil.Code = model.No; mil.Name = model.Name; mil.State = 1; mil.IsDelete = false; mil = base.SetCurrentUser(mil); DataOperateBusiness <Epm_Milepost> .Get().Add(mil); } result.Data = rows; result.Flag = EResultFlag.Success; WriteLog(AdminModule.TypeDictionary.GetText(), SystemRight.Add.GetText(), "新增数据类型:" + model.Id + ":" + model.Name); } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "AddType"); } return(result); }
/// <summary> /// 修改数据类型 /// </summary> /// <param name="model"></param> /// <returns></returns> public Result <int> UpdateType(Base_TypeDictionary model) { var oldModel = DataOperateBasic <Base_TypeDictionary> .Get().GetModel(model.Id); model = FiterUpdate(oldModel, model); Result <int> result = new Result <int>(); try { var rows = DataOperateBasic <Base_TypeDictionary> .Get().Update(model); if (model.Type == "MilepostType") { var parent = DataOperateBusiness <Epm_Milepost> .Get().GetList(i => i.ParentId == 0 && i.Code == model.No && i.IsDelete == false).FirstOrDefault(); parent.Name = model.Name; DataOperateBusiness <Epm_Milepost> .Get().Update(parent); } result.Data = rows; result.Flag = EResultFlag.Success; WriteLog(AdminModule.TypeDictionary.GetText(), SystemRight.Modify.GetText(), "修改数据类型:" + model.Id + ":" + model.Name); } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "UpdateType"); } return(result); }
/// <summary> /// 修改网站设置 /// </summary> /// <param name="model"></param> /// <returns></returns> public Result <int> UpdateConfig(Base_Config model) { var oldModel = DataOperateBasic <Base_Config> .Get().GetModel(model.Id); model = FiterUpdate(oldModel, model); model.Logo = oldModel.Logo; Result <int> result = new Result <int>(); try { var rows = DataOperateBasic <Base_Config> .Get().Update(model); result.Data = rows; result.Flag = EResultFlag.Success; WriteLog(AdminModule.SystemParameter.GetText(), SystemRight.Add.GetText(), "修改网站设置:" + model.Id + ":" + model.Name); } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "UpdateConfig"); } return(result); }
/// <summary> /// 根据供应商名称获取供应商信息 /// </summary> /// <param name="companyName">供应商名称</param> public Result <Base_Company> GetCompanyByName(string companyName) { Result <Base_Company> result = new Result <Base_Company>(); BasicDataContext baseDB = new BasicDataContext(); try { var model = DataOperateBasic <Base_Company> .Get(baseDB).GetList(t => t.Name == companyName).FirstOrDefault(); result.Data = model; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetCompanyByName"); } finally { if (baseDB.Database.Connection.State == ConnectionState.Closed) { baseDB.Database.Connection.Dispose(); } } return(result); }
private Result <List <Base_User> > GetAgencyUserList(string name, List <Base_User> allUser, int pageIndex, int pageSize, IList <string> rolelist) { Result <List <Base_User> > result = new Result <List <Base_User> >(); try { var allRole = DataOperateBasic <Base_Role> .Get().GetList(t => t.IsDelete == false && t.Belong == "Owner" && rolelist.Contains(t.RoleName)).ToList(); var roleIdList = allRole.Select(t => t.Id).ToList(); var userRole = DataOperateBasic <Base_UserRole> .Get().GetList(t => t.IsDelete == false && roleIdList.Contains(t.RoleId)).ToList(); var userList = (from user in allUser join ur in userRole on user.Id equals ur.UserId where (user.UserName.Contains(name) || user.UserCode.Contains(name) || user.Phone.Contains(name)) select user).Distinct().ToList(); result.AllRowsCount = userList.Count(); userList = userList.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); result.Data = userList; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetAgencyUserList"); } return(result); }
/// <summary> /// 保存用户登录日志 注册日志 /// </summary> /// <param name="content"></param> /// <param name="user"></param> /// <returns></returns> public Result <Base_Log> WriteLoginLog(string content, Base_User user) { Result <Base_Log> result = new Result <Base_Log>(); try { Base_Log log = new Base_Log(); log.ClientIP = ApplicationContext.Current.ClientIP; log.WebServerIP = ApplicationContext.Current.WebIP; log.ServiceServerIP = ApplicationContext.Current.ServiceIP; log.ActionDesc = "用户登录"; log.ModuleName = "用户管理"; log.Contents = content; log.UserAcct = user.UserAcct; log.UserId = user.Id;//登录失败则写入id为0 log.CreateUserId = user.Id; log.CreateUserName = user.UserAcct; log.CreateTime = DateTime.Now; log.OperateUserId = user.Id; log.OperateUserName = user.UserAcct; log.OperateTime = DateTime.Now; var rows = DataOperateBasic <Base_Log> .Get().Add(log); result.Data = log; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "WriteLoginLog"); } return(result); }
/// <summary> /// 添加电子协议 /// </summary> /// <param name="model"></param> /// <param name="fileList">附件列表</param> /// <returns></returns> public Result <int> AddProtocol(Base_Protocol model, List <Base_Files> fileList) { model = base.SetCurrentUser(model); Result <int> result = new Result <int>(); try { var rows = DataOperateBasic <Base_Protocol> .Get().Add(model); //新增附件 AddFilesByTable(model, fileList); result.Data = rows; result.Flag = EResultFlag.Success; WriteLog(AdminModule.ElectronicAgreement.GetText(), SystemRight.Add.GetText(), "新增电子协议:" + model.Id + ":" + model.Title); } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "AddProtocol"); } return(result); }
/// <summary> /// 删除危险作业实景 /// </summary> /// <param name="id"></param> /// <returns></returns> public Result <int> DeleteWorkRealScenen(long id) { Result <int> result = new Result <int>(); try { var scene = DataOperateBusiness <Epm_WorkUploadRealScene> .Get().GetList(t => t.WorkId == id).FirstOrDefault(); if (scene != null) { //处理附件 string tableName = scene.GetType().Name; var files = DataOperateBasic <Base_Files> .Get().GetList(i => i.TableId == scene.Id && i.TableName == tableName).ToList(); DataOperateBasic <Base_Files> .Get().DeleteRange(files); //删除实景 DataOperateBusiness <Epm_WorkUploadRealScene> .Get().Delete(scene); //处理待办 var tempApp = DataOperateBusiness <Epm_Approver> .Get().GetList(t => t.BusinessId == id).FirstOrDefault(); DataOperateBusiness <Epm_Approver> .Get().Delete(tempApp); } } catch (Exception ex) { result.Data = -1; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "DeleteWorkRealScenenState"); } return(result); }
/// <summary> /// 添加附件 /// </summary> /// <param name="model"></param> /// <param name="fileList"></param> /// <param name="isdelete"></param> /// <returns></returns> public Result <List <Base_Files> > AddFilesByTables(string model, List <Base_Files> fileList, bool isdelete) { Result <List <Base_Files> > result = new Result <List <Base_Files> >(); if (fileList != null) { long id = 0; //新增附件 List <Base_Files> fileModels = new List <Base_Files>(); foreach (var item in fileList) { SetCurrentUser(item); item.TableId = id; item.TableName = model; fileModels.Add(item); } int rows = 0; rows = DataOperateBasic <Base_Files> .Get().AddRange(fileModels); if (rows > 0) { result.Data = fileModels; result.Flag = EResultFlag.Success; } else { result.Data = null; result.Flag = EResultFlag.Failure; } } return(result); }
/// <summary> /// 添加附件 /// </summary> /// <param name="model"></param> /// <param name="fileList"></param> /// <returns></returns> public int AddFilesByTable(BaseModel model, List <Base_Files> fileList, bool isdelete = true) { if (fileList != null) { long id = model.Id; string tableName = model.GetType().Name; //删除之前的附件 if (isdelete) { var columns = fileList.Select(i => i.TableColumn); //var oldFiles = DataOperateBasic<Base_Files>.Get().GetList(i => i.TableId == id && i.TableName == tableName && columns.Contains(i.TableColumn)).ToList(); var oldFiles = DataOperateBasic <Base_Files> .Get().GetList(i => i.TableId == id && i.TableName == tableName).ToList(); DataOperateBasic <Base_Files> .Get().DeleteRange(oldFiles); } //新增附件 List <Base_Files> fileModels = new List <Base_Files>(); foreach (var item in fileList) { SetCurrentUser(item); item.TableId = id; item.TableName = tableName; fileModels.Add(item); } int rows = 0; rows = DataOperateBasic <Base_Files> .Get().AddRange(fileModels); return(rows); } return(0); }
///<summary> ///获取详情: ///</summary> /// <param name="id">数据Id</param> /// <returns>数据详情model</returns> public Result <SpecialAcceptanceView> GetSpecialAcceptanceModel(long id) { Result <SpecialAcceptanceView> result = new Result <SpecialAcceptanceView>(); try { if (id <= 0) { throw new Exception("请选择要查看的专项验收!"); } var specialAcceptance = DataOperateBusiness <Epm_SpecialAcceptance> .Get().GetModel(id); SpecialAcceptanceView model = new SpecialAcceptanceView() { Id = specialAcceptance.Id, ProjectId = specialAcceptance.ProjectId, ProjectName = specialAcceptance.ProjectName, TypeId = specialAcceptance.TypeId, TypeName = specialAcceptance.TypeName, Title = specialAcceptance.Title, Content = specialAcceptance.Content, Num = specialAcceptance.Num, RecCompanyId = specialAcceptance.RecCompanyId, RecCompanyName = specialAcceptance.RecCompanyName, RecUserId = specialAcceptance.RecUserId, RecUserName = specialAcceptance.RecUserName, RecTime = specialAcceptance.RecTime, AcceptanceResult = specialAcceptance.AcceptanceResult, State = specialAcceptance.State, Remark = specialAcceptance.Remark, CrtCompanyId = CurrentUser.CompanyId, CrtCompanyName = CurrentCompanyName, IsDelete = false }; if (model != null) { model.AcceptanceDetailList = DataOperateBusiness <Epm_SpecialAcceptanceDetails> .Get() .GetList(p => p.SpecialCheckId == id).ToList(); string tableName = model.GetType().Name; model.AttachList = DataOperateBasic <Base_Files> .Get().GetList(p => p.TableId == id && p.TableName == tableName).ToList(); } result.Data = model; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetSpecialAcceptanceModel"); } return(result); }
/// <summary> /// 获取工程处项目经理 /// </summary>L /// <param name="name"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public Result <List <Base_User> > GetAgencyPMList(string name, int pageIndex, int pageSize) { var rolelist = new List <string>() { Role.GCCXMJL.GetText() }; var allUser = DataOperateBasic <Base_User> .Get().GetList(t => t.IsDelete == false && (t.Card != "QY" || string.IsNullOrEmpty(t.Card))).ToList(); return(GetAgencyUserList(name, allUser, pageIndex, pageSize, rolelist)); }
/// <summary> /// 获取工程处领导 /// </summary> /// <param name="name"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> private Result <List <Base_User> > GetAgencyLeaderList(string name, int pageIndex, int pageSize) { var rolelist = new List <string>() { Role.LDBZ.GetText() }; var allUser = DataOperateBasic <Base_User> .Get().GetList(t => t.IsDelete == false).ToList(); return(GetAgencyUserList(name, allUser, pageIndex, pageSize, rolelist)); }
/// <summary> /// 获取分公司项目负责人 /// </summary> /// <param name="name"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public Result <List <Base_User> > GetBrCompanyPMList(string name, long companyId, int pageIndex, int pageSize) { var rolelist = new List <string>() { Role.FGXMFZR.GetText() }; var allUser = DataOperateBasic <Base_User> .Get().GetList(t => t.IsDelete == false && t.CompanyId == companyId).ToList(); return(GetAgencyUserList(name, allUser, pageIndex, pageSize, rolelist)); }
private void ViewToEmp(TrainView view, out Epm_Train model, out List <Epm_TrainCompany> companys) { model = new Epm_Train(); model = SetCurrentUser(model); model.CrtCompanyId = CurrentCompanyID.ToLongReq(); model.CrtCompanyName = CurrentCompanyName; model.CompanyId = CurrentCompanyID.ToLongReq(); model.CompanyName = CurrentCompanyName; model.Id = view.Id; model.CompanyId = view.CompanyId; model.CompanyName = view.CompanyName; model.Content = view.Content; model.CrtCompanyId = view.CrtCompanyId; model.CrtCompanyName = view.CrtCompanyName; model.ProjectId = view.ProjectId; model.ProjectName = view.ProjectName; model.Remark = view.Remark; model.StartTime = view.StartTime; model.State = view.State; model.Title = view.Title; model.TrainCompanyId = view.TrainCompanyId; model.TrainCompanyName = view.TrainCompanyName; model.TrainTypeName = view.TrainTypeName; model.TrainTypeNo = view.TrainTypeNo; model.TrainUserId = view.TrainUserId; model.TrainUserName = view.TrainUserName; model.EndTime = view.EndTime; model.CreateUserId = view.CreateUserId; model.CreateUserName = view.CreateUserName; model.CreateTime = view.CreateTime; companys = new List <Epm_TrainCompany>(); if (!string.IsNullOrWhiteSpace(view.CompanyIds)) { var Ids = view.CompanyIds.Split(',').ToLongList(); var list = DataOperateBasic <Base_Company> .Get().GetList(t => Ids.Contains(t.Id)); foreach (var item in list) { var comany = new Epm_TrainCompany(); base.SetCurrentUser(comany); comany.CrtCompanyId = CurrentCompanyID.ToLongReq(); comany.CrtCompanyName = CurrentCompanyName; comany.CompanyId = item.Id; comany.CompanyName = item.Name; comany.TrainId = view.Id; comany.CompanyCode = item.Code; comany.CompanyType = item.Type; companys.Add(comany); } } }
/// <summary> /// 获取指定配置项 /// </summary> /// <param name="setKey"></param> /// <returns></returns> public Base_Settings LoadSettingsByKeys(Settings setKey) { Result <List <Base_Settings> > result = new Result <List <Base_Settings> >(); var list = DataOperateBasic <Base_Settings> .Get().GetList().ToList(); result.Data = list; var model = list.FirstOrDefault(i => i.Code == setKey.ToString()); return(model); }
/// <summary> /// 删除对应业务数据的附件 /// </summary> /// <param name="tableName"></param> /// <param name="id"></param> /// <returns></returns> public int DeleteFilesByTable(string tableName, List <long> ids, string column) { int rows = 0; var models = DataOperateBasic <Base_Files> .Get().GetList(i => ids.Contains(i.TableId) && i.TableName == tableName && i.TableColumn == column).ToList(); foreach (var item in models) { item.DeleteTime = DateTime.Now; } rows = DataOperateBasic <Base_Files> .Get().DeleteRange(models); return(rows); }
///<summary> ///删除专项验收 ///</summary> /// <param name="id">要删除的专项验收 ID</param> /// <returns>受影响的行数</returns> public Result <bool> DeleteSpecialAcceptanceById(long id) { Result <bool> result = new Result <bool>(); try { var model = DataOperateBusiness <Epm_SpecialAcceptance> .Get().GetModel(id); if (model == null) { throw new Exception("要删除的专项验收不存在!"); } if (model.State != (int)ApprovalState.Enabled && model.State != (int)ApprovalState.Discarded) { throw new Exception("只要未提交审核或已废弃的专项验收才能进行删除操作!"); } DbContextTransaction transaction = context.Database.BeginTransaction(); try { string tableName = model.GetType().Name; var rows = DataOperateBusiness <Epm_SpecialAcceptance> .Get().Delete(id); DataOperateBusiness <Epm_SpecialAcceptanceDetails> .Get().Delete(p => p.SpecialCheckId == id); transaction.Commit(); DataOperateBasic <Base_Files> .Get().Delete(p => p.TableName == tableName && p.TableId == id); result.Data = true; result.Flag = EResultFlag.Success; WriteLog(BusinessType.Special.GetText(), SystemRight.Delete.GetText(), "批量删除: " + rows); } catch (Exception ex) { transaction.Rollback(); throw new Exception(ex.Message); } } catch (Exception ex) { result.Data = false; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "DeleteSpecialAcceptanceById"); } return(result); }
/// <summary> /// 根据单位ID和岗位名称获取人员信息 /// </summary> /// <param name="id"></param> /// <param name="postName"></param> /// <returns></returns> public Result <List <Base_User> > GetUserListByPost(long id, string postName) { Result <List <Base_User> > result = new Result <List <Base_User> >(); try { var list = DataOperateBasic <Base_User> .Get().GetList(t => !t.IsDelete && t.CompanyId == id && t.PostValue == postName).ToList(); result.Data = list; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetUserListByPost"); } return(result); }
/// <summary> /// 根据guid查询图片附件 /// </summary> /// <param name="guid"></param> /// <returns></returns> public Result <List <Base_Files> > GetBaseFileByGuid(string guid) { Result <List <Base_Files> > result = new Result <List <Base_Files> >(); try { var data = DataOperateBasic <Base_Files> .Get().GetList(p => p.GuidId == guid).ToList(); result.Data = data; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetBaseFiles"); } return(result); }
public Result <Base_Files> GetBaseFile(long id) { Result <Base_Files> result = new Result <Base_Files>(); try { var data = DataOperateBasic <Base_Files> .Get().GetModel(id); result.Data = data; result.Flag = EResultFlag.Success; } catch (Exception ex) { result.Data = null; result.Flag = EResultFlag.Failure; result.Exception = new ExceptionEx(ex, "GetBaseFile"); } return(result); }