public IActionResult GetSupportInfo(int id) { DataAccess.TASM_SUPPORT_Da manager = new DataAccess.TASM_SUPPORT_Da(); TASM_SUPPORT model = manager.CurrentDb.GetById(id); return(SuccessResult(model)); }
public IActionResult GetUpdateInfo(int id) { DataAccess.TASM_SUPPORT_Da manager = new DataAccess.TASM_SUPPORT_Da(); SupportModel model = manager.SelectById(id); return(SuccessResult(model)); }
public IActionResult List(ListSupportInputModel model) { DataAccess.TASM_SUPPORT_Da manager = new DataAccess.TASM_SUPPORT_Da(); SqlSugar.PageModel p = new SqlSugar.PageModel(); p.PageIndex = model.pageindex; p.PageSize = model.pagesize; List <SupportModel> list = manager.ListByWhere(model.keywords, ref p, model.WatchType, model.WatchState, model.Uuid); return(SuccessResultList(list, p)); }
public IActionResult List(string keywords, int pageIndex, int pageSize, int watchType = 0, string orderby = "SID") { DataAccess.TASM_SUPPORT_Da manager = new DataAccess.TASM_SUPPORT_Da(); SqlSugar.PageModel p = new SqlSugar.PageModel(); p.PageIndex = pageIndex; p.PageSize = pageSize; List <SupportModel> list = manager.ListByWhere(keywords, ref p, (SupprotWatchType)watchType, SupprotWatchState.全部, this.UserInfo.USER_ID, orderby); return(SuccessResultList(list, p)); }
public IActionResult Add(Entites.CodeGenerator.TASM_SUPPORT model) { model.CREATETIME = DateTime.Now; model.STATUS = 0; DataAccess.TASM_SUPPORT_Da manager = new DataAccess.TASM_SUPPORT_Da(); if (!manager.CurrentDb.Insert(model)) { return(FailMessage()); } return(SuccessMessage("添加成功")); }
public IActionResult ExportExcel(string keyword = "") { DataAccess.TASM_SUPPORT_Da manager = new DataAccess.TASM_SUPPORT_Da(); List <TASM_SUPPORT> list = new List <TASM_SUPPORT>(); list = manager.ListByWhere(keyword); HSSFWorkbook excelBook = new HSSFWorkbook(); //创建工作簿Excel ISheet sheet1 = excelBook.CreateSheet("项目履历表"); IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("概要"); row1.CreateCell(1).SetCellValue("创建者"); row1.CreateCell(2).SetCellValue("处理人"); row1.CreateCell(3).SetCellValue("发现时间"); row1.CreateCell(4).SetCellValue("创建时间"); for (int i = 0; i < list.Count(); i++) { NPOI.SS.UserModel.IRow rowTemp = sheet1.CreateRow(i + 1); rowTemp.CreateCell(0).SetCellValue(list[i].TITLE); rowTemp.CreateCell(1).SetCellValue(list[i].CREATOR); rowTemp.CreateCell(2).SetCellValue(list[i].CONDUCTOR); rowTemp.CreateCell(3).SetCellValue(list[i].FINDATE); rowTemp.CreateCell(4).SetCellValue(list[i].CREATETIME.ToString()); } var fileName = "工单信息" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-ffff") + ".xls";//文件名 //将Excel表格转化为流,输出 MemoryStream bookStream = new MemoryStream(); excelBook.Write(bookStream); bookStream.Seek(0, SeekOrigin.Begin); return(File(bookStream, "application/vnd.ms-excel", fileName)); }
public IActionResult Update(Entites.CodeGenerator.TASM_SUPPORT model) { if (model.CREATOR != this.User_Id && model.CONDUCTOR != this.User_Id) { return(FailMessage("抱歉您不是项目相关人员,无法修改项目状态")); } DataAccess.TASM_SUPPORT_Da manager = new DataAccess.TASM_SUPPORT_Da(); manager.Db.BeginTran(); try { if (!manager.CurrentDb.Update(model)) { manager.Db.RollbackTran(); return(FailMessage()); } //DataAccess.TASM_SUPPORT_PERSONAL_Da da = new TASM_SUPPORT_PERSONAL_Da(); //TASM_SUPPORT_PERSONAL personal = da.CurrentDb.AsQueryable().Where(s => s.SID == model.SID && s.STATUS == (int)Entites.SupprotWatchState.待办).First(); //personal.DID = model.CONDUCTOR; //if (!da.CurrentDb.Update(personal)) //{ // manager.Db.RollbackTran(); // return FailMessage(); //} manager.Db.CommitTran(); return(SuccessMessage("修改成功")); } catch (Exception e) { manager.Db.RollbackTran(); return(FailMessage(e.ToString())); } }
public bool Create(AddDisposerModel model) { DataAccess.TASM_SUPPORT_DISPOSER_Da disposer_manager = new DataAccess.TASM_SUPPORT_DISPOSER_Da(); try { Logger.LogInformation("=========创建技术处理========="); disposer_manager.Db.BeginTran(); int disposerId = 0; //1.创建技术人员处理表信息 if (!InsertDisposer(disposer_manager, model, ref disposerId)) { Logger.LogInformation("创建技术人员处理信息失败"); this.Msg = "创建技术人员处理信息失败!"; disposer_manager.Db.RollbackTran(); return(false); } //2,当前处理人员发生修改,新增一条 修改记录 history TASM_SUPPORT_Da support_manager = new DataAccess.TASM_SUPPORT_Da(); var supportModel = support_manager.CurrentDb.GetById(model.SID); if (!InsertHistory(model, supportModel, model.NEXTUSER, model.SUPPORTSTATUS, disposerId)) { this.Msg = "创建操作历史失败!"; Logger.LogInformation("创建操作历史失败"); disposer_manager.Db.RollbackTran(); return(false); } //3,新的处理人员再新增一条 处理信息(顺序不能变) if (!InsertPersonal(supportModel.CONDUCTOR, model.NEXTUSER, model.SUPPORTSTATUS, model.SID)) { this.Msg = "分发工单失败!"; Logger.LogInformation("分发工单失败"); disposer_manager.Db.RollbackTran(); return(false); } //4,修改工单表的memberid,memberid为处理表的主键id 此处有先后顺序 if (!UpdateSupport(supportModel, support_manager, model.NEXTUSER, model.SUPPORTSTATUS, disposerId)) { this.Msg = "修改工单信息失败!"; Logger.LogInformation("修改工单信息失败"); disposer_manager.Db.RollbackTran(); return(false); } //5,修改个人信息处理表 if (!UpdatePersonal(model.PERSONALID)) { this.Msg = "修改个人处理状态失败!"; Logger.LogInformation("修改个人处理状态失败"); disposer_manager.Db.RollbackTran(); return(false); } //6,添加推送消息 if (!InsertPush(model, disposerId)) { this.Msg = "修改个人处理状态失败!"; Logger.LogInformation("修改个人处理状态失败"); disposer_manager.Db.RollbackTran(); return(false); } //7,发送通知 if (!PushMessage(model.SID, support_manager)) { Logger.LogInformation("推送消息失败"); disposer_manager.Db.RollbackTran(); return(false); } disposer_manager.Db.CommitTran(); return(true); } catch (Exception e) { Logger.LogInformation("" + e); disposer_manager.Db.RollbackTran(); this.Msg = "处理失败!"; return(false); } }
public bool Create(AddPrincipalCheckModel model) { DataAccess.TASM_SUPPORT_PRINCIPAL_Da manager = new DataAccess.TASM_SUPPORT_PRINCIPAL_Da(); try { manager.Db.BeginTran(); int pid = 0; //1,添加 现场审核处理表数据,并获得新id if (!InsertPrincipal(model, manager, ref pid)) { Msg = "创建审核信息失败!"; manager.Db.RollbackTran(); return(false); } //2,创建操作历史 DataAccess.TASM_SUPPORT_Da support_manager = new DataAccess.TASM_SUPPORT_Da(); var supportModel = support_manager.CurrentDb.GetById(model.SID); //工单id 查询工单信息 if (!InsertHistory(model, supportModel, model.SUPPORTSTATUS, model.NEXTUSER, pid)) { Msg = "创建操作历史失败!"; manager.Db.RollbackTran(); return(false); } //3如果审核不通过,重新分发给现场 if (model.SUPPORTSTATUS == (int)SupportendPoint.现场负责人审核_驳回再整改) { //3,新的处理人员再新增一条 处理信息(顺序不能变) 取了工单处理人,为个人处理表的创建人,顺序不能变 if (!InsertPersonal(supportModel.CONDUCTOR, model.NEXTUSER, model.SUPPORTSTATUS, model.SID)) { this.Msg = "分发工单失败!"; manager.Db.RollbackTran(); return(false); } } //4,修改工单表的状态 if (!UpdateSupport(supportModel, support_manager, model.NEXTUSER, model.SUPPORTSTATUS, pid)) { Msg = "修改工单状态失败!"; manager.Db.RollbackTran(); return(false); } //5,修改个人信息处理表 if (!UpdatePersonal(model.PERSONALID)) { this.Msg = "修改个人处理状态失败!"; manager.Db.RollbackTran(); return(false); } //6,添加推送消息 if (!InsertPush(model, pid)) { this.Msg = "修改个人处理状态失败!"; manager.Db.RollbackTran(); return(false); } //7,发送通知 if (!PushMessage(model.SID, support_manager)) { Logger.LogInformation("推送消息失败"); manager.Db.RollbackTran(); return(false); } manager.Db.CommitTran(); return(true); } catch (Exception e) { manager.Db.RollbackTran(); return(false); } }
public bool Create(AddSiteCheckModel model) { DataAccess.TASM_SUPPORT_SITE_Da manager = new DataAccess.TASM_SUPPORT_SITE_Da(); try { manager.Db.BeginTran(); //1,添加现场处理表数据, int siteId = 0; if (!InsertSite(model, manager, ref siteId)) { this.Msg = "创建现场处理信息失败!"; manager.Db.RollbackTran(); return(false); } //2,当前处理人员发生修改,新增一条 修改记录 history DataAccess.TASM_SUPPORT_Da support_manager = new DataAccess.TASM_SUPPORT_Da(); var supportModel = support_manager.CurrentDb.GetById(model.SID); //工单id 查询工单信息 if (!InsertHistory(model, supportModel, siteId, model.SUPPORTSTATUS, model.NEXTUSER)) { this.Msg = "创建操作历史失败!"; manager.Db.RollbackTran(); return(false); } //3,新的处理人员再新增一条 处理信息(顺序不能变) 取了工单处理人,为个人处理表的创建人,顺序不能变 if (!InsertPersonal(supportModel.CONDUCTOR, model.NEXTUSER, model.SUPPORTSTATUS, model.SID)) { this.Msg = "分发工单失败!"; manager.Db.RollbackTran(); return(false); } //4,修改工单表的状态 if (!UpdateSupport(supportModel, support_manager, model.NEXTUSER, model.SUPPORTSTATUS, siteId)) { this.Msg = "修改工单状态失败!"; manager.Db.RollbackTran(); return(false); } //5,修改个人信息处理表 if (!UpdatePersonal(model.PERSONALID)) { this.Msg = "修改个人处理状态失败!"; manager.Db.RollbackTran(); return(false); } //6,添加推送消息 if (!InsertPush(model, siteId)) { this.Msg = "修改个人处理状态失败!"; manager.Db.RollbackTran(); return(false); } //7,发送通知 if (!PushMessage(model.SID, support_manager)) { Logger.LogInformation("推送消息失败"); manager.Db.RollbackTran(); return(false); } manager.Db.CommitTran(); return(true); } catch (Exception e) { manager.Db.RollbackTran(); return(false); } }