/// <summary> /// 获取分页列表 /// </summary> /// <param name="sw"></param> /// <param name="total"></param> /// <returns></returns> public static DataTable getDT(DC_PHOTO_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM DC_PHOTO"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.PHOTO_ID) == false) { sb.AppendFormat(" AND PHOTO_ID = '{0}'", ClsSql.EncodeSql(sw.PHOTO_ID)); } 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)); } string sql = "SELECT PHOTO_ID, PHOTOTITLE, PHOTOFILENAME, PHOTOEXPLAIN, PHOTOTIME, PHOTOTYPE, PRID" + sb.ToString() + " order by PHOTO_ID desc"; string sqlC = "select count(1) " + sb.ToString(); total = int.Parse(DataBaseClass.ReturnSqlField(sqlC)); sw.curPage = PagerCls.getCurPage(new PagerSW { curPage = sw.curPage, pageSize = sw.pageSize, rowCount = total }); DataSet ds = DataBaseClass.FullDataSet(sql, (sw.curPage - 1) * sw.pageSize, sw.pageSize, "a"); return(ds.Tables[0]); }
/// <summary> /// 获取记录 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static DataTable getDT(DC_PHOTO_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM DC_PHOTO"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.PHOTO_ID) == false) { sb.AppendFormat(" AND PHOTO_ID = '{0}'", ClsSql.EncodeSql(sw.PHOTO_ID)); } 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)); } string sql = ""; sql = "SELECT PHOTO_ID, PHOTOTITLE, PHOTOFILENAME, PHOTOEXPLAIN, PHOTOTIME, PHOTOTYPE, PRID" + sb.ToString() + " order by PHOTO_ID desc"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }
/// <summary> /// 判断记录是否存在 /// </summary> /// <param name="sw">参见模型</param> /// <returns>true存在 false不存在</returns> public static bool isExists(DC_PHOTO_SW sw) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("select 1 from DC_PHOTO where 1=1"); if (string.IsNullOrEmpty(sw.PHOTO_ID) == false) { sb.AppendFormat(" where PHOTO_ID= '{0}'", ClsSql.EncodeSql(sw.PHOTO_ID)); } return(DataBaseClass.JudgeRecordExists(sb.ToString())); }
/// <summary> /// 获取列表 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <DC_PHOTO_Model> getModelList(DC_PHOTO_SW sw) { var result = new List <DC_PHOTO_Model>(); DataTable dt = BaseDT.DC_PHOTO.getDT(sw);//列表 for (int i = 0; i < dt.Rows.Count; i++) { DC_PHOTO_Model m = new DC_PHOTO_Model(); m.PHOTO_ID = dt.Rows[i]["PHOTO_ID"].ToString(); m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString(); m.PHOTOFILENAME = dt.Rows[i]["PHOTOFILENAME"].ToString(); m.PHOTOEXPLAIN = dt.Rows[i]["PHOTOEXPLAIN"].ToString(); m.PHOTOTIME = PublicClassLibrary.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); }
/// <summary> /// 根据查询条件获取某一条用户信息记录,用于修改、删除、用户登录验证 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static DC_PHOTO_Model getModel(DC_PHOTO_SW sw) { var result = new List <DC_PHOTO_Model>(); DataTable dt = BaseDT.DC_PHOTO.getDT(sw);//列表 DC_PHOTO_Model m = new DC_PHOTO_Model(); if (dt.Rows.Count > 0) { int i = 0; m.PHOTO_ID = dt.Rows[i]["PHOTO_ID"].ToString(); m.PHOTOTITLE = dt.Rows[i]["PHOTOTITLE"].ToString(); m.PHOTOFILENAME = dt.Rows[i]["PHOTOFILENAME"].ToString(); m.PHOTOEXPLAIN = dt.Rows[i]["PHOTOEXPLAIN"].ToString(); m.PHOTOTIME = PublicClassLibrary.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); }