/// <summary> /// CAA20報表 /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable CAA26_1(ArrayList ParameterList) { CAAModel.RecordingDueDetail bco = new CAAModel.RecordingDueDetail(ConntionDB); DataTable Dt = bco.GetDueDetail(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } else { return Dt; } }
//取得營業所資料 private static string Get_Z_O_Name(string strCode) { string strResult = string.Empty; if (strCode != "") { CAAModel.RecordingDueDetail BCO = new CAAModel.RecordingDueDetail(ConntionDB); ParameterList.Clear(); ParameterList.Add(strCode); DataTable dt = BCO.Get_Z_O_Name(ParameterList); if (dt.Rows.Count != 0) { strResult = dt.Rows[0]["SCODE"].ToString().Trim() + " " + dt.Rows[0]["EXPLAIN"].ToString().Trim(); } } return strResult; }