/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <SceneryOrderRefundDomain> GetAllDomain(QueryCondition query, Hashtable hsWhere)
{
query.AddEqual("RowState", "1").AddOrderBy("Id", false);
var parameters = WriteAdoTemplate.CreateDbParameters();
StringBuilder strSql = new StringBuilder();
StringBuilder otherWhere = new StringBuilder();
if (hsWhere.ContainsKey("ApprovalStatus"))
{
otherWhere.AppendFormat(" and ApprovalStatus in (0,1)");
}
strSql.Append("select Id,SceneryTCId,SceneryName,BatchNumber,SerialId,PlayDate,Total,ApprovalStatus,PayType,CreateTime,Creater,UpdateTime,Updater,RowState from SceneryOrderRefund ");
if (query.GetPager() != null)
{
string sumSql = "sum(Total) as SumTotal";
strSql = new StringBuilder(GetPagerSql(strSql.ToString(), query, parameters, otherWhere.ToString(), sumSql));
}
else
{
strSql.Append(query.GetSQL_Where(parameters));
strSql.Append(otherWhere);
strSql.Append(query.GetSQL_Order());
}
return(ReadAdoTemplate.QueryWithRowMapperDelegate <SceneryOrderRefundDomain>(CommandType.Text, strSql.ToString(), MapRow, parameters));
}
