public void HienThiComboBoxTheoNgay(ComboBox cbx)
{
SoTietKiemData STK = new SoTietKiemData();
NgayGiaoDichData NGD = new NgayGiaoDichData();
DataTable m_DT1 = STK.LayTheoNgayDH();
cbx.DataSource = m_DT1;
cbx.DisplayMember = "NgayGiaoDich";
cbx.ValueMember = "NgayGiaoDich";
}
public String LayMaSo()
{
String MaSo = "";
SoTietKiemData Data = new SoTietKiemData();
DataTable tbl = Data.LaySoTheoMa();
foreach (DataRow row in tbl.Rows)
{
MaSo = row["MaSoTietKiem"].ToString();
}
return(MaSo);
}
//Kiem Tra Ngay Giao Dich
public Boolean KTNgayGD(DateTime NgayGD)
{
SoTietKiemData data = new SoTietKiemData();
DataTable tbl = data.LayTheoNgayDH(NgayGD);
foreach (DataRow row in tbl.Rows)
{
if (row["NgayGiaoDich"].ToString() == row["NgayHieuLuc"].ToString())
{
return(false);
}
}
return(true);
}
public int KiemTraNgayDenHan()
{
int SoNgay = 0;
SoTietKiemData STK1 = new SoTietKiemData();
DataTable m_DT2 = STK1.LayTheoNgayDH();
foreach (DataRow row in m_DT2.Rows)
{
//DateTime d1 = new DateTime(2009,5,2);
DateTime d1 = Convert.ToDateTime(row["NgayDenHan"].ToString());
DateTime d2 = DateTime.Today;
SoNgay = Convert.ToInt32(d1.ToOADate() - d2.ToOADate());
}
return(SoNgay);
}
public String LayMaSoTietKiem()
{
String MaSo = "";
SoTietKiemData data = new SoTietKiemData();
DataTable tbl = data.LaySoTietKiem();
foreach (DataRow row in tbl.Rows)
{
String chuoi = row["MaSoTietKiem"].ToString();
string so = chuoi.Substring(3, 6);
int TT = Convert.ToInt32(so);
MaSo = "STK" + (m_QuyDinh.LaySTT(TT + 1));
}
return(MaSo);
}
public static IList <SoTietKiemInfo> LayDsSoTietKiemTheoMa(String MaSoTK)
{
IList <SoTietKiemInfo> ds = new List <SoTietKiemInfo>();
SoTietKiemData data = new SoTietKiemData();
DataTable tbl = data.LaySoTheoMa(MaSoTK);
IList <SoTietKiemInfo> STK = new List <SoTietKiemInfo>();
foreach (DataRow row in tbl.Rows)
{
SoTietKiemInfo S = new SoTietKiemInfo();
if (row["MaLoaiTietKiem"].ToString() != "TK423100")
{
MessageBoxEx.Show("Bạn đang sư dụng chức năng in sổ không kỳ hạn!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
else
{
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"]);
m_KH.NgayCap = Convert.ToDateTime(row["NgayCap"]);
m_KH.NoiCap = Convert.ToString(row["NoiCap"]);
ChiTietPhatSinhGDInfo m_PSGD = new ChiTietPhatSinhGDInfo();
m_PSGD.SoTien = Convert.ToInt64(row["SoTien"]);
LaiSuatTietKiemInfo m_LS = new LaiSuatTietKiemInfo();
m_LS.MucLaiSuat = Convert.ToInt32(row["MucLaiSuat"]);
SoDuTietKiemInfo m_SoDuInfo = new SoDuTietKiemInfo();
m_SoDuInfo.SoDu = Convert.ToInt64(row["SoDu"]);
S.MaSoTietKiem = Convert.ToString(row["MaSoTietKiem"]);
S.LaiSuatTK = m_LS;
S.MaKH = m_KH;
S.ChiTietPSGD = m_PSGD;
S.SoDuTK = m_SoDuInfo;
}
STK.Add(S);
}
return(STK);
}
public void ThemSoKKH(ComboBoxEx MaSoTK, TextBoxX TenKH, TextBoxX LoaiTietKiem, TextBoxX LaiSuat, TextBoxX SoDu, TextBoxX NgayDenHan, TextBoxX SoButToan, TextBoxX SoHieuTaiKhoanCo, TextBoxX SoHieuTaiKhoanCo1)
{
SoTietKiemData data = new SoTietKiemData();
DataTable tbl = data.ThemSoKKH(MaSoTK.SelectedValue.ToString());
foreach (DataRow row in tbl.Rows)
{
if (row["MaLoaiTietKiem"].ToString() != "TK423100")
{
}
else
{
TenKH.Text = Convert.ToString(row["HoTen"]);
LoaiTietKiem.Text = Convert.ToString(row["TenLoaiTietKiem"]);
LaiSuat.Text = Convert.ToString(row["MucLaiSuat"]);
SoDu.Text = Convert.ToString(row["SoDu"]);
NgayDenHan.Text = Convert.ToString(row["NgayDenHan"]);
SoButToan.Text = Convert.ToString(row["SoButToan"]);
SoHieuTaiKhoanCo.Text = Convert.ToString(row["SoHieuTaiKhoan"]);
SoHieuTaiKhoanCo1.Text = Convert.ToString(row["SoHieuTaiKhoanCo"]);
}
}
}
public static IList <SoTietKiemInfo> LayDsSoTKCoKyHan()
{
IList <SoTietKiemInfo> ds = new List <SoTietKiemInfo>();
SoTietKiemData data = new SoTietKiemData();
DataTable tbl = data.LaySoTheoMa();
IList <SoTietKiemInfo> STK = new List <SoTietKiemInfo>();
foreach (DataRow row in tbl.Rows)
{
SoTietKiemInfo S = new SoTietKiemInfo();
if (row["MaLoaiTietKiem"].ToString() == "TK423100")
{
MessageBoxEx.Show("Bạn đang sư dụng chức năng in sổ không co ky han!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
else
{
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"]);
m_KH.NgayCap = Convert.ToDateTime(row["NgayCap"]);
m_KH.NoiCap = Convert.ToString(row["NoiCap"]);
ChiTietPhatSinhGDInfo m_PSGD = new ChiTietPhatSinhGDInfo();
m_PSGD.SoTien = Convert.ToInt64(row["SoTien"]);
LaiSuatTietKiemInfo m_LS = new LaiSuatTietKiemInfo();
m_LS.MucLaiSuat = Convert.ToInt32(row["MucLaiSuat"]);
SoDuTietKiemInfo m_SoDuInfo = new SoDuTietKiemInfo();
m_SoDuInfo.SoDu = Convert.ToInt64(row["SoDu"]);
LoaiTietKiemInfo m_LTK = new LoaiTietKiemInfo();
m_LTK.KyHan = Convert.ToInt32(row["KyHan"]);
PhongGiaoDichInfo m_PGD = new PhongGiaoDichInfo();
m_PGD.MaPhongGD = Convert.ToString(row["MaPhongGiaoDich"]);
DMKyLaiTKInfo m_DMKyLaiTK = new DMKyLaiTKInfo();
m_DMKyLaiTK.LoaiKyTinhLai = Convert.ToString(row["LoaiKyTinhLai"]);
S.MaSoTietKiem = Convert.ToString(row["MaSoTietKiem"]);
S.NgayHieuLuc = Convert.ToDateTime(row["NgayHieuLuc"]);
S.NgayDenHan = Convert.ToDateTime(row["NgayDenHan"]);
S.LaiSuatTK = m_LS;
S.MaKH = m_KH;
S.ChiTietPSGD = m_PSGD;
S.SoDuTK = m_SoDuInfo;
S.PhongGiaoDich = m_PGD;
S.DMKyTinhLai = m_DMKyLaiTK;
S.MaLoaiTietKiem = m_LTK;
}
STK.Add(S);
}
return(STK);
}
