//仓位
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;
}
}
