public bool XoaCTXuat(CTXuatNL ct) { string[] param = { "@MaPX", "@MaNL" }; object[] values = { ct.MaPhieuXuat, ct.MaNL }; string query = "Delete from tblCTXuatNL where MaPhieuXuat=@MaPX and MaNL=@MaNL"; return(db.ExecuteNonQueryPara(query, param, values)); }
public bool SuaCTXuat(CTXuatNL ct) { string[] param = { "@MaPX", "@MaNL", "@SoLuong" }; object[] values = { ct.MaPhieuXuat, ct.MaNL, ct.SoLuong }; string query = "Update tblCTXuatNL set SoLuong=@SoLuong where MaPhieuXuat=@MaPX and MaNL=@MaNL"; return(db.ExecuteNonQueryPara(query, param, values)); }
public bool ThemCTXuat(CTXuatNL ct) { string[] param = { "@MaPX", "@MaNL", "@TenNL", "@SoLuong", "@DonViTinh" }; object[] values = { ct.MaPhieuXuat, ct.MaNL, ct.TenNL, ct.SoLuong, ct.DonViTinh }; string query = "Insert into tblCTXuatNL(MaPhieuXuat,MaNL,TenNL,SoLuong,DonViTinh) values (@MaPX,@MaNL,@TenNL,@SoLuong,@DonViTinh)"; return(db.ExecuteNonQueryPara(query, param, values)); }
public bool XoaCTXuat(CTXuatNL ct) { return(dalctx.XoaCTXuat(ct)); }
public bool SuaCTXuat(CTXuatNL ct) { return(dalctx.SuaCTXuat(ct)); }
public bool ThemCTXuat(CTXuatNL ct) { return(dalctx.ThemCTXuat(ct)); }