示例#1
0
        /// <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;
            }
        }
示例#2
0
    //取得營業所資料
    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;
    }