public KhachHang getby_tk_khachhang(string _tentaikhoan, ref string errMsg)
{
try
{
string sqlstr = "select * from khachhang where tendangnhap like N'" + _tentaikhoan + "'";
IDataReader dr = SQLExecute.getIDataReader(sqlstr, ref errMsg);
KhachHang obj = new KhachHang();
obj = (KhachHang)CBO.FillObject(dr, typeof(KhachHang));
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public SanPham getby_sanpham_ID(string _ma_sp, ref string errMsg)
{
try
{
string sqlstr = "select * from [dbo].[SanPham] where [MaSP] like N'" + _ma_sp + "'";
IDataReader dr = SQLExecute.getIDataReader(sqlstr, ref errMsg);
SanPham obj = new SanPham();
obj = (SanPham)CBO.FillObject(dr, typeof(SanPham));
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public SanPham_Size getby_sanpham_size(int _masp, int _ma_size, ref string errMsg)
{
try
{
string sqlstr = "select * from SanPham_Size where MaSize = " + _ma_size + "and MaSP =" + _masp;
IDataReader dr = SQLExecute.getIDataReader(sqlstr, ref errMsg);
SanPham_Size obj = new SanPham_Size();
obj = (SanPham_Size)CBO.FillObject(dr, typeof(SanPham_Size));
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public hoadon getby_hoadon(string _mahodon, ref string errMsg)
{
try
{
string sqlstr = "select * from hoadon where mahoadon like N'" + _mahodon + "'";
IDataReader dr = SQLExecute.getIDataReader(sqlstr, ref errMsg);
hoadon obj = new hoadon();
obj = (hoadon)CBO.FillObject(dr, typeof(hoadon));
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public Entities.SanPham getby_sanpham(string _masanpham, ref string errMsg)
{
try
{
string sqlstr = "select * from sanpham where MaSP like N'" + _masanpham + "'";
IDataReader dr = SQLExecute.getIDataReader(sqlstr, ref errMsg);
Entities.SanPham obj = new Entities.SanPham();
obj = (Entities.SanPham)CBO.FillObject(dr, typeof(Entities.SanPham));
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public Size getby_size_ID(string _ma_size, ref string errMsg)
{
try
{
string sqlstr = "select * from Size where MaSize like N'" + _ma_size + "'";
IDataReader dr = SQLExecute.getIDataReader(sqlstr, ref errMsg);
Size obj = new Size();
obj = (Size)CBO.FillObject(dr, typeof(Size));
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
