private bool InsertPmc(TASM_SUPPORT_PMC model, TASM_SUPPORT_PMC_Da manager, ref int pmcId)
{
model.CREATETIME = DateTime.Now;
model.STATUS = 0;
pmcId = manager.Db.Insertable(model).ExecuteReturnIdentity();;
return(pmcId > 0);
}
private bool InsertHistory(TASM_SUPPORT_PMC model, TASM_SUPPORT_PMC_Da manager, TASM_SUPPORT supportModel, int pmcId, int supportStatus, int nextUser)
{
TASM_SUPPORT_HIS_Da his_manager = new TASM_SUPPORT_HIS_Da();
TASM_SUPPORT_HIS hisModel = new TASM_SUPPORT_HIS();
hisModel.CREATETIME = DateTime.Now;
hisModel.PRE_USER = supportModel.CONDUCTOR;
hisModel.NEXT_USER = nextUser;
hisModel.SID = model.SID;
hisModel.REMARKS = "PMC已处理,等待现场处理";
hisModel.PRE_STATUS = supportModel.STATUS;
hisModel.NEXT_STATUS = supportStatus;
hisModel.TYPE = (int)SupportHisType.PMC跟进;; //tasm_disposer表
hisModel.TID = pmcId;
return(his_manager.CurrentDb.Insert(hisModel));
}
public IActionResult PmcUpdate(HisPmcModel info)
{
TASM_SUPPORT_PMC_Da pmc = new TASM_SUPPORT_PMC_Da();
TASM_SUPPORT_HIS_Da his = new TASM_SUPPORT_HIS_Da();
var hisModel = his.SelectBySidType(info.SID, 2);
pmc.Db.BeginTran();
hisModel.NEXT_USER = int.Parse(info.NEXT_USER);
if (his.Db.Updateable(hisModel).ExecuteCommand() < 1)
{
pmc.Db.RollbackTran();
return(FailMessage());
}
TASM_SUPPORT_PMC model = new TASM_SUPPORT_PMC()
{
BOOKNO = info.BOOKNO,
CONSIGNEE = info.CONSIGNEE,
ID = info.TID,
DELIVERY = DateTime.Parse(info.DELIVERY),
SENDDATE = DateTime.Parse(info.SENDDATE),
SENDNO = info.SENDNO,
REMARKS = info.REMARKS
};
if (pmc.Db.Updateable(model).ExecuteCommand() < 1)
{
pmc.Db.RollbackTran();
return(FailMessage());
}
pmc.Db.CommitTran();
return(SuccessMessage());
}
/// <summary>
/// PMC处理
/// </summary>
/// <param name="supportModel"></param>
/// <param name="item"></param>
/// <param name="sid"></param>
/// <returns></returns>
private bool CreatePmcOrder(TASM_SUPPORT supportModel, ExcelModel item, int sid)
{
try
{
logger.Info("===创建PMC处理开始===！");
DataAccess.TASM_SUPPORT_PMC_Da supportPmcOrder = new TASM_SUPPORT_PMC_Da();
TASM_SUPPORT_PMC pmcModel = new TASM_SUPPORT_PMC();
pmcModel.BOOKNO = item.BookNo;
pmcModel.DELIVERY = ConventDateTime(item.Delivery);
pmcModel.SENDDATE = ConventDateTime(item.SendDate);
pmcModel.SENDNO = item.SendNo;
pmcModel.CONSIGNEE = item.Consignee;
pmcModel.STATUS = 0;
pmcModel.CREATETIME = DateTime.Now;
pmcModel.REMARKS = "导入数据";
int pmcid = supportPmcOrder.Db.Insertable(pmcModel).ExecuteReturnIdentity();
logger.Info("插入PMC处理表，处理完成");
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.CONDUCTOR; //上一处理人
supportHisModel.NEXT_USER = supportModel.CONDUCTOR; //下一处理人
supportHisModel.PRE_STATUS = 1; //上一状态，订单初始创建，为0
supportHisModel.NEXT_STATUS = 2; //下一状态，订单初始创建 下一状态为 现场处理，状态0，此处创建订单不做为状态，默认创建 和 创建后未处理状态都是0
supportHisModel.TYPE = 2; //类型，也代表着是哪个表的数据 初始为0
supportHisModel.TID = pmcid; //数据id 根据type 那张表，看是哪一条数据。
supportHisModel.REMARKS = "PMC已处理,等待现场处理,导入数据";
supportHisModel.CREATETIME = DateTime.Now;
supportHis.Db.Insertable(supportHisModel);
logger.Info("插入历史表，PMC处理完成");
TASM_SUPPORT_PERSONAL_Da supportPersonal = new TASM_SUPPORT_PERSONAL_Da();
TASM_SUPPORT_PERSONAL personalModel = new TASM_SUPPORT_PERSONAL();
personalModel.CID = supportModel.CONDUCTOR;
personalModel.DID = supportModel.CONDUCTOR;
personalModel.CREATETIME = DateTime.Now;
personalModel.SID = sid;
personalModel.STATUS = 2;
personalModel.TID = 2;
personalModel.CREATETIME = DateTime.Now;
personalModel.REMARKS = "数据导入";
supportPersonal.Db.Insertable(personalModel);
logger.Info("插入个人处理表，PMC处理完成");
logger.Info("===创建PMC处理结束===！");
return(true);
}
catch (Exception ex)
{
logger.Error("创建Pmc失败" + ex);
return(false);
}
}
/// <summary>
/// 删除工单
/// </summary>
/// <param name="sid"></param>
/// <returns></returns>
public bool Delete(int sid)
{
TASM_SUPPORT_Da support = new TASM_SUPPORT_Da();
support.Db.BeginTran();
try
{
if (!support.CurrentDb.DeleteById(sid))
{
support.Db.RollbackTran();
this.Msg = "删除工单主表失败";
Logger.LogInformation("删除工单主表失败！");
return(false);
}
TASM_SUPPORT_DISPOSER_Da disposer = new TASM_SUPPORT_DISPOSER_Da();
if (disposer.Db.Queryable <TASM_SUPPORT_DISPOSER>().Where(s => s.SID == sid).Count() > 0)
{
if (disposer.Db.Deleteable <TASM_SUPPORT_DISPOSER>().Where(s => s.SID == sid).ExecuteCommand() <= 0)
{
support.Db.RollbackTran();
this.Msg = "删除责任人处理失败";
Logger.LogInformation("删除责任人处理失败！");
return(false);
}
}
TASM_SUPPORT_PMC_Da pmc = new TASM_SUPPORT_PMC_Da();
if (pmc.Db.Queryable <TASM_SUPPORT_PMC>().Where(s => s.SID == sid).Count() > 0)
{
if (pmc.Db.Deleteable <TASM_SUPPORT_PMC>().Where(s => s.SID == sid).ExecuteCommand() <= 0)
{
support.Db.RollbackTran();
this.Msg = "售后内勤删除失败！";
Logger.LogInformation("售后内勤删除失败！");
return(false);
}
}
TASM_SUPPORT_SITE_Da site = new TASM_SUPPORT_SITE_Da();
if (site.Db.Queryable <TASM_SUPPORT_SITE>().Where(s => s.SID == sid).Count() > 0)
{
if (site.Db.Deleteable <TASM_SUPPORT_SITE>().Where(s => s.SID == sid).ExecuteCommand() <= 0)
{
support.Db.RollbackTran();
this.Msg = "删除现场信息失败！";
Logger.LogInformation("删除现场信息失败！");
return(false);
}
}
TASM_SUPPORT_PRINCIPAL_Da principal = new TASM_SUPPORT_PRINCIPAL_Da();
if (principal.Db.Queryable <TASM_SUPPORT_PRINCIPAL>().Where(s => s.SID == sid).Count() > 0)
{
if (principal.Db.Deleteable <TASM_SUPPORT_PRINCIPAL>().Where(s => s.SID == sid).ExecuteCommand() <= 0)
{
support.Db.RollbackTran();
this.Msg = "删除审核信息失败！";
Logger.LogInformation("删除审核信息失败！");
return(false);
}
}
TASM_SUPPORT_HIS_Da his = new TASM_SUPPORT_HIS_Da();
if (his.Db.Queryable <TASM_SUPPORT_HIS>().Where(s => s.SID == sid).Count() > 0)
{
if (his.Db.Deleteable <TASM_SUPPORT_HIS>().Where(s => s.SID == sid).ExecuteCommand() <= 0)
{
support.Db.RollbackTran();
this.Msg = "删除审核信息失败！";
Logger.LogInformation("删除审核信息失败！");
return(false);
}
}
TASM_SUPPORT_PERSONAL_Da personal = new TASM_SUPPORT_PERSONAL_Da();
if (personal.Db.Queryable <TASM_SUPPORT_PERSONAL>().Where(s => s.SID == sid).Count() > 0)
{
if (personal.Db.Deleteable <TASM_SUPPORT_PERSONAL>().Where(s => s.SID == sid).ExecuteCommand() <= 0)
{
support.Db.RollbackTran();
this.Msg = "删除审核信息失败！";
Logger.LogInformation("删除审核信息失败！");
return(false);
}
}
TASM_SUPPORT_PUSH_Da push = new TASM_SUPPORT_PUSH_Da();
if (push.Db.Queryable <TASM_SUPPORT_PUSH>().Where(s => s.SID == sid).Count() > 0)
{
if (push.Db.Deleteable <TASM_SUPPORT_PUSH>().Where(s => s.SID == sid).ExecuteCommand() <= 0)
{
support.Db.RollbackTran();
this.Msg = "删除审核信息失败！";
Logger.LogInformation("删除审核信息失败！");
return(false);
}
}
support.Db.CommitTran();
return(true);
}
catch (Exception e)
{
Logger.LogInformation(e.ToString());
support.Db.RollbackTran();
return(false);
}
}
public bool Create(AddPmcCheckModel model)
{
TASM_SUPPORT_PMC_Da manager = new TASM_SUPPORT_PMC_Da();
try
{
manager.Db.BeginTran();
int pmcId = 0;
//1，添加 PMC处理表数据
if (!InsertPmc(model, manager, ref pmcId))
{
this.Msg = "创建PMC处理信息失败！";
manager.Db.RollbackTran();
return(false);
}
TASM_SUPPORT_Da support_manager = new TASM_SUPPORT_Da();
var supportModel = support_manager.CurrentDb.GetById(model.SID); //工单id 查询工单信息
//2,当前处理人员发生修改，新增一条 修改记录 history
if (!InsertHistory(model, manager, supportModel, pmcId, 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, pmcId))
{
this.Msg = "修改工单信息失败！";
manager.Db.RollbackTran();
return(false);
}
//5,修改个人信息处理表
if (!UpdatePersonal(model.PERSONALID))
{
this.Msg = "修改个人处理状态失败！";
manager.Db.RollbackTran();
return(false);
}
//6,添加推送消息
if (!InsertPush(model, pmcId))
{
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);
}
}
