public static List <ChucVu_DTO> HienThiDanhSachChucVu(int index) { List <ChucVu_DTO> lstChucVu = new List <ChucVu_DTO>(); try { string strTruyVan = string.Format("SELECT * FROM ChucVu"); DataTable _dt = new DataTable(); _dt = DataProvider.fillDataTable(strTruyVan); if (_dt != null) { for (index = 0; index < _dt.Rows.Count; index++) { ChucVu_DTO cvDTO = new ChucVu_DTO(); cvDTO.MaChucVu = _dt.Rows[index]["MaChucVu"].ToString(); cvDTO.TenChucVu = _dt.Rows[index]["TenChucVu"].ToString(); lstChucVu.Add(cvDTO); } } } catch (Exception ex) { XtraMessageBox.Show("Error : " + ex.Message); } return(lstChucVu); }
private void btnXoa_Click(object sender, EventArgs e) { ChucVu_DTO chucVu = new ChucVu_DTO(); if (txtmacv.Text.Equals("")) { MessageBox.Show("Mã chức vụ trống dữ liệu"); } else if (txtmacv.Text.Length > 5) { MessageBox.Show("Mã chức vụ không tồn tại"); } else { chucVu.Macv = txtmacv.Text; if (chucVu_BUL.deleteChucVu(chucVu)) { MessageBox.Show("Xóa thành công"); } else { MessageBox.Show("Xóa không thành công"); } } hienthi(); }
public ChucVu_DTO GetChucVuByMaCV(string maCV) { ChucVu_DTO chucvu = null; string query = "select * from ChucVu where MaCV=N'" + maCV + "'"; DataTable data = DataProvider.Instace.ExcuteQuey(query); foreach (DataRow item in data.Rows) { chucvu = new ChucVu_DTO(item); return(chucvu); } return(chucvu); }
public List <ChucVu_DTO> GetListChucVu() { List <ChucVu_DTO> listChucVu = new List <ChucVu_DTO>(); string query = "select * from ChucVu"; DataTable data = DataProvider.Instace.ExcuteQuey(query); foreach (DataRow item in data.Rows) { ChucVu_DTO chucvu = new ChucVu_DTO(item); listChucVu.Add(chucvu); } return(listChucVu); }
public List <ChucVu_DTO> HienThiDanhSachChucVu() //Lấy danh sách ChucVu { List <ChucVu_DTO> list = new List <ChucVu_DTO>(); string query = string.Format("Select * from tbl_ChucVu order by MaChucVu"); System.Data.DataTable data = DataProVider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { ChucVu_DTO dssp = new ChucVu_DTO(item); list.Add(dssp); } return(list); }
public List <ChucVu_DTO> TimKiemTheoTenChucVu(string TenChucVu) { List <ChucVu_DTO> list = new List <ChucVu_DTO>(); string query = string.Format("SELECT * FROM tbl_ChucVu WHERE dbo.TimKiem(ChucVu) LIKE N'%' + dbo.TimKiem(N'{0}') + '%'", TenChucVu); DataTable table = DataProVider.Instance.ExecuteQuery(query); foreach (DataRow item in table.Rows) { ChucVu_DTO TDV = new ChucVu_DTO(item); list.Add(TDV); } return(list); }
// private List <ChucVu_DTO> LoadDepartmentaData() { //SqlCommand reader = new SqlCommand("SELECT * From CHUCVU", con); SqlDataReader reader = new SqlCommand("SELECT * From CHUCVU", con); List <ChucVu_DTO> list = new List <ChucVu_DTO>(); con.Open(); reader.ExecuteReader(); while (reader.Read()) { ChucVu_DTO cvDTO = new ChucVu_DTO(); cvDTO.StrMaCV = reader.ToString(); cvDTO.StrTenCV = reader.ToString(); } }
private void txbMaNV_TextChanged(object sender, EventArgs e) { string maNV = txbMaNV.Text; if (maNV != (string)dgvThongTinNV.SelectedCells[0].OwningRow.Cells["Mã NV"].Value) { txbTenNV.Clear(); txbDiaChi.Clear(); txbSoDT.Clear(); txbUser.Clear(); txbDisplayName.Clear(); return; } if (dgvThongTinNV.SelectedCells.Count > 0) { string maCV = (string)dgvThongTinNV.SelectedCells[0].OwningRow.Cells["Chức Vụ"].Value; string trangThaiNV = (string)dgvThongTinNV.SelectedCells[0].OwningRow.Cells["Trạng Thái"].Value; if (trangThaiNV == "Đã Nghỉ Việc") { txbUser.Text = "Đã nghỉ việc"; txbDisplayName.Text = "Đã nghỉ việc"; return; } else { txbUser.Text = Account_DAO.Instance.GetAccountByMaNV(maNV).TenDangNhap; txbDisplayName.Text = Account_DAO.Instance.GetAccountByMaNV(maNV).TenHienThi; } ChucVu_DTO chucvu = ChucVu_DAO.Instance.GetChucVuByMaCV(maCV); comChucVu.SelectedItem = chucvu; int index = -1; int i = 0; if (maCV == null) { return; } foreach (ChucVu_DTO item in comChucVu.Items) { if (item.MaCV == chucvu.MaCV) { index = i; break; } i++; } comChucVu.SelectedIndex = index; } }
public static int ThemChucVu(ChucVu_DTO cvDTO) { int count = 0; try { string strTruyVan = string.Format("INSERT INTO ChucVu(MaChucVu,TenChucVu) VALUES('{0}',N'{1}')", cvDTO.MaChucVu, cvDTO.TenChucVu); count = DataProvider.ExecuteNonQuery(strTruyVan); } catch (Exception ex) { XtraMessageBox.Show("Error : " + ex.Message); } return(count); }
public static int CapNhatChucVu(ChucVu_DTO cvDTO) { int count = 0; try { string strTruyVan = string.Format("UPDATE ChucVu SET TenChucVu = N'{0}' WHERE MaChucVu = '{1}'", cvDTO.TenChucVu, cvDTO.MaChucVu); count = DataProvider.ExecuteNonQuery(strTruyVan); } catch (Exception ex) { XtraMessageBox.Show("Error : " + ex.Message); } return(count); }
private void btnThemChucVu_Click(object sender, EventArgs e) { ChucVu_DTO cvDTO = new ChucVu_DTO(); string errorS = ""; if (txtMaChucVu.Text.Trim() != "") { if (ChucVu_BLL.KiemTraMa(txtMaChucVu.Text) == 1) { errorS += "Mã chức vụ bị trùng!!!\n"; } else { cvDTO.MaChucVu = txtMaChucVu.Text; } } else { errorS += "Chưa nhập mã chức vụ!!\n"; } if (txtTenChucVu.Text.Trim() != "") { cvDTO.TenChucVu = txtTenChucVu.Text; } else { errorS += "Chưa nhập tên chức vụ!!\n"; } if (errorS != "") { XtraMessageBox.Show(errorS, "Thông báo lỗi"); return; } if (ChucVu_BLL.ThemChucVu(cvDTO) == 1) { lstChucVu.Add(cvDTO); HienThiLaiDuLieuTrenGridView(); XtraMessageBox.Show("Thêm 1 chức vụ thành công", "Thông báo"); } else { XtraMessageBox.Show("Thêm 1 chức vụ thất bại", "Thông báo"); return; } }
private void btnSua_Click(object sender, EventArgs e) { if (txtmacv.Text.Equals("")) { MessageBox.Show("Mã chức vụ trống dữ liệu"); } else if (txtmacv.Text.Length > 5) { MessageBox.Show("Mã chức vụ không dài quá 5 ký tự"); } else if (txttencv.Text.Equals("")) { MessageBox.Show("Tên chức vụ trống dữ liệu"); } else if (txttencv.Text.Length > 20) { MessageBox.Show("Tên chức vụ không dài quá 20 ký tự"); } else if (txthesopc.Text.Equals("")) { MessageBox.Show("Hệ số phụ cấp trống dữ liệu"); } else { try { ChucVu_DTO chucVu = new ChucVu_DTO(); chucVu.Macv = txtmacv.Text; chucVu.Tencv = txttencv.Text; chucVu.Hesopc = float.Parse(txthesopc.Text); if (chucVu_BUL.updateChucVu(chucVu)) { MessageBox.Show("Sửa thành công"); } else { MessageBox.Show("Sửa không thành công"); } } catch (FormatException) { MessageBox.Show("Hệ số phụ cấp sai định dạng"); } } hienthi(); }
private void frm_bcNhanVien_Load(object sender, EventArgs e) { //report viewer NhanVien_DTOBindingSource.DataSource = NhanVien_BUS.LayDSNhanVien(); this.reportViewer1.RefreshReport(); //combobox chức vụ List <ChucVu_DTO> lst = ChucVu_BUS.LayChucVu(); cboChucVu.DataSource = lst; ChucVu_DTO d = new ChucVu_DTO(); d.SMaCV = "TC"; d.STenCV = "Tất cả"; lst.Insert(0, d); cboChucVu.ValueMember = "SMaCV"; cboChucVu.DisplayMember = "STenCV"; }
public int themChucVu(ChucVu_DTO cv) { int check = kiemTraTonTai(cv.MaCV); if (check > 0) { return(0); } else { CHUCVU6 themcv = new CHUCVU6 { MACV = cv.MaCV, TENCV = cv.TenCV, HESOPC = cv.HeSoPhuCap }; db.CHUCVU6s.InsertOnSubmit(themcv); db.SubmitChanges(); return(1); } }
public Boolean deleteChucVu(ChucVu_DTO c) { String sql = "DELETE FROM chucvu WHERE macv = @macv"; try { SqlConnection conn = getConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@macv", c.Macv); cmd.ExecuteNonQuery(); return(true); } catch (SqlException) { } return(false); }
private void btnCapNhatChucVu_Click(object sender, EventArgs e) { btnCapNhatChucVu.Enabled = false; ChucVu_DTO cvDTO = new ChucVu_DTO(); cvDTO.MaChucVu = txtMaChucVu.Text; cvDTO.TenChucVu = txtTenChucVu.Text; if (ChucVu_BLL.CapNhatChucVu(cvDTO) == 1) { //ChucVu_DTO cvDTOUpdate = lstChucVu.Single(n => n.MaChucVu == cvDTO.MaChucVu); //cvDTOUpdate.MaChucVu = cvDTO.MaChucVu; //cvDTOUpdate.TenChucVu = cvDTO.TenChucVu; //HienThiLaiDuLieuTrenGridView(); HienThiDanhSachChucVu(pos); XtraMessageBox.Show("Cập nhật chức vụ thành công", "Thông báo"); } else { XtraMessageBox.Show("Cập nhật chức vụ thất bại", "Thông báo"); return; } }
public List <ChucVu_DTO> LoadDSChucVu() { List <ChucVu_DTO> lsChucVu = new List <ChucVu_DTO>(); SqlConnection conn = DataProvider.TaoKetNoi(); string strTruyVan = "SELECT * FROM ChucVu WHERE TrangThai = 1"; SqlDataReader reader = DataProvider.TruyVanDuLieu(strTruyVan, conn); while (reader.Read()) { ChucVu_DTO chucvu = new ChucVu_DTO() { MaCV = reader["MaCV"].ToString(), TenCV = reader["TenCV"].ToString(), TrangThai = int.Parse(reader["TrangThai"].ToString()) }; lsChucVu.Add(chucvu); } reader.Close(); conn.Close(); return(lsChucVu); }
public static List <ChucVu_DTO> LoadChucVu() { string strTruyVan = "SELECT * FROM CHUCVU"; con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.LayDataTable(strTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <ChucVu_DTO> listcv = new List <ChucVu_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { ChucVu_DTO cv = new ChucVu_DTO(); cv.StrMaCV = dt.Rows[i]["MA_CV"].ToString(); cv.StrTenCV = dt.Rows[i]["TEN_CV"].ToString(); listcv.Add(cv); } DataProvider.DongKetNoi(con); return(listcv); }
public Boolean insertChucVu(ChucVu_DTO c) { String sql = "INSERT INTO chucvu VALUES (@macv, @tencv, @hesopc)"; try { SqlConnection conn = getConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@macv", c.Macv); cmd.Parameters.AddWithValue("@tencv", c.Tencv); cmd.Parameters.AddWithValue("@hesopc", c.Hesopc); cmd.ExecuteNonQuery(); return(true); } catch (SqlException) { } return(false); }
public Boolean updateChucVu(ChucVu_DTO c) { String sql = "UPDATE chucvu SET tencv = @tencv, hesopc = @hesopc WHERE macv = @macv"; try { SqlConnection conn = getConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@tencv", c.Tencv); cmd.Parameters.AddWithValue("@hesopc", c.Hesopc); cmd.Parameters.AddWithValue("@macv", c.Macv); cmd.ExecuteNonQuery(); return(true); } catch (SqlException) { } return(false); }
public static List <ChucVu_DTO> LayChucVu() { string sTruyVan = "select * from chucvu"; con = DataProvider.MoKetNoi(); DataTable dt = DataProvider.TruyVanLayDuLieu(sTruyVan, con); if (dt.Rows.Count == 0) { return(null); } List <ChucVu_DTO> lstChucVu = new List <ChucVu_DTO>(); for (int i = 0; i < dt.Rows.Count; i++) { ChucVu_DTO cv = new ChucVu_DTO(); cv.SMaCV = dt.Rows[i]["macv"].ToString(); cv.STenCV = dt.Rows[i]["tencv"].ToString(); cv.FHSPhuCap = float.Parse(dt.Rows[i]["hsphucap"].ToString()); lstChucVu.Add(cv); } DataProvider.DongKetNoi(con); return(lstChucVu); }
public Boolean insertChucVu(ChucVu_DTO c) { return(cv.insertChucVu(c)); }
public Boolean updateChucVu(ChucVu_DTO c) { return(cv.updateChucVu(c)); }
public Boolean deleteChucVu(ChucVu_DTO c) { return(cv.deleteChucVu(c)); }
public int themChucVu_BUS(GunaTextBox txtMa, GunaTextBox txtTen, GunaTextBox hspc) { ChucVu_DTO cv = new ChucVu_DTO(txtMa.Text.ToUpper(), txtTen.Text.ToUpper(), Single.Parse(hspc.Text)); return(ChucVu_DAO.createInstance.themChucVu(cv)); }
public static int ThemChucVu(ChucVu_DTO cvDTO) => ChucVu_DAL.ThemChucVu(cvDTO);
public static int CapNhatChucVu(ChucVu_DTO cvDTO) => ChucVu_DAL.CapNhatChucVu(cvDTO);