public void aa()
{
Model.order myorder = new Model.order();
myorder.id = Convert.ToInt32(Request.QueryString["id"]);
BLL.BLLorderupdate blll = new BLL.BLLorderupdate();
SqlDataReader dr = blll.readorder(myorder);
if (dr.Read())
{
ordernum.Text = dr["_ordernum"].ToString();
sellremarks.Text = dr["_sellremarks"].ToString();
proid.Text = dr["_id"].ToString();
if (dr["_paystate"].ToString() == "1")
{
ispay.Checked = true;
}
else
{
notpay.Checked = true;
}
if (dr["_prostate"].ToString() == "1")
{
ispro.Checked = true;
}
else
{
notpro.Checked = true;
}
}
dr.Close();
}
public void aa()
{
Model.order myorder = new Model.order();
myorder.id = Convert.ToInt32(Request.QueryString["id"]);
BLL.BLLorderupdate blll = new BLL.BLLorderupdate();
SqlDataReader dr = blll.readorder(myorder);
if (dr.Read())
{
proid.Text = dr["_id"].ToString();
needbill.Text = dr["_needbill"].ToString();
waysgive.Text = dr["_waysgive"].ToString();
pronum.Text = dr["_ordernum"].ToString();
ordertime.Text = dr["_ordertime"].ToString();
sellremarks.Text = dr["_sellremarks"].ToString();
count.Text = dr["_count"].ToString();
address.Text = dr["_address"].ToString();
sumpric.Text = dr["_sumprice"].ToString();
name.Text = dr["_name"].ToString();
tel.Text = dr["_tel"].ToString();
mobile.Text = dr["_mobile"].ToString();
buyremarks.Text = dr["_buyremarks"].ToString();
mail.Text = dr["_mail"].ToString();
}
dr.Close();
}
protected void change_Click(object sender, EventArgs e)
{
Model.order myorder = new Model.order();
myorder.id = Convert.ToInt32(Request.QueryString["id"]);
myorder.sellremarks = sellremarks.Text;
if (ispay.Checked == true)
{
myorder.paystate = 1;
}
if(notpay .Checked ==true )
{
myorder.paystate = 0;
}
if (ispro.Checked == true)
{
myorder.prostate = 1;
}
if(notpro .Checked ==true )
{
myorder.prostate = 0;
}
BLL.BLLorderupdate blll = new BLL.BLLorderupdate();
int result = blll.update(myorder );
if (result > 0)
{
Common .MessageAlert .AlertLocation (Page , "if(confirm('更新成功，是否返回订单列表?')) location.href='orderselect.aspx'");
}
}
public void aa()
{
Model.order myorder = new Model.order();
myorder.id = Convert .ToInt32( Request.QueryString["id"]);
BLL.BLLorderupdate blll = new BLL.BLLorderupdate();
MySqlDataReader dr = blll.readorder(myorder);
if (dr.Read())
{
ordernum .Text =dr["_ordernum"].ToString ();
sellremarks.Text = dr["_sellremarks"].ToString();
proid.Text = dr["_id"].ToString();
if (dr["_paystate"].ToString() == "1")
{
ispay.Checked = true;
}
else
{
notpay.Checked = true;
}
if (dr["_prostate"].ToString() == "1")
{
ispro.Checked = true;
}
else
{
notpro.Checked = true;
}
}
dr.Close();
}
protected void change_Click(object sender, EventArgs e)
{
Model.order myorder = new Model.order();
myorder.id = Convert.ToInt32(Request.QueryString["id"]);
myorder.sellremarks = sellremarks.Text;
if (ispay.Checked == true)
{
myorder.paystate = 1;
}
if (notpay.Checked == true)
{
myorder.paystate = 0;
}
if (ispro.Checked == true)
{
myorder.prostate = 1;
}
if (notpro.Checked == true)
{
myorder.prostate = 0;
}
BLL.BLLorderupdate blll = new BLL.BLLorderupdate();
int result = blll.update(myorder);
if (result > 0)
{
Common.MessageAlert.AlertLocation(Page, "if(confirm('更新成功，是否返回订单列表?')) location.href='orderselect.aspx'");
}
}
public void aa()
{
Model.order myorder = new Model.order();
myorder.id = Convert.ToInt32(Request.QueryString["id"]);
BLL.BLLorderupdate blll = new BLL.BLLorderupdate();
MySqlDataReader dr = blll.readorder(myorder);
if (dr.Read())
{
proid.Text = dr["_id"].ToString();
needbill.Text = dr["_needbill"].ToString();
waysgive.Text = dr["_waysgive"].ToString();
pronum.Text = dr["_ordernum"].ToString();
ordertime.Text = dr["_ordertime"].ToString();
sellremarks.Text = dr["_sellremarks"].ToString();
count.Text = dr["_count"].ToString();
address.Text = dr["_address"].ToString();
sumpric.Text = dr["_sumprice"].ToString();
name.Text = dr["_name"].ToString();
tel.Text = dr["_tel"].ToString();
mobile.Text = dr["_mobile"].ToString();
buyremarks.Text = dr["_buyremarks"].ToString();
mail.Text = dr["_mail"].ToString();
}
dr.Close ();
}
public void pp()
{
Model.order moo = new Model.order();
moo.userid = Convert.ToInt32(Session["_userid"]);
BLL.oredr bmy = new BLL.oredr();
DataSet ds = bmy.findOrders(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, moo);
foreach (DataTable ta in ds.Tables)
{
foreach (DataRow row in ta.Rows)
{
Model.order or = new Model.order();
or.paystate = Convert.ToInt32(row["_paystate"].ToString());
if (or.paystate == 1)
{
str = "已支付";
}
else
{
str = "未支付";
}
}
}
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
protected void Button3_Click(object sender, EventArgs e)
{
if (ordernum.Text != "")
{
Label1.Visible = false;
Model.order myorder = new Model.order();
myorder.ordernum = ordernum.Text;
BLL.BLLorderselect blll = new BLL.BLLorderselect();
int result = blll.pageint1(myorder);
AspNetPager1.RecordCount = result;
LoadDataInfo1();
if (result == 0)
{
Label1.Visible = true;
GridView1.DataSource = null;
GridView1.DataBind();
AspNetPager1.Visible = false;
}
}
else
{
Label1.Visible = true;
GridView1.DataSource = null;
GridView1.DataBind();
AspNetPager1.Visible = false;
}
}
protected void Button3_Click(object sender, EventArgs e)
{
if (ordernum.Text != "")
{
Label1.Visible = false;
Model.order myorder = new Model.order();
myorder.ordernum = ordernum.Text;
BLL.BLLorderselect blll = new BLL.BLLorderselect();
int result = blll.pageint1(myorder);
AspNetPager1.RecordCount = result;
LoadDataInfo1();
if (result == 0)
{
Label1.Visible = true;
GridView1.DataSource = null;
GridView1.DataBind();
AspNetPager1.Visible = false;
}
}
else
{
Label1.Visible = true;
GridView1.DataSource = null;
GridView1.DataBind();
AspNetPager1.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Model.order myorder = (Model.order)Session["orderTable"];
ordernum.Text = myorder.ordernum;
wprice.Text = myorder.sumprice.ToString();
waysgive.Text = myorder.waysgive;
Session["dt"] = null;
}
public void pp()
{
Model.order moo = new Model.order();
moo.userid = Convert.ToInt32(Session["_userid"]);
BLL.oredr bmy = new BLL.oredr();
DataSet ds = bmy.dspor(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, moo);
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
public void LoadDataInfo1()
{
Model .order myorder=new Model.order ();
myorder .ordernum =ordernum .Text ;
BLL.BLLorderselect blll = new BLL.BLLorderselect();
DataSet ds = blll.pagebind1(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize,myorder );
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
public void pp()
{
Model.order moo = new Model.order();
moo.userid = Convert.ToInt32(Session["_user_id"]);
BLL.oredr bmy = new BLL.oredr();
DataSet ds = bmy.dspor(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, moo);
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
public void LoadDataInfo1()
{
Model.order myorder = new Model.order();
myorder.ordernum = ordernum.Text;
BLL.BLLorderselect blll = new BLL.BLLorderselect();
DataSet ds = blll.pagebind1(AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, myorder);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
Model.order mymodel = new Model.order();
mymodel.id = Convert.ToInt32(e.CommandArgument);
BLL.BLLorderselect blll = new BLL.BLLorderselect();
int result = blll.delete(mymodel);
if (result > 0)
{
Response.Write("<script>alert('删除成功!');location.href='orderselect.aspx'</script>");
}
GridView1.DataBind();
}
}
protected void ImageButton2_Command(object sender, CommandEventArgs e)
{
if (e.CommandName == "Pay")
{
int id = Convert.ToInt32(e.CommandArgument);
BLL.oredr bllu = new BLL.oredr();
Model.order moor = bllu.getuserOrder(id);
if (moor != null)
{
Session["orderTable"] = moor;
Response.Redirect("orderListPay.aspx");
}
else
{
Common.MessageAlert.Alert(Page, "不好意思，系统阻塞了.....");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["_userid"] == null)
{
Common.MessageAlert.AlertLocation(Page, "alert('对不起，您没有登陆！');location.href='Login.aspx'");
}
else
{
if (!IsPostBack)
{
Model.order mooj = new Model.order();
mooj.userid = Convert.ToInt32(Session["_userid"]);
BLL.oredr boo = new BLL.oredr();
int i = boo.count(mooj);
AspNetPager1.RecordCount = i;
AspNetPager1.PageSize = 6;
pp();
}
}
}
protected void ImageButton1_Command(object sender, CommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int id = Convert.ToInt32(e.CommandArgument);
Model.order moor = new Model.order();
moor.id = id;
moor.userid = Convert.ToInt32(Session["_userid"]);
BLL.oredr bllu = new BLL.oredr();
int i = bllu.deor(moor);
if (i > 0)
{
Common.MessageAlert.Alert(Page, "删除成功！！");
pp();
}
else
{
Common.MessageAlert.Alert(Page, "删除失败！！");
}
}
}
protected void ImageButton1_Command(object sender, CommandEventArgs e)
{
if (e.CommandName == "Delete")
{
int id = Convert.ToInt32(e.CommandArgument);
Model.order moor = new Model.order();
moor.id = id;
moor.userid = Convert.ToInt32(Session["_userid"]);
BLL.oredr bllu = new BLL.oredr();
int i = bllu.deleteUserOrder(moor);
if (i > 0)
{
Common.MessageAlert.Alert(Page, "删除成功！！");
pp();
}
else
{
Common.MessageAlert.Alert(Page, "删除失败！！");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["_userid"] == null)
{
Common.MessageAlert.AlertLocation(Page, "alert('对不起，您没有登陆！');location.href='Login.aspx'");
}
else
{
if (!IsPostBack)
{
Model.order mooj = new Model.order();
mooj.userid = Convert.ToInt32(Session["_userid"]);
BLL.oredr boo = new BLL.oredr();
int i = boo.count(mooj);
AspNetPager1.RecordCount = i;
AspNetPager1.PageSize = 6;
pp();
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
Model.order mymodel = new Model.order();
mymodel.id = Convert .ToInt32 ( e.CommandArgument);
BLL.BLLorderselect blll = new BLL.BLLorderselect();
int result = blll.delete(mymodel );
if (result > 0)
{
Response.Write("<script>alert('删除成功!');location.href='orderselect.aspx'</script>");
}
GridView1.DataBind();
}
}
public void bindordertable()
{
//ordertable数据的插入
Model.order myorder = new Model.order();
myorder.ordernum = DateTime.Now.ToString("yyyyMMddhhmmssfff");
Session["ordernum"] = myorder.ordernum;
myorder.userid = Convert.ToInt32(Session["_userid"]);
myorder.buyremarks = Server.HtmlEncode(buyremarks.Text);
myorder.count = Convert.ToInt32(wholeprocount.Text);
myorder.address = Server.HtmlEncode(address.Text);
myorder.tel = Server.HtmlEncode(tel.Text);
myorder.mobile = Server.HtmlEncode(mobile.Text);
myorder.mail = Server.HtmlEncode(mail.Text);
myorder.name = Server.HtmlEncode(receivename.Text);
myorder.sumprice = Convert.ToDouble(wprice.Text);
//if (needbill.Checked)
//{
// myorder.needbill = 1;
//}
//else
//{
// myorder.needbill = 0;
//}
if (online.Checked)
{
myorder.waysgive = "在线支付";
}
else
{
myorder.waysgive = "货到付款";
}
Session["waysgive"] = myorder.waysgive;
Session["orderUser"] = myorder;
BLL.BLLshoplist2 blll = new BLL.BLLshoplist2();
int result = blll.insertOrdertable(myorder);
//ordertabldetail数据的插入
int result2 = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
Model.orderdetail myorderdetail = new Model.orderdetail();
Label sumweight = new Label();
Label sumprice = new Label();
Label weight = new Label();
Label count = new Label();
Label localprice = new Label();
Label title = new Label();
Label cate = new Label();
Label id = new Label();
Image img = new Image();
sumweight = (Label)GridView1.Rows[i].FindControl("sumweight");
sumprice = (Label)GridView1.Rows[i].FindControl("sumprice");
weight = (Label)GridView1.Rows[i].FindControl("weight");
count = (Label)GridView1.Rows[i].FindControl("count");
localprice = (Label)GridView1.Rows[i].FindControl("localprice");
title = (Label)GridView1.Rows[i].FindControl("title");
img = (Image)GridView1.Rows[i].FindControl("img");
cate = (Label)GridView1.Rows[i].FindControl("cate");
id = (Label)GridView1.Rows[i].FindControl("id");
myorderdetail.ordernum = Session["ordernum"].ToString();
myorderdetail.sumweight = sumweight.Text;
myorderdetail.sumprice = Convert.ToDouble(sumprice.Text);
myorderdetail.weight = weight.Text;
myorderdetail.count = Convert.ToInt32(count.Text);
myorderdetail.price = Convert.ToDouble(localprice.Text);
myorderdetail.title = title.Text;
myorderdetail.proimage = img.ImageUrl;
myorderdetail.cate = cate.Text;
myorderdetail.proid = Convert.ToInt32(id.Text);
result2 = blll.insertdetail(myorderdetail);
}
if (result > 0 && result2 > 0)
{
Response.Redirect("shoplist3.aspx");
}
else
{
Common.MessageAlert.Alert(Page, "提交失败!");
}
}
public void bindordertable()
{
//ordertable数据的插入
Model.order myorder = new Model.order();
myorder.ordernum = DateTime.Now.ToString("yyyyMMddhhmmssfff");
Session["ordernum"] = myorder.ordernum;
myorder.userid = Convert.ToInt32(Session["_userid"]);
myorder.buyremarks =Server .HtmlEncode ( buyremarks.Text);
myorder.count = Convert.ToInt32(wholeprocount.Text);
myorder.address =Server .HtmlEncode ( address.Text);
myorder.tel =Server .HtmlEncode ( tel.Text);
myorder.mobile =Server .HtmlEncode ( mobile.Text);
myorder.mail =Server .HtmlEncode ( mail.Text);
myorder.name =Server .HtmlEncode ( receivename.Text);
myorder.sumprice = Convert.ToDouble(wprice.Text);
if (needbill.Checked)
{
myorder.needbill = 1;
}
else
{
myorder.needbill = 0;
}
if (online.Checked)
{
myorder.waysgive = "在线支付";
}
else
{
myorder.waysgive = "货到付款";
}
Session["waysgive"] = myorder.waysgive;
BLL.BLLshoplist2 blll = new BLL.BLLshoplist2();
int result = blll.insert(myorder);
//ordertabldetail数据的插入
int result2=0;
for(int i=0;i<GridView1 .Rows .Count ;i++)
{
Model .orderdetail myorderdetail=new Model.orderdetail ();
Label sumweight = new Label();
Label sumprice = new Label();
Label weight = new Label();
Label count = new Label();
Label localprice = new Label();
Label title = new Label();
Label size = new Label();
Label color = new Label();
Label cate = new Label();
Label id=new Label();
Image img = new Image();
sumweight = (Label)GridView1.Rows[i].FindControl("sumweight");
sumprice = (Label)GridView1.Rows[i].FindControl("sumprice");
weight = (Label)GridView1.Rows[i].FindControl("weight");
count = (Label)GridView1.Rows[i].FindControl("count");
localprice = (Label)GridView1.Rows[i].FindControl("localprice");
title = (Label)GridView1.Rows[i].FindControl("title");
img = (Image)GridView1.Rows[i].FindControl("img");
cate = (Label)GridView1.Rows[i].FindControl("cate");
color = (Label)GridView1.Rows[i].FindControl("color");
size = (Label)GridView1.Rows[i].FindControl("size");
id = (Label)GridView1.Rows[i].FindControl("id");
myorderdetail.ordernum = Session["ordernum"].ToString();
myorderdetail.sumweight = sumweight.Text;
myorderdetail.sumprice =Convert .ToDouble ( sumprice.Text);
myorderdetail.weight = weight.Text;
myorderdetail.count =Convert .ToInt32( count.Text);
myorderdetail.price =Convert .ToDouble ( localprice.Text);
myorderdetail.title = title.Text;
myorderdetail.proimage = img.ImageUrl;
myorderdetail.cate = cate.Text;
myorderdetail.color = color.Text;
myorderdetail.size = size.Text;
myorderdetail.proid =Convert .ToInt32 ( id.Text);
result2 = blll.insertdetail(myorderdetail);
}
if (result > 0&&result2 >0)
{
Response .Redirect ("shoplist3.aspx");
}
else
{
Common.MessageAlert.Alert(Page, "提交失败!");
}
}
