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