/// <summary>
/// 管理
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Man(JC_MONITOR_Model m)
{
if (string.IsNullOrEmpty(m.MANTIME))
{
m.MANTIME = ClsSwitch.SwitTM(DateTime.Now);
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE JC_MONITOR");
sb.AppendFormat(" set ");
sb.AppendFormat("MANSTATE='{0}'", ClsSql.EncodeSql(m.MANSTATE));
sb.AppendFormat(",MANRESULT='{0}'", ClsSql.EncodeSql(m.MANRESULT));
sb.AppendFormat(",MANTIME='{0}'", ClsSql.EncodeSql(m.MANTIME));
sb.AppendFormat(",MANUSERID='{0}'", ClsSql.EncodeSql(m.MANUSERID));
sb.AppendFormat(" where IMBID= '{0}'", ClsSql.EncodeSql(m.IMBID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功！", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(JC_MONITOR_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO JC_MONITOR(TTBH, IMBTIME, JD, WD, SPJ, FYJ, IMBIMGURL)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.TTBH));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.IMBTIME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.JD));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.WD));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SPJ));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FYJ));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.IMBIMGURL));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功！", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 删除监测
/// </summary>
/// <returns></returns>
public JsonResult DeletJcMonitor()
{
string imid = Request.Params["imid"];//接收监测信息id
var sw = new JC_MONITOR_Model();
sw.IMBID = imid;
sw.opMethod = "Del";
var ms = JC_MONITORCls.ManagerMonitor(sw);
return(Json(ms));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(JC_MONITOR_Model m)
{
bool bln = DataBaseClass.ExeSql("delete from JC_MONITOR where IMBID=" + m.IMBID + "");
if (bln == true)
{
return(new Message(true, "删除成功！", ""));
}
else
{
return(new Message(false, "删除失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 根据查询条件获取某一条信息记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static JC_MONITOR_Model getModelMonitor(JC_MONITOR_SW sw)
{
DataTable dt = BaseDT.JC_MONITOR.getDT(sw);
JC_MONITOR_Model m = new JC_MONITOR_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.IMBID = dt.Rows[i]["IMBID"].ToString();
m.TTBH = dt.Rows[i]["TTBH"].ToString();
m.IMBTIME = ClsSwitch.SwitTM(dt.Rows[i]["IMBTIME"].ToString());
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.SPJ = dt.Rows[i]["SPJ"].ToString();
m.FYJ = dt.Rows[i]["FYJ"].ToString();
m.IMBIMGURL = dt.Rows[i]["IMBIMGURL"].ToString();
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = ClsSwitch.SwitTM(dt.Rows[i]["MANTIME"].ToString());
m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
if (!string.IsNullOrEmpty(m.MANUSERID))
{
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
USERID = m.MANUSERID
});
DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'");
if (drUser.Length > 0)
{
m.ManUserName = drUser[0]["USERNAME"].ToString();
}
dtUser.Clear();
dtUser.Dispose();
}
m.BasicInfoModel = getModel(new JC_MONITOR_BASICINFO_SW {
TTBH = m.TTBH
});
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message ManagerMonitor(JC_MONITOR_Model m)
{
if (m.opMethod == "Add")
{
SystemCls.LogSave("3", "电子监控火情信息图片:" + m.IMBID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_MONITOR.Add(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
if (m.opMethod == "Del")
{
SystemCls.LogSave("5", "电子监控火情信息图片:" + m.IMBID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_MONITOR.Del(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
if (m.opMethod == "Man")
{
SystemCls.LogSave("5", "电子监控火情信息图片:" + m.IMBID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_MONITOR.Man(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
return(new Message(false, "无效操作", ""));
}
