private void user_comboBoxEx_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataTable userright_dt = sqlconnection.ExecuteDataTable(Constant.strConnectSQL_T, CommandType.Text, string.Format("select gageright from {0} where gageuser='******'", Constant.gage_user_sqlname, user_comboBoxEx.Text), null);
int right_value = Convert.ToInt32(userright_dt.Rows[0][0]);
byte[] byte_array = ByteTransferHelper.IntToByte(right_value);
bool[] bool_array = ByteTransferHelper.ByteToBit(byte_array[0]);
for (int i = 0; i < checked_control.Length; i++)
{
CheckBoxX ck = checked_control[i] as CheckBoxX;
ck.Checked = bool_array[i];
}
}
catch (Exception ex)
{
MessageBox.Show("combox索引发生变化时发生异常:" + ex.Message);
}
}
private void Modifyright_buttonX_Click(object sender, EventArgs e)
{
try
{
bool[] bool_array = new bool[8];
for (int i = 0; i < checked_control.Length; i++)
{
CheckBoxX ck = checked_control[i] as CheckBoxX;
bool_array[i] = ck.Checked;
}
int right_value = Convert.ToInt32(ByteTransferHelper.BitToByte(bool_array));
sqlconnection.ExecuteDataTable(Constant.strConnectSQL_T, CommandType.Text, string.Format("update {0} set gageright='{1}' where gageuser='******'", Constant.gage_user_sqlname, right_value, user_comboBoxEx.Text), null);
MessageBox.Show("修改完成!");
}
catch (Exception ex)
{
MessageBox.Show("修改用户权限时发生异常:" + ex.Message);
}
}
