//載入最下方高見副代理區塊
private void BindSPEC(string strPICK_DATE, string strPICK_BATCH)
{
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 dtSPEC = BCO.QueryVDS_CGD_DAILY_SPEC(ParameterList);
Session["CGD39_SPEC_" + PageTimeStamp.Value] = dtSPEC;
if (dtSPEC.Rows.Count > 0)
{
txtSPEC_STORENUM_ALL.Text = dtSPEC.Rows[0]["SPEC_STORENUM_ALL"].ToString();
txtSPEC_PERIODNUM_ALL.Text = dtSPEC.Rows[0]["SPEC_PERIODNUM_ALL"].ToString();
txtSPEC_STAFFNUM.Text = dtSPEC.Rows[0]["SPEC_STAFFNUM"].ToString();
txtSEPC_HR.Text = dtSPEC.Rows[0]["SEPC_HR"].ToString();
txtVDS_TRANSNUM.Text = dtSPEC.Rows[0]["VDS_TRANSNUM"].ToString();
txtDPS_TRANSNUM.Text = dtSPEC.Rows[0]["DPS_TRANSNUM"].ToString();
txtSPEC_STORENUM.Text = dtSPEC.Rows[0]["SPEC_STORENUM"].ToString();
txtSPEC_ITEMNUM.Text = dtSPEC.Rows[0]["SPEC_ITEMNUM"].ToString();
txtSPEC_PERIODNUM.Text = dtSPEC.Rows[0]["SPEC_PERIODNUM"].ToString();
txtNOTES.Text = dtSPEC.Rows[0]["NOTES"].ToString();
}
else
{
ParameterList.Clear();
ParameterList.Add(DBPara(slpPickDate.Text, ParaType.Varchar2));
ParameterList.Add(DBPara(txtPICK_BATCH.Text, ParaType.Varchar2));
DataTable dtC67 = BCO.QueryDeilyDPSitem(ParameterList); //C6,C7
DataTable dtC5 = BCO.QueryDailyDPSitemData(ParameterList); //C5
DataTable dtC48 = BCO.GetPickOutItem(ParameterList); //C4,C8
string strSPEC_STORENUM_ALL = "0";
string strSPEC_PERIODNUM_ALL = "0";
string strVDS_TRANSNUM = "0";
string strDPS_TRANSNUM = "0";
string strSPEC_ITEMNUM = "0";
string strSPEC_PERIODNUM = "0";
if (dtC5.Rows.Count > 0)
strSPEC_STORENUM_ALL = dtC5.Rows[0]["SPEC_STORE_CNT"].ToString();//C5 副代理門市店數-合計
if (dtC67.Rows.Count > 0)
{
strSPEC_PERIODNUM_ALL = dtC67.Rows[0]["SPEC_QTY_SUM"].ToString(); //C6 副代理明細資料-數量
strVDS_TRANSNUM = dtC67.Rows[0]["PICK_REC_CNT"].ToString(); //C7 理貨明細資料-比數
strDPS_TRANSNUM = dtC67.Rows[0]["PICK_REC_CNT"].ToString(); //C7 理貨明細資料-比數
}
if (dtC48.Rows.Count > 0)
{
strSPEC_ITEMNUM = dtC48.Rows[0]["SPEC_ITEMNUM"].ToString();//C4-> count 資料列數
strSPEC_PERIODNUM = dtC48.Rows[0]["SPEC_PERIODNUM"].ToString();//C8-> 取《非理貨商品門市資料》區塊的《冊數》欄位合計值
}
//載入預設值
txtSPEC_STORENUM_ALL.Text = strSPEC_STORENUM_ALL;
txtSPEC_PERIODNUM_ALL.Text = strSPEC_PERIODNUM_ALL;
txtSPEC_STAFFNUM.Text = "0";
txtSEPC_HR.Text = "0";
txtVDS_TRANSNUM.Text = strVDS_TRANSNUM;
txtDPS_TRANSNUM.Text = strDPS_TRANSNUM;
txtSPEC_STORENUM.Text = "0";
txtSPEC_ITEMNUM.Text = strSPEC_ITEMNUM;
txtSPEC_PERIODNUM.Text = strSPEC_PERIODNUM;
txtNOTES.Text = "0";
}
int iSUM_PERIODNUM = int.Parse(txtSPEC_PERIODNUM_ALL.Text) + int.Parse(txtSPEC_PERIODNUM.Text);
txtSUM_PERIODNUM.Text = iSUM_PERIODNUM.ToString();
}
