/// <summary>
/// 上一页信息
/// </summary>
/// <param name="Page">当前页</param>
/// <returns>上一页信息</returns>
public List <StoreOrderInfo> upPage(int Page)
{
Select lcutstring = new Select();
List <StoreOrderInfo> OrderList = new List <StoreOrderInfo>();
string Sql = "select UserID from StoreUser where UserName='******'";//查询UserID
Object obj = SqlHelper.ReadSclar(Sql);
int upPage = Page - 1;
string Sql1 = "select top 5 * from StoreOrderInfo where UserId='" + obj.ToString() + "' and orderID not in (select top ('" + upPage + "'*5) OrderID from StoreOrderInfo where UserId='" + obj.ToString() + "' ) order by OrderID asc";//下一页
SqlHelper.ReadDateReadBegin(Sql1);
while (SqlHelper.SqlReader.Read())//存入信息
{
StoreOrderInfo orderinfo = new StoreOrderInfo();
orderinfo.SaveOrderID = Convert.ToInt32(SqlHelper.SqlReader["SaveOrderID"]);
orderinfo.GoodName = lcutstring.CutString(SqlHelper.SqlReader["GoodName"].ToString(), 8);
orderinfo.TradeStatus = Convert.ToChar(SqlHelper.SqlReader["TradeStatus"]);
orderinfo.TotalPrices = Convert.ToInt32(SqlHelper.SqlReader["TotalPrices"]);
orderinfo.SubmitTime = SqlHelper.SqlReader["SubmitTime"].ToString();
orderinfo.IsEvaluate = Convert.ToChar(SqlHelper.SqlReader["IsEvaluate"]);
orderinfo.ImgAddress = SqlHelper.SqlReader["ImgAddress"].ToString();
OrderList.Add(orderinfo);
}
SqlHelper.ReadDateReadEnd();
return(OrderList);
}
/// <summary>
/// 获取订单信息
/// </summary>
/// <returns>订单信息</returns>
public List <StoreOrderInfo> OrderInfo()
{
Select lcutstring = new Select();
List <StoreOrderInfo> OrderList = new List <StoreOrderInfo>();
string Sql = "select UserID from StoreUser where UserName='******'"; //查询UserID
Object obj = SqlHelper.ReadSclar(Sql);
string Sql1 = "select top 5 * from StoreOrderInfo where Ltrim(UserID)='" + obj.ToString() + "'"; //查出前五条信息
SqlHelper.ReadDateReadBegin(Sql1);
while (SqlHelper.SqlReader.Read())//将信息存入
{
StoreOrderInfo orderinfo = new StoreOrderInfo();
orderinfo.SaveOrderID = Convert.ToInt32(SqlHelper.SqlReader["SaveOrderID"]);
orderinfo.GoodName = lcutstring.CutString(SqlHelper.SqlReader["GoodName"].ToString(), 8);
orderinfo.TradeStatus = Convert.ToChar(SqlHelper.SqlReader["TradeStatus"]);
orderinfo.TotalPrices = Convert.ToInt32(SqlHelper.SqlReader["TotalPrices"]);
orderinfo.SubmitTime = SqlHelper.SqlReader["SubmitTime"].ToString();
orderinfo.IsEvaluate = Convert.ToChar(SqlHelper.SqlReader["IsEvaluate"]);
orderinfo.ImgAddress = SqlHelper.SqlReader["ImgAddress"].ToString();
OrderList.Add(orderinfo);
}
SqlHelper.ReadDateReadEnd();
return(OrderList);
}