/// <summary> /// 获取数据列表 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static IEnumerable <PEST_REMOTEDIAGN_Model> getListModel(PEST_REMOTEDIAGN_SW sw, out int total) { var result = new List <PEST_REMOTEDIAGN_Model>(); DataTable dt = BaseDT.PEST_REMOTEDIAGN.getDT(sw, out total);//列表 DataTable dt122 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "122" }); //诊断状态 for (int i = 0; i < dt.Rows.Count; i++) { PEST_REMOTEDIAGN_Model m = new PEST_REMOTEDIAGN_Model(); m.PEST_REMOTEDIAGNID = dt.Rows[i]["PEST_REMOTEDIAGNID"].ToString(); m.DIAGNTITLE = dt.Rows[i]["DIAGNTITLE"].ToString(); m.DIAGNCONTENT = dt.Rows[i]["DIAGNCONTENT"].ToString(); m.DIAGNTIME = ClsSwitch.SwitMN(dt.Rows[i]["DIAGNTIME"].ToString()); m.DIAGNEXPERTS = dt.Rows[i]["DIAGNEXPERTS"].ToString(); m.DIAGNSTATUS = dt.Rows[i]["DIAGNSTATUS"].ToString(); m.DIAGNSTATUSName = BaseDT.T_SYS_DICT.getName(dt122, m.DIAGNSTATUS); m.DIAGNRESULT = dt.Rows[i]["DIAGNRESULT"].ToString(); m.DIAGNSPONSERUID = dt.Rows[i]["DIAGNSPONSERUID"].ToString(); if (!string.IsNullOrEmpty(m.DIAGNSPONSERUID)) { m.DIAGNSPONSERNAME = T_SYSSEC_IPSUSERCls.getname(m.DIAGNSPONSERUID); } m.DIAGNSPONSERTIME = ClsSwitch.SwitMN(dt.Rows[i]["DIAGNSPONSERTIME"].ToString()); result.Add(m); } dt.Clear(); dt.Dispose(); dt122.Clear(); dt122.Dispose(); return(result); }
/// <summary> /// 获取单条数据 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static PEST_REMOTEDIAGN_Model getModel(PEST_REMOTEDIAGN_SW sw) { DataTable dt = BaseDT.PEST_REMOTEDIAGN.getDT(sw);//列表 DataTable dt122 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = "122" }); //诊断状态 PEST_REMOTEDIAGN_Model m = new PEST_REMOTEDIAGN_Model(); if (dt.Rows.Count > 0) { int i = 0; m.PEST_REMOTEDIAGNID = dt.Rows[i]["PEST_REMOTEDIAGNID"].ToString(); m.DIAGNTITLE = dt.Rows[i]["DIAGNTITLE"].ToString(); m.DIAGNCONTENT = dt.Rows[i]["DIAGNCONTENT"].ToString(); m.DIAGNTIME = ClsSwitch.SwitMN(dt.Rows[i]["DIAGNTIME"].ToString()); m.DIAGNEXPERTS = dt.Rows[i]["DIAGNEXPERTS"].ToString(); m.DIAGNSTATUS = dt.Rows[i]["DIAGNSTATUS"].ToString(); m.DIAGNSTATUSName = BaseDT.T_SYS_DICT.getName(dt122, m.DIAGNSTATUS); m.DIAGNRESULT = dt.Rows[i]["DIAGNRESULT"].ToString(); m.DIAGNSPONSERUID = dt.Rows[i]["DIAGNSPONSERUID"].ToString(); if (!string.IsNullOrEmpty(m.DIAGNSPONSERUID)) { m.DIAGNSPONSERNAME = T_SYSSEC_IPSUSERCls.getname(m.DIAGNSPONSERUID); } m.DIAGNSPONSERTIME = ClsSwitch.SwitMN(dt.Rows[i]["DIAGNSPONSERTIME"].ToString()); } dt.Clear(); dt.Dispose(); dt122.Clear(); dt122.Dispose(); return(m); }
/// <summary> /// 获取记录 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(PEST_REMOTEDIAGN_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM PEST_REMOTEDIAGN WHERE 1=1"); if (string.IsNullOrEmpty(sw.PEST_REMOTEDIAGNID) == false) { sb.AppendFormat(" AND PEST_REMOTEDIAGNID = '{0}'", ClsSql.EncodeSql(sw.PEST_REMOTEDIAGNID)); } if (string.IsNullOrEmpty(sw.DIAGNTITLE) == false) { sb.AppendFormat(" AND DIAGNTITLE like '%{0}%'", ClsSql.EncodeSql(sw.DIAGNTITLE)); } if (string.IsNullOrEmpty(sw.DIAGNSTARTTIME) == false) { sb.AppendFormat(" AND DIAGNTIME >= '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.DIAGNSTARTTIME).ToString())); } if (string.IsNullOrEmpty(sw.DIAGNENDTIME) == false) { sb.AppendFormat(" AND DIAGNTIME <= '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.DIAGNENDTIME).AddDays(1).AddSeconds(-1).ToString())); } if (string.IsNullOrEmpty(sw.DIAGNSTATUS) == false) { sb.AppendFormat(" AND DIAGNSTATUS = '{0}'", ClsSql.EncodeSql(sw.DIAGNSTATUS)); } if (string.IsNullOrEmpty(sw.DIAGNSPONSERUID) == false) { sb.AppendFormat(" AND DIAGNSPONSERUID = '{0}'", ClsSql.EncodeSql(sw.DIAGNSPONSERUID)); } string sql = "SELECT PEST_REMOTEDIAGNID, DIAGNTITLE, DIAGNCONTENT, DIAGNTIME, DIAGNEXPERTS, DIAGNSTATUS, DIAGNRESULT, DIAGNSPONSERUID, DIAGNSPONSERTIME" + sb.ToString() + " ORDER BY DIAGNTIME DESC "; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在</returns> public static bool isExists(PEST_REMOTEDIAGN_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from PEST_REMOTEDIAGN where 1=1"); if (string.IsNullOrEmpty(sw.PEST_REMOTEDIAGNID) == false) { sb.AppendFormat(" and PEST_REMOTEDIAGNID= '{0}'", ClsSql.EncodeSql(sw.PEST_REMOTEDIAGNID)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static DataTable getDT(PEST_REMOTEDIAGN_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM PEST_REMOTEDIAGN WHERE 1=1"); if (string.IsNullOrEmpty(sw.PEST_REMOTEDIAGNID) == false) { sb.AppendFormat(" AND PEST_REMOTEDIAGNID = '{0}'", ClsSql.EncodeSql(sw.PEST_REMOTEDIAGNID)); } if (string.IsNullOrEmpty(sw.DIAGNTITLE) == false) { sb.AppendFormat(" AND DIAGNTITLE like '%{0}%'", ClsSql.EncodeSql(sw.DIAGNTITLE)); } if (string.IsNullOrEmpty(sw.DIAGNSTARTTIME) == false) { sb.AppendFormat(" AND DIAGNTIME >= '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.DIAGNSTARTTIME).ToString())); } if (string.IsNullOrEmpty(sw.DIAGNENDTIME) == false) { sb.AppendFormat(" AND DIAGNTIME <= '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.DIAGNENDTIME).AddDays(1).AddSeconds(-1).ToString())); } if (string.IsNullOrEmpty(sw.DIAGNSTATUS) == false) { sb.AppendFormat(" AND DIAGNSTATUS = '{0}'", ClsSql.EncodeSql(sw.DIAGNSTATUS)); } if (string.IsNullOrEmpty(sw.DIAGNSPONSERUID) == false) { sb.AppendFormat(" AND DIAGNSPONSERUID = '{0}'", ClsSql.EncodeSql(sw.DIAGNSPONSERUID)); } string sql = "SELECT PEST_REMOTEDIAGNID, DIAGNTITLE, DIAGNCONTENT, DIAGNTIME, DIAGNEXPERTS, DIAGNSTATUS, DIAGNRESULT, DIAGNSPONSERUID, DIAGNSPONSERTIME" + sb.ToString() + " ORDER BY DIAGNTIME DESC "; string sqlC = "select count(1) " + sb.ToString(); total = int.Parse(DataBaseClass.ReturnSqlField(sqlC)); sw.CurPage = PagerCls.getCurPage(new PagerSW { curPage = sw.CurPage, pageSize = sw.PageSize, rowCount = total }); DataSet ds = DataBaseClass.FullDataSet(sql, (sw.CurPage - 1) * sw.PageSize, sw.PageSize, "a"); return(ds.Tables[0]); }