public IActionResult GetSiteInfo(int id) { DataAccess.TASM_SUPPORT_SITE_Da manager = new DataAccess.TASM_SUPPORT_SITE_Da(); TASM_SUPPORT_SITE model = manager.CurrentDb.GetById(id); return(SuccessResult(model)); }
private bool InsertSite(TASM_SUPPORT_SITE model, TASM_SUPPORT_SITE_Da manager, ref int siteId) { model.CREATETIME = DateTime.Now; siteId = manager.Db.Insertable(model).ExecuteReturnIdentity(); return(siteId > 0); }
private bool InsertHistory(TASM_SUPPORT_SITE model, TASM_SUPPORT supportModel, int siteId, int supportStatus, int nextUser) { DataAccess.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 = "现场已处理,等待审核"; hisModel.PRE_STATUS = supportModel.STATUS; hisModel.NEXT_STATUS = supportStatus; hisModel.TYPE = (int)Entites.SupportHisType.现场处理; hisModel.TID = siteId; return(his_manager.CurrentDb.Insert(hisModel)); }
public IActionResult SiteUpdate(HisSiteModel info) { TASM_SUPPORT_SITE_Da site = new TASM_SUPPORT_SITE_Da(); TASM_SUPPORT_HIS_Da his = new TASM_SUPPORT_HIS_Da(); var hisModel = his.SelectBySidType(info.SID, 3); site.Db.BeginTran(); hisModel.NEXT_USER = int.Parse(info.NEXT_USER); if (his.Db.Updateable(hisModel).ExecuteCommand() < 1) { site.Db.RollbackTran(); return(FailMessage()); } TASM_SUPPORT_SITE model = new TASM_SUPPORT_SITE() { ID = info.TID, DESCRIPTION = info.DESCRIPTION, ENDDATE = DateTime.Parse(info.ENDDATE), REAMRKS = info.REAMRKS, SID = info.SID }; if (site.Db.Updateable(model).ExecuteCommand() < 1) { site.Db.RollbackTran(); return(FailMessage()); } site.Db.CommitTran(); return(SuccessMessage()); }
/// <summary> /// 现场处理 /// </summary> /// <returns></returns> private bool CreateSiteCheck(TASM_SUPPORT supportModel, ExcelModel item, int sid) { try { logger.Info("===创建现场处理开始===!"); TASM_SUPPORT_SITE_Da supportSite = new TASM_SUPPORT_SITE_Da(); TASM_SUPPORT_SITE siteMode = new TASM_SUPPORT_SITE(); siteMode.CREATETIME = DateTime.Now; siteMode.DESCRIPTION = item.Description; siteMode.ENDDATE = ConventDateTime(item.EndDate); siteMode.REAMRKS = "导入数据"; int siteId = supportSite.Db.Insertable(siteMode).ExecuteReturnIdentity(); 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 = item.IsPmcPoint == "是" ? 2 : 1; //上一状态,订单初始创建,为0 supportHisModel.NEXT_STATUS = 3; //下一状态,订单初始创建 下一状态为 现场处理,状态0,此处创建订单不做为状态,默认创建 和 创建后未处理状态都是0 supportHisModel.TYPE = 3; //类型,也代表着是哪个表的数据 初始为0 supportHisModel.TID = siteId; //数据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 = 3; personalModel.CREATETIME = DateTime.Now; personalModel.REMARKS = "数据导入"; supportPersonal.Db.Insertable(personalModel); logger.Info("插入个人处理表,现场处理完成"); logger.Info("===创建现场处理结束===!"); return(true); } catch (Exception ex) { logger.Error("创建现场处理失败" + ex); return(false); } }