public static String LaySoTienTheoMa(String MaSoTK)
        {
            InPhieuThuData data = new InPhieuThuData();
            DataTable      tbl  = data.LaySoTheoMa(MaSoTK);

            String soTien = Convert.ToString(tbl.Rows[0]["SoTien"]);

            return(soTien);
        }
        public static IList <InPhieuThuInfo> LayDsSoTietKiemTheoMa()
        {
            IList <InPhieuThuInfo> ds = new List <InPhieuThuInfo>();

            InPhieuThuData data = new InPhieuThuData();
            DataTable      tbl  = data.LaySoTheoMa();

            IList <InPhieuThuInfo> TK = new List <InPhieuThuInfo>();

            foreach (DataRow row in tbl.Rows)
            {
                InPhieuThuInfo PT = new InPhieuThuInfo();

                KhachHangInfo m_KH = new KhachHangInfo();
                m_KH.HoTen  = Convert.ToString(row["HoTen"]);
                m_KH.CMND   = Convert.ToString(row["CMND"]);
                m_KH.DiaChi = Convert.ToString(row["DiaChi"]);

                ChiTietPhatSinhGDInfo m_PSGD = new ChiTietPhatSinhGDInfo();
                m_PSGD.SoTien = Convert.ToInt64(row["SoTien"]);
                //m_PSGD.SoHieuTaiKhoanCo.SoHieuTaiKhoan = Convert.ToString(row["SoHieuTaiKhoanCo"]);


                DMTaiKhoanInfo m_DMTK = new DMTaiKhoanInfo();
                m_DMTK.TenTaiKhoan = Convert.ToString(row["TenTaiKhoan"]);
                //m_DMTK.SoHieuTaiKhoan = Convert.ToString(row["SoHieuTaiKhoan"]);

                SoTietKiemInfo m_STK = new SoTietKiemInfo();
                m_STK.MaSoTietKiem = Convert.ToString(row["MaSoTietKiem"]);

                LoaiTietKiemInfo m_LTK = new LoaiTietKiemInfo();
                m_LTK.TenLoaiTietKiem = Convert.ToString("TenLoaiTietKiem");

                DMLoaiTienInfo m_DMT = new DMLoaiTienInfo();
                m_DMT.LoaiTien = Convert.ToString(row["LoaiTien"]);

                PT.KhachHang         = m_KH;
                PT.ChiTietPhatSinhGD = m_PSGD;
                PT.LoaiTietKiem      = m_LTK;
                PT.SoTietKiem        = m_STK;
                PT.DMTaiKhoan        = m_DMTK;

                PT.DMLoaiTien = m_DMT;

                TK.Add(PT);
            }
            return(TK);
        }