/// <summary>
/// 门票列表
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageIndex">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="search">查询条件</param>
/// <returns>门票列表</returns>
public IList <MScenicTickets> GetList(int pageSize, int pageIndex, ref int recordCount, MSearchScenicTickets search)
{
pageIndex = pageIndex > 0 ? pageIndex : 1;
return(dal.GetList(pageSize, pageIndex, ref recordCount, search));
}
/// <summary>
/// 门票列表
/// </summary>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageIndex">当前页</param>
/// <param name="recordCount">总记录数</param>
/// <param name="search">查询条件</param>
/// <returns>门票列表</returns>
public virtual IList <MScenicTickets> GetList(int pageSize, int pageIndex, ref int recordCount, MSearchScenicTickets search)
{
string tableName = "view_ScenicTickets_Select";
string primaryKey = "TicketsId";
string fields = "CompanyId,TicketsId,ScenicId,TypeName,RetailPrice,WebsitePrices,StartTime,EndTime,Payment,ExamineStatus,Status,B2B,B2C,ScenicName,IssueTime";
string orderBy = "ExamineStatus ASC,LastUpdateTime Desc"; //按照待审核，已审核，最后修改时间排序
#region 查询条件
StringBuilder query = new StringBuilder();
query.Append(" 1=1");
if (search != null)
{
if (search.ExamineStatus != null)
{
query.AppendFormat(" and ExamineStatus = {0}", (int)search.ExamineStatus);
}
if (search.Status != null)
{
query.AppendFormat(" and Status = {0}", (int)search.Status);
}
if (!string.IsNullOrEmpty(search.ScenicName))
{
query.AppendFormat(" and ScenicName like '%{0}%'", search.ScenicName);
}
if (!string.IsNullOrEmpty(search.TypeName))
{
query.AppendFormat(" and TypeName like '%{0}%'", search.TypeName);
}
if (!string.IsNullOrEmpty(search.ScenicId))
{
query.AppendFormat(" and ScenicId = '{0}'", search.ScenicId);
}
if (search.B2B != null)
{
query.AppendFormat(" and B2B = {0}", (int)search.B2B);
}
if (search.B2C != null)
{
query.AppendFormat(" and B2C = {0}", (int)search.B2C);
}
if (!string.IsNullOrEmpty(search.TicketsName))
{
query.AppendFormat(" and TypeName = '{0}'", search.TicketsName);
}
}
#endregion
IList <MScenicTickets> list = new List <MScenicTickets>();
MScenicTickets item = null;
using (IDataReader reader = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref recordCount,
tableName, primaryKey, fields, query.ToString(), orderBy))
{
while (reader.Read())
{
item = new MScenicTickets()
{
CompanyId = reader["CompanyId"].ToString(),
TicketsId = reader["TicketsId"].ToString(),
ScenicId = reader["ScenicId"].ToString(),
ScenicName = reader["ScenicName"].ToString(),
TypeName = reader["TypeName"].ToString(),
RetailPrice = reader.IsDBNull(reader.GetOrdinal("RetailPrice")) ? 0 : (decimal)reader["RetailPrice"],
WebsitePrices = reader.IsDBNull(reader.GetOrdinal("WebsitePrices")) ? 0 : (decimal)reader["WebsitePrices"],
Payment = (ScenicPayment)Enum.Parse(typeof(ScenicPayment), reader["Payment"].ToString()),
Status = (ScenicTicketsStatus)Enum.Parse(typeof(ScenicTicketsStatus), reader["Status"].ToString()),
ExamineStatus = (ExamineStatus)Enum.Parse(typeof(ExamineStatus), reader["ExamineStatus"].ToString()),
B2B = (ScenicB2BDisplay)Enum.Parse(typeof(ScenicB2BDisplay), reader["B2B"].ToString()),
B2C = (ScenicB2CDisplay)Enum.Parse(typeof(ScenicB2CDisplay), reader["B2C"].ToString()),
IssueTime = (DateTime)reader["IssueTime"],
};
if (!reader.IsDBNull(reader.GetOrdinal("StartTime")))
{
item.StartTime = (DateTime)reader["StartTime"];
}
if (!reader.IsDBNull(reader.GetOrdinal("EndTime")))
{
item.EndTime = (DateTime)reader["EndTime"];
}
list.Add(item);
}
}
return(list);
}
