public int updatePhongBan(PhongBan_DTO pb) { String sql = "update PhongBan set tenpb=@TenPB,ngaytl=@NgayTL where mapb=@MaPB"; try { SqlConnection conn = getConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@MaPB", pb.MaPB); cmd.Parameters.AddWithValue("@TenPB", pb.TenPB); cmd.Parameters.AddWithValue("@NgayTL", pb.NgayTL); cmd.ExecuteNonQuery(); return(1); } catch (SqlException e) { //MessageBox.Show(e.Message);\ //return 0; } return(0); }
public int insertPhongBan(PhongBan_DTO pb) { String sql = "insert into PhongBan values(@MaPB,@TenPB,@NgayTL)"; try { SqlConnection conn = getConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@MaPB", pb.MaPB); cmd.Parameters.AddWithValue("@TenPB", pb.TenPB); cmd.Parameters.AddWithValue("@NgayTL", pb.NgayTL); cmd.ExecuteNonQuery(); return(1); } catch (SqlException e) { //MessageBox.Show(e.Message); //return 0; } return(0); }
private void btnTimKiem_Click(object sender, EventArgs e) { PhongBan_DTO pb = new PhongBan_DTO(); pb.MaPB = txtMaPB.Text; pb.TenPB = txtTenPB.Text; pb.NgayTL = dtpNgayTL.Text; DataTable dt = phongBan_BUL.findPhongBan(pb); dtgPhongBan.DataSource = dt; }
public DataTable findPhongBan(PhongBan_DTO pb) { String sql = "select * from PHONGBAN where 1=1 and mapb like '%" + pb.MaPB + "%' and tenpb like '%" + pb.TenPB + "%'"; SqlConnection conn = getConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(sql, conn); SqlDataReader reader = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); return(dt); }
private void btnSua_Click(object sender, EventArgs e) { if (txtMaPB.Text.Equals("") || txtTenPB.Text.Equals("")) { MessageBox.Show("Phải điền đủ thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { PhongBan_DTO pb = new PhongBan_DTO(); pb.MaPB = txtMaPB.Text; pb.TenPB = txtTenPB.Text; pb.NgayTL = dtpNgayTL.Text; int kq = phongBan_BUL.updatePhongBan(pb); if (kq == 1) { MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (kq == 0) { MessageBox.Show("Sửa thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } HienThi(); }
public DataTable findPhongBan(PhongBan_DTO pb) { return(phongBan_DAL.findPhongBan(pb)); }
public int updatePhongBan(PhongBan_DTO pb) { return(phongBan_DAL.updatePhongBan(pb)); }
public int insertPhongBan(PhongBan_DTO pb) { return(phongBan_DAL.insertPhongBan(pb)); }