/// <summary> /// 產生CGD19第三張報表_新版 /// </summary> /// <param name="ParameterList">查詢DB的參數</param> /// <returns>回傳查詢結果</returns> public DataTable GGD19_3(ArrayList ParameterList) { CGDModel.ProcessStoreBackReport BCO = new PIC.VDS2G.LGT.CGD.ProcessStoreBackReport(ConntionDB); DataTable Dt = BCO.ProcessStoreDataV1(ParameterList); #region 檢查回傳資料 if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } #endregion return Dt; }
/// <summary> /// 檢查單號是否存在 /// </summary> /// <param name="strBillNo">單號</param> /// <param name="strReportType">單據類別</param> private bool chkBillExist(string strReportType, string strBillNo) { bool result = true; CGDModel.ProcessStoreBackReport BCO = new PIC.VDS2G.LGT.CGD.ProcessStoreBackReport(ConntionDB); ParameterList.Clear(); ParameterList.Add(strReportType);//0 單據類別 ParameterList.Add(strBillNo);//1 單號 if (BCO.CheckStoreOutNO(ParameterList) == 0) { result = false; } else { result = true; } return result; }