/// <summary> /// 订单分页查询 /// </summary> /// <param name="CurrentPage"></param> /// <returns></returns> public List <SaveOrders> DivideShow(int CurrentPage) { List <SaveOrders> ListOrder = new List <SaveOrders>(); string Sqlstring1 = "select top (8) StoreUser.UserName,Good.GoodName,OrderID,TotalPrices,SaveOrders.IsDeal from SaveOrders left join SingleGoodInfo on SaveOrders.SingleGoodID=SingleGoodInfo.SingleGoodID left join StoreUser on StoreUser.UserID=SaveOrders.UserID left join Good on SingleGoodInfo.GoodID=Good.GoodID where OrderID not in (select top (" + CurrentPage * 8 + ") OrderID from SaveOrders order by OrderID asc)order by OrderID"; SqlHelper.ReadDateReadBegin(Sqlstring1); while (SqlHelper.SqlReader.Read()) { SaveOrders mOrder = new SaveOrders(); mOrder.ReceiveStr = SqlHelper.SqlReader["UserName"].ToString(); mOrder.Getstr = SqlHelper.SqlReader["GoodName"].ToString(); mOrder.OrderID = SqlHelper.SqlReader["OrderID"].ToString(); mOrder.TotalPrices = Convert.ToInt32(SqlHelper.SqlReader["TotalPrices"]); string str = SqlHelper.SqlReader["IsDeal"].ToString(); switch (str) { case "0": mOrder.IsDeal = "未处理"; break; case "1": mOrder.IsDeal = "已处理"; break; case "2": mOrder.IsDeal = "已取消"; break; } ListOrder.Add(mOrder); } SqlHelper.ReadDateReadEnd(); return(ListOrder); }
/// <summary> /// 修改处理订单管理员ID /// </summary> /// <param name="alter"></param> /// <returns></returns> //public bool AlterStaffID(SaveOrders alter) //{ // string sqlstr="update Orders set StaffID ='"+alter .StaffID +"'"+" where OrderID='"+alter .StaffID +"'"+";update SaveOrders set StaffID ='"+alter .StaffID +"'"+" where OrderID='"+alter .StaffID +"'"; // if (SqlHelper.ExecuteNonQuery(sqlstr) > 0) // { // return true; // } // else // { // return false; // } //} /// <summary> /// 时间获取 /// </summary> /// <param name="GetTime"></param> /// <returns></returns> public bool GetTradeTime(SaveOrders GetTime) { string sqlstring = ""; switch (GetTime.TradeStatus.ToString()) { case "1": sqlstring = "update SaveOrders set SubmitTime = getdate() where OrderID='" + GetTime.OrderID + "'" + ";update Orders set SubmitTime = getdate() where OrderID='" + GetTime.OrderID + "'";; break; case "2": sqlstring = "update SaveOrders set SendTime = getdate() where OrderID='" + GetTime.OrderID + "'" + ";update Orders set SendTime = getdate() where OrderID='" + GetTime.OrderID + "'"; break; case "3": sqlstring = "update SaveOrders set EndTime = getdate() where OrderID='" + GetTime.OrderID + "'" + "; update Orders set EndTime = getdate() where OrderID='" + GetTime.OrderID + "'"; break; } if (GetTime.TradeStatus.ToString() != "0") { if (SqlHelper.ExecuteNonQuery(sqlstring) > 0) { return(true); } else { return(false); } } else { return(false); } }
public bool DeleteOrder(SaveOrders mSaveOrder) { string sqlstring = "delete from SaveOrders where OrderID='" + mSaveOrder.OrderID + "'"; if (SqlHelper.ExecuteNonQuery(sqlstring) > 0) { return(true); } else { return(false); } }
/// <summary> /// 验证输入的订单号是否存在 /// </summary> /// <param name="mOrder"></param> /// <returns></returns> public bool OrderExam(SaveOrders mOrder) { string sqlstring = "select UserID from SaveOrders where OrderID='" + mOrder.OrderID + "'"; if (SqlHelper.ReadSclar(sqlstring) != null) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["hOrderID"] != null) { tbxOrderID.Text = Session["hOrderID"].ToString(); } SaveOrders hOrder = new Models.SaveOrders(); hOrder.OrderID = tbxOrderID.Text; OA mOrder = new OA(); OAController mController = new OAController(); arry = mController.SearchOrder(mOrder, hOrder); tbxAddress.Text = arry[1]; tbxCalloffReason.Text = arry[7]; tbxEndTime.Text = arry[9]; tbxNumber.Text = arry[2]; tbxSendTime.Text = arry[8]; tbxStaffID.Text = arry[10]; tbxSubmitTime.Text = arry[5]; tbxToTalPrice.Text = arry[3]; tbxUserID.Text = arry[0]; switch (arry[6]) { case "0": //TradeStatus.SelectedIndex = 0; this.lblTradeStatus.Text = "买家未付款"; break; case "1": //TradeStatus.SelectedIndex = 1; this.lblTradeStatus.Text = "买家付款"; break; case "2": // TradeStatus.SelectedIndex = 2; this.lblTradeStatus.Text = "商城发货"; break; case "3": //TradeStatus.SelectedIndex = 3; this.lblTradeStatus.Text = "交易完成"; break; } } Session["hOrder"] = ""; }
/// <summary> /// 对订单的修改 /// </summary> /// <returns></returns> public bool AlterOrderStatus(SaveOrders alter) { string sqlstring = "update Orders set TradeStatus ='" + alter.TradeStatus + "'" + "where OrderID='" + alter.OrderID + "'" + ";update SaveOrders set TradeStatus ='" + alter.TradeStatus + "'" + "where OrderID='" + alter.OrderID + "'" + ";update SaveOrders set IsDeal ='" + alter.IsDeal + "'" + "where OrderID='" + alter.OrderID + "'" + ";update Orders set IsDeal ='" + alter.IsDeal + "'" + "where OrderID='" + alter.OrderID + "'" + ";update SaveOrders set StaffID='" + alter.StaffID + "'" + "where OrderID='" + alter.OrderID + "'" + ";update Orders set StaffID='" + alter.StaffID + "'" + "where OrderID='" + alter.OrderID + "'"; string sqlstring2 = "select UserInfo.MoneySum from StoreUser left join UserInfo on UserInfo.UserID=StoreUser.UserID where UserName='******'"; StoreUser mStore = new StoreUser(); mStore.UserName = alter.ReceiveStr; int TempUserID = StoreUser.UserNameGetID(mStore); int Money = Convert.ToInt32(SqlHelper.ReadSclar(sqlstring2)) + Convert.ToInt32(alter.TotalPrices); string sqlstring3 = "update UserInfo set MoneySum ='" + Money + "'" + "where UserID='" + TempUserID + "'"; if (alter.TradeStatus == '3' && alter.Number != 0) { string sqlstring4 = "select Good.SalesVolume from SaveOrders left join SaveSingleGoodInfo on SaveOrders.SingleGoodID=SaveSingleGoodInfo.SingleGoodID left join Good on SaveSingleGoodInfo.GoodID=Good.GoodID where OrderID='" + alter.OrderID + "'"; string sqlstring5 = "select GoodID from SaveOrders left join SaveSingleGoodInfo on SaveOrders.SingleGoodID=SaveSingleGoodInfo.SingleGoodID where OrderID='" + alter.OrderID + "'"; int SalesVolume = (Convert.ToInt32(SqlHelper.ReadSclar(sqlstring4)) + alter.Number); int GoodID = Convert.ToInt32(SqlHelper.ReadSclar(sqlstring5)); string sqlstring6 = "update Good set SalesVolume='" + SalesVolume + "'" + " where GoodID='" + GoodID + "'"; string sqlstring8 = "select Good.GoodIncentory from SaveOrders left join SaveSingleGoodInfo on SaveOrders.SingleGoodID=SaveSingleGoodInfo.SingleGoodID left join Good on SaveSingleGoodInfo.GoodID=Good.GoodID where OrderID='" + alter.OrderID + "'"; int GoodIncentory = (Convert.ToInt32(SqlHelper.ReadSclar(sqlstring8)) - alter.Number); string sqlstring7 = "update Good set GoodIncentory='" + GoodIncentory + "'" + " where GoodID='" + GoodID + "'"; SingleGoodInfo mSingleGoodInfo = new SingleGoodInfo(); mSingleGoodInfo.SingleGoodID = alter.SingleGoodID; int TempGoodID = SingleGoodInfo.SingleGoodIDGetGood(mSingleGoodInfo); string sqlstring1 = "delete top(" + alter.Number + ") from SaveSingleGoodInfo where GoodID='" + TempGoodID + "'"; if (SqlHelper.ExecuteNonQuery(sqlstring) > 0 && SqlHelper.ExecuteNonQuery(sqlstring1) > 0 && SqlHelper.ExecuteNonQuery(sqlstring3) > 0 && SqlHelper.ExecuteNonQuery(sqlstring6) > 0 && SqlHelper.ExecuteNonQuery(sqlstring7) > 0) { return(true); } else { return(false); } } else { if (SqlHelper.ExecuteNonQuery(sqlstring) > 0) { return(true); } else { return(false); } } }
public string[] OrderInfoRead(SaveOrders Order) { string sqlstring1 = "select StoreUser.UserName,ShipAddress.Address,SingleGoodID,Number,TotalPrices,SubmitTime,TradeStatus,CalloffReason,SendTime,EndTime,Admin.TrueName,SaveOrders.IsDeal from SaveOrders left join StoreUser on StoreUser.UserID=SaveOrders.UserID left Join Admin on Admin.StaffID=SaveOrders.StaffID left join ShipAddress on SaveOrders.AddressID=ShipAddress.AddressID where SaveOrders.OrderID=N'" + Order.OrderID + "'"; SqlHelper.ReadDateReadBegin(sqlstring1); while (SqlHelper.SqlReader.Read()) { arr[0] = SqlHelper.SqlReader["UserName"].ToString(); arr[1] = SqlHelper.SqlReader["Address"].ToString(); arr[2] = SqlHelper.SqlReader["Number"].ToString(); arr[3] = SqlHelper.SqlReader["TotalPrices"].ToString(); arr[5] = SqlHelper.SqlReader["SubmitTime"].ToString(); arr[6] = SqlHelper.SqlReader["TradeStatus"].ToString(); arr[7] = SqlHelper.SqlReader["CalloffReason"].ToString(); arr[8] = SqlHelper.SqlReader["SendTime"].ToString(); arr[9] = SqlHelper.SqlReader["EndTime"].ToString(); arr[10] = SqlHelper.SqlReader["TrueName"].ToString(); arr[12] = SqlHelper.SqlReader["IsDeal"].ToString(); arr[4] = SqlHelper.SqlReader["SingleGoodID"].ToString(); } SqlHelper.ReadDateReadEnd(); return(arr); }
/// <summary> /// 高级管理员查看订单信息列表 /// </summary> /// <param name="surrentPage"></param> /// <returns></returns> public List <SaveOrders> OrderShow(int surrentPage) { List <SaveOrders> listOrder = new List <SaveOrders>(); string Sqlstring1 = "select top 8 OrderID,UserID,TotalPrices,SubmitTime,TradeStatus from SaveOrders where OrderID not in (select top " + surrentPage * 8 + " OrderID from SaveOrders order by OrderID asc) order by OrderID"; SqlHelper.ReadDateReadBegin(Sqlstring1); while (SqlHelper.SqlReader.Read()) { SaveOrders morder = new SaveOrders(); morder.OrderID = SqlHelper.SqlReader["OrderID"].ToString(); morder.UserID = Convert.ToInt32(SqlHelper.SqlReader["UserID"]); morder.TotalPrices = Convert.ToDouble(SqlHelper.SqlReader["TotalPrices"]); morder.SubmitTime = SqlHelper.SqlReader["SubmitTime"].ToString(); switch (Convert.ToChar(SqlHelper.SqlReader["TradeStatus"])) { case '0': morder.aTradeStatus = "买家未付款"; break; case '1': morder.aTradeStatus = "买家付款"; break; case '2': morder.aTradeStatus = "商城发货"; break; case '3': morder.aTradeStatus = "交易完成"; break; } listOrder.Add(morder); } SqlHelper.ReadDateReadEnd(); return(listOrder); }
protected void Alter_Click(object sender, EventArgs e) { if (Session["hUserName"] != null) { StrUserName = Session["hUserName"].ToString(); } OA m = new OA(); SaveOrders status = new SaveOrders(); Admins madmin = new Admins(); madmin.UserName = StrUserName; madmin.StaffID = Admins.UserNameGetStaffID(madmin); status.StaffID = madmin.StaffID; status.TradeStatus = Convert.ToChar(Status); if (Status == "3") { TradeStatus.Enabled = false; } if (Session["hOrderID"] != null) { tbxOrderID.Text = Session["hOrderID"].ToString(); } else { tbxOrderID.Text = receive; } status.OrderID = tbxOrderID.Text; if (tbxNumber.Text == null) { tbxNumber.Text = "0"; } else { status.Number = Convert.ToInt32(tbxNumber.Text); } status.Number = Convert.ToInt32(tbxNumber.Text); status.SingleGoodID = Convert.ToInt32(Session["SingleGoodID"]); status.IsDeal = Deal; OAController mCon = new OAController(); if (Status == "3") { status.TotalPrices = Convert.ToDouble(tbxToTalPrice.Text); status.ReceiveStr = tbxUserID.Text; //将用户用户名传入 } if (mCon.TradeStatus(m, status) && mCon.GetTimeCon(m, status)) { Tip.Text = "修改成功"; //this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ggg", "<script language='javascript'>alert('" + "修改成功!!" + "');</script>"); } else { Tip.Text = "修改失败"; //this.Page.ClientScript.RegisterStartupScript(this.GetType(), "ggg", "<script language='javascript'>alert('" + "修改失败!!" + "');</script>"); } //读取数据代码 { if (Session["hOrderID"] != null) { tbxOrderID.Text = Session["hOrderID"].ToString(); } else { tbxOrderID.Text = receive; } SaveOrders hOrder = new Models.SaveOrders(); hOrder.OrderID = tbxOrderID.Text; OA mOrder = new OA(); OAController mController = new OAController(); arry = mController.SearchOrder(mOrder, hOrder); tbxAddress.Text = arry[1]; tbxCalloffReason.Text = arry[7]; tbxEndTime.Text = arry[9]; tbxNumber.Text = arry[2]; tbxSendTime.Text = arry[8]; tbxStaffID.Text = arry[10]; tbxSubmitTime.Text = arry[5]; tbxToTalPrice.Text = arry[3]; tbxUserID.Text = arry[0]; switch (arry[6]) { case "0": TradeStatus.SelectedIndex = 0; break; case "1": TradeStatus.SelectedIndex = 1; break; case "2": TradeStatus.SelectedIndex = 2; break; case "3": TradeStatus.SelectedIndex = 3; break; } } }
protected void Page_Load(object sender, EventArgs e) { string str = Request.QueryString["OrderID"]; receive = str; if (!IsPostBack) { if (Session["hOrderID"] != null) { tbxOrderID.Text = Session["hOrderID"].ToString(); } else { tbxOrderID.Text = str; } SaveOrders hOrder = new Models.SaveOrders(); OA mOrder = new OA(); OAController mController = new OAController(); hOrder.OrderID = tbxOrderID.Text; arry = mController.SearchOrder(mOrder, hOrder); if (arry[6] == "3") { TradeStatus.Enabled = false; } hOrder.IsDeal = arry[12]; if (hOrder.IsDeal == "2") { this.TradeStatus.Enabled = false; } tbxAddress.Text = arry[1]; tbxCalloffReason.Text = arry[7]; tbxEndTime.Text = arry[9]; tbxNumber.Text = arry[2]; tbxSendTime.Text = arry[8]; tbxStaffID.Text = arry[10]; tbxSubmitTime.Text = arry[5]; tbxToTalPrice.Text = arry[3]; tbxUserID.Text = arry[0]; Session["SingleGoodID"] = arry[4]; switch (arry[6]) { case "0": TradeStatus.SelectedIndex = 0; break; case "1": TradeStatus.SelectedIndex = 1; break; case "2": TradeStatus.SelectedIndex = 2; break; case "3": TradeStatus.SelectedIndex = 3; break; } Session["hOrder"] = ""; } }