/// <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));
}
