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