/// <summary> /// 获取数据 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(PEST_PHOTO_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM PEST_PHOTO WHERE 1=1"); #region 查询条件 //根据表名查询 if (string.IsNullOrEmpty(sw.PHOTOTYPE) == false) { sb.AppendFormat(" AND PHOTOTYPE = '{0}'", ClsSql.EncodeSql(sw.PHOTOTYPE)); } //根据所属序号查询 if (string.IsNullOrEmpty(sw.PRID) == false) { sb.AppendFormat(" AND PRID = '{0}'", ClsSql.EncodeSql(sw.PRID)); } //根据照片标题查询 if (string.IsNullOrEmpty(sw.PHOTOTITLE) == false) { sb.AppendFormat(" AND PHOTOTITLE = '{0}'", ClsSql.EncodeSql(sw.PHOTOTITLE)); } //根据照片描述查询 if (string.IsNullOrEmpty(sw.PHOTOEXPLAIN) == false) { sb.AppendFormat(" AND PHOTOEXPLAIN like '%{0}%'", ClsSql.EncodeSql(sw.PHOTOEXPLAIN)); } #endregion string sql = "SELECT PEST_PHOTOID, PHOTOTITLE, PHOTOFILENAME, PHOTOEXPLAIN, PHOTOTIME, PHOTOTYPE, PRID " + sb.ToString() + " ORDER BY PEST_PHOTOID, PHOTOTIME "; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 获取单条记录 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static PEST_PHOTO_Model getModel(PEST_PHOTO_SW sw) { PEST_PHOTO_Model m = new PEST_PHOTO_Model(); DataTable dt = BaseDT.PEST_PHOTO.getDT(sw);//列表 if (dt.Rows.Count > 0) { int i = 0; m.PEST_PHOTOID = dt.Rows[i]["PEST_PHOTOID"].ToString(); m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString(); m.PHOTOFILENAME = dt.Rows[i]["PHOTOFILENAME"].ToString(); m.PHOTOEXPLAIN = dt.Rows[i]["PHOTOEXPLAIN"].ToString(); m.PHOTOTIME = ClsSwitch.SwitTM(dt.Rows[i]["PHOTOTIME"].ToString()); m.PHOTOTYPE = dt.Rows[i]["PHOTOTYPE"].ToString(); m.PRID = dt.Rows[i]["PRID"].ToString(); } dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <PEST_PHOTO_Model> getModelList(PEST_PHOTO_SW sw) { var result = new List <PEST_PHOTO_Model>(); DataTable dt = BaseDT.PEST_PHOTO.getDT(sw);//列表 for (int i = 0; i < dt.Rows.Count; i++) { PEST_PHOTO_Model m = new PEST_PHOTO_Model(); m.PEST_PHOTOID = dt.Rows[i]["PEST_PHOTOID"].ToString(); m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString(); m.PHOTOFILENAME = dt.Rows[i]["PHOTOFILENAME"].ToString(); m.PHOTOEXPLAIN = dt.Rows[i]["PHOTOEXPLAIN"].ToString(); m.PHOTOTIME = ClsSwitch.SwitTM(dt.Rows[i]["PHOTOTIME"].ToString()); m.PHOTOTYPE = dt.Rows[i]["PHOTOTYPE"].ToString(); m.PRID = dt.Rows[i]["PRID"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }