/// <summary>
/// 增、删、改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Manager(JC_PERALARM_Model m)
{
if (m.opMethod == "Add")
{
string[] arr = m.BYORGNOLIST.Split(',');
for (int i = 0; i < arr.Length; i++)
{
m.BYORGNO = arr[i];
BaseDT.JC_PERALARM.Add(m);
}
SystemCls.LogSave("3", "群众报警:" + m.PERALARMID, ClsStr.getModelContent(m));
return(new Message(true, "添加成功", m.returnUrl));
}
if (m.opMethod == "Mdy")
{
SystemCls.LogSave("4", "群众报警:" + m.PERALARMID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_PERALARM.Mdy(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
if (m.opMethod == "Del")
{
SystemCls.LogSave("5", "群众报警:" + m.PERALARMID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_PERALARM.Del(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
if (m.opMethod == "Man")
{
SystemCls.LogSave("5", "群众报警:" + m.PERALARMID, ClsStr.getModelContent(m));
Message msgUser = BaseDT.JC_PERALARM.Man(m);
return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
}
return(new Message(false, "无效操作", ""));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(JC_PERALARM_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO JC_PERALARM(FIRENAME,BYORGNO,PERALARMPHONE, PERALARMNAME, PERALARMTIME, PERALARMADDRESS, PERALARMCONTENT ,MANSTATE , MANRESULT, MANTIME, MANUSERID,JD, WD, PEARLARMPRE)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.FIRENAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMPHONE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMNAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMTIME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMADDRESS));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PERALARMCONTENT));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANSTATE));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANRESULT));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANTIME));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.MANUSERID));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.JD));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.WD));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.PEARLARMPRE));
//sb.AppendFormat(",{0}", ClsSql.saveNullField(m.PEARLARMISSUED));
sb.AppendFormat(")");
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 Man(JC_PERALARM_Model m)
{
if (string.IsNullOrEmpty(m.MANTIME))
{
m.MANTIME = ClsSwitch.SwitTM(DateTime.Now);
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE JC_PERALARM");
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 PERALARMID= '{0}'", ClsSql.EncodeSql(m.PERALARMID));
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 Mdy(JC_PERALARM_Model m)
{
//PERALARMID, PERALARMPHONE, PERALARMNAME, PERALARMTIME, PERALARMADDRESS, PERALARMCONTENT, MANSTATE, MANRESULT, MANTIME, MANUSERID
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE JC_PERALARM");
sb.AppendFormat(" set ");
sb.AppendFormat("FIRENAME='{0}'", ClsSql.EncodeSql(m.FIRENAME));
sb.AppendFormat(",BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO));
sb.AppendFormat(",PERALARMPHONE='{0}'", ClsSql.EncodeSql(m.PERALARMPHONE));
sb.AppendFormat(",PERALARMNAME='{0}'", ClsSql.EncodeSql(m.PERALARMNAME));
sb.AppendFormat(",PERALARMTIME='{0}'", ClsSql.EncodeSql(m.PERALARMTIME));
sb.AppendFormat(",PERALARMADDRESS='{0}'", ClsSql.EncodeSql(m.PERALARMADDRESS));
sb.AppendFormat(",PERALARMCONTENT='{0}'", ClsSql.EncodeSql(m.PERALARMCONTENT));
if (string.IsNullOrEmpty(m.MANSTATE) == false)
{
sb.AppendFormat(",MANSTATE='{0}'", ClsSql.EncodeSql(m.MANSTATE));
}
sb.AppendFormat(",MANRESULT='{0}'", ClsSql.EncodeSql(m.MANRESULT));
if (string.IsNullOrEmpty(m.MANTIME) == false)
{
sb.AppendFormat(",MANTIME='{0}'", ClsSql.EncodeSql(m.MANTIME));
}
if (string.IsNullOrEmpty(m.MANUSERID) == false)
{
sb.AppendFormat(",MANUSERID='{0}'", ClsSql.EncodeSql(m.MANUSERID));
}
//JD, WD, PEARLARMPRE, PEARLARMISSUED
if (string.IsNullOrEmpty(m.JD) == false)
{
sb.AppendFormat(",JD='{0}'", ClsSql.EncodeSql(m.JD));
}
if (string.IsNullOrEmpty(m.WD) == false)
{
sb.AppendFormat(",WD='{0}'", ClsSql.EncodeSql(m.WD));
}
sb.AppendFormat(",PEARLARMPRE='{0}'", ClsSql.EncodeSql(m.PEARLARMPRE));
sb.AppendFormat(",PEARLARMISSUED='{0}'", ClsSql.EncodeSql(m.PEARLARMISSUED));
sb.AppendFormat(" where PERALARMID= '{0}'", ClsSql.EncodeSql(m.PERALARMID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功！", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确！", ""));
}
}
/// <summary>
/// 获取用户列表（分页）
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <JC_PERALARM_Model> getListModelPager(JC_PERALARM_SW sw, out int total)
{
var result = new List <JC_PERALARM_Model>();
DataTable dt = BaseDT.JC_PERALARM.getDT(sw, out total);//用户列表
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
});
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_PERALARM_Model m = new JC_PERALARM_Model();
m.PERALARMID = dt.Rows[i]["PERALARMID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIRENAME = dt.Rows[i]["FIRENAME"].ToString();
m.PERALARMPHONE = dt.Rows[i]["PERALARMPHONE"].ToString();
m.PERALARMNAME = dt.Rows[i]["PERALARMNAME"].ToString();
m.PERALARMTIME = ClsSwitch.SwitTM(dt.Rows[i]["PERALARMTIME"].ToString());
m.PERALARMADDRESS = dt.Rows[i]["PERALARMADDRESS"].ToString();
m.PERALARMCONTENT = dt.Rows[i]["PERALARMCONTENT"].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();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.PEARLARMPRE = dt.Rows[i]["PEARLARMPRE"].ToString();
m.PEARLARMISSUED = dt.Rows[i]["PEARLARMISSUED"].ToString();
if (!string.IsNullOrEmpty(m.MANUSERID))
{
DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'");
if (drUser.Length > 0)
{
m.ManUserName = drUser[0]["USERNAME"].ToString();
}
}
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
result.Add(m);
}
dtORG.Clear();
dtORG.Dispose();
dtUser.Clear();
dtUser.Dispose();
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取某一条信息记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static JC_PERALARM_Model getModel(JC_PERALARM_SW sw)
{
DataTable dt = BaseDT.JC_PERALARM.getDT(sw);
JC_PERALARM_Model m = new JC_PERALARM_Model();
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
if (dt.Rows.Count > 0)
{
int i = 0;
m.PERALARMID = dt.Rows[i]["PERALARMID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIRENAME = dt.Rows[i]["FIRENAME"].ToString();
m.PERALARMPHONE = dt.Rows[i]["PERALARMPHONE"].ToString();
m.PERALARMNAME = dt.Rows[i]["PERALARMNAME"].ToString();
m.PERALARMTIME = ClsSwitch.SwitTM(dt.Rows[i]["PERALARMTIME"].ToString());
m.PERALARMADDRESS = dt.Rows[i]["PERALARMADDRESS"].ToString();
m.PERALARMCONTENT = dt.Rows[i]["PERALARMCONTENT"].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();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.PEARLARMPRE = dt.Rows[i]["PEARLARMPRE"].ToString();
m.PEARLARMISSUED = dt.Rows[i]["PEARLARMISSUED"].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.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
}
dtORG.Clear();
dtORG.Dispose();
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(JC_PERALARM_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete JC_PERALARM");
sb.AppendFormat(" where PERALARMID= '{0}'", ClsSql.EncodeSql(m.PERALARMID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "删除成功！", ""));
}
else
{
return(new Message(false, "删除失败，请检查各输入框是否正确！", ""));
}
}
