/// <summary> /// 获取数据 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(PEST_COLLECT_DATAUPLOAD_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM PEST_COLLECT_DATAUPLOAD WHERE 1=1"); #region 查询条件 //根据文件名查询 if (string.IsNullOrEmpty(sw.PESTCOLLDATAID) == false) { sb.AppendFormat(" AND PESTCOLLDATAID = '{0}'", ClsSql.EncodeSql(sw.PESTCOLLDATAID)); } //根据文件名查询 if (string.IsNullOrEmpty(sw.UPLOADNAME) == false) { sb.AppendFormat(" AND UPLOADNAME like '%{0}%'", ClsSql.EncodeSql(sw.UPLOADNAME)); } //根据文件描述查询 if (string.IsNullOrEmpty(sw.UPLOADDESCRIBE) == false) { sb.AppendFormat(" AND UPLOADDESCRIBE = '{0}'", ClsSql.EncodeSql(sw.UPLOADDESCRIBE)); } #endregion string sql = "SELECT * " + sb.ToString() + " order by PESTCOLLDATAUPLOADID,UPLOADTYPE "; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <PEST_COLLECT_DATAUPLOAD_Model> getModelList(PEST_COLLECT_DATAUPLOAD_SW sw) { var result = new List <PEST_COLLECT_DATAUPLOAD_Model>(); DataTable dt = BaseDT.PEST_COLLECT_DATAUPLOAD.getDT(sw);//列表 for (int i = 0; i < dt.Rows.Count; i++) { PEST_COLLECT_DATAUPLOAD_Model m = new PEST_COLLECT_DATAUPLOAD_Model(); m.PESTCOLLDATAUPLOADID = dt.Rows[i]["PESTCOLLDATAUPLOADID"].ToString(); m.PESTCOLLDATAID = dt.Rows[i]["PESTCOLLDATAID"].ToString(); m.UPLOADNAME = dt.Rows[i]["UPLOADNAME"].ToString(); m.UPLOADDESCRIBE = dt.Rows[i]["UPLOADDESCRIBE"].ToString(); m.UPLOADURL = dt.Rows[i]["UPLOADURL"].ToString(); m.UPLOADTYPE = dt.Rows[i]["UPLOADTYPE"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }