/// <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 PEST_CONSULTATION_Model getModel(PEST_CONSULTATION_SW sw) { DataTable dt = BaseDT.PEST_CONSULTATION.getDT(sw);//列表 PEST_CONSULTATION_Model m = new PEST_CONSULTATION_Model(); if (dt.Rows.Count > 0) { int i = 0; m.PEST_CONSULTATIONID = dt.Rows[i]["PEST_CONSULTATIONID"].ToString(); m.CONSULTITLE = dt.Rows[i]["CONSULTITLE"].ToString(); m.CONSULPHONE = dt.Rows[i]["CONSULPHONE"].ToString(); m.CONSULTIME = ClsSwitch.SwitMN(dt.Rows[i]["CONSULTIME"].ToString()); m.CONSULCONTENT = dt.Rows[i]["CONSULCONTENT"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static IEnumerable <PEST_CONSULTATION_Model> getListModel(PEST_CONSULTATION_SW sw, out int total) { var result = new List <PEST_CONSULTATION_Model>(); DataTable dt = BaseDT.PEST_CONSULTATION.getDT(sw, out total);//列表 for (int i = 0; i < dt.Rows.Count; i++) { PEST_CONSULTATION_Model m = new PEST_CONSULTATION_Model(); m.PEST_CONSULTATIONID = dt.Rows[i]["PEST_CONSULTATIONID"].ToString(); m.CONSULTITLE = dt.Rows[i]["CONSULTITLE"].ToString(); m.CONSULPHONE = dt.Rows[i]["CONSULPHONE"].ToString(); m.CONSULTIME = ClsSwitch.SwitMN(dt.Rows[i]["CONSULTIME"].ToString()); m.CONSULCONTENT = dt.Rows[i]["CONSULCONTENT"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }