protected void ChucVuGridView_RowCommand(object sender, GridViewCommandEventArgs e) { //nếu bấm nút xóa ==>xóa ngay if (e.CommandName == "xoa") { string macv = (e.CommandArgument).ToString(); if (chucvuBUS.XoaChucVu(macv) == true) { chucvuBUS.XoaChucVu(macv); NapDuLieu(); } else { ThongBaoPopup.Show(); } } //nếu bấm nút sửa ==>bật popup sửa else if (e.CommandName == "sua") { //lấy danh sach ChucVu ChucVuCollection cvColl = new ChucVuCollection(); cvColl = chucvuBUS.TimDSChucVu(TimTextbox.Text); //Lấy index dòng đang chọn int index = Convert.ToInt32(e.CommandArgument.ToString()); ViewState["macv"] = cvColl.Index(index).MaCV; string tencv = cvColl.Index(index).TenCV; SuaPopup.Show(); SuaTextBox.Text = tencv; } }
public ChucVuCollection TimDSChucVu(string tencv) { ChucVuCollection cvColl = new ChucVuCollection(); SqlConnection cnn = new SqlConnection(cnnstr); string query = "select * from ChucVu where tencv <> '' "; query += "order by tencv"; SqlCommand cmd = new SqlCommand(query, cnn); if (tencv != "") { query = "select * from ChucVu where tencv like @tencv and tencv <>''"; query += "order by tencv"; cmd = new SqlCommand(query, cnn); cmd.Parameters.AddWithValue("@tencv", "%" + tencv + "%"); } cnn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ChucVuBO cvBO = new ChucVuBO(); cvBO.MaCV = dr["macv"].ToString(); cvBO.TenCV = dr["tencv"].ToString(); cvColl.Add(cvBO); } cnn.Close(); return cvColl; }