public static IList <NhanVienInfo> LayDsNhanVien()
{
IList <NhanVienInfo> ds = new List <NhanVienInfo>();
NhanVienData data = new NhanVienData();
DataTable tbl = data.LayDSNhanVien();
IList <NhanVienInfo> NhanVien = new List <NhanVienInfo>();
foreach (DataRow row in tbl.Rows)
{
NhanVienInfo NV = new NhanVienInfo();
PhongGiaoDichInfo m_PGD = new PhongGiaoDichInfo();
m_PGD.TenPhongGD = Convert.ToString(row["TenPhong"]);
NV.MaNV = Convert.ToString(row["MaNV"]);
NV.HoTen = Convert.ToString(row["HoTen"]);
NV.DiaChi = Convert.ToString(row["DiaChi"]);
NV.DienThoai = Convert.ToString(row["DienThoai"]);
NV.NgaySinh = Convert.ToDateTime(row["NgaySinh"]);
NV.MaPhongGD = m_PGD;
NhanVien.Add(NV);
}
return(NhanVien);
}
//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;
//}
#endregion
#region STK co kỳ hạn
public static IList <SoTietKiemInfo> LayDsSoTKCoKyHan(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 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);
}
