/// <summary>
/// 获取记录
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(PEST_CONSULREPLY_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM PEST_CONSULREPLY WHERE 1=1");
if (string.IsNullOrEmpty(sw.PEST_CONSULREPLYID) == false)
{
sb.AppendFormat(" AND PEST_CONSULTATIONID = '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULTATIONID));
}
if (string.IsNullOrEmpty(sw.PEST_CONSULTATIONID) == false)
{
sb.AppendFormat(" AND PEST_CONSULTATIONID = '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULTATIONID));
}
if (string.IsNullOrEmpty(sw.REPLYUID) == false)
{
sb.AppendFormat(" AND REPLYUID = '{0}'", ClsSql.EncodeSql(sw.REPLYUID));
}
if (string.IsNullOrEmpty(sw.REPLYTIME) == false)
{
sb.AppendFormat(" AND REPLYTIME = '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.REPLYTIME).ToString()));
sb.AppendFormat(" AND REPLYTIME = '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.REPLYTIME).AddDays(1).AddSeconds(-1).ToString()));
}
string sql = "SELECT PEST_CONSULREPLYID, PEST_CONSULTATIONID, REPLYUID, REPLYTIME, REPLYCONTENT" + sb.ToString() + " ORDER BY REPLYTIME ";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 获取分页列表
/// </summary>
/// <param name="sw"></param>
/// <param name="total"></param>
/// <returns></returns>
public static DataTable getDT(PEST_CONSULREPLY_SW sw, out int total)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM PEST_CONSULREPLY WHERE 1=1");
if (string.IsNullOrEmpty(sw.PEST_CONSULREPLYID) == false)
{
sb.AppendFormat(" AND PEST_CONSULTATIONID = '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULTATIONID));
}
if (string.IsNullOrEmpty(sw.PEST_CONSULTATIONID) == false)
{
sb.AppendFormat(" AND PEST_CONSULTATIONID = '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULTATIONID));
}
if (string.IsNullOrEmpty(sw.REPLYUID) == false)
{
sb.AppendFormat(" AND REPLYUID = '{0}'", ClsSql.EncodeSql(sw.REPLYUID));
}
if (string.IsNullOrEmpty(sw.REPLYTIME) == false)
{
sb.AppendFormat(" AND REPLYTIME = '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.REPLYTIME).ToString()));
sb.AppendFormat(" AND REPLYTIME = '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.REPLYTIME).AddDays(1).AddSeconds(-1).ToString()));
}
string sql = "SELECT PEST_CONSULREPLYID, PEST_CONSULTATIONID, REPLYUID, REPLYTIME, REPLYCONTENT" + sb.ToString() + " ORDER BY REPLYTIME ";
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>true存在 false不存在</returns>
public static bool isExists(PEST_CONSULREPLY_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from PEST_CONSULREPLY where 1=1");
if (string.IsNullOrEmpty(sw.PEST_CONSULREPLYID) == false)
{
sb.AppendFormat(" where PEST_CONSULREPLYID= '{0}'", ClsSql.EncodeSql(sw.PEST_CONSULREPLYID));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
