/// <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);
}
