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 }