安徽工业大学工商学院毕业设计(论文)
}
3、客户信息中心模块
客户表TableAdapter khb = new 客户表TableAdapter(); 支付表TableAdapter zfb = new 支付表TableAdapter(); protected void Page_Load(object sender, EventArgs e) {
string zh = Request.QueryString[\].ToString().Trim(); DataTable dt= khb.GetDataBy1(zh); Label6.Text = zh;
Label1.Text = dt.Rows[0][2].ToString().Trim(); Label2.Text = dt.Rows[0][4].ToString().Trim(); Label3.Text = dt.Rows[0][3].ToString().Trim(); Label4.Text = dt.Rows[0][5].ToString().Trim(); Label5.Text = dt.Rows[0][6].ToString().Trim(); DataTable dt1 = zfb.GetDataBy2(zh); GridView1.DataSource = dt1; GridView1.DataBind();
?
?
17
安徽工业大学工商学院毕业设计(论文)
}
protected void Button2_Click(object sender, EventArgs e) { try {
DataTable zfdt = zfb.GetDataBy3(int.Parse(TextBox2.Text)); //物流表TableAdapter wlb = new 物流表TableAdapter();
//DataTable wldt = wlb.GetDataBy2(zfdt.Rows[0][0].ToString().Trim()); 申请退货表TableAdapter sqth = new 申请退货表TableAdapter(); sqth.InsertQuery(Label1.Text, TextBox2.Text, TextBox1.Text); Label7.Visible = false; TextBox1.Visible = false; Button2.Visible = false;
Response.Write(\已提交申请,请等待审核。。。~~~')\); } catch {
Response.Write(\请输入正确的支付号!!~~')\); } }
protected void Button1_Click1(object sender, EventArgs e) {
Label7.Visible = true; TextBox1.Visible = true; Button2.Visible = true; Label8.Visible = true; TextBox2.Visible = true; }
?
?
18
安徽工业大学工商学院毕业设计(论文)
}
4、退货审核模块
申请退货表TableAdapter sqth = new 申请退货表TableAdapter(); 支付表TableAdapter zfb = new 支付表TableAdapter(); 退货单表TableAdapter thd = new 退货单表TableAdapter(); 客户表TableAdapter khb = new 客户表TableAdapter(); protected void Page_Load(object sender, EventArgs e) {
}
protected void Button1_Click(object sender, EventArgs e) {
DataTable zfdt = zfb.GetDataBy3(int.Parse(TextBox1.Text)); thd.InsertQuery(int.Parse(zfdt.Rows[0][2].ToString()),
decimal.Parse(zfdt.Rows[0][3].ToString()), Label1.Text, TextBox1.Text, zfdt.Rows[0][6].ToString()); sqth.DeleteQuery(TextBox1.Text.Trim());
?
?
19
安徽工业大学工商学院毕业设计(论文)
Response.Write(\批准成功')\); }
protected void Button2_Click(object sender, EventArgs e) {
sqth.DeleteQuery(TextBox1.Text.Trim());
Response.Write(\已经驳回客户的退货!!!!')\); }
protected void Button3_Click1(object sender, EventArgs e) {
DataTable dt = sqth.GetDataBy1(TextBox1.Text);
DataTable dt1 = zfb.GetDataBy3(int.Parse(TextBox1.Text)); DataTable dt2 = khb.GetDataBy1(dt1.Rows[0][6].ToString()); GridView2.DataSource = dt2; GridView2.DataBind();
DataTable zhdt = zfb.GetDataBy3(int.Parse(TextBox1.Text)); GridView3.DataSource = zhdt; GridView3.DataBind();
DataTable sqdt = sqth.GetDataBy1(TextBox1.Text); Label1.Text = sqdt.Rows[0][3].ToString(); Button1.Visible = true; Button2.Visible = true; } }
?
?
20

