private void LoadData()
{
if (Request["pickdate"] != null)
slpPickDate.Text = Request["pickdate"].ToString();
if (Request["pick_batch"] != null)
txtPICK_BATCH.Text = Request["pick_batch"].ToString();
BindMaster(slpPickDate.Text, txtPICK_BATCH.Text);
//理貨品項短溢明細區塊
BindGridView1();
DataTable dtSUM = (DataTable)Session["CGD38_SUM_" + PageTimeStamp.Value];
if (dtSUM.Rows.Count > 0)
hdfErrorNum.Value = dtSUM.Rows[0]["ErrorNum"].ToString();//CGD38.25 總錯誤本數
decimal dSumSHORT_NUM = 0;
decimal dSumOVER_NUM = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
string strSHORT_NUM = ((TextBox)GridView1.Rows[i].FindControl("txtSHORT_NUM")).Text;
string strOVER_NUM = ((TextBox)GridView1.Rows[i].FindControl("txtOVER_NUM")).Text;
if (strSHORT_NUM == "")
strSHORT_NUM = "0";
if (strOVER_NUM == "")
strOVER_NUM = "0";
dSumSHORT_NUM += decimal.Parse(strSHORT_NUM);
dSumOVER_NUM += decimal.Parse(strOVER_NUM);
}
decimal dErrRate = 0;
if ((txtTotalITEM2.Text.Trim() == "0") || (txtTotalITEM2.Text.Trim() == ""))
dErrRate = 0;
else
dErrRate = Math.Round((dSumSHORT_NUM + dSumOVER_NUM + decimal.Parse(hdfErrorNum.Value)) / decimal.Parse(txtTotalITEM2.Text) * 100, 4);
this.txtSUM_SHORTNUM.Text = dSumSHORT_NUM.ToString();
this.txtSUM_OVERNUM.Text = dSumOVER_NUM.ToString();
this.txtERR_RATE.Text = dErrRate.ToString();
this.txtSUM_SHORTNUM.Attributes.Add("ReadOnly", "ReadOnly");
this.txtSUM_OVERNUM.Attributes.Add("ReadOnly", "ReadOnly");
this.txtERR_RATE.Attributes.Add("ReadOnly", "ReadOnly");
this.txtSUM_SHORTNUM.CssClass = "readtxtbox";
this.txtSUM_OVERNUM.CssClass = "readtxtbox";
this.txtERR_RATE.CssClass = "readtxtbox";
CGDModel.VDS_CGD39_BCO BCO = new CGDModel.VDS_CGD39_BCO(ConntionDB);
ParameterList.Clear();
ParameterList.Add(DBPara(slpPickDate.Text, ParaType.Varchar2));
ParameterList.Add(DBPara(txtPICK_BATCH.Text, ParaType.Varchar2));
DataTable dtINFO = BCO.QueryVENDOR_DAILY_INFO(ParameterList);
Session["CGD39_INFO_" + PageTimeStamp.Value] = dtINFO;
GridView2.DataSource = dtINFO;
GridView2.DataBind();
//前置作業工時
GridView3.DataSource = dtINFO;
GridView3.DataBind();
GridView4.DataSource = dtINFO;
GridView4.DataBind();
GridView5.DataSource = dtINFO;
GridView5.DataBind();
GridView6.DataSource = dtINFO;
GridView6.DataBind();
//載入最下方高見副代理區塊
BindSPEC(slpPickDate.Text, txtPICK_BATCH.Text);
//建立&修改人員區塊
DataTable dtSPEC = (DataTable)Session["CGD39_SPEC_" + PageTimeStamp.Value];
if (dtSPEC.Rows.Count != 0)
{
txtCreateDate.Text = dtSPEC.Rows[0]["CreateDate"].ToString(); ;
SLP_CREATEUID.Text = dtSPEC.Rows[0]["CREATEUID"].ToString();
txtUpdateDate.Text = dtSPEC.Rows[0]["UpdateDate"].ToString();
SLP_UPDATEUID.Text = dtSPEC.Rows[0]["UPDATEUID"].ToString();
}
UpdatePanel2.Update();
}
