/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(YJ_DCSMS_TMP_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT YJ_DCSMS_TMPID, SMSGROUPNAME, SMSGROUPTYPE, DANGERCLASS, TMPCONTENT, SMSSENDUSERLIST, ORDERBY, ISENABLE,TID");
sb.AppendFormat(" FROM YJ_DCSMS_TMP");
sb.AppendFormat(" WHERE 1=1");
if (!string.IsNullOrEmpty(sw.YJ_DCSMS_TMPID))//火险id
{
sb.AppendFormat(" AND YJ_DCSMS_TMPID='{0}'", ClsSql.EncodeSql(sw.YJ_DCSMS_TMPID));
}
if (!string.IsNullOrEmpty(sw.DANGERCLASS))//火险等级
{
sb.AppendFormat(" AND DANGERCLASS='{0}'", ClsSql.EncodeSql(sw.DANGERCLASS));
}
if (!string.IsNullOrEmpty(sw.ISENABLE))//是否启用
{
sb.AppendFormat(" AND ISENABLE='{0}'", ClsSql.EncodeSql(sw.ISENABLE));
}
sb.AppendFormat(" ORDER BY DANGERCLASS,ORDERBY ");
DataSet ds = DataBaseClass.FullDataSet(sb.ToString());
return(ds.Tables[0]);
}
/// <summary>
/// 模板列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <YJ_DCSMS_TMP_Model> GetListModel(YJ_DCSMS_TMP_SW sw)
{
var result = new List <YJ_DCSMS_TMP_Model>();
DataTable dt = BaseDT.YJ_DCSMS_TMP.getDT(sw);//获取模板
DataTable dtFIRELEVEL = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "24"
}); //预案
for (int i = 0; i < dt.Rows.Count; i++)
{
YJ_DCSMS_TMP_Model m = new YJ_DCSMS_TMP_Model();
m.YJ_DCSMS_TMPID = dt.Rows[i]["YJ_DCSMS_TMPID"].ToString();
m.SMSGROUPNAME = dt.Rows[i]["SMSGROUPNAME"].ToString();
m.SMSGROUPTYPE = dt.Rows[i]["SMSGROUPTYPE"].ToString();
m.SMSSENDUSERLIST = dt.Rows[i]["SMSSENDUSERLIST"].ToString();
m.TMPCONTENT = dt.Rows[i]["TMPCONTENT"].ToString();
m.DANGERCLASS = dt.Rows[i]["DANGERCLASS"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
m.ISENABLE = dt.Rows[i]["ISENABLE"].ToString();
m.TID = dt.Rows[i]["TID"] == null ? "" : dt.Rows[i]["TID"].ToString();
m.ISENABLEName = (m.ISENABLE == "1") ? "启用" : "未启用";
if (m.SMSGROUPTYPE == "0")
{
m.SMSGROUPTYPEName = "通讯录";
}
else if (m.SMSGROUPTYPE == "1")
{
m.SMSGROUPTYPEName = "值班员";
}
else if (m.SMSGROUPTYPE == "2")
{
m.SMSGROUPTYPEName = "护林员";
}
else
{
m.SMSGROUPTYPEName = "设置错误";
}
m.FIRELEVELName = BaseDT.T_SYS_DICT.getName(dtFIRELEVEL, m.DANGERCLASS);
m.dicModel = T_SYS_DICTCls.getModel(new T_SYS_DICTSW {
DICTTYPEID = "24", DICTVALUE = m.DANGERCLASS
});
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取某一条用户信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static YJ_DCSMS_TMP_Model getModel(YJ_DCSMS_TMP_SW sw)
{
var result = new List <YJ_DCSMS_TMP_Model>();
DataTable dt = BaseDT.YJ_DCSMS_TMP.getDT(sw);//列表
YJ_DCSMS_TMP_Model m = new YJ_DCSMS_TMP_Model();
DataTable dtFIRELEVEL = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "22"
}); //预案
if (dt.Rows.Count > 0)
{
int i = 0;
m.YJ_DCSMS_TMPID = dt.Rows[i]["YJ_DCSMS_TMPID"].ToString();
m.SMSGROUPNAME = dt.Rows[i]["SMSGROUPNAME"].ToString();
m.SMSGROUPTYPE = dt.Rows[i]["SMSGROUPTYPE"].ToString();
m.SMSSENDUSERLIST = dt.Rows[i]["SMSSENDUSERLIST"].ToString();
m.TMPCONTENT = dt.Rows[i]["TMPCONTENT"].ToString();
m.DANGERCLASS = dt.Rows[i]["DANGERCLASS"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
m.ISENABLE = dt.Rows[i]["ISENABLE"].ToString();
m.TID = dt.Rows[i]["TID"] == null ? "" : dt.Rows[i]["TID"].ToString();
m.ISENABLEName = (m.ISENABLE == "1") ? "启用" : "未启用";
if (m.SMSGROUPTYPE == "0")
{
m.SMSGROUPTYPEName = "通讯录";
}
else if (m.SMSGROUPTYPE == "1")
{
m.SMSGROUPTYPEName = "值班员";
}
else if (m.SMSGROUPTYPE == "2")
{
m.SMSGROUPTYPEName = "护林员";
}
else
{
m.SMSGROUPTYPEName = "设置错误";
}
m.FIRELEVELName = BaseDT.T_SYS_DICT.getName(dtFIRELEVEL, m.DANGERCLASS);
}
dt.Clear();
dt.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
return(m);
}
