public DataTable DocLoaiNhanVien_begin()
{
//Provider provider = new Provider();
string sql = "begin tran";
sql += " select MaLoai,TenLoai from LoaiNV";
provider.cm = provider.CreateCommandStringSql(sql);
return(provider.ExecSelectCommand_OpenConnection(provider.cm));
}
public DataTable DocBanAn_BeginTran(int maNH, string khuvuc, string succhua)
{
//Provider provider = new Provider();
DataTable tb = new DataTable();
string sql = "SET TRANSACTION ISOLATION LEVEL repeatable read begin tran select b.MaBan,k.TenKhuVuc,k.ViTri,lb.SucChua,b.TrangThai,nh.TenNH";
sql += " from BanAn b,KhuVuc k,NhaHang n,LoaiBan lb,NhaHang nh";
sql += " where b.MaKhuVuc=k.MaKhuVuc and b.LoaiBan=lb.MaLoai and nh.MaNH=n.MaNH and n.MaNH=" + maNH + khuvuc + succhua;
provider.cm = provider.CreateCommandStringSql(sql);
return(provider.ExecSelectCommand_OpenConnection(provider.cm));
}