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