private void BindMaster(string strPICK_DATE, string strPICK_BATCH)
{
CGDModel.VDS_CGD38_BCO BCO = new CGDModel.VDS_CGD38_BCO(ConntionDB);
ParameterList.Clear();
ParameterList.Add(DBNull.Value);//ID
ParameterList.Add(DBPara(strPICK_DATE, ParaType.Varchar2));
ParameterList.Add(DBPara(strPICK_BATCH, ParaType.Varchar2));
DataTable dtRPT = BCO.QueryVDS_CGD_DAILY_RPT(ParameterList);
Session["CGD38_RPT_" + PageTimeStamp.Value] = dtRPT;
hdfID.Value = "";
if (dtRPT.Rows.Count > 0)
hdfID.Value = dtRPT.Rows[0]["ID"].ToString();
ParameterList.Clear();
ParameterList.Add(DBPara(hdfID.Value, ParaType.Number));//ID
ParameterList.Add(DBPara(strPICK_DATE, ParaType.Varchar2));
ParameterList.Add(DBPara(strPICK_BATCH, ParaType.Varchar2));
DataTable dtSUM = BCO.GetSummaryData(ParameterList);
Session["CGD38_SUM_" + PageTimeStamp.Value] = dtSUM;
//載入第一個區塊的資料(含建立&修改人資料)
BindFirstBlock();
//中間區塊計算用的隱藏TEXTBOX
txtTEMP_TIME07.Text = ShowTime(GetDef("PickTimeS"));
txtTEMP_TIME08.Text = ShowTime(GetDef("PickTimeE"));
//載入最後區塊(理貨各項數據區塊)
BindLastBlock();
}
private void BindMaster(string strPICK_DATE, string strPICK_BATCH)
{
CGDModel.VDS_CGD38_BCO BCO = new CGDModel.VDS_CGD38_BCO(ConntionDB);
ParameterList.Clear();
ParameterList.Add(DBNull.Value);//ID
ParameterList.Add(DBPara(strPICK_DATE, ParaType.Varchar2));
ParameterList.Add(DBPara(strPICK_BATCH, ParaType.Varchar2));
DataTable dtRPT = BCO.QueryVDS_CGD_DAILY_RPT(ParameterList);
Session["CGD38_RPT_" + PageTimeStamp.Value] = dtRPT;
hdfID.Value = "";
hdfRPT_UPDATEUID.Value = "";
hdfRPT_UPDATEDATE.Value = "";
if (dtRPT.Rows.Count > 0)
{
hdfID.Value = dtRPT.Rows[0]["ID"].ToString();
hdfRPT_UPDATEUID.Value = dtRPT.Rows[0]["UPDATEUID"].ToString();
hdfRPT_UPDATEDATE.Value = dtRPT.Rows[0]["UPDATEDATE"].ToString();
}
ParameterList.Clear();
ParameterList.Add(DBPara(hdfID.Value, ParaType.Number));//ID
ParameterList.Add(DBPara(strPICK_DATE, ParaType.Varchar2));
ParameterList.Add(DBPara(strPICK_BATCH, ParaType.Varchar2));
DataTable dtSUM = BCO.GetSummaryData(ParameterList);
Session["CGD38_SUM_" + PageTimeStamp.Value] = dtSUM;
//載入第一個區塊的資料
BindFirstBlock();
}
