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