public void HienThiComboboxTheoMaKheuocTV(NumericUpDown numSoTienGoc, ComboBox cmbTaiKhoanNo, ComboBox cmbTaiKhoanCo, String MaSoKU)
        {
            DataTable tbl = new HoSoKheUocLayer().LayHoSoKheUocTheoMa(MaSoKU);

            if (tbl.Rows.Count > 0)
            {
                //cmbSoTaiKhoan.Text = tbl.Rows[0]["TKChoVay"].ToString();
                // dtpNgayTinhLai.Text = tbl.Rows[0]["NgayTinhLai"].ToString();
                numSoTienGoc.Text           = tbl.Rows[0]["SoTienHienTai"].ToString();
                cmbTaiKhoanNo.SelectedValue = tbl.Rows[0]["ThuLai"].ToString();
                cmbTaiKhoanCo.SelectedValue = tbl.Rows[0]["ThuLai"].ToString();
            }
            //catch { }
        }
        public void HienThiComboboxTheoMaKheuoc(NumericUpDown numConLai, NumericUpDown numDuocPhep, ComboBox cmbSoTaiKhoan, ComboBox cmbTKNo, String MaSoKU)
        {
            DataTable tbl = new HoSoKheUocLayer().LayHoSoKheUocTheoMa(MaSoKU);

            //DataTable tbl1 = new LaiSuatPlayer().LayLaiSuat();
            if (tbl.Rows.Count > 0)
            {
                cmbSoTaiKhoan.Text = tbl.Rows[0]["TKChoVay"].ToString();
                numDuocPhep.Text   = tbl.Rows[0]["SoTienHienTai"].ToString();
                numConLai.Text     = tbl.Rows[0]["SoTienHienTai"].ToString();
                cmbTKNo.Text       = tbl.Rows[0]["TKChoVay"].ToString();
                //cmbTKCo.Text = tbl.Rows[0]["TKChoVay"].ToString();
            }
            //catch { }
        }
        //public void HienThiComboboxTheoMaKheuoc(NumericUpDown numSoTienLaiTH,NumericUpDown numSoTienLaiQH, String MaSoKU)
        //{
        //    DataTable tbl = new HoSoKheUocLayer().LayHoSoKheUocTheoMa(MaSoKU);
        //    //DataTable tbl1 = new LaiSuatPlayer().LayLaiSuat(MaLaiSuat);
        //    if (tbl.Rows.Count > 0)
        //    {
        //        //cmbSoTaiKhoan.Text = tbl.Rows[0]["TKChoVay"].ToString();
        //        dtpNgayTinhLai.Text = tbl.Rows[0]["NgayTinhLai"].ToString();
        //        numSoTienGoc.Text = tbl.Rows[0]["SoTienHienTai"].ToString();
        //        cmbTaiKhoanNo.Text = tbl.Rows[0]["ThuLai"].ToString();
        //        cmbTaiKhoanCo.Text = tbl.Rows[0]["ThuLai"].ToString();

        //    }
        //    //catch { }
        //}

        public void HienThiComboboxTheoMaKheuocTL(TextBox txtSoTienLaiQH, TextBox txtSoTienLaiTH, DateTimePicker dtpNgayTinhLai, NumericUpDown numSoTienGoc, ComboBox cmbTaiKhoanNo, ComboBox cmbTaiKhoanCo, String MaSoKU)
        {
            DataTable tbl = new HoSoKheUocLayer().LayHoSoKheUocTheoMa(MaSoKU);

            if (tbl.Rows.Count > 0)
            {
                //cmbSoTaiKhoan.Text = tbl.Rows[0]["TKChoVay"].ToString();
                dtpNgayTinhLai.Text         = tbl.Rows[0]["NgayTinhLai"].ToString();
                numSoTienGoc.Text           = tbl.Rows[0]["SoTienHienTai"].ToString();
                cmbTaiKhoanNo.SelectedValue = tbl.Rows[0]["ThuLai"].ToString();
                cmbTaiKhoanCo.SelectedValue = tbl.Rows[0]["ThuLai"].ToString();
                //ThuLaiController tl = new ThuLaiController();
                //String tinhlai = Convert.ToString(tl.TinhLai(MaSoKU));
                //numSoTienLaiTH.Value = Convert.ToInt64(tinhlai);
                ThuLaiController tlctrol = new ThuLaiController();
                //String s_MaSoKU = Convert.ToString(cm).Trim();
                txtSoTienLaiTH.Text = Convert.ToString(tlctrol.TinhLai(MaSoKU));
                txtSoTienLaiQH.Text = Convert.ToString(tlctrol.TinhLaiQH(MaSoKU));
            }
            //catch { }
        }