public bool SuaCTDoanhThu(CTDoanhThu ct) { string[] param = { "@Ngay", "@MaMon", "SoLuongBan", "TongTien" }; object[] values = { ct.Ngay, ct.MaMon, ct.SoLuong, ct.TongTien }; string query = "Update tblCTDoanhThu set SoLuongBan=@SoLuongBan,TongTien=@TongTien where Ngay=@Ngay and MaMon=@MaMon"; return(db.ExecuteNonQueryPara(query, param, values)); }
public bool ThemCTDoanhThu(CTDoanhThu ct) { string[] param = { "@Ngay", "@MaMon", "SoLuongBan", "TongTien" }; object[] values = { ct.Ngay, ct.MaMon, ct.SoLuong, ct.TongTien }; string query = "Insert into tblCTDoanhThu(Ngay,MaMon,SoLuongBan,TongTien) values(@Ngay,@MaMon,@SoLuongBan,@TongTien)"; return(db.ExecuteNonQueryPara(query, param, values)); }
public bool ThemCTDoanhThu(CTDoanhThu ct) { return(ctdoanhthu.ThemCTDoanhThu(ct)); }
public bool SuaCTDoanhThu(CTDoanhThu ct) { return(ctdoanhthu.SuaCTDoanhThu(ct)); }