Beispiel #1
0
        /// <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;
        }
Beispiel #2
0
    /// <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;
    }