Webshell Akmal archtte id

Directory: C:\MyData\WWW\asc365\ using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Configuration; using wzLib; namespace App.prog { public partial class tuopansearch : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindCompany(); } } private void BindCompany() { string str = "select storcode,storname from BA_STORDF"; DataTable dt = SQLHelper.getDataTable(str); DropDownList1.DataSource = dt.DefaultView; DropDownList1.DataTextField = "storname"; DropDownList1.DataValueField = "storcode"; DropDownList1.DataBind(); string type = DropDownList1.SelectedValue; //string str1 = "select BILLNO,BILLNO+'('+cast(TRANSDATE as varchar(11))+')' as billname from TR_SEATRANSLOG where STORCODE='" + type + "'"; string str1 = "select TRANSDATE,CONVERT(char(10),TRANSDATE,20) as billname from TR_SEATRANSLOG where STORCODE='" + type + "'"; DataTable dt2 = SQLHelper.getDataTable(str1); DropDownList2.DataSource = dt2; DropDownList2.DataTextField = "billname"; DropDownList2.DataValueField = "TRANSDATE"; DropDownList2.DataBind(); string type2 = DropDownList2.SelectedValue; //string str2 = "select tuopan from tr_tuopan where billno='" + type2 + "'"; string str2 = " select distinct(tuopan) as tuopan from tr_tuopan where billno IN (select BILLNO from TR_SEATRANSLOG where STORCODE='" + type + "' AND TRANSDATE='" + type2 + "')"; DataTable dt3 = SQLHelper.getDataTable(str2); DropDownList3.DataSource = dt3; DropDownList3.DataTextField = "tuopan"; DropDownList3.DataValueField = "tuopan"; DropDownList3.DataBind(); } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { string type = DropDownList1.SelectedValue; //string str1 = "select BILLNO,BILLNO+'('+cast(TRANSDATE as varchar(11))+')' as billname from TR_SEATRANSLOG where STORCODE='" + type + "'"; string str1 = "select TRANSDATE,CONVERT(char(10),TRANSDATE,20) as billname from TR_SEATRANSLOG where STORCODE='" + type + "'"; DataTable dt2 = SQLHelper.getDataTable(str1); DropDownList2.DataSource = dt2; DropDownList2.DataTextField = "billname"; DropDownList2.DataValueField = "TRANSDATE"; DropDownList2.DataBind(); string type2 = DropDownList2.SelectedValue; //string str2 = "select tuopan from tr_tuopan where billno='" + type2 + "'"; string str2 = " select distinct(tuopan) as tuopan from tr_tuopan where billno IN (select BILLNO from TR_SEATRANSLOG where STORCODE='" + type + "' AND TRANSDATE='" + type2 + "')"; DataTable dt3 = SQLHelper.getDataTable(str2); DropDownList3.DataSource = dt3; DropDownList3.DataTextField = "tuopan"; DropDownList3.DataValueField = "tuopan"; DropDownList3.DataBind(); } protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { string type = DropDownList1.SelectedValue; string type2 = DropDownList2.SelectedValue; //string str2 = "select tuopan from tr_tuopan where billno='" + type2 + "'"; string str2 = " select distinct(tuopan) as tuopan from tr_tuopan where billno IN (select BILLNO from TR_SEATRANSLOG where STORCODE='" + type + "' AND TRANSDATE='" + type2 + "')"; DataTable dt3 = SQLHelper.getDataTable(str2); DropDownList3.DataSource = dt3; DropDownList3.DataTextField = "tuopan"; DropDownList3.DataValueField = "tuopan"; DropDownList3.DataBind(); } public bool Isnumeric(string number) { int result = -1; try { result = Convert.ToInt32(number); return true; } catch { return false; } } protected void Button1_Click(object sender, EventArgs e) { string[,] prodetail = new string[100000, 4]; int p_i = 0; string[,] prodetail2 = new string[100000, 3]; int p_i2 = 0; string storcode = DropDownList1.SelectedValue.ToString(); string transdate = DropDownList2.SelectedValue.ToString(); //string billno = DropDownList2.SelectedValue.ToString(); string tuopan = DropDownList3.SelectedValue.ToString(); string str = "select prdcode10,(select prdname from bu_prdprd where prdcode=a.prdcode10) as prdname,boxno from TR_SEATRANSLIST a where billno IN (select BILLNO from TR_SEATRANSLOG where STORCODE='" + storcode + "' AND TRANSDATE='" + transdate + "')"; DataTable dt = SQLHelper.getDataTable(str); for (int i = 0; i < dt.Rows.Count; i++) { string boxno = dt.Rows[i]["boxno"].ToString(); if (boxno.IndexOf(",") != -1) { string[] box1 = boxno.Split(','); for (int j = 0; j < box1.Length; j++) { if (Isnumeric(box1[j].Trim())) { prodetail[p_i, 0] = dt.Rows[i]["prdcode10"].ToString(); prodetail[p_i, 1] = box1[j].Trim(); prodetail[p_i, 2] = dt.Rows[i]["prdname"].ToString(); p_i++; } } } else if (boxno.IndexOf("-") != -1) { string[] box2 = boxno.Split('-'); if (Isnumeric(box2[0]) && Isnumeric(box2[1])) { int box3 = Convert.ToInt32(box2[0]); int box4 = Convert.ToInt32(box2[1]); for (int k = box3; k <= box4; k++) { prodetail[p_i, 0] = dt.Rows[i]["prdcode10"].ToString(); prodetail[p_i, 1] = k.ToString(); prodetail[p_i, 2] = dt.Rows[i]["prdname"].ToString(); p_i++; } } } else { if (Isnumeric(boxno)) { prodetail[p_i, 0] = dt.Rows[i]["prdcode10"].ToString(); prodetail[p_i, 1] = boxno; prodetail[p_i, 2] = dt.Rows[i]["prdname"].ToString(); p_i++; } } } string str2 = "select mingxi from TR_TUOPAN where billno IN (select BILLNO from TR_SEATRANSLOG where STORCODE='" + storcode + "' AND TRANSDATE='" + transdate + "') and tuopan='"+tuopan+"'"; DataTable dc = SQLHelper.getDataTable(str2); string testboxcode = ""; for(int k = 0; k < dc.Rows.Count; k ++) { string[] mingxi = dc.Rows[k]["mingxi"].ToString().Split('.'); for (int i = 0; i < mingxi.Length; i++) { if (false == testboxcode.Contains(mingxi[i].Trim()))//此箱号没有测试过 { int kk = 0; for (int j = 0; j < p_i; j++) { if (mingxi[i].Trim() == prodetail[j, 1].Trim()) { kk = 1; prodetail2[p_i2, 0] = prodetail[j, 0]; prodetail2[p_i2, 1] = prodetail[j, 1]; prodetail2[p_i2, 2] = prodetail[j, 2]; p_i2++; } } if (kk == 0) { prodetail2[p_i2, 0] =""; prodetail2[p_i2, 1] = mingxi[i].Trim(); prodetail2[p_i2, 2] =""; p_i2++; } } } testboxcode = dc.Rows[k]["mingxi"].ToString() + "."; } DataTable dt2=new DataTable(); dt2.Columns.Add("货品编码"); dt2.Columns.Add("货品名称"); dt2.Columns.Add("箱号"); for (int i = 0; i < p_i2; i++) { if (prodetail2[i, 1].Length > 0) { DataRow NewRow = dt2.NewRow(); NewRow["货品编码"] = prodetail2[i, 0]; NewRow["货品名称"] = prodetail2[i, 2]; NewRow["箱号"] = prodetail2[i, 1]; dt2.Rows.Add(NewRow); } } GridView1.DataSource = dt2; GridView1.DataBind(); } } }