public static int DeleteSanPham(SanPhamObjTr ctd) { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@masp", ctd.MaSP) }; return(ConnectToSQLTr.ExecuteNonQuery("XoaSanPham", para)); }
public static int UpdateSanPham(SanPhamObjTr ctd) { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@masp", ctd.MaSP), new SqlParameter("@tensp", ctd.TenSP), new SqlParameter("@hangsx", ctd.HangSX), new SqlParameter("@dvt ", ctd.DVT), new SqlParameter("@gianhap ", ctd.GiaNhap), new SqlParameter("@giaban", ctd.GiaBan), new SqlParameter("@soluong ", ctd.SoLuong), new SqlParameter("@maquay", ctd.MaQuay) }; return(ConnectToSQLTr.ExecuteNonQuery("SuaSanPham", para)); }
public static DataTable GetListSanPham() { return(ConnectToSQLTr.GetData(" select MaSp,TenSP,HangSX,DVT,GiaNhap,GiaBan,SoLuong,TenQuay from SanPham ,QuayHang where SanPham.MaQuay=QuayHang.MaQuay ")); }
public static DataTable GetListQuayHang() { return(ConnectToSQLTr.GetData(" select * from QuayHang ")); }