/// <summary>
/// 报警处理
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Man(T_IPS_ALARM_Model m)
{
if (string.IsNullOrEmpty(m.ALARMID))
{
return(new Message(false, "修改失败，请选择要处理的记录！", ""));
}
StringBuilder sb = new StringBuilder();
//(ORGNO,LOGINUSERNAME,USERNAME,USERPWD,REGISTERTIME,LOGINNUM,NOTE)
sb.AppendFormat("UPDATE T_IPS_ALARM");
sb.AppendFormat(" set ");
sb.AppendFormat(" ALARMCONTENT='{0}'", ClsSql.EncodeSql(m.ALARMCONTENT));
sb.AppendFormat(" ,MANSTATE='{0}'", "1");
sb.AppendFormat(" ,MANRESULT='{0}'", ClsSql.EncodeSql(m.MANRESULT));
sb.AppendFormat(" ,MANTIME='{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
sb.AppendFormat(" ,MANUSERID='{0}'", SystemCls.getUserID());
sb.AppendFormat(" where ALARMID= '{0}'", ClsSql.EncodeSql(m.ALARMID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "处理成功！", ""));
}
else
{
return(new Message(false, "处理失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 删除、处理
/// </summary>
/// <param name="m">参见模型T_IPS_ALARM_Model</param>
/// <returns>参见模型Manager</returns>
public static Message Manager(T_IPS_ALARM_Model m)
{
if (m.opMethod == "Del")
{
T_IPS_ALARM_Model m1 = getModel(new T_IPS_ALARM_SW {
ALARMID = m.ALARMID
});
SystemCls.LogSave("5", "报警处理:" + m.PHONE, ClsStr.getModelContent(m1));
Message msgUser = BaseDT.T_IPS_ALARM.Del(m);
return(new Message(msgUser.Success, msgUser.Msg, ""));
}
if (m.opMethod == "Man")
{
T_IPS_ALARM_Model m1 = getModel(new T_IPS_ALARM_SW {
ALARMID = m.ALARMID
});
SystemCls.LogSave("4", "报警处理:" + m.PHONE, ClsStr.getModelContent(m1));
Message msgUser = BaseDT.T_IPS_ALARM.Man(m);
return(new Message(msgUser.Success, msgUser.Msg, ""));
}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 删除报警点
/// </summary>
/// <returns></returns>
public JsonResult DelteAlarmAjax()
{
string alarmid = Request.Params["alarmid"];
Message ms = null;
if (string.IsNullOrEmpty(alarmid))
{
ms = new Message(false, "报警主键ALAEMID传参失败!", "");
return(Json(ms));
}
var m = new T_IPS_ALARM_Model();
m.opMethod = "Del";
m.ALARMID = alarmid;
ms = T_IPS_ALARMCls.Manager(m);
return(Json(ms));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(T_IPS_ALARM_Model m)
{
if (string.IsNullOrEmpty(m.ALARMID))
{
return(new Message(false, "删除失败，请选择要处理的记录！", ""));
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("DELETE FROM T_IPS_ALARM");
sb.AppendFormat(" where ALARMID= '{0}'", ClsSql.EncodeSql(m.ALARMID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功！", ""));
}
else
{
return(new Message(false, "删除失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 保存更新报警信息
/// </summary>
/// <returns></returns>
public JsonResult SaveAlarmInfoAjax()
{
string alarmid = Request.Params["alarmid"];
string bjcontent = Request.Params["bjcontent"];
string tbresult = Request.Params["tbresult"];
Message ms = null;
if (string.IsNullOrEmpty(alarmid))
{
ms = new Message(false, "alarmid参数传递错误!", "");
return(Json(ms));
}
var m = new T_IPS_ALARM_Model();
m.opMethod = "Man";
m.ALARMID = alarmid;
m.MANRESULT = tbresult;
m.ALARMCONTENT = bjcontent;
m.MANUSERID = SystemCls.getUserID();
ms = T_IPS_ALARMCls.Manager(m);
return(Json(ms));
}
/// <summary>
/// 获取一条数据
/// </summary>
/// <example>
/// sw.ALARMID 报警ID
/// </example>
/// <param name="sw">参见条件模型T_IPS_ALARM_SW</param>
/// <returns>参见模型T_IPS_ALARM_Model</returns>
public static T_IPS_ALARM_Model getModel(T_IPS_ALARM_SW sw)
{
DataTable dt = BaseDT.T_IPS_ALARM.getDT(sw);
T_IPS_ALARM_Model m = new T_IPS_ALARM_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.ALARMID = dt.Rows[i]["ALARMID"].ToString();
m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString();
m.LATITUDE = dt.Rows[i]["LATITUDE"].ToString();
//******************计算坐标偏移量
string[] arr = PublicCls.switJWD(m.LATITUDE, m.LONGITUDE);
m.LATITUDE = arr[0];
m.LONGITUDE = arr[1];
//******************计算坐标偏移量 End
m.HEIGHT = dt.Rows[i]["HEIGHT"].ToString();
m.PHONE = dt.Rows[i]["PHONE"].ToString();
m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString();
m.ALARMTIME = dt.Rows[i]["ALARMTIME"].ToString();
if (string.IsNullOrEmpty(m.ALARMTIME) == false)
{
m.ALARMTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.ALARMTIME);
}
m.ALARMCONTENT = dt.Rows[i]["ALARMCONTENT"].ToString();
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = dt.Rows[i]["MANTIME"].ToString();
if (string.IsNullOrEmpty(m.MANTIME) == false)
{
m.MANTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.MANTIME);
}
m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
DataTable dtHRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
PHONE = m.PHONE
});
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
USERID = m.MANUSERID
});
DataRow[] drHRUser = dtHRUser.Select("PHONE='" + m.PHONE + "'");
if (drHRUser.Length > 0)
{
m.OrgNoName = drHRUser[0]["ORGNAME"].ToString();
m.HName = drHRUser[0]["HNAME"].ToString();
m.HID = drHRUser[0]["HID"].ToString();
m.OrgNo = drHRUser[0]["BYORGNO"].ToString();
}
if (!string.IsNullOrEmpty(m.MANUSERID))
{
DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'");
if (drUser.Length > 0)
{
m.ManUserName = drUser[0]["USERNAME"].ToString();
}
}
dtUser.Clear();
dtUser.Dispose();
dtHRUser.Clear();
dtHRUser.Dispose();
////权限获取
//var userid = SystemCls.getUserID();
//var rightsw = new T_SYSSEC_IPSUSER_SW();
//rightsw.USERID = userid;
//m.Rights = T_SYSSEC_RIGHTCls.getRightStrByUID(rightsw);
}
dt.Clear();
dt.Dispose();
return(m);
}
