public void PaySuccess()//先提交订单 保存订单session,然后支付成功的时候读取session存取数据库 { //Session["Order_"] string strGID = Session["Order_GID"].ToString();; // Request.Form["GID"]; string strUID = Session["Order_UID"].ToString(); //Request.Form["UID"]; string strPayed = Session["Order_Payed"].ToString(); //Request.Form["Payed"]; string strCount = Session["Order_count"].ToString(); // Request.Form["count"]; string strAddress = Session["Order_Address"].ToString(); // Request.Form["Address"]; string strSize = Session["Order_Size"].ToString(); // Request.Form["Size"]; YC_Order order = new YC_Order(); order.GID = Convert.ToInt32(strGID); order.UID = Convert.ToInt32(strUID); order.Price = Convert.ToDouble(strPayed); order.Count = Convert.ToInt32(strCount); order.Address = strAddress; order.GoodSize = strSize; ///存入数据库 if (BLL.OrderBLL.generateOrder(order) == 1) { Response.Write("1"); } else { Response.Write("0"); } }
/// <summary> /// 发货 /// </summary> /// <param name="sendtype">发货方式</param> /// <param name="yundan">运单号</param> /// <param name="oid">订单ID</param> /// <returns></returns> public static int SendingGood(string sendtype, string yundan, int oid) { YC_Order order = new YC_Order(); order.Sendtype = sendtype; order.IsSended = 1; order.OID = oid; order.WayNumber = yundan; return(Convert.ToInt32(DAL.OrderServer.sendOrder(order))); }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "btnshouhuo") { int oid = Convert.ToInt32(e.CommandArgument); YC_Order order = new YC_Order(); order.OID = oid; if (BLL.OrderBLL.OrderFinished(order) == 1) { bind(); } } }
/// <summary> /// 确认收收货 订单完成,设置FinishedTime /// </summary> /// <param name="order"></param> /// <returns></returns> public static object OrderFinished(YC_Order order) { sqltext = " update [dbo].[YC_Order] set [FinishedTime]=(convert(char(10),getdate(),120)+' '+Convert(varchar(8),Getdate(),108)) where OID='" + order.OID + "'"; return(SQLHELPER.ExecuteNonQuery(sqltext)); }
/// <summary> /// 发货(修改状态为 发货,填写发货方式,运单号,订单Id) /// </summary> /// <param name="order"></param> /// <returns></returns> public static object sendOrder(YC_Order order) { sqltext = "update [dbo].[YC_Order] set SendType='" + order.Sendtype + "',SendTime=convert(char(10),getdate(),120)+' '+Convert(varchar(8),Getdate(),108),WayNumber='" + order.WayNumber + "' where OID='" + order.OID + "'"; return(SQLHELPER.ExecuteNonQuery(sqltext)); }
/// <summary> /// 生成订单 下单 /// </summary> /// <param name="order"></param> /// <returns></returns> public static object GenerateOrder(YC_Order order) { sqltext = " INSERT INTO [dbo].[YC_Order]([GID],[UID],[Price],[Count],[SendType],[Address],[BuyTime],[SendTime],[FinishedTime],[GoodSize],[WayNumber])values('" + order.GID + "', '" + order.UID + "', '" + order.Price + "', '" + order.Count + "', '', '" + order.Address + "', convert(char(10),getdate(),120)+' '+Convert(varchar(8),Getdate(),108), null, null, '" + order.GoodSize + "', '" + order.WayNumber + "'); "; return(SQLHELPER.ExecuteNonQuery(sqltext)); }
/// <summary> /// 确认收货,传入订单ID /// </summary> /// <param name="order"></param> /// <returns></returns> public static int OrderFinished(YC_Order order) { return(Convert.ToInt32(DAL.OrderServer.OrderFinished(order))); }
/// <summary> /// 生成订单 /// </summary> /// <param name="or">传入商品ID 用户ID 已付资金,数量,地址,尺寸</param> /// <returns></returns> public static int generateOrder(YC_Order or) { return(Convert.ToInt32(DAL.OrderServer.GenerateOrder(or))); }