protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
TtNum1.BLL.Order bllOrder = new TtNum1.BLL.Order();
TtNum1.Model.Order molOrder = new TtNum1.Model.Order();
bllGoodsInfo.Update_gx3(DateTime.Now.ToString());
bllGoodsInfo.Update_gx(DateTime.Now.ToString());
bllGoodsInfo.Update_gx1();
bllGoodsInfo.Update_gx2(DateTime.Now.ToString());
//bllGoodsInfo.Update_ywc();
//DataSet getGBstylenum = bllOrderinfo.getGBStyle();
//int GBstylenum = Int32.Parse(getGBstylenum.Tables[0].Rows[0][0].ToString());
//DataSet getGBstylenum2 = bllOrderinfo.getGBStyle2();
//int GBstylenum2 = Int32.Parse(getGBstylenum2.Tables[0].Rows[0][0].ToString());
//if (GBstylenum == GBstylenum2)
//{
// molOrder.Style = "已完成";
// bllOrder.updateGBOrderlist(molOrder);
//}
bllGoodsInfo.Update_ywc1();
Dataload(0, 10,"");
}
}
protected void Page_Load(object sender, EventArgs e)
{
/* if (Request.QueryString["User_id"] == null)
{
Response.Write("<script>window.alert('您没有选择用户，无法传值');window.location=index.aspx;</script>");
}
else
{*/
RadButton2.Visible = false;
RadButton3.Visible = false;
ViewState["BackUrl"] = Request.UrlReferrer.ToString();
string a = Request.QueryString["Order_ID"].ToString();
modOrder = bllOrder.GetMode2(Convert.ToInt16(a));
Label1.Text = modOrder.U_ID.ToString();
DataTable dt = bllOrder.GetList_1(a).Tables[0];
if (dt.Rows.Count > 0)
{
Label3.Text = dt.Rows[0]["User_Name"].ToString();
Label4.Text = dt.Rows[0]["Order_time"].ToString();
Label7.Text = dt.Rows[0]["Zipcode"].ToString();
Label8.Text = dt.Rows[0]["Address_info"].ToString();
Label9.Text = dt.Rows[0]["Phone"].ToString();
Label10.Text = dt.Rows[0]["Method"].ToString();
Label12.Text = dt.Rows[0]["Style"].ToString();
if (dt.Rows[0]["Style"].ToString().Trim() == "待付款")
{
RadButton1.Visible = false;
}
if (dt.Rows[0]["Style"].ToString().Trim() == "待人数满员")
{
RadButton1.Visible = false;
}
if (dt.Rows[0]["IN_group_buying"].ToString().Trim() == "1")
{
RadButton1.Visible = false;
}
Label13.Text = dt.Rows[0]["Order_status"].ToString();
// }
}
DataSet ds = bllOrder.sumo(Label1.Text);
if (ds.Tables[0].Rows[0][0].ToString() != "0")
{
Label14.Text = ds.Tables[0].Rows[0][0].ToString();
}
}
public void dataload1()
{
molOrder = bllOrder.GetModel1(int.Parse(Request["ID"])); //获取订单编号
lblorderid_text.Text = molOrder.U_ID.ToString(); //将订单编号给label
lblordertime.Text = molOrder.Order_time.ToString();
moladdress = blladdress.GetModel2(int.Parse(Request["ID"]));
lblperson.Text = moladdress.Get_Name;
orderway.Text = molOrder.Method;
lbladderss.Text = moladdress.Address_info;
lblmoney.Text = molOrder.Money_Sum.ToString();
SqlDataSource1.SelectCommand = "select * from [Orderinfo] where IN_group_buying = 0 and U_ID='" + lblorderid_text.Text + "'";
}
protected void Button1_Click(object sender, EventArgs e)
{
molOrder = bllOrder.GetModel1(int.Parse(Request["ID"]));
molOrderinfo = bllOrderinfo.GetModel1(Int32.Parse(molOrder.U_ID.ToString())); //在Orderinfo中获取U_ID
DataTable num = bllOrderinfo.GetList("U_ID = '" + molOrder.U_ID + "'").Tables[0]; //根据order表获得orderinfo，创建一个数据表给num
for (int i = 0; i < num.Rows.Count; i++)
{
DataTable Goods = bllgoods.GetList("Goods_ID = '" + num.Rows[i]["Goods_ID"].ToString() + "'").Tables[0]; //根据获取到的Goods_ID创建一个数据表给Goods
molgoods.Goods_ID = Int32.Parse(num.Rows[i]["Goods_ID"].ToString());
molgoods.Stock = Int32.Parse(Goods.Rows[0]["Stock"].ToString()) - Int32.Parse(num.Rows[i]["Goods_Num"].ToString()); //遍历之后减库存
molgoods.Sales_volume = Int32.Parse(Goods.Rows[0]["Sales_volume"].ToString()) + Int32.Parse(num.Rows[i]["Goods_Num"].ToString()); //遍历之后加销量
bllgoods.Updatestock(molgoods);
}
molOrder.Style = "已付款";
bllOrder.Update(molOrder);
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('付款成功！');location.href='PersonalOrder.aspx';</script>");
}
public void dataload1()
{
molOrder = bllOrder.GetModel1(int.Parse(Request["ID"])); //获取订单编号
lblorderid_text.Text = molOrder.U_ID.ToString(); //将订单编号给label
lblordertime.Text = molOrder.Order_time.ToString();
moladdress = blladdress.GetModel2(int.Parse(Request["ID"]));
lblperson.Text = moladdress.Get_Name;
orderway.Text = molOrder.Method;
lbladderss.Text = moladdress.Address_info;
SqlDataSource1.SelectCommand = "select * from GoodsInfo left join Orderinfo on GoodsInfo.Goods_ID = Orderinfo.Goods_ID where Orderinfo.U_ID='" + lblorderid_text.Text + "' and Orderinfo.IN_group_buying=1 or Orderinfo.IN_group_buying=3";
DataTable gbstatus = bllgoods.getGBStatus(lblorderid_text.Text).Tables[0];
int num;
DataSet getGBgoodsNum = bllOrderinfo.getnum();
num =Int32.Parse( getGBgoodsNum.Tables[0].Rows[0][0].ToString());
for (int i = 0; i < num; i++)
{
//DataSet GBgoods = bllOrderinfo.GetGBlist(lblorderid_text.Text);
if (gbstatus.Rows[i]["GB_Status"].ToString() == "火热进行中" || gbstatus.Rows[i]["Style"].ToString() == "已付款")
// || gbstatus.Rows[0]["Style"].ToString() == "已完成")
{
payboxcon.Visible = false;
allmoneycon.Visible = false;
}
else if (gbstatus.Rows[i]["GB_Status"].ToString() == "团购已完成" || gbstatus.Rows[i]["Style"].ToString() == "未付款")
//)
{
allmoneycon.Visible = true;
payboxcon.Visible = true;
DataSet a = bllgoods.getGBMoney(lblorderid_text.Text);
lblmoney.Text = a.Tables[0].Rows[0][0].ToString();
Button1.Visible = true;
break;
}
}
//SqlDataSource1.SelectCommand = "select * from [Orderinfo] where IN_group_buying = 1 and U_ID='" + lblorderid_text.Text + "'";
}
/// <summary>
/// 得到UID
/// </summary>
public TtNum1.Model.Order GetModel1(int U_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" Order_ID,U_ID,User_Name,Order_status,Method,Style,Goods_Name,Goods_ID,Goods_Num,Goods_Money,Money_Sum,Order_time,address_id,IN_group_buying ");
strSql.Append(" from [Order] ");
strSql.Append(" where U_ID= '" + U_ID + "'");
TtNum1.Model.Order model = new TtNum1.Model.Order();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Order_ID"] != null && ds.Tables[0].Rows[0]["Order_ID"].ToString() != "")
{
model.Order_ID = int.Parse(ds.Tables[0].Rows[0]["Order_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["U_ID"] != null && ds.Tables[0].Rows[0]["U_ID"].ToString() != "")
{
model.U_ID = int.Parse(ds.Tables[0].Rows[0]["U_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["User_Name"] != null && ds.Tables[0].Rows[0]["User_Name"].ToString() != "")
{
model.User_Name = ds.Tables[0].Rows[0]["User_Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Order_status"] != null && ds.Tables[0].Rows[0]["Order_status"].ToString() != "")
{
model.Order_status = ds.Tables[0].Rows[0]["Order_status"].ToString();
}
if (ds.Tables[0].Rows[0]["Method"] != null && ds.Tables[0].Rows[0]["Method"].ToString() != "")
{
model.Method = ds.Tables[0].Rows[0]["Method"].ToString();
}
if (ds.Tables[0].Rows[0]["Style"] != null && ds.Tables[0].Rows[0]["Style"].ToString() != "")
{
model.Style = ds.Tables[0].Rows[0]["Style"].ToString();
}
if (ds.Tables[0].Rows[0]["Goods_Name"] != null && ds.Tables[0].Rows[0]["Goods_Name"].ToString() != "")
{
model.Goods_Name = ds.Tables[0].Rows[0]["Goods_Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Goods_ID"] != null && ds.Tables[0].Rows[0]["Goods_ID"].ToString() != "")
{
model.Goods_ID = int.Parse(ds.Tables[0].Rows[0]["Goods_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["Goods_Num"] != null && ds.Tables[0].Rows[0]["Goods_Num"].ToString() != "")
{
model.Goods_Num = int.Parse(ds.Tables[0].Rows[0]["Goods_Num"].ToString());
}
if (ds.Tables[0].Rows[0]["IN_group_buying"] != null && ds.Tables[0].Rows[0]["IN_group_buying"].ToString() != "")
{
model.IN_group_buying = int.Parse(ds.Tables[0].Rows[0]["IN_group_buying"].ToString());
}
if (ds.Tables[0].Rows[0]["Goods_Money"] != null && ds.Tables[0].Rows[0]["Goods_Money"].ToString() != "")
{
model.Goods_Money = int.Parse(ds.Tables[0].Rows[0]["Goods_Money"].ToString());
}
if (ds.Tables[0].Rows[0]["Money_Sum"] != null && ds.Tables[0].Rows[0]["Money_Sum"].ToString() != "")
{
model.Money_Sum = int.Parse(ds.Tables[0].Rows[0]["Money_Sum"].ToString());
}
if (ds.Tables[0].Rows[0]["Order_time"] != null && ds.Tables[0].Rows[0]["Order_time"].ToString() != "")
{
model.Order_time = DateTime.Parse(ds.Tables[0].Rows[0]["Order_time"].ToString());
}
if (ds.Tables[0].Rows[0]["address_id"] != null && ds.Tables[0].Rows[0]["address_id"].ToString() != "")
{
model.address_id = ds.Tables[0].Rows[0]["address_id"].ToString();
}
return model;
}
else
{
return null;
}
}
public TtNum1.Model.Order GetMode2(int Order_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" [Order].U_ID,[Order].User_Name,[Order].Order_time,[Address].Zipcode,[Address].Address_info,[Address].Phone,[Address].Method,[Order].Order_ID,[Order].Style,[Order].Order_status from [Order],[Address] where [Address].U_ID=[Order].U_ID and Order_ID= " + Order_ID + "");
TtNum1.Model.Order model = new TtNum1.Model.Order();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{ if (ds.Tables[0].Rows[0]["U_ID"] != null && ds.Tables[0].Rows[0]["U_ID"].ToString() != "")
{
model.U_ID = int.Parse(ds.Tables[0].Rows[0]["U_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["User_Name"] != null && ds.Tables[0].Rows[0]["User_Name"].ToString() != "")
{
model.User_Name = ds.Tables[0].Rows[0]["User_Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Order_time"] != null && ds.Tables[0].Rows[0]["Order_time"].ToString() != "")
{
model.Order_time = DateTime.Parse(ds.Tables[0].Rows[0]["Order_time"].ToString());
}
if (ds.Tables[0].Rows[0]["Zipcode"] != null && ds.Tables[0].Rows[0]["Zipcode"].ToString() != "")
{
model.Zipcode = ds.Tables[0].Rows[0]["Zipcode"].ToString();
}
if (ds.Tables[0].Rows[0]["Address_info"] != null && ds.Tables[0].Rows[0]["Address_info"].ToString() != "")
{
model.Address_info = ds.Tables[0].Rows[0]["Address_info"].ToString();
}
if (ds.Tables[0].Rows[0]["Phone"] != null && ds.Tables[0].Rows[0]["Phone"].ToString() != "")
{
model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
}
if (ds.Tables[0].Rows[0]["Method"] != null && ds.Tables[0].Rows[0]["Method"].ToString() != "")
{
model.Method = ds.Tables[0].Rows[0]["Method"].ToString();
}
if (ds.Tables[0].Rows[0]["Order_ID"] != null && ds.Tables[0].Rows[0]["Order_ID"].ToString() != "")
{
model.Order_ID = int.Parse(ds.Tables[0].Rows[0]["Order_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["Order_status"] != null && ds.Tables[0].Rows[0]["Order_status"].ToString() != "")
{
model.Order_status = ds.Tables[0].Rows[0]["Order_status"].ToString();
}
if (ds.Tables[0].Rows[0]["Style"] != null && ds.Tables[0].Rows[0]["Style"].ToString() != "")
{
model.Style = ds.Tables[0].Rows[0]["Style"].ToString();
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TtNum1.Model.Order GetModel(int Order_ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" Order_ID,U_ID,Order_time,Order_status,Order_name,Order_zipcode,Order_address,Order_phone,Order_way,Order_message,Num,Style,Good_ID ");
strSql.Append(" from Order ");
strSql.Append(" where Order_ID="+Order_ID+"" );
TtNum1.Model.Order model=new TtNum1.Model.Order();
DataSet ds=DbHelperSQL.Query(strSql.ToString());
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TtNum1.Model.Order DataRowToModel(DataRow row)
{
TtNum1.Model.Order model=new TtNum1.Model.Order();
if (row != null)
{
if(row["Order_ID"]!=null && row["Order_ID"].ToString()!="")
{
model.Order_ID=int.Parse(row["Order_ID"].ToString());
}
if(row["U_ID"]!=null && row["U_ID"].ToString()!="")
{
model.U_ID=int.Parse(row["U_ID"].ToString());
}
if(row["Order_time"]!=null && row["Order_time"].ToString()!="")
{
model.Order_time=DateTime.Parse(row["Order_time"].ToString());
}
if(row["Order_status"]!=null)
{
model.Order_status=row["Order_status"].ToString();
}
if(row["Order_name"]!=null)
{
model.Order_name=row["Order_name"].ToString();
}
if(row["Order_zipcode"]!=null)
{
model.Order_zipcode=row["Order_zipcode"].ToString();
}
if(row["Order_address"]!=null)
{
model.Order_address=row["Order_address"].ToString();
}
if(row["Order_phone"]!=null)
{
model.Order_phone=row["Order_phone"].ToString();
}
if(row["Order_way"]!=null)
{
model.Order_way=row["Order_way"].ToString();
}
if(row["Order_message"]!=null)
{
model.Order_message=row["Order_message"].ToString();
}
if(row["Num"]!=null && row["Num"].ToString()!="")
{
model.Num=int.Parse(row["Num"].ToString());
}
if(row["Style"]!=null)
{
model.Style=row["Style"].ToString();
}
if(row["Good_ID"]!=null && row["Good_ID"].ToString()!="")
{
model.Good_ID=int.Parse(row["Good_ID"].ToString());
}
}
return model;
}