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