/// <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); }