public bool CapNhat(NhanVien obj)
{
string strsql = "update NhanVien set TenNhanVien = @TenNhanVien, GioiTinh = @GioiTinh,DiaChi = @DiaChi,NgaySinh= @NgaySinh, SoDT= @SoDT , ChucVu = @ChucVu, TaiKhoan = @TaiKhoan where MaNV = @MaNV";
SqlParameter[] pars = new SqlParameter[9];
pars[0] = new SqlParameter("@MaNV", SqlDbType.NChar, 5);
pars[0].Value = obj.MaNV;
pars[1] = new SqlParameter("@TenNhanVien", SqlDbType.NChar, 30);
pars[1].Value = obj.TenNhanVien;
pars[2] = new SqlParameter("GioiTinh", SqlDbType.NChar, 4);
pars[2].Value = obj.GioiTinh;
pars[3] = new SqlParameter("DiaChi", SqlDbType.NChar, 30);
pars[3].Value = obj.DiaChi;
pars[4] = new SqlParameter("NgaySinh", SqlDbType.DateTime);
pars[4].Value = obj.NgaySinh;
pars[5] = new SqlParameter("SoDT", SqlDbType.NChar, 10);
pars[5].Value = obj.SDT;
pars[6] = new SqlParameter("ChucVu", SqlDbType.NChar, 10);
pars[6].Value = obj.ChucVu;
pars[7] = new SqlParameter("TaiKhoan", SqlDbType.NChar, 50);
pars[7].Value = obj.TaiKhoan;
pars[8] = new SqlParameter("MatKhau", SqlDbType.NChar, 50);
pars[8].Value = obj.MatKhau;
return(ConnectSQL.ThucHien(strsql, pars));
}
public bool Xoa(string MaNV)
{
//Lay manv
string strDel = "delete from NhanVien where MaNV = '" + MaNV + "'";
return(ConnectSQL.ThucHien(strDel));
}
public bool ThemMoi(NhanVien objNV)
{
string sqlstr = "insert into NhanVien(MaNV, TenNhanVien, GioiTinh, DiaChi, NgaySinh, SoDT, ChucVu, TaiKhoan, MatKhau) values (@MaNV, @TenNhanVien,@GioiTinh,@DiaChi,@NgaySinh,@SoDT,@ChucVu,@TaiKhoan,@MatKhau)";
SqlParameter[] pars = new SqlParameter[9];
pars[0] = new SqlParameter("@MaNV", SqlDbType.NChar, 5);
pars[0].Value = objNV.MaNV;
pars[1] = new SqlParameter("@TenNhanVien", SqlDbType.NChar, 30);
pars[1].Value = objNV.TenNhanVien;
pars[2] = new SqlParameter("@GioiTinh", SqlDbType.NChar, 4);
pars[2].Value = objNV.GioiTinh;
pars[3] = new SqlParameter("@DiaChi", SqlDbType.NChar, 30);
pars[3].Value = objNV.DiaChi;
pars[4] = new SqlParameter("@NgaySinh", SqlDbType.DateTime);
pars[4].Value = objNV.NgaySinh;
pars[5] = new SqlParameter("@SoDT", SqlDbType.NChar, 10);
pars[5].Value = objNV.SDT;
pars[6] = new SqlParameter("@ChucVu", SqlDbType.NChar, 10);
pars[6].Value = objNV.ChucVu;
pars[7] = new SqlParameter("@TaiKhoan", SqlDbType.NChar, 50);
pars[7].Value = objNV.TaiKhoan;
pars[8] = new SqlParameter("@MatKhau", SqlDbType.NChar, 50);
pars[8].Value = objNV.MatKhau;
return(ConnectSQL.ThucHien(sqlstr, pars));
}
private DataTable GetMaNV(string tk, string mk)
{
string sqlstr = "select * from NhanVien where TaiKhoan = N'" + tk + "' and MatKhau = N'" + mk + "'";
DataTable kq = ConnectSQL.GetData(sqlstr);
return(kq);
}
private bool Login(string tk, string mk)
{
string sqlstr = "select * from NhanVien where TaiKhoan = N'" + tk + "' and MatKhau = N'" + mk + "'";
DataTable kq = ConnectSQL.GetData(sqlstr);
return(kq.Rows.Count > 0);
}
public DataTable TimKiemNhanVien(string tukhoa)
{
//Dùng winform
/*
* string strsql = "select MaNV, TenNhanVien, ChucVu,SoDT,DiaChi,NgaySinh from NhanVien where 1=1";
* //Nếu tên có thông tin thì lọc
* if(!string.IsNullOrWhiteSpace(tukhoa))
* {
* strsql += string.Format(" and (MaNV = '{0}' or TenNhanVien like N'%{1}%')",tukhoa,tukhoa);
* }*/
//Sử dụng thủ tục
string strsql = "execute sp_timkiem N'" + tukhoa + "'";
return(ConnectSQL.GetData(strsql));
}
public bool CapNhat(MayBay objMB)
{
string sqlstr = "Update MayBay set MaMayBay = @MaMayBay, TenMayBay = @TenMayBay, HangSanXuat = @HangSanXuat, SoLuongGhe1 = @SoLuongGhe1, SoLuongGhe2 = @SoLuongGhe2 where MaMayBay = @MaMayBay ";
SqlParameter[] pars = new SqlParameter[5];
pars[0] = new SqlParameter("@MaMayBay", SqlDbType.NChar, 5);
pars[0].Value = objMB.MaMayBay;
pars[1] = new SqlParameter("@TenMayBay", SqlDbType.NChar, 30);
pars[1].Value = objMB.TenMayBay;
pars[2] = new SqlParameter("@HangSanXuat", SqlDbType.NChar, 30);
pars[2].Value = objMB.HangSanXuat;
pars[3] = new SqlParameter("@SoLuongGhe1", SqlDbType.Int);
pars[3].Value = objMB.SoLuongGhe1;
pars[4] = new SqlParameter("@SoLuongGhe2", SqlDbType.Int);
pars[4].Value = objMB.SoLuongGhe2;
return(ConnectSQL.ThucHien(sqlstr, pars));
}
public bool ThemMoi(MayBay objMB)
{
string sqlstr = "insert into MayBay(MaMayBay, TenMayBay, HangSanXuat, SoLuongGhe1, SoLuongGhe2) values (@MaMayBay, @TenMayBay, @HangSanXuat, @SoLuongGhe1, @SoLuongGhe2)";
SqlParameter[] pars = new SqlParameter[5];
pars[0] = new SqlParameter("@MaMayBay", SqlDbType.NChar, 5);
pars[0].Value = objMB.MaMayBay;
pars[1] = new SqlParameter("@TenMayBay", SqlDbType.NChar, 30);
pars[1].Value = objMB.TenMayBay;
pars[2] = new SqlParameter("@HangSanXuat", SqlDbType.NChar, 30);
pars[2].Value = objMB.HangSanXuat;
pars[3] = new SqlParameter("@SoLuongGhe1", SqlDbType.Int);
pars[3].Value = objMB.SoLuongGhe1;
pars[4] = new SqlParameter("@SoLuongGhe2", SqlDbType.Int);
pars[4].Value = objMB.SoLuongGhe2;
return(ConnectSQL.ThucHien(sqlstr, pars));
}
public bool Xoa(string MaMB)
{
string sqlstr = "delete from MayBay where MaMayBay = '" + MaMB + "'";
return(ConnectSQL.ThucHien(sqlstr));
}
public DataTable GetDataMayBay()
{
string sqlstr = "select * from MayBay";
return(ConnectSQL.GetData(sqlstr));
}
public DataTable ChiTietTheoMa(string manv)
{
return(ConnectSQL.GetData("select MaNV, TenNhanVien,GioiTinh, ChucVu,SoDT,DiaChi,NgaySinh,TaiKhoan from NhanVien where MaNV = '" + manv + "'"));
}
public DataTable GetDataNV()
{
string strsql = "select MaNV, TenNhanVien,GioiTinh, ChucVu,SoDT,DiaChi,NgaySinh from NhanVien";
return(ConnectSQL.GetData(strsql));
}
