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