private void BindOrderGifts()
{
PurchaseOrderGiftQuery query = new PurchaseOrderGiftQuery();
query.PageSize = 10;
query.PageIndex = pagerOrderGifts.PageIndex;
query.PurchaseOrderId = purchaseOrderId;
DbQueryResult purchaseOrderGifts = SubsiteSalesHelper.GetPurchaseOrderGifts(query);
dlstOrderGifts.DataSource = purchaseOrderGifts.Data;
dlstOrderGifts.DataBind();
pagerOrderGifts.TotalRecords = purchaseOrderGifts.TotalRecords;
}
public override DbQueryResult GetPurchaseOrderGifts(PurchaseOrderGiftQuery query)
{
DbQueryResult result = new DbQueryResult();
StringBuilder builder = new StringBuilder();
builder.AppendFormat("select top {0} * from Hishop_PurchaseOrderGifts where PurchaseOrderId=@PurchaseOrderId", query.PageSize);
if (query.PageIndex == 1)
{
builder.Append(" ORDER BY GiftId ASC");
}
else
{
builder.AppendFormat(" and GiftId > (select max(GiftId) from (select top {0} GiftId from Hishop_PurchaseOrderGifts where PurchaseOrderId=@PurchaseOrderId ORDER BY GiftId ASC ) as tbltemp) ORDER BY GiftId ASC", (query.PageIndex - 1) * query.PageSize);
}
if (query.IsCount)
{
builder.AppendFormat(";select count(GiftId) as Total from Hishop_PurchaseOrderGifts where PurchaseOrderId=@PurchaseOrderId", new object[0]);
}
DbCommand sqlStringCommand = database.GetSqlStringCommand(builder.ToString());
database.AddInParameter(sqlStringCommand, "PurchaseOrderId", DbType.String, query.PurchaseOrderId);
using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
{
result.Data = DataHelper.ConverDataReaderToDataTable(reader);
if (query.IsCount && reader.NextResult())
{
reader.Read();
result.TotalRecords = reader.GetInt32(0);
}
}
return result;
}
public static DbQueryResult GetPurchaseOrderGifts(PurchaseOrderGiftQuery query)
{
return SubsiteSalesProvider.Instance().GetPurchaseOrderGifts(query);
}