//Tinh lai so co ky han
public double RutLaiSoCoKyHan(String MaSo)
{
double m_tienLai = 0;
DataTable data = m_RutTietKiemData.LayDSSo(MaSo);
DataRow row = data.Rows[0];
m_tienLai += Convert.ToDouble(row["MucLaiSuat"]) * Convert.ToInt64(row["SoDu"]) * Convert.ToInt32(row["KyHan"]);
return(m_tienLai / 100);
}
public int TinhNgay(String MaSo)
{
RutTietKiemData dataRut = new RutTietKiemData();
DataTable data = dataRut.LayDSSo(MaSo);
DataRow row = data.Rows[0];
DateTime d1 = Convert.ToDateTime(row["NgayHieuLuc"].ToString());
DateTime d2 = Convert.ToDateTime(row["NgayDenHan"].ToString());
int SoNgay = Convert.ToInt32(d2.ToOADate() - d1.ToOADate());
return(SoNgay);
}
public void LayRutTietKiem(ComboBoxEx MaSoTK, TextBoxX MaKH, TextBoxX TenKH, TextBoxX SoDu, TextBoxX LoaiTienGui, TextBoxX LoaiTietKiem, TextBoxX LaiSuat, TextBoxX NgayHieuLuc, TextBoxX NgayDenHan, TextBoxX SoButToan)
{
RutTietKiemData data1 = new RutTietKiemData();
DataTable tbl = data1.LayDSSo(MaSoTK.SelectedValue.ToString());
DataRow row = tbl.Rows[0];
MaKH.Text = Convert.ToString(row["MaKH"]);
TenKH.Text = Convert.ToString(row["HoTen"]);
SoDu.Text = Convert.ToString(row["SoDu"]);
LoaiTienGui.Text = Convert.ToString(row["LoaiTien"]);
LoaiTietKiem.Text = Convert.ToString(row["TenLoaiTietKiem"]);
LaiSuat.Text = Convert.ToString(row["MucLaiSuat"]);
NgayDenHan.Text = Convert.ToString(row["NgayHieuLuc"]);
NgayHieuLuc.Text = Convert.ToString(row["NgayDenHan"]);
SoButToan.Text = Convert.ToString(row["SoButToan"]);
}