/// <summary>
/// 分页获取模板集合
/// </summary>
public List <BS_Template> GetList(ref PagerModel pager, string noticeType, string coreType, string name, Enums.TemplateType templateType)
{
StringBuilder sql = new StringBuilder(string.Format(@"
select *
from BS_Template t
where 1=1 "));
if (!string.IsNullOrWhiteSpace(noticeType))
{
sql.AppendFormat(" and nt.name like '%{0}%'", noticeType);
}
if (!string.IsNullOrWhiteSpace(coreType))
{
sql.AppendFormat(" and ct.name like '%{0}%'", coreType);
}
if (!string.IsNullOrWhiteSpace(name))
{
sql.AppendFormat(" and t.name like '%{0}%'", name);
}
sql.AppendFormat(" and t.type = '{0}'", (int)templateType);
string orderby = "order by cast(id as int)";
pager = DBHelper.FindPageBySql <BS_Template>(sql.ToString(), orderby, pager.rows, pager.page);
return(pager.result as List <BS_Template>);
}
/// <summary>
/// 分页获取
/// </summary>
public List <BS_Test> GetList(ref PagerModel pager, string name)
{
StringBuilder sql = new StringBuilder(string.Format(@"
select *
from BS_Test t
where 1=1 "));
if (!string.IsNullOrWhiteSpace(name))
{
sql.AppendFormat(" and t.name like '%{0}%'", name);
}
string orderby = string.Empty;
pager = DBHelper.FindPageBySql <BS_Test>(sql.ToString(), orderby, pager.rows, pager.page);
return(pager.result as List <BS_Test>);
}
/// <summary>
/// 分页获取集合
/// </summary>
public List <TWO_ORDER> GetListPage(ref PagerModel pager, string name, DateTime startTime, DateTime endTime, int?status)
{
SqlString sql = new SqlString(string.Format(@"
select *
from two_order t
where 1=1
and DEL_FLAG='{0}'", "0"));
sql.AppendSql(@"
and (
ORDER_TIME>=STR_TO_DATE(@startTime, '%Y-%m-%d %H:%i:%s')
and ORDER_TIME<=STR_TO_DATE(@endTime, '%Y-%m-%d %H:%i:%s')
)", startTime.ToString("yyyy-MM-dd HH:mm:ss"), endTime.ToString("yyyy-MM-dd HH:mm:ss"));
if (!string.IsNullOrWhiteSpace(name))
{
sql.AppendSql(" and PRISONER_NAME like @name", "%" + name + "%");
}
if (status != null)
{
sql.AppendSql(" and T_STATUS = @status", status);
}
if (status != null)
{
sql.AppendFormat(" and T_STATUS = '{0}'", status); //测试追加非参数化SQL
}
sql.AppendSql(" and 1=1"); //测试没有参数
string orderby = "order by ORDER_TIME desc, ID asc"; //测试排序
pager = DBHelper.FindPageBySql <TWO_ORDER>(sql.SQL, orderby, pager.rows, pager.page, sql.Params);
return(pager.result as List <TWO_ORDER>);
}