/// <summary> /// 获取用户所属科室角色信息 /// </summary> /// <param name="userId"></param> /// <returns></returns> public List <UserReleationData> GetUserDepartmentRoleInfos(string userId) { SQL sql = new SQL("获取用户所属科室角色信息", "select 用户关联ID, 用户ID, 科室ID, 角色ID from 影像用户关联 where 用户Id=:用户ID"); sql.AddParameter("用户ID", DbType.String, userId); DataTable dtReleation = _dbHelper.ExecuteSQL(sql); if (dtReleation == null || dtReleation.Rows.Count <= 0) { return(null); } List <UserReleationData> urds = new List <UserReleationData>(); foreach (DataRow dr in dtReleation.Rows) { UserReleationData urd = new UserReleationData(); urd.BindRowData(dr); urds.Add(urd); } return(urds); }
public UserReleationData GetSelectUserReleation() { if (dataGridView1.SelectedRows.Count <= 0) { return(null); } DataGridViewRow dvr = dataGridView1.SelectedRows[0]; string userID = dvr.Cells["用户ID"].Value.ToString(); DataRow[] drs = (dataGridView1.DataSource as DataTable).Select("用户ID='" + userID + "'"); if (drs.Length > 0) { UserReleationData userReleation = new UserReleationData(); userReleation.BindRowData(drs[0]); return(userReleation); } return(null); }
private void SyncSelRowData() { try { ClearData(); if (dataGridView1.DataSource == null) { return; } if (dataGridView1.SelectedRows.Count <= 0) { return; } DataGridViewRow dvr = dataGridView1.SelectedRows[0]; string userID = dvr.Cells["用户ID"].Value.ToString(); DataRow[] drs = (dataGridView1.DataSource as DataTable).Select("用户ID='" + userID + "'"); if (drs.Length > 0) { UserInfoData userData = new UserInfoData(); userData.BindRowData(drs[0]); UserReleationData userReleation = new UserReleationData(); userReleation.BindRowData(drs[0]); txtAccountName.Text = userData.系统账号; txtAccountName.Tag = userData.用户ID; txtUserName.Text = userData.用户名称; cbxLevel.SelectedIndex = userData.职称级别; if (userData.账号信息 != null) { txtPwd.Text = UserModel.DecryPwd(userData.账号信息.密码); txtSurePwd.Text = txtPwd.Text; rtbAccountDescription.Text = userData.账号信息.备注; chkStopUse.Checked = userData.账号信息.是否停用; } if (string.IsNullOrEmpty(userReleation.角色ID) == false) { cbxRoleGroup.Text = drs[0]["角色名称"].ToString();// cbxRoleGroup.Items.IndexOf(userReleation.角色ID); } picSignImage.Image = userData.签名图片; //显示人员信息 if (userData.人员信息 != null) { txtName.Text = userData.人员信息.人员姓名; cbxSex.Text = userData.人员信息.人员性别; dtpBirth.Value = userData.人员信息.出生日期; txtCardNo.Text = userData.人员信息.身份证号; txtOfficePhone.Text = userData.人员信息.办公电话; txtTelePhone.Text = userData.人员信息.联系电话; txtAddress.Text = userData.人员信息.联系地址; txtEmail.Text = userData.人员信息.电子邮件; rtbUserDescription.Text = userData.人员信息.备注; } picUserPhoto.Image = userData.人员照片; } } catch (Exception ex) { MsgBox.ShowException(ex, this); } }