/// <summary>
/// 保存报警设置
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string SaveAlarmSetting(HttpContext context)
{
var jr = new JsonResultModel <int>()
{
IsSucceed = false,
Data = 0,
Msg = "保存报警设置失败",
RedirectUrl = string.Empty
};
DevInfoModel devModel = null;
bool isupdate = Convert.ToBoolean(context.Request.Params["isUpdate"]);
string _devName = string.IsNullOrEmpty(context.Request.Params["devName"]) ? "eccm" : context.Request.Params["devName"];
int _devID = string.IsNullOrEmpty(context.Request.Params["devID"]) ? 0 : Convert.ToInt32(context.Request.Params["devID"]);
int _devType = string.IsNullOrEmpty(context.Request.Params["devType"]) ? 0 : Convert.ToInt32(context.Request.Params["devType"]);
int _communityID = string.IsNullOrEmpty(context.Request.Params["communityID"]) ? 0 : Convert.ToInt32(context.Request.Params["communityID"]);
string _devhouseTypes = context.Request.Params["systype"];
devModel = new DevInfoModel()
{
devID = _devID,
devName = _devName,
devType = _devType,
communityID = _communityID,
sort = 10000,
devhouseTypes = _devhouseTypes
};
var data = string.IsNullOrEmpty(context.Request.Params["settingData"]) ? new List <AlarmSettingModel>() : JsonConvert.DeserializeObject <List <AlarmSettingModel> >(context.Request.Params["settingData"]);
if (data != null && data.Count > 0)
{
int rcount = alarmsetting_bll.SaveAlarmSetting(data, isupdate, devModel);
if (rcount > 0)
{
jr.IsSucceed = true;
jr.Data = rcount;
jr.Msg = "保存报警设置成功";
}
}
return(JsonConvert.SerializeObject(jr));
}
/// <summary>
/// 保存报警设置
/// </summary>
public int SaveAlarmSetting(List <AlarmSettingModel> alarmlist, bool isupdate, DevInfoModel devmodel)
{
List <string> cmdlist = new List <string>();
if (isupdate)
{
cmdlist.Add(string.Format("update devinfo set devName='{0}',devType={1} where devID={2}", devmodel.devName, devmodel.devType, devmodel.devID));
cmdlist.Add(string.Format("DELETE from devhousesystype where devhouseID={0}", devmodel.devID));
if (!string.IsNullOrEmpty(devmodel.devhouseTypes))
{
cmdlist.AddRange(devmodel.devhouseTypes.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(s => string.Format("insert into devhousesystype(devhouseID,systypeID) values ({0},{1})", devmodel.devID, s)));
}
cmdlist.AddRange(alarmlist.Select(s => string.Format("UPDATE alarmsetting set `maxValue`= {0}, minValue = {1}, isWork = {2},`delayed`= {3},isSend = {4} where devID = {5} and alarmCode = '{6}'", s.maxValue, s.minValue, s.isWork, s.delayed, s.isSend, s.devID, s.alarmCode)));
}
else
{
cmdlist.Add(string.Format("insert into devinfo(devID,devName,devType,communityID,sort) values ({0},'{1}',{2},{3},{4})", devmodel.devID, devmodel.devName, devmodel.devType, devmodel.communityID, devmodel.sort));
cmdlist.Add(string.Format("DELETE from devhousesystype where devhouseID={0}", devmodel.devID));
if (!string.IsNullOrEmpty(devmodel.devhouseTypes))
{
cmdlist.AddRange(devmodel.devhouseTypes.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(s => string.Format("insert into devhousesystype(devhouseID,systypeID) values ({0},{1})", devmodel.devID, s)));
}
cmdlist.Add(string.Format("delete from alarmsetting where devID={0}", devmodel.devID));
cmdlist.AddRange(alarmlist.Select(s => string.Format("insert into alarmsetting(devID,alarmCode,`maxValue`,minValue,isWork,`delayed`,isSend) values ({0},'{1}',{2},{3},{4},{5},{6})", s.devID, s.alarmCode, s.maxValue, s.minValue, s.isWork, s.delayed, s.isSend)));
}
return(alarmsetting_dal.SaveAlarmSetting(cmdlist));
}
