public ActionResult CheckUpdateLevel(RequestData data) { string levelId = data.Get("LevelId"); string entid = data.Get("entId"); PostResult result = new PostResult(); result.Success = false; T_THEPEAK_ENT_SUB_LISTModel modelEnt = new T_THEPEAK_ENT_SUB_LISTModel(); //modelEnt.LEVEL_ID =decimal.Parse( levelId); modelEnt.CONTROL_MEAS = decimal.Parse(levelId); modelEnt.Update(T_THEPEAK_ENT_SUB_LIST.ID == decimal.Parse(entid)); result.Success = true; return(Json(result)); }
public ActionResult SaveThePeak(RequestData data) { PostResult result = new PostResult(); List <dynamic> getXunChalis = null; string entGuid = data.Get("entGuid"); try { T_THEPEAK_MAIN_LIST_INFOModel model = new T_THEPEAK_MAIN_LIST_INFOModel(); model = this.GetModelValue <T_THEPEAK_MAIN_LIST_INFOModel>(model, data); model.PEAK_TYPE = "zfyj"; model.RESPONSE_AREA = model.LIMIT_AREA; //model.LIMITED_NUM = model.LIMITED_NUM ; model.ALL_NUM = model.LIMITED_NUM + model.STOP_NUM + model.THEPEAK_NUM; //主表 int peakId = model.GetIDByInsert(); FileUploadHandle.FileMessageSave(data, peakId.ToString()); //更新主表 T_THEPEAK_ENT_SUB_LISTModel entSub = new T_THEPEAK_ENT_SUB_LISTModel(); entSub.THEPEAKID = peakId; entSub.Update(T_THEPEAK_ENT_SUB_LIST.GUID == entGuid); //获取需要巡查的企业 getXunChalis = GetXunCha(peakId); result.Data = getXunChalis; result.Message = peakId.ToString(); result.Success = true; //UpdateAttach(Json,getID) //添加主表日志 base.AddLog(null, LogType.InsertOperate, "【任务下发成功】 " + ModelToString(model.ID)); } catch (Exception ex) { base.AddLog(null, LogType.InsertOperate, "【下发错峰任务失败】 " + ex.Message + ex.StackTrace); Lang.add_failure = "下发错峰任务失败"; result.Success = false; } //return result; return(Json(result)); }
public ActionResult CheckConfigEnt(RequestData data) { string levelId = data.Get("LevelId"); string entid = data.Get("entId"); bool isCheck = bool.Parse(data.Get("isCheck")); string peakId = data.Get("peakId"); string controlId = data.Get("controlId"); string entType = data.Get("entType"); string entGuid = data.Get("entGuid"); string companyId = data.Get("companyId"); PostResult result = new PostResult(); result.Success = false; T_THEPEAK_ENT_SUB_LISTModel modelEnt = new T_THEPEAK_ENT_SUB_LISTModel(); modelEnt.LEVEL_ID = decimal.Parse(levelId); //modelEnt.GUID modelEnt.CONTROL_MEAS = string.IsNullOrEmpty(controlId)? modelEnt.LEVEL_ID :decimal.Parse(controlId); if (!string.IsNullOrEmpty(peakId)) { modelEnt.THEPEAKID = decimal.Parse(peakId); } modelEnt.ENT_PEAK_TYPE = decimal.Parse(entType); modelEnt.GUID = entGuid; modelEnt.COMPANY_ID = decimal.Parse(companyId); if (isCheck) { modelEnt.IS_SELECT = 1; } // modelEnt.Insert(); else { modelEnt.IS_SELECT = 0; } modelEnt.Update(T_THEPEAK_ENT_SUB_LIST.ID == decimal.Parse(entid)); result.Success = true; return(Json(result)); }
protected override bool DoEdit(RequestData data) { bool reulst = true; string entGuid = data.Get("entGuid"); try { T_THEPEAK_MAIN_LIST_INFOModel model = new T_THEPEAK_MAIN_LIST_INFOModel(); model = this.GetModelValue <T_THEPEAK_MAIN_LIST_INFOModel>(model, data); reulst = model.Update(T_THEPEAK_MAIN_LIST_INFO.ID == data.Get("id")); //更新主表 T_THEPEAK_ENT_SUB_LISTModel entSub = new T_THEPEAK_ENT_SUB_LISTModel(); entSub.THEPEAKID = decimal.Parse(data.Get("id")); entSub.Update(T_THEPEAK_ENT_SUB_LIST.GUID == entGuid); } catch (Exception ex) { base.AddLog(null, LogType.InsertOperate, "【编辑错峰任务失败】 " + ex.Message + ex.StackTrace); Lang.add_failure = "编辑错峰任务失败"; reulst = false; } return(reulst); }
public ActionResult UpdateCompanyForIndustryType(RequestData data) { string levelId = data.Get("LevelId"); string IndustryType = data.Get("IndustryType"); bool isCheck = bool.Parse(data.Get("isCheck")); string entGuid = data.Get("entGuid"); string peakId = data.Get("peakId"); if (!string.IsNullOrEmpty(IndustryType)) { string[] arrayType = IndustryType.Split(','); for (int i = 0; i < arrayType.Length; i++) { arrayType[i] = "'" + arrayType[i] + "'"; } IndustryType = string.Join(",", arrayType); } // string actionType = data.Get("ActionType"); /*思路: 根据等级和行业类型获取相关企业 * 获取企业关联表ent * 遍历企业表 * 如果check为false就删除 * 查找关联表如果表中不存在相关企业进行插入 */ T_THEPEAK_ENT_SUB_LISTModel modelEnt = new T_THEPEAK_ENT_SUB_LISTModel(); modelEnt.GUID = entGuid; FieldModel where = null; where &= T_THEPEAK_LEVEL_CONFIG.PEAK_LEVE_ID == levelId; if (!string.IsNullOrEmpty(IndustryType)) { where &= T_BASE_COMPANY.BASTYPE.In(IndustryType); } var dynmaicSql = SqlModel.SelectAll( T_SYS_AREA.AREA_TEXT.As("AREA_TEXT") , T_SYS_AREA.AREA_CODE // , T_BASE_COMPANY.ID.As("T_COMPANY_ID") , T_THEPEAK_LEVEL_LIST_INFO.ID.As("LEVEL_ID") , T_THEPEAK_LEVEL_CONFIG.IS_STOP , T_THEPEAK_LEVEL_CONFIG.LIMIT_TYPE , T_THEPEAK_LEVEL_CONFIG.PEAK_LEVE_ID ) .From(DB.T_BASE_COMPANY) .LeftJoin(DB.T_SYS_AREA).On(T_BASE_COMPANY.AREA == T_SYS_AREA.AREA_CODE) .LeftJoin(DB.T_THEPEAK_LEVEL_CONFIG).On(T_THEPEAK_LEVEL_CONFIG.COMPANY_ID == T_BASE_COMPANY.ID) .LeftJoin(DB.T_THEPEAK_LEVEL_LIST_INFO).On(T_THEPEAK_LEVEL_LIST_INFO.ID == T_THEPEAK_LEVEL_CONFIG.PEAK_LEVE_ID) // .LeftJoin(DB.T_THEPEAK_ENT_SUB_LIST).On(T_THEPEAK_ENT_SUB_LIST.COMPANY_ID == T_BASE_COMPANY.ID & T_THEPEAK_LEVEL_LIST_INFO.ID == T_THEPEAK_ENT_SUB_LIST.LEVEL_ID) .Where(where).ExecToDynamicList(); var configEnt = SqlModel.SelectAll().From(DB.T_THEPEAK_ENT_SUB_LIST).Where(T_THEPEAK_ENT_SUB_LIST.LEVEL_ID == decimal.Parse(levelId) & T_THEPEAK_ENT_SUB_LIST.GUID == entGuid).ExecToDynamicList(); if (!isCheck) { modelEnt.IS_SELECT = 0; //删除 dynmaicSql.ForEach( m => { modelEnt.Update(T_THEPEAK_ENT_SUB_LIST.COMPANY_ID == m["ID"] & T_THEPEAK_ENT_SUB_LIST.LEVEL_ID == m["LEVEL_ID"] & T_THEPEAK_ENT_SUB_LIST.GUID == entGuid); }); //&modelEnt.GUID== entGuid } else { //往企业关系表插入值 dynmaicSql.ForEach( m => { modelEnt.IS_SELECT = 1; modelEnt.Update(T_THEPEAK_ENT_SUB_LIST.COMPANY_ID == m["ID"] & T_THEPEAK_ENT_SUB_LIST.LEVEL_ID == m["LEVEL_ID"] & T_THEPEAK_ENT_SUB_LIST.GUID == entGuid); }); } return(Json(dynmaicSql)); }