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);
}