/// <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);
}
