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));
}
