private void QueryData()
{
#region
try
{
string strPrefixed = "POP_DisApproveError";
Session[string.Format("{0}_DISNO_{1}", strPrefixed, PageTimeStamp.Value)] = null;
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
ALOModel.ProcessMultiDisRecords BCO = new ALOModel.ProcessMultiDisRecords(ConnectionDB);
DataTable dt = null;
if (Session[SessionIDName] == null)
{
dt = BCO.QueryDisItemForALO20(GetQueryParams());
Session[SessionIDName] = dt;
}
else
{
dt = (DataTable)Session[SessionIDName];
}
#region Virtual Data
//DataTable dt = new DataTable();
//DataRow dr;
//dt.Columns.Add("DIS_NO");
//dt.Columns.Add("ROOT_NAME");
//dt.Columns.Add("PMA_NAME");
//dt.Columns.Add("PATTERN_NAME");
//dt.Columns.Add("ITEM");
//dt.Columns.Add("ITEM_NAME");
//dt.Columns.Add("PERIOD");
//dt.Columns.Add("ACCEPT_QTY");
//dt.Columns.Add("DIS_PRE_QTY");
//dt.Columns.Add("DIS_QTY");
//dt.Columns.Add("ST_ACCEPT_DATE");
//dt.Columns.Add("APPROVE_DATE");
//dt.Columns.Add("N_ST_ACCEPT_STATUS");
//dt.Columns.Add("N_CHECK");
//dt.Columns.Add("N_Deal_Result");
//dr = dt.NewRow();
//dr["DIS_NO"] = "AAA";
//dr["ITEM"] = "100978";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "AAA";
//dr["ITEM"] = "100111";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "AAA";
//dr["ITEM"] = "100222";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "AAA";
//dr["ITEM"] = "100333";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "BBB";
//dr["ITEM"] = "100978";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "CCC";
//dr["ITEM"] = "100111";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = "0";
//dr["N_CHECK"] = "1";
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "CCC";
//dr["ITEM"] = "100222";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "CCC";
//dr["ITEM"] = "100333";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "DDD";
//dr["ITEM"] = "100555";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "EEE";
//dr["ITEM"] = "100666";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
//dr = dt.NewRow();
//dr["DIS_NO"] = "FFF";
//dr["ITEM"] = "100777";
//dr["ST_ACCEPT_DATE"] = SLP_SLPDate1.Text;
//dr["APPROVE_DATE"] = DateTime.Now.AddDays(-15).ToString("yyyy/MM/dd");
//dr["N_ST_ACCEPT_STATUS"] = GetOutStatus();
//dr["N_CHECK"] = GetCheckStatus();
//dt.Rows.Add(dr);
#endregion
if (dt != null && dt.Rows.Count > 0)
{
gv_Result.PageSize = iCurrentGvPageSize;
gv_Result.PageIndex = iCurrentGvPageIndex;
DataView dv = dt.DefaultView;
dv.Sort = "DIS_NO";
gv_Result.DataSource = dv;
gv_Result.DataBind();
//if (dt.Rows.Count >= 30)
// Panel_Result.Height = 500;
//else if (dt.Rows.Count >= 10)
// Panel_Result.Height = 300;
//else
// Panel_Result.Height = 200;
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", dt.Rows.Count.ToString());
SwitchControlsAfterQuery(true);
}
else
{
gv_Result.DataBind();
//Panel_Result.Height = 0;
ResultMsgLabel.Text = "查無資料";
SwitchControlsAfterQuery(false);
}
}
catch (Exception ex)
{
gv_Result.DataBind();
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
private string ProcessConfirmFromBridge(string strStAcceptDate, string strDisNoForAry, string strCtrlPending, Int32 iProcessingAryIndex)
{
#region
bool bResult = false, bResultCheck = false;
string strCallbackResult = "";
string strResult = "", strErrMsg = "", strErrMsgCheck = "";
string strPrefixed = "POP_DisApproveError";
string strDisNo = "", strNextDisNo = "";
string strDIS_QTY = "";
string[] strAryDisAry = strDisNoForAry.Split(";".ToCharArray());
string[] strAryCtrlPending = strCtrlPending.Split(";".ToCharArray());
try
{
fmStatus = FormStatus.fmProcess;
ALOModel.MaintainDisRecord BCO = new ALOModel.MaintainDisRecord(ConnectionDB);
if (iProcessingAryIndex < strAryDisAry.Length)
{
strDisNo = strAryDisAry[iProcessingAryIndex];
ArrayList ParameterList = new ArrayList();//20091113
//---------------------------------------------------------------------
//2010/02/09 added:確認前檢核
ALOModel.MaintainDisCRMRecord BCO3 = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(strStAcceptDate);
ParameterList.Add(strDisNo);
try
{
bResultCheck = BCO3.Pick_Control_Check(ParameterList, out strErrMsgCheck);
}
catch (Exception ex)
{
throw ex;
}
//---------------------------------------------------------------------
ParameterList.Clear();
ParameterList.Add(strStAcceptDate);
ParameterList.Add(strDisNo);
ParameterList.Add("VDS_ALO_DIS_STORE");
ParameterList.Add(strAryCtrlPending[5]);
try
{
bResult = BCO.ProcessConfirm(ParameterList, out strResult, out strErrMsg, null);
}
catch (Exception ex)
{
throw ex;
}
if (!bResult)
{
Session[string.Format("{0}_DISNO_{1}", strPrefixed, strAryCtrlPending[0])] += string.Format("{0},", strDisNo);
Session[string.Format("{0}_OPTYPE_{1}", strPrefixed, strAryCtrlPending[0])] = "1";
Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strAryCtrlPending[0])] += string.Format("配本序號:{0},{1}{2}{3};\r\n", strDisNo, strErrMsgCheck, bResultCheck ? "" : ",", strErrMsg);
}
else
{
if (!bResultCheck)
{
Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strAryCtrlPending[0])] += string.Format("配本序號:{0},{1};\r\n", strDisNo, strErrMsgCheck);
}
}
ALOModel.ProcessMultiDisRecords BCO2 = new ALOModel.ProcessMultiDisRecords(ConnectionDB);
DataTable dtTemp = BCO2.QueryDisItemForALO20(GetQueryParams(strStAcceptDate, strDisNo, bResult));
if (dtTemp != null && dtTemp.Rows.Count > 0)
strDIS_QTY = dtTemp.Rows[0]["DIS_QTY"].ToString().Trim();
iProcessingAryIndex = iProcessingAryIndex + 1;
if (iProcessingAryIndex < strAryDisAry.Length)
{
strNextDisNo = strAryDisAry[iProcessingAryIndex];
}
else
{
strNextDisNo = "X";//表示已執行到最後一筆
}
//0:DIS_NO字串For陣列用-
//1:下一筆陣列Index-
//2:執行結果-
//3:錯誤訊息-
//4:要關閉執行狀態的DIS_NO-
//5:要開啟執行狀態的DIS_NO-
//6:是否有累積執行錯誤之DIS_NO-
//7:ST_ACCEPT_DATE ClientID-
//8:ResultMsgLabel ClientID-
//9:ErrMsgLabel ClientID-
//10:將再開啟之控制項字串陣列
//11:DIS_QTY
string strCtrlIDToUnLock = string.Format("{0}", strAryCtrlPending[1]);
strCallbackResult = string.Format("{0}-{1}-{2}-{3}-{4}-{5}-{6}-{7}-{8}-{9}-{10}-{11}",
strDisNoForAry,
iProcessingAryIndex,
bResult ? "OK" : "NG",
Session[string.Format("{0}_ERRMSG_{1}", strPrefixed, strAryCtrlPending[0])].ToString(),//strErrMsg,
strDisNo,
strNextDisNo,
Session[string.Format("{0}_DISNO_{1}", strPrefixed, strAryCtrlPending[0])] == null ? "0" : "1",
strAryCtrlPending[2],
strAryCtrlPending[3],
strAryCtrlPending[4],
strCtrlIDToUnLock,
strDIS_QTY
);
}
}
catch (Exception ex)
{
throw ex;
}
return strCallbackResult;
#endregion
}
/// <summary>
/// 檢核後之變更量異動
/// </summary>
private void ReplaceDisQty()
{
#region
string SessionIDName_PARAMS = string.Format("{0}_PARAMS_{1}", PAGE_DT_01, PageTimeStamp.Value);
ArrayList ParameterList = (ArrayList)Session[SessionIDName_PARAMS];
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
DataTable dtOriginal = (DataTable)Session[SessionIDName];
ALOModel.ProcessMultiDisRecords BCO = new ALOModel.ProcessMultiDisRecords(ConnectionDB);
DataTable dtNew = null;
try
{
dtNew = BCO.QueryDisItemForALO20(ParameterList);
if (dtOriginal != null && dtNew != null && dtNew.Rows.Count > 0)
{
for (Int32 i = 0; i <= dtOriginal.Rows.Count - 1; i++)
{
for (Int32 j = 0; j <= dtNew.Rows.Count - 1; j++)
{
if (dtOriginal.Rows[i]["DIS_NO"].ToString().Trim() == dtNew.Rows[j]["DIS_NO"].ToString().Trim() &&
dtOriginal.Rows[i]["ITEM"].ToString().Trim() == dtNew.Rows[j]["ITEM"].ToString().Trim() &&
dtOriginal.Rows[i]["PERIOD"].ToString().Trim() == dtNew.Rows[j]["PERIOD"].ToString().Trim()
)
{
dtOriginal.Rows[i]["DIS_QTY"] = dtNew.Rows[j]["DIS_QTY"].ToString().Trim();
break;
}
}
}
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
