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