/// <summary> /// 获取数量列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <WILD_ANIMALFILE_Model> getModelList(WILD_ANIMALFILE_SW sw) { var result = new List <WILD_ANIMALFILE_Model>(); DataTable dt = BaseDT.WILD_ANIMALFILE.getDT(sw);//列表 DataTable dtBiolo = BaseDT.T_SYS_BIOLOGICALTYPE.getDT(new T_SYS_BIOLOGICALTYPE_SW()); for (int i = 0; i < dt.Rows.Count; i++) { WILD_ANIMALFILE_Model m = new WILD_ANIMALFILE_Model(); m.PESTFILEID = dt.Rows[i]["PESTFILEID"].ToString(); m.BIOLOGICALTYPECODE = dt.Rows[i]["BIOLOGICALTYPECODE"].ToString(); m.BIOLOGICALTYPENAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.BIOLOGICALTYPECODE); m.PESTFILETITLE = dt.Rows[i]["PESTFILETITLE"].ToString(); m.PESTFILETYPE = dt.Rows[i]["PESTFILETYPE"].ToString(); m.PESTFILENAME = dt.Rows[i]["PESTFILENAME"].ToString(); m.UPLOADTIME = ClsSwitch.SwitTM(dt.Rows[i]["UPLOADTIME"].ToString()); m.UID = dt.Rows[i]["UID"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); dtBiolo.Clear(); dtBiolo.Dispose(); return(result); }
/// <summary> /// 获取数据 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(WILD_ANIMALFILE_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM WILD_ANIMALFILE WHERE 1=1"); #region 查询条件 //生物物种编码 if (string.IsNullOrEmpty(sw.BIOLOGICALTYPECODE) == false) { sb.AppendFormat(" AND BIOLOGICALTYPECODE = '{0}'", ClsSql.EncodeSql(sw.BIOLOGICALTYPECODE)); } //附近名称 if (string.IsNullOrEmpty(sw.PESTFILETITLE) == false) { sb.AppendFormat(" AND PESTFILETITLE = '{0}'", ClsSql.EncodeSql(sw.PESTFILETITLE)); } //附件类别 if (string.IsNullOrEmpty(sw.PESTFILETYPE) == false) { sb.AppendFormat(" AND PESTFILETYPE = '{0}'", ClsSql.EncodeSql(sw.PESTFILETYPE)); } #endregion string sql = "SELECT PESTFILEID, BIOLOGICALTYPECODE, PESTFILETITLE, PESTFILETYPE, PESTFILENAME, UPLOADTIME, UID " + sb.ToString() + " ORDER BY UPLOADTIME "; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 获取单条记录 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static WILD_ANIMALFILE_Model getModel(WILD_ANIMALFILE_SW sw) { WILD_ANIMALFILE_Model m = new WILD_ANIMALFILE_Model(); DataTable dt = BaseDT.WILD_ANIMALFILE.getDT(sw);//列表 if (dt.Rows.Count > 0) { int i = 0; m.PESTFILEID = dt.Rows[i]["PESTFILEID"].ToString(); m.BIOLOGICALTYPECODE = dt.Rows[i]["BIOLOGICALTYPECODE"].ToString(); m.PESTFILETITLE = dt.Rows[i]["PESTFILETITLE"].ToString(); m.PESTFILETYPE = dt.Rows[i]["PESTFILETYPE"].ToString(); m.PESTFILENAME = dt.Rows[i]["PESTFILENAME"].ToString(); m.UPLOADTIME = ClsSwitch.SwitTM(dt.Rows[i]["UPLOADTIME"].ToString()); m.UID = dt.Rows[i]["UID"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }