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