/// <summary> /// 修改职位权限 /// </summary> /// <param name="pj"></param> /// <returns></returns> public int UpdatePositionJurisdiction(PositionJurisdictionModel pj) { string coAdims_str = "update adims_position_jurisdiction set position='" + pj.position + "' where id='" + pj.ID + "'"; return(dBConn.ExecuteNonQuery(coAdims_str)); }
public int AddPositionJurisdiction(PositionJurisdictionModel pj) { pj.jurisdiction = "0000000000000000000000000000"; string coAdims_str = "insert into adims_position_jurisdiction(position,jurisdiction) values('" + pj.position + "','" + pj.jurisdiction + "')"; return(dBConn.ExecuteNonQuery(coAdims_str)); }
private void button1_Click(object sender, EventArgs e) { PositionJurisdictionModel pj = new PositionJurisdictionModel(); pj.position = position_txt.Text; _UserDal.AddPositionJurisdiction(pj); pos_set = _UserDal.GetPositionJurisdictionAll(); dataGridView1.DataSource = pos_set.Tables[0]; }
private void button3_Click(object sender, EventArgs e) { if (dataGridView1.SelectedCells.Count == 0) { MessageBox.Show("请选择要删除的岗位", "警告"); return; } else if (MessageBox.Show("您真的要删除吗?", "警告", MessageBoxButtons.YesNo) == DialogResult.Yes) { int i = dataGridView1.SelectedCells[0].RowIndex; PositionJurisdictionModel pj = new PositionJurisdictionModel(); pj.ID = (int)dataGridView1.Rows[i].Cells[0].Value; _UserDal.DeletePositionJurisdiction(pj); _UserDal.DeleteUserByPosition(dataGridView1.Rows[i].Cells[1].Value.ToString()); pos_set = _UserDal.GetPositionJurisdictionAll(); dataGridView1.DataSource = pos_set.Tables[0]; } }
private void button2_Click(object sender, EventArgs e) { if (flag == 0) { int count = dataGridView1.SelectedCells.Count; i = dataGridView1.SelectedCells[count - 1].RowIndex; // dataGridView1.Rows[i].Cells[1].Value = null; List <cell_pos> mylist = new List <cell_pos>(); for (int j = 0; j < count; j++) { cell_pos mycell = new cell_pos(); mycell.row_index = dataGridView1.SelectedCells[j].RowIndex; mycell.col_index = dataGridView1.SelectedCells[j].ColumnIndex; mylist.Add(mycell); } for (int j = 0; j < count; j++) { dataGridView1.Rows[mylist[j].row_index].Cells[mylist[j].col_index].Selected = false; } dataGridView1.Rows[i].Cells[1].Selected = true; position_txt.Text = ""; position_txt.Focus(); button2.Text = "保存"; flag = 1; } else { PositionJurisdictionModel pj = new PositionJurisdictionModel(); pj.ID = (int)dataGridView1.Rows[i].Cells[0].Value; if (position_txt.Text == "") { MessageBox.Show("请填写职务名称", "警告"); return; } pj.position = position_txt.Text; _UserDal.UpdatePositionJurisdiction(pj); _UserDal.UpdateUserPosition(dataGridView1.Rows[i].Cells[1].Value.ToString(), position_txt.Text); button2.Text = "修改"; flag = 0; pos_set = _UserDal.GetPositionJurisdictionAll(); dataGridView1.DataSource = pos_set.Tables[0]; } }
/// <summary> /// 删除职位权限 /// </summary> /// <param name="pj"></param> /// <returns></returns> public int DeletePositionJurisdiction(PositionJurisdictionModel pj) { string coAdims_str = "delete from adims_position_jurisdiction where id='" + pj.ID + "'"; return(dBConn.ExecuteNonQuery(coAdims_str)); }