/// <summary>
/// 保存权限事件(授权事件)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_saveRights_Click(object sender, EventArgs e)
{
try
{
DataRow userRow = gridView_user.GetDataRow(gridView_user.FocusedRowHandle);
if (null == userRow)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("请选择一条员工记录");
return;
}
if (checkedList.Count == 0)
{
//if (Common.Ctrs.DLG.MessageBox.Show("您没有勾选组合权限，确定要保存吗？", "提示", Common.Ctrs.DLG.MyMessageBoxButtons.OkCancel) == DialogResult.Cancel)
//{
// return;
//}
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("请选择要对应的病种组合");
return;
}
else
{
string focusedUserID = userRow["USERID"].ToString().Trim();
DataTable rightDt = DS_SqlService.GetUserMatchDiseaseGroup(focusedUserID);
//设置参数
List <DbParameter> parameters = new List <DbParameter>();
SqlParameter param1 = new SqlParameter("@groupids", SqlDbType.Char);
param1.Value = string.Join("$", checkedList.Select(p => p["ID"].ToString()).ToArray());
parameters.Add(param1);
int result = 0;
if (null == rightDt || rightDt.Rows.Count == 0)
{//新增权限
SqlParameter param2 = new SqlParameter("@userid", SqlDbType.Char);
param2.Value = focusedUserID;
parameters.Add(param2);
SqlParameter param3 = new SqlParameter("@username", SqlDbType.Char);
param3.Value = userRow["USERNAME"].ToString().Trim();
parameters.Add(param3);
SqlParameter param4 = new SqlParameter("@valid", SqlDbType.Int);
param4.Value = 1;
parameters.Add(param4);
SqlParameter param5 = new SqlParameter("@create_user", SqlDbType.Char);
param5.Value = DS_Common.currentUser.Id;
parameters.Add(param5);
SqlParameter param6 = new SqlParameter("@create_time", SqlDbType.Char);
param6.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
parameters.Add(param6);
result = DS_SqlService.InsertUserMatchDiseaseGroup(parameters);
}
else
{//编辑权限
SqlParameter param7 = new SqlParameter("@updateuser", SqlDbType.Char);
param7.Value = DS_Common.currentUser.Id;
parameters.Add(param7);
SqlParameter param8 = new SqlParameter("@updatetime", SqlDbType.Char);
param8.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
parameters.Add(param8);
SqlParameter param9 = new SqlParameter("@id", SqlDbType.Int);
param9.Value = int.Parse(rightDt.Rows[0]["ID"].ToString());
parameters.Add(param9);
result = DS_SqlService.UpdateUserMatchDiseaseGroup(parameters);
}
if (result == 1)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("授权成功");
}
}
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(1, ex);
}
}
