public DataTable DocBanAn_CommitTran(int maNH, string khuvuc, string succhua) { //Provider provider = new Provider(); DataTable tb = new DataTable(); string sql = "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 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; // sql += " and b.maban not in(select MaBan from DatBan where MaNH="+ maNH+" and ThoiGianDen=CONVERT(nvarchar,GETDATE(),101) and TrangThai=0)"; sql += " commit tran"; provider.cm = provider.CreateCommandStringSql(sql); return(provider.ExecSelectCommand_CloseConnection(provider.cm)); }
public static DataTable DocLoaiNhanVien_commit() { Provider provider = new Provider(); string sql = "select MaLoai,TenLoai from LoaiNV commit tran"; SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecSelectCommand_CloseConnection(cm); }
public DataTable DocLoaiNhanVien_commit() { // Provider provider = new Provider(); string sql = "select MaLoai,TenLoai from LoaiNV commit tran"; provider.cm = provider.CreateCommandStringSql(sql); return(provider.ExecSelectCommand_CloseConnection(provider.cm)); }