protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (CheckData() == false)
return;
BCO.ConfirmStockTake bco = new BCO.ConfirmStockTake(ConntionDB);
string strAdjustNo;
string strAdjust = "0";
bool isExist = false;
DataTable dtData = queryData(out isExist);
for (int i = 0; i < dtData.Rows.Count; i++)
{
if (dtData.Rows[i]["DIFF_QTY"].ToString().Trim() != "0")
{
strAdjust = "1";
break;
}
}
ArrayList aList = new ArrayList();
aList.Clear();
aList.Add(GetValueSetParameter(txtStocktakeNo.Text.Trim(), "string"));
aList.Add(GetValueSetParameter(this.ddlS.Text.Trim() == "" ? "" : this.lblLocateNo.Text + this.ddlS.Text, "string"));
aList.Add(GetValueSetParameter(this.ddlE.Text.Trim() == "" ? "" : this.lblLocateNo.Text + this.ddlE.Text, "string"));
aList.Add(GetValueSetParameter(strAdjust, "int"));
aList.Add(GetValueSetParameter(Session["UID"].ToString(), "string"));
bco.CreateTakeDiff(aList, DBT, out strAdjustNo);
if (strAdjustNo != "No")
{
lblStocktakeNo.Text = strAdjustNo;
}
ScriptManager.RegisterStartupScript(Page, this.GetType(), "IVM051.aspx", "alert(' 確認成功 ');", true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
private void ddlDatabind()
{
BCO.ConfirmStockTake bco = new BCO.ConfirmStockTake(ConntionDB);
string strLocateNo = string.Empty;
string strResult = string.Empty;
bco.GetLocateNo(this.txtStocktakeNo.Text, out strLocateNo, out strResult);
if (strResult == "0")
{
lblLocateNo.Text = "";
lblStocktakeNo.Text = "";
ddlS.Items.Clear();
ddlE.Items.Clear();
GridView1.DataBind();
//txtStocktakeNo.Focus();
if (txtStocktakeNo.Text.Trim() != "")
{
ShowErrorMessage("此盤點單號不存在");
ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + this.txtStocktakeNo.ClientID + "').focus();", true);
}
ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(UpdatePanel), "ButtonControl", "DisableButton();", true);
}
else
{
lblLocateNo.Text = strLocateNo;
DataTable Dt = null;
Dt = bco.GetLocateSection(this.txtStocktakeNo.Text);
this.ddlS.DataSource = Dt;
this.ddlS.DataTextField = "LOCATE_SECTION";
this.ddlS.DataValueField = "LOCATE_SECTION";
this.ddlS.DataBind();
this.ddlS.Items.Insert(0, " ");
this.ddlE.DataSource = Dt;
this.ddlE.DataTextField = "LOCATE_SECTION";
this.ddlE.DataValueField = "LOCATE_SECTION";
this.ddlE.DataBind();
this.ddlE.Items.Insert(0, " ");
Dt = CreateEmptyTable();
GridView1.DataSource = Dt;
GridView1.DataBind();
lblStocktakeNo.Text = "";
ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(UpdatePanel), "ButtonControl", "EnableButton();", true);
}
}
private bool CheckData()
{
BCO.ConfirmStockTake bco = new BCO.ConfirmStockTake(ConntionDB);
string strLocateNo = string.Empty;
string strResult = string.Empty;
bco.GetLocateNo(this.txtStocktakeNo.Text, out strLocateNo, out strResult);
if (strResult == "0")
{
ShowErrorMessage("此盤點單號不存在");
ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(UpdatePanel), "隨便寫", "document.getElementById('" + this.txtStocktakeNo.ClientID + "').focus();", true);
return false;
}
if (lblLocateNo.Text.Trim() == "")
{
ShowErrorMessage("請輸入 [儲區]");
return false;
}
bool isExist = false;
DataTable dtData = queryData(out isExist);
if (dtData.Rows.Count == 0)
{
if (isExist == false)
{
ShowErrorMessage("查無待確認資料");
return false;
}
}
return true;
}
public DataTable queryData(out bool isExist)
{
ResultMsgLabel.Text = "";
BCO.ConfirmStockTake bco = new BCO.ConfirmStockTake(ConntionDB);
DataTable Dt = null;
ArrayList aList = this.getParameterList();
Dt = bco.QueryStockTakeDetl(aList, out isExist);
ViewState["Data"] = Dt;
return Dt;
}
