public string XoaNhanVien(string manv) { string kq = "false"; try { string str = "XoaNhanVien"; SqlConnection con = new SqlConnection(ConnectDATA.getconnect()); con.Open(); SqlCommand cmd = new SqlCommand(str, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@manv", manv); cmd.Parameters["@manv"].Direction = ParameterDirection.Input; SqlParameter para = new SqlParameter("@kq", SqlDbType.Int); para.Direction = ParameterDirection.Output; cmd.Parameters.Add(para); cmd.ExecuteNonQuery(); kq = para.Value.ToString(); con.Close(); cmd.Dispose(); } catch (Exception er) { MessageBox.Show(er.Message); } return(kq); }
public string SuaNhanVien(string manv, string tennv, string ngaysinh, string gioitinh, string quequan, string luong, string macv, string mapb) { string str = "SuaNhanVien"; SqlConnection con = new SqlConnection(ConnectDATA.getconnect()); con.Open(); SqlCommand cmd = new SqlCommand(str, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@manv", manv); cmd.Parameters.AddWithValue("@ten", tennv); cmd.Parameters.AddWithValue("@ns", Convert.ToDateTime(ngaysinh)); cmd.Parameters.AddWithValue("@gt", gioitinh); cmd.Parameters.AddWithValue("@qq", quequan); cmd.Parameters.AddWithValue("@l", luong); cmd.Parameters.AddWithValue("@macv", macv); cmd.Parameters.AddWithValue("@mapb", mapb); SqlParameter para = new SqlParameter("@kq", SqlDbType.Int); para.Direction = ParameterDirection.Output; cmd.Parameters.Add(para); cmd.ExecuteNonQuery(); string kq = para.Value.ToString(); cmd.Dispose(); con.Close(); return(kq); }
public DataTable ShowMaNV() { string str = @"select MaNV as ma from tblNhanVien"; SqlConnection con = new SqlConnection(ConnectDATA.getconnect()); SqlDataAdapter ad = new SqlDataAdapter(str, con); DataTable dt = new DataTable(); ad.Fill(dt); return(dt); }
public DataTable ShowPhongBan() { string str = @"select MaPB as [Mã Phòng Ban] from tblPhongBan"; SqlConnection con = new SqlConnection(ConnectDATA.getconnect()); SqlDataAdapter ad = new SqlDataAdapter(str, con); DataTable dt = new DataTable(); ad.Fill(dt); return(dt); }
public DataTable ShowChucVu() { string str = @"select MaCV as [Mã Chức Vụ] from tblChucVu"; SqlConnection con = new SqlConnection(ConnectDATA.getconnect()); SqlDataAdapter ad = new SqlDataAdapter(str, con); DataTable dt = new DataTable(); ad.Fill(dt); return(dt); }
private void connect() { try { con = new SqlConnection(ConnectDATA.getconnect()); con.Open(); } catch (Exception) { MessageBox.Show("Không thể kết nối cơ sở dữ liệu"); } }
public DataTable ShowNhanVien() { string str = @"select MaNV as [Mã Nhân Viên],TenNV as [Tên Nhân Viên],NgaySinh as [Ngày Sinh], GioiTinh as [Giới tính],QueQuan as [Quê Quán],Luong as [Lương],MaCV as [Mã Chức Vụ], MaPB as [Mã Phòng Ban] from tblNhanVien"; SqlConnection con = new SqlConnection(ConnectDATA.getconnect()); SqlDataAdapter ad = new SqlDataAdapter(str, con); DataTable dt = new DataTable(); ad.Fill(dt); return(dt); }
public DataTable TimKiem(string manv, string tennv, string macv, int chose) { string str = "TimKiemNhanVien"; SqlConnection con = new SqlConnection(ConnectDATA.getconnect()); con.Open(); SqlCommand cmd = new SqlCommand(str, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@manv", manv); cmd.Parameters["@manv"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("@ten", tennv); cmd.Parameters["@ten"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("@macv", macv); cmd.Parameters["@macv"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("@chose", chose); cmd.Parameters["@chose"].Direction = ParameterDirection.Input; SqlDataAdapter ad = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); ad.Fill(dt); return(dt); }