public List <ReservationsInfo> GetReservationsPagerByRule(ReservationsSearchEntity serach, PagerInfo pager)
{
List <ReservationsInfo> result = new List <ReservationsInfo>();
StringBuilder builder = new StringBuilder();
if (serach.CustomerID > 0)
{
builder.Append(" AND CustomerID=@CustomerID ");
}
if (!string.IsNullOrEmpty(serach.RType))
{
builder.Append(" AND RType =@RType ");
}
if (!string.IsNullOrEmpty(serach.PayType))
{
builder.Append(" AND PayType=@PayType ");
}
if (serach.Status > -2)
{
builder.Append(" AND Status=@Status ");
}
string sql = ReservationsStatement.GetReservationPagerHeader + builder.ToString() + ReservationsStatement.GetReservationPagerFooter;
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(sql, "Text"));
if (serach.CustomerID > 0)
{
command.AddInputParameter("@CustomerID", DbType.Int64, serach.CustomerID);
}
if (!string.IsNullOrEmpty(serach.RType))
{
command.AddInputParameter("@RType", DbType.Int32, serach.RType);
}
if (!string.IsNullOrEmpty(serach.PayType))
{
command.AddInputParameter("@PayType", DbType.String, serach.PayType);
}
if (serach.Status > -2)
{
command.AddInputParameter("@Status", DbType.Int32, serach.Status);
}
command.AddInputParameter("@PageIndex", DbType.Int32, pager.PageIndex);
command.AddInputParameter("@PageSize", DbType.Int32, pager.PageSize);
command.AddInputParameter("@recordCount", DbType.Int32, pager.SumCount);
result = command.ExecuteEntityList <ReservationsInfo>();
return(result);
}
public int GetReservationsCount(ReservationsSearchEntity serach)
{
StringBuilder builder = new StringBuilder();
builder.Append(ReservationsStatement.GetReservationCount);
if (serach.CustomerID > 0)
{
builder.Append(" AND CustomerID=@CustomerID ");
}
if (!string.IsNullOrEmpty(serach.RType))
{
builder.Append(" AND RType =@RType ");
}
if (!string.IsNullOrEmpty(serach.PayType))
{
builder.Append(" AND PayType=@PayType ");
}
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(builder.ToString(), "Text"));
if (serach.CustomerID > 0)
{
command.AddInputParameter("@CustomerID", DbType.Int64, serach.CustomerID);
}
if (!string.IsNullOrEmpty(serach.RType))
{
command.AddInputParameter("@RType", DbType.String, serach.RType);
}
if (!string.IsNullOrEmpty(serach.PayType))
{
command.AddInputParameter("@PayType", DbType.String, serach.PayType);
}
var o = command.ExecuteScalar <object>();
return(Convert.ToInt32(o));
}