/// <summary>
/// 创建工单
/// </summary>
/// <param name="daSupport"></param>
/// <param name="item"></param>
/// <returns></returns>
private bool CreateSupport(TASM_SUPPORT_Da daSupport, ExcelModel item, ref int sid, ref TASM_SUPPORT supportModel)
{
try
{
logger.Info("===创建工单开始===！");
//step1 添加工单主表，
supportModel = new Entites.CodeGenerator.TASM_SUPPORT();
supportModel.CREATOR = GetUserIdByName(item.CreateName); //工单初始创建人
supportModel.CONTENT = item.Content; //问题描述
supportModel.TYPE = item.SupportType;
supportModel.SEVERITY = item.Severity;
supportModel.FINDATE = ConventDateTime(item.Createtime);
supportModel.CONDUCTOR = GetUserIdByName(item.ConductorName);
supportModel.STATUS = item.EndPiont;
supportModel.STATE = item.ConductorStatus;
supportModel.MID = GetsMachineByName(item.MachineCode);
supportModel.CODE = GetSupportCode(Project.CODE);
supportModel.TITLE = "导入数据";
supportModel.CREATETIME = DateTime.Now;
sid = daSupport.Db.Insertable(supportModel).ExecuteReturnIdentity();
logger.Info("插入工单表");
//step2 添加历史表
TASM_SUPPORT_HIS_Da supportHis = new TASM_SUPPORT_HIS_Da();
TASM_SUPPORT_HIS supportHisModel = new TASM_SUPPORT_HIS();
supportHisModel.SID = sid;
supportHisModel.PRE_USER = supportModel.CREATOR; //上一处理人
supportHisModel.NEXT_USER = supportModel.CONDUCTOR; //下一处理人
supportHisModel.PRE_STATUS = 0; //上一状态，订单初始创建，为0
supportHisModel.NEXT_STATUS = 0; //下一状态，订单初始创建 下一状态为 现场处理，状态0，此处创建订单不做为状态，默认创建 和 创建后未处理状态都是0
supportHisModel.TYPE = 0; //类型，也代表着是哪个表的数据 初始为0
supportHisModel.TID = sid; //数据id 根据type 那张表，看是哪一条数据。
supportHisModel.REMARKS = "工单创建，等待技术处理,导入数据";
supportHisModel.CREATETIME = DateTime.Now;
supportHis.Db.Insertable(supportHisModel);
logger.Info("插入历史表：创建工单");
logger.Info("===创建工单结束===！");
return(true);
}
catch (Exception ex)
{
logger.Error("创建工单失败" + ex);
return(false);
}
}
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 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()));
}
}
