//仓位 protected void getWarehousePosition() { string sql = "SELECT DISTINCT WL_ID,WL_NAME FROM TBWS_LOCATION WHERE WL_WSID='" + DropDownListWarehouse.SelectedValue + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); DropDownListPosition.DataSource = dt; DropDownListPosition.DataTextField = "WL_NAME"; DropDownListPosition.DataValueField = "WL_ID"; DropDownListPosition.DataBind(); }
//仓位 protected void getWarehousePosition() { DropDownListPosition.Items.Clear(); string sql = "SELECT DISTINCT WL_ID,WL_NAME FROM TBWS_LOCATION WHERE WL_WSID='" + DropDownListWarehouse.SelectedValue + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); DataRow row = dt.NewRow(); row["WL_ID"] = "0"; row["WL_NAME"] = "待查"; dt.Rows.InsertAt(row, 0);//添加为待查 DropDownListPosition.DataSource = dt; DropDownListPosition.DataTextField = "WL_NAME"; DropDownListPosition.DataValueField = "WL_ID"; DropDownListPosition.DataBind(); }
//绑定初始化信息 private void bindInitInfo() { string outcode = ""; if (Request.QueryString["ID"] != null) { outcode = Request.QueryString["ID"]; } /*总表信息*/ string sql = "SELECT Top 1 OutCode AS Code,DepCode AS LLDepCode,Dep AS LLDep,Date AS Date," + "TSAID as SCZH,WarehouseCode AS WarehouseCode,SenderCode AS SenderCode," + "Sender AS Sender,DocCode AS DocumentCode," + "Doc AS Document,VerifierCode AS VerifierCode," + "Verifier AS Verifier,ApprovedDate AS ApproveDate,ROB AS Colour,TotalState AS State," + "TotalNote AS Comment FROM View_SM_OUT WHERE OutCode='" + outcode + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sql); if (dr.Read()) { LabelCode.Visible = true; LabelCode.Text = dr["Code"].ToString(); //入库单号 LabelState.Text = dr["State"].ToString(); //是否审核 InputColour.Value = dr["Colour"].ToString(); //红蓝字 TextBoxDate.Text = dr["Date"].ToString(); //日期 try { DropDownListDep.Items.FindByValue(dr["LLDepCode"].ToString()).Selected = true; } catch { } //try { DropDownListSCZH.Items.FindByValue(dr["SCZH"].ToString()).Selected = true; } //catch { } TextBoxSCZH.Text = dr["SCZH"].ToString(); try { DropDownListWarehouse.Items.FindByValue(dr["WarehouseCode"].ToString()).Selected = true; } catch { } //选择仓位 getWarehousePosition(); DropDownListPosition.ClearSelection(); try { DropDownListPosition.Items.FindByValue(dr["PositionCode"].ToString()).Selected = true; //仓库 } catch { } //制作班组 try { DropDownListBZ.Items.FindByValue(dr["Comment"].ToString()).Selected = true; } catch { } //TextBoxComment.Text = dr["Comment"].ToString(); LabelDoc.Text = dr["Document"].ToString(); LabelDocCode.Text = dr["DocumentCode"].ToString(); try { DropDownListSender.Items.FindByValue(dr["SenderCode"].ToString()).Selected = true; } catch { } LabelVerifier.Text = dr["Verifier"].ToString(); LabelVerifierCode.Text = dr["VerifierCode"].ToString(); LabelApproveDate.Text = dr["ApproveDate"].ToString(); //仓库,仓位 } dr.Close(); /*详细表信息*/ sql = "SELECT UniqueCode AS UniqueID,SQCODE AS SQCODE,MaterialCode AS MaterialCode,MaterialName AS MaterialName," + "Attribute AS Attribute,GB AS GB,Standard AS MaterialStandard,Fixed AS Fixed,Length AS Length,Width AS Width," + "LotNumber AS LotNumber,Unit AS Unit,DueNumber AS DN,RealNumber AS RN,DueSupportNumber AS DQN,RealSupportNumber AS RQN," + "UnitPrice AS UnitPrice,Amount AS Amount,WarehouseCode AS WarehouseCode," + "Warehouse AS Warehouse,LocationCode AS PositionCode,Location AS Position," + "PlanMode AS PlanMode,PTC AS PTC,OrderCode AS OrderID,DetailNote AS Comment " + "FROM View_SM_OUT WHERE OutCode='" + outcode + "'"; DataTable tb = DBCallCommon.GetDTUsingSqlText(sql); GridView1.DataSource = tb; GridView1.DataBind(); if (InputColour.Value == "1") { ImageRed.Visible = true; } if (LabelState.Text == "1") { btnsave.Enabled = true; btnverity.Enabled = true; btnantiverity.Enabled = false; dj_delete.Visible = true;//单据删除 btninsert.Visible = true; btnappend.Visible = true; btndelete.Visible = true; btnPrint.Visible = false; } if (LabelState.Text == "2") { ImageVerify.Visible = true; btnsave.Enabled = false; btnverity.Enabled = false; btnantiverity.Enabled = true; dj_delete.Visible = false;//单据删除 btninsert.Visible = false; btnappend.Visible = false; btndelete.Visible = false; } }