/// <summary> /// 插入技术人员处理表 /// </summary> /// <param name="disposer_manager"></param> /// <param name="model"></param> /// <param name="disposerId"></param> /// <returns></returns> private bool InsertDisposer(TASM_SUPPORT_DISPOSER_Da disposer_manager, TASM_SUPPORT_DISPOSER model, ref int disposerId) { model.CREATETIME = DateTime.Now; model.STATUS = 0; disposerId = disposer_manager.Db.Insertable(model).ExecuteReturnIdentity(); return(disposerId > 0); }
public IActionResult DisposerUpdate(AddDisposerModel info) { TASM_SUPPORT_DISPOSER_Da disposer = new TASM_SUPPORT_DISPOSER_Da(); TASM_SUPPORT_HIS_Da his = new TASM_SUPPORT_HIS_Da(); var hisModel = his.SelectBySidType(info.SID, 1); disposer.Db.BeginTran(); hisModel.NEXT_USER = info.NEXTUSER; if (his.Db.Updateable(hisModel).ExecuteCommand() < 1) { disposer.Db.RollbackTran(); return(FailMessage()); } TASM_SUPPORT_DISPOSER model = new TASM_SUPPORT_DISPOSER() { ANALYZE = info.ANALYZE, ANALYZEUSER = info.ANALYZEUSER, BOM = info.BOM, DUTY = info.DUTY, ID = info.ID, ISORDER = info.ISORDER, ORDERMAN = info.ORDERMAN, ORDERTIME = info.ORDERTIME, RESPONSIBLE = info.RESPONSIBLE, SID = info.SID, SOLUTION = info.SOLUTION, STATUS = info.STATUS, CREATETIME = info.CREATETIME, REMARKS = info.REMARKS }; if (disposer.Db.Updateable(model).ExecuteCommand() < 1) { disposer.Db.RollbackTran(); return(FailMessage()); } disposer.Db.CommitTran(); return(SuccessMessage()); }
/// <summary> /// 技术处理 /// </summary> /// <param name="supportModel"></param> /// <param name="item"></param> /// <param name="sid"></param> /// <param name="disid"></param> /// <returns></returns> private bool CreateDisposer(TASM_SUPPORT supportModel, ExcelModel item, int sid) { try { logger.Info("===创建现场处理开始===!"); //step3 现场处理表 TASM_SUPPORT_DISPOSER_Da supportDisposer = new TASM_SUPPORT_DISPOSER_Da(); TASM_SUPPORT_DISPOSER disposerModel = new TASM_SUPPORT_DISPOSER(); disposerModel.SID = sid; disposerModel.ANALYZEUSER = GetUserIdByName(item.AnalyzeUserName); disposerModel.ANALYZE = item.Analyze; disposerModel.SOLUTION = item.Solution; disposerModel.STATUS = 0; disposerModel.REMARKS = "导入数据"; disposerModel.RESPONSIBLE = item.Responsible; disposerModel.DUTY = item.Duty; disposerModel.BOM = item.Bom; disposerModel.ORDERMAN = item.OrderMan; disposerModel.ORDERTIME = ConventDateTime(item.OrderTime); disposerModel.ISORDER = item.IsOrder == "是" ? 1 : 0; int disid = supportDisposer.Db.Insertable(disposerModel).ExecuteReturnIdentity(); logger.Info("插入技术处理表完成"); //step4 现场处理 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 = 0; //上一状态,订单初始创建,为0 supportHisModel.NEXT_STATUS = item.IsPmcPoint == "是" ? 2 : 1; //下一状态,订单初始创建 下一状态为 现场处理,状态0,此处创建订单不做为状态,默认创建 和 创建后未处理状态都是0 supportHisModel.TYPE = 1; //类型,也代表着是哪个表的数据 初始为0 supportHisModel.TID = disid; //数据id 根据type 那张表,看是哪一条数据。 supportHisModel.REMARKS = "技术已处理,等待现场处理,导入数据"; supportHisModel.CREATETIME = DateTime.Now; supportHis.Db.Insertable(supportHisModel); logger.Info("插入历史表,技术处理完成"); 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 = 0; //2代表现场完成,PMC 介入, 1则是 现场处理完成,无需PMC,直接跳到现场处理。 personalModel.CREATETIME = DateTime.Now; personalModel.REMARKS = "数据导入"; supportPersonal.Db.Insertable(personalModel); logger.Info("插入个人处理表,技术处理完成"); logger.Info("===创建现场处理结束===!"); return(true); } catch (Exception ex) { logger.Error("创建Disposer失败" + 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); } }