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(); }