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