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