/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <E_FILE_Model> getListModel(E_File_SW sw) { DataTable dt = BaseDT.E_FILE.getDT(sw);//列表 var result = new List <E_FILE_Model>(); for (int i = 0; i < dt.Rows.Count; i++) { E_FILE_Model m = new E_FILE_Model(); m.BYEMAILID = dt.Rows[i]["BYEMAILID"].ToString(); m.EFID = dt.Rows[i]["EFID"].ToString(); m.EMAILFILENAME = dt.Rows[i]["EMAILFILENAME"].ToString(); m.EMAILFILESIZE = dt.Rows[i]["EMAILFILESIZE"].ToString(); m.EMAILFILETITLE = dt.Rows[i]["EMAILFILETITLE"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 获取数据 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(E_File_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM E_File a"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.EFID) == false) { sb.AppendFormat(" AND EFID = '{0}'", ClsSql.EncodeSql(sw.EFID)); } if (string.IsNullOrEmpty(sw.BYEMAILID) == false) { sb.AppendFormat(" AND BYEMAILID = '{0}'", ClsSql.EncodeSql(sw.BYEMAILID)); } string sql = "SELECT EFID, BYEMAILID, EMAILFILETITLE, EMAILFILESIZE, EMAILFILENAME" + sb.ToString() + " order by EFID"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }