public HoaDonInfo HoaDon_GetItem(int HoaDonID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@HoaDonID", HoaDonID);
SqlDataReader rd = SQLDB.executereader("sp_HoaDon_GetItem", CommandType.StoredProcedure);
HoaDonInfo item = null;
while (rd.Read())
{
item = new HoaDonInfo();
item.NgayVao = rd["NgayVao"].ToString();
item.NgayVao_So = int.Parse(rd["NgayVao_So"].ToString());
item.GioVao = int.Parse(rd["GioVao"].ToString());
item.PhutVao = int.Parse(rd["PhutVao"].ToString());
item.NgayRa = rd["NgayRa"].ToString();
item.NgayRa_So = int.Parse(rd["NgayRa_So"].ToString());
item.GioRa = int.Parse(rd["GioRa"].ToString());
item.PhutRa = int.Parse(rd["PhutRa"].ToString());
item.KhuyenMai = decimal.Parse(rd["KhuyenMai"].ToString());
item.KhoanKhac = decimal.Parse(rd["KhoanKhac"].ToString());
item.GhiChu = rd["GhiChu"].ToString();
item.DaThanhToan = int.Parse(rd["DaThanhToan"].ToString());
item.LoaiThue = int.Parse(rd["LoaiThue"].ToString());
item.Ca = int.Parse(rd["Ca"].ToString());
item.TenKhachHang = rd["TenKhachHang"].ToString();
}
return item;
}
public List<TKDoanhThuDichVuInfo> HoaDonDichVu_GetItems_TheoThang(int Thang, int Nam)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@Thang", Thang);
SQLDB.Addparameter("@Nam", Nam);
SqlDataReader rd = SQLDB.executereader("sp_HoaDonDichVu_GetItems_TheoThang", CommandType.StoredProcedure);
List<TKDoanhThuDichVuInfo> list = new List<TKDoanhThuDichVuInfo>();
TKDoanhThuDichVuInfo item = null;
while (rd.Read())
{
item = new TKDoanhThuDichVuInfo();
item.HoaDon_DichVuID = int.Parse(rd["HoaDon_DichVuID"].ToString());
item.HoaDonID = int.Parse(rd["HoaDonID"].ToString());
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.DichVuID = int.Parse(rd["DichVuID"].ToString());
item.KhachHangID = int.Parse(rd["KhachHangID"].ToString());
item.HoTen = rd["HoTen"].ToString();
item.PhongName = rd["PhongName"].ToString();
item.DichVuName = rd["DichVuName"].ToString();
item.NgaySuDung = rd["NgaySuDung"].ToString();
item.SoLuong = int.Parse(rd["SoLuong"].ToString());
item.DonGia = decimal.Parse(rd["DonGia"].ToString());
item.TongTien = decimal.Parse(rd["TongTien"].ToString());
list.Add(item);
}
return list;
}
public KhachHangInfo KhachHang_GetItem(int KhachHangID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@KhachHangID", KhachHangID);
SqlDataReader rd = SQLDB.executereader("sp_KhachHang_GetItem", CommandType.StoredProcedure);
KhachHangInfo item = null;
while (rd.Read())
{
item = new KhachHangInfo();
item.KhachHangID = int.Parse(rd["KhachHangID"].ToString());
item.HoTen = rd["HoTen"].ToString();
item.DiaChi = rd["DiaChi"].ToString();
item.DienThoai = rd["DienThoai"].ToString();
item.CMND = rd["CMND"].ToString();
item.NgaySinh = rd["NgaySinh"].ToString();
item.NoiSinh = rd["NoiSinh"].ToString();
item.SoVisa = rd["SoVisa"].ToString();
item.ThoiHanVisa = rd["ThoiHanVisa"].ToString();
item.NguoiTiepNhan = rd["NguoiTiepNhan"].ToString();
item.NgayNhapCanh = rd["NgayNhapCanh"].ToString();
item.TamTruTuNgay = rd["TamTruTuNgay"].ToString();
item.TamTruDenNgay = rd["TamTruDenNgay"].ToString();
item.QuocTichID = int.Parse(rd["QuocTichID"].ToString());
item.GioiTinh = int.Parse(rd["GioiTinh"].ToString());
}
return item;
}
public QuocTichInfo QuocTich_GetItem(int QuocTichID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@QuocTichID", QuocTichID);
SqlDataReader rd = SQLDB.executereader("sp_QuocTich_GetItem", CommandType.StoredProcedure);
QuocTichInfo item=null;
while (rd.Read())
{
item = new QuocTichInfo();
item.QuocTichID = int.Parse(rd["QuocTichID"].ToString());
item.TenQuocTich = rd["TenQuocTich"].ToString();
}
return item;
}
public LoaiPhongInfo LoaiPhong_GetItem(int LoaiPhongID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@LoaiPhongID", LoaiPhongID);
SqlDataReader rd = SQLDB.executereader("sp_LoaiPhong_GetItem", CommandType.StoredProcedure);
LoaiPhongInfo item=null;
while (rd.Read())
{
item = new LoaiPhongInfo();
item.LoaiPhongID = int.Parse(rd["LoaiPhongID"].ToString());
item.LoaiPhongName = rd["LoaiPhongName"].ToString();
}
return item;
}
public List<QuocTichInfo> QuocTich_GetItems()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_QuocTich_GetItems", CommandType.StoredProcedure);
List<QuocTichInfo> list = new List<QuocTichInfo>();
QuocTichInfo item = null;
while (rd.Read())
{
item = new QuocTichInfo();
item.QuocTichID = int.Parse(rd["QuocTichID"].ToString());
item.TenQuocTich = rd["TenQuocTich"].ToString();
list.Add(item);
}
return list;
}
public List<LoaiPhongInfo> LoaiPhong_GetItems()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_LoaiPhong_GetItems", CommandType.StoredProcedure);
List<LoaiPhongInfo> list = new List<LoaiPhongInfo>();
LoaiPhongInfo item = null;
while (rd.Read())
{
item = new LoaiPhongInfo();
item.LoaiPhongID = int.Parse(rd["LoaiPhongID"].ToString());
item.LoaiPhongName = rd["LoaiPhongName"].ToString();
list.Add(item);
}
return list;
}
public GroupInfo Group_GetItem(int GroupID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@GroupID", GroupID);
SqlDataReader rd = SQLDB.executereader("sp_Group_GetItem", CommandType.StoredProcedure);
GroupInfo item = null;
while (rd.Read())
{
item = new GroupInfo();
item.GroupID = int.Parse(rd["GroupID"].ToString());
item.GroupName = rd["GroupName"].ToString();
item.Descriptions = rd["Descriptions"].ToString();
item.IsActived = int.Parse(rd["IsActived"].ToString());
}
return item;
}
public ChiTietPhieuNhapKhoInfo ChiTietPhieuNhapKho_GetItem(int ChiTietPhieuNhapID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@ChiTietPhieuNhapID", ChiTietPhieuNhapID);
SqlDataReader rd = SQLDB.executereader("sp_ChiTietPhieuNhapKho_GetItem", CommandType.StoredProcedure);
ChiTietPhieuNhapKhoInfo item = null;
while (rd.Read())
{
item = new ChiTietPhieuNhapKhoInfo();
item.SoLuong = int.Parse(rd["SoLuong"].ToString());
item.DonGia = decimal.Parse(rd["DonGia"].ToString());
item.TongTien = decimal.Parse(rd["ThanhTien"].ToString());
item.DichVuID = int.Parse(rd["DichVuID"].ToString());
}
return item;
}
public List<UserInfo> User_GetActivedItems()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_User_GetActivedItems", CommandType.StoredProcedure);
List<UserInfo> list = new List<UserInfo>();
UserInfo item = null;
while (rd.Read())
{
item = new UserInfo();
item.UserID = int.Parse(rd["UserID"].ToString());
item.UserName = rd["UserName"].ToString();
list.Add(item);
}
return list;
}
public DichVuInfo DichVu_GetItem(int DichVuID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@DichVuID", DichVuID);
SqlDataReader rd = SQLDB.executereader("sp_DichVu_GetItem", CommandType.StoredProcedure);
DichVuInfo item=null;
while (rd.Read())
{
item = new DichVuInfo();
item.DichVuID = int.Parse(rd["DichVuID"].ToString());
item.DichVuName = rd["DichVuName"].ToString();
item.GiaTien = decimal.Parse(rd["GiaTien"].ToString());
item.SL = int.Parse(rd["SL"].ToString());
}
return item;
}
public List<DichVuInfo> DichVu_GetItems()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_DichVu_GetItems", CommandType.StoredProcedure);
List<DichVuInfo> list = new List<DichVuInfo>();
DichVuInfo item = null;
while (rd.Read())
{
item = new DichVuInfo();
item.DichVuID = int.Parse(rd["DichVuID"].ToString());
item.DichVuName = rd["DichVuName"].ToString();
item.GiaTien = decimal.Parse(rd["GiaTien"].ToString());
item.SL = int.Parse(rd["SL"].ToString());
list.Add(item);
}
return list;
}
public Ngay_PhongInfo Ngay_Phong_GetItemByPhongID(int PhongID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@PhongID", PhongID);
SqlDataReader rd = SQLDB.executereader("sp_Ngay_Phong_GetItemByPhongID", CommandType.StoredProcedure);
Ngay_PhongInfo item = null;
while (rd.Read())
{
item = new Ngay_PhongInfo();
item.Ngay_PhongID = int.Parse(rd["Ngay_PhongID"].ToString());
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.GiaNgay = decimal.Parse(rd["GiaNgay"].ToString());
item.GiaTuan = decimal.Parse(rd["GiaTuan"].ToString());
item.GiaThang = decimal.Parse(rd["GiaThang"].ToString());
}
return item;
}
public UserInfo User_GetItem(int UserID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@UserID", UserID);
SqlDataReader rd = SQLDB.executereader("sp_User_GetItem", CommandType.StoredProcedure);
UserInfo item = null;
while (rd.Read())
{
item = new UserInfo();
item.UserID = int.Parse(rd["UserID"].ToString());
item.UserName = rd["UserName"].ToString();
item.FullName = rd["FullName"].ToString();
item.DisplayName = rd["DisplayName"].ToString();
item.IsActived = int.Parse(rd["IsActived"].ToString());
}
return item;
}
public Gio_PhongInfo Gio_Phong_GetItem(int Gio_PhongID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@Gio_PhongID", Gio_PhongID);
SqlDataReader rd = SQLDB.executereader("sp_Gio_Phong_GetItem", CommandType.StoredProcedure);
Gio_PhongInfo item = null;
while (rd.Read())
{
item = new Gio_PhongInfo();
item.Gio_PhongID = int.Parse(rd["Gio_PhongID"].ToString());
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.GioPhongName = rd["GioPhongName"].ToString();
item.PhanTram = int.Parse(rd["PhanTram"].ToString());
item.GiaTien = decimal.Parse(rd["GiaTien"].ToString());
item.status = rd["status"].ToString();
}
return item;
}
public PhieuNhapKhoInfo PhieuNhapKho_GetItem(int PhieuNhapKhoID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@PhieuNhapKhoID", PhieuNhapKhoID);
SqlDataReader rd = SQLDB.executereader("sp_PhieuNhapKho_GetItem", CommandType.StoredProcedure);
PhieuNhapKhoInfo item = null;
while (rd.Read())
{
item = new PhieuNhapKhoInfo();
item.PhieuNhapKhoID = int.Parse(rd["PhieuNhapKhoID"].ToString());
item.NgayNhap = rd["NgayNhap"].ToString();
item.ThangNhap = int.Parse(rd["ThangNhap"].ToString());
item.NamNhap = int.Parse(rd["NamNhap"].ToString());
item.NgayNhapSo = int.Parse(rd["NgayNhapSo"].ToString());
item.GhiChu = rd["GhiChu"].ToString();
}
return item;
}
public PhongInfo Phong_GetItem(int PhongID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@PhongID", PhongID);
SqlDataReader rd = SQLDB.executereader("sp_Phong_GetItem", CommandType.StoredProcedure);
PhongInfo item = null;
while (rd.Read())
{
item = new PhongInfo();
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.PhongName = rd["PhongName"].ToString();
item.LoaiPhongID = int.Parse(rd["LoaiPhongID"].ToString());
item.TienNghiID = int.Parse(rd["TienNghiID"].ToString());
item.SoGiuong = int.Parse(rd["SoGiuong"].ToString());
item.SoNguoi = int.Parse(rd["SoNguoi"].ToString());
item.TienNghiName = rd["TienNghiName"].ToString();
}
return item;
}
public List<Nguoi_PhongInfo> Nguoi_Phong_GetItemByPhongID(int PhongID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@PhongID", PhongID);
SqlDataReader rd = SQLDB.executereader("sp_Nguoi_Phong_GetItemByPhongID", CommandType.StoredProcedure);
List<Nguoi_PhongInfo> list = new List<Nguoi_PhongInfo>();
Nguoi_PhongInfo item = null;
while (rd.Read())
{
item = new Nguoi_PhongInfo();
item.Nguoi_PhongID = int.Parse(rd["Nguoi_PhongID"].ToString());
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.NguoiPhongName = rd["NguoiPhongName"].ToString();
item.CongThem = rd["CongThem"].ToString();
item.status = rd["Status"].ToString();
list.Add(item);
}
return list;
}
public List<ChiTietPhieuNhapKhoInfo> ChiTietPhieuNhapKho_GetItems([Optional, DefaultParameterValue(0)] int PhieuNhapKhoID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@PhieuNhapKhoID", PhieuNhapKhoID);
SqlDataReader rd = SQLDB.executereader("sp_ChiTietPhieuNhapKho_GetItems", CommandType.StoredProcedure);
List<ChiTietPhieuNhapKhoInfo> list = new List<ChiTietPhieuNhapKhoInfo>();
ChiTietPhieuNhapKhoInfo item = null;
while (rd.Read())
{
item = new ChiTietPhieuNhapKhoInfo();
item.ChiTietPhieuNhapID = int.Parse(rd["ChiTietPhieuNhapID"].ToString());
item.SoLuong = int.Parse(rd["SoLuong"].ToString());
item.DonGia = decimal.Parse(rd["DonGia"].ToString());
item.TongTien = decimal.Parse(rd["ThanhTien"].ToString());
item.DichVuID = int.Parse(rd["DichVuID"].ToString());
item.DichVuName = rd["DichVuName"].ToString();
list.Add(item);
}
return list;
}
public List<Gio_PhongInfo> Gio_Phong_GetItemByPhongID(int PhongID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@PhongID", PhongID);
SqlDataReader rd = SQLDB.executereader("sp_Gio_Phong_GetItemByPhongID", CommandType.StoredProcedure);
List<Gio_PhongInfo> list = new List<Gio_PhongInfo>();
Gio_PhongInfo item = null;
while (rd.Read())
{
item = new Gio_PhongInfo();
item.Gio_PhongID = int.Parse(rd["Gio_PhongID"].ToString());
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.GioPhongName = rd["GioPhongName"].ToString();
item.PhanTram = int.Parse(rd["PhanTram"].ToString());
item.GiaTien = decimal.Parse(rd["GiaTien"].ToString());
item.status = rd["status"].ToString();
list.Add(item);
}
return list;
}
public List<Phong_KhachHangInfo> Phong_KhachHang_GetItems(int HoaDonID, int PhongID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@HoaDonID", HoaDonID);
SQLDB.Addparameter("@PhongID", PhongID);
SqlDataReader rd = SQLDB.executereader("sp_Phong_KhachHang_GetItems", CommandType.StoredProcedure);
List<Phong_KhachHangInfo> list = new List<Phong_KhachHangInfo>();
Phong_KhachHangInfo item = null;
while (rd.Read())
{
item = new Phong_KhachHangInfo();
item.KhachHangID = int.Parse(rd["KhachHangID"].ToString());
item.HoTen = rd["HoTen"].ToString();
item.CMND = rd["CMND"].ToString();
item.HoaDonID = int.Parse(rd["HoaDonID"].ToString());
item.PhongID = int.Parse(rd["PhongID"].ToString());
list.Add(item);
}
return list;
}
public HoaDonDichVuInfo HoaDonDichVu_GetItem(int HoaDon_DichVuID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@HoaDon_DichVuID", HoaDon_DichVuID);
SqlDataReader rd = SQLDB.executereader("sp_HoaDonDichVu_GetItem", CommandType.StoredProcedure);
HoaDonDichVuInfo item = null;
while (rd.Read())
{
item = new HoaDonDichVuInfo();
item.HoaDon_DichVuID = int.Parse(rd["HoaDon_DichVuID"].ToString());
item.HoaDonID = int.Parse(rd["HoaDonID"].ToString());
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.DichVuID = int.Parse(rd["DichVuID"].ToString());
item.KhachHangID = int.Parse(rd["KhachHangID"].ToString());
item.NgaySuDung = rd["NgaySuDung"].ToString();
item.SoLuong = int.Parse(rd["SoLuong"].ToString());
item.DonGia = decimal.Parse(rd["DonGia"].ToString());
item.TongTien = decimal.Parse(rd["TongTien"].ToString());
}
return item;
}
public List<UserGroupInfo> UserGroup_GetItem(int UserID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@UserID", UserID);
SqlDataReader rd = SQLDB.executereader("sp_UserGroup_GetItem", CommandType.StoredProcedure);
List<UserGroupInfo> list = new List<UserGroupInfo>();
UserGroupInfo item = null;
while (rd.Read())
{
item = new UserGroupInfo();
item.UserGroupID = int.Parse(rd["UserGroupID"].ToString());
item.UserID = int.Parse(rd["UserID"].ToString());
item.GroupID = int.Parse(rd["GroupID"].ToString());
item.ExpiryDate = rd["ExpiryDate"].ToString();
item.EffectiveDate = rd["EffectiveDate"].ToString();
item.IsTrialUsed = int.Parse(rd["IsTrialUsed"].ToString());
list.Add(item);
}
return list;
}
public List<TKDoanhThuInfo> HoaDon_GetItems_DaThanhToan()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_HoaDon_GetItems_DaThanhToan", CommandType.StoredProcedure);
List<TKDoanhThuInfo> list = new List<TKDoanhThuInfo>();
TKDoanhThuInfo item = null;
while (rd.Read())
{
item = new TKDoanhThuInfo();
item.HoaDonID = int.Parse(rd["HoaDonID"].ToString());
item.NgayVao = rd["NgayVao"].ToString();
item.NgayRa = rd["NgayRa"].ToString();
item.DaThanhToan = int.Parse(rd["DaThanhToan"].ToString());
item.LoaiThue = int.Parse(rd["LoaiThue"].ToString());
item.Ca = int.Parse(rd["Ca"].ToString());
item.TongTien = decimal.Parse(rd["TongTien"].ToString());
list.Add(item);
}
return list;
}
public List<Gia_PhongInfo> Phong_GiaPhong()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_Phong_GiaPhong", CommandType.StoredProcedure);
List<Gia_PhongInfo> list = new List<Gia_PhongInfo>();
Gia_PhongInfo item = null;
string s = "";
while (rd.Read())
{
item = new Gia_PhongInfo();
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.PhongName = rd["PhongName"].ToString();
s = rd["GiaGio"].ToString();
item.GiaGio = rd["GiaGio"].ToString();
item.GiaNgay = decimal.Parse(rd["GiaNgay"].ToString());
item.GiaTuan = decimal.Parse(rd["GiaTuan"].ToString());
item.GiaThang = decimal.Parse(rd["GiaThang"].ToString());
list.Add(item);
}
return list;
}
public List<PhongInfo> Phong_GetItems([Optional,DefaultParameterValue(0)] int PhongID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@PhongID", PhongID);
SqlDataReader rd = SQLDB.executereader("sp_Phong_GetItems", CommandType.StoredProcedure);
List<PhongInfo> list = new List<PhongInfo>();
PhongInfo item = null;
while (rd.Read())
{
item = new PhongInfo();
item.PhongID = int.Parse(rd["PhongID"].ToString());
item.PhongName = rd["PhongName"].ToString();
item.LoaiPhongID = int.Parse(rd["LoaiPhongID"].ToString());
item.LoaiPhongName = rd["LoaiPhongName"].ToString();
item.SoGiuong = int.Parse(rd["SoGiuong"].ToString());
item.SoNguoi = int.Parse(rd["SoNguoi"].ToString());
item.TienNghiName = rd["TienNghiName"].ToString();
list.Add(item);
}
return list;
}
public List<PhieuNhapKhoInfo> PhieuNhapKho_GetItems()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_PhieuNhapKho_GetItems", CommandType.StoredProcedure);
List<PhieuNhapKhoInfo> list = new List<PhieuNhapKhoInfo>();
PhieuNhapKhoInfo item = null;
while (rd.Read())
{
item = new PhieuNhapKhoInfo();
item.PhieuNhapKhoID = int.Parse(rd["PhieuNhapKhoID"].ToString());
item.NgayNhap = rd["NgayNhap"].ToString();
item.GhiChu = rd["GhiChu"].ToString();
item.UserName = rd["UserName"].ToString();
if (!String.IsNullOrEmpty(rd["TongTien"].ToString()))
item.TongTien = decimal.Parse(rd["TongTien"].ToString());
else
item.TongTien = 0;
list.Add(item);
}
return list;
}
public List<ModuleInfo> Module_GetItems(int GroupID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@GroupID", GroupID);
SqlDataReader rd = SQLDB.executereader("dbo.sp_Modules_GetItems", CommandType.StoredProcedure);
List<ModuleInfo> list = new List<ModuleInfo>();
ModuleInfo item = null;
while (rd.Read())
{
item = new ModuleInfo();
item.ModuleID = int.Parse(rd["ModuleID"].ToString());
item.ModuleName = rd["ModuleName"].ToString();
item.ModuleKey = rd["ModuleKey"].ToString();
item.TabID = int.Parse(rd["TabID"].ToString());
item.TabName = rd["TabName"].ToString();
item.ViewOrder = int.Parse(rd["ViewOrder"].ToString());
item.IsView = int.Parse(rd["IsView"].ToString());
item.IsEdit = int.Parse(rd["IsEdit"].ToString());
list.Add(item);
}
return list;
}
public List<UserInfo> User_GetItems([Optional, DefaultParameterValue(0)] int UserID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@UserID", UserID);
SqlDataReader rd = SQLDB.executereader("sp_User_GetItems", CommandType.StoredProcedure);
List<UserInfo> list = new List<UserInfo>();
UserInfo item = null;
while (rd.Read())
{
item = new UserInfo();
item.UserID = int.Parse(rd["UserID"].ToString());
item.UserName = rd["UserName"].ToString();
item.FullName = rd["FullName"].ToString();
item.DisplayName = rd["DisplayName"].ToString();
item.IsActived = int.Parse(rd["IsActived"].ToString());
list.Add(item);
}
return list;
}
public PhieuNhapKhoInfo PhieuNhapKho_GetLatestItem()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_PhieuNhapKho_GetLatestItem", CommandType.StoredProcedure);
PhieuNhapKhoInfo item = null;
while (rd.Read())
{
item = new PhieuNhapKhoInfo();
item.PhieuNhapKhoID = int.Parse(rd["PhieuNhapKhoID"].ToString());
}
return item;
}
