public void DataBind(aers_tbl_staff data = null) { if (data == null) { staff = new aers_tbl_staff(); state = FormState.Add; } else { staff = data; state = FormState.Modify; txt_Name.Text = data.Name; txt_RoleState.SelectedValue = data.RoleState.ToString(); txt_Sex.SelectedText = data.Sex; txt_Phone.Text = data.Phone; txt_StaffRemarks.Text = data.Remarks; aers_tbl_hospdep hospdep = dalhospdep.FindhospdepByDepId(staff.DepId); if (hospdep != null) { aers_tbl_hospital listhosp = dalhospital.hospitalFindAll().FirstOrDefault(o => o.HospId == hospdep.HospId); txt_HospId.EditValue = listhosp.HospId; this.txt_HospdepId.Text = hospdep.HospdepName; this.txt_HospdepId.Tag = hospdep.HospdepId; } } }
public void DataBind(aers_tbl_registereduser data = null) { if (data == null) { registereduser = new aers_tbl_registereduser(); state = FormState.Add; } else { registereduser = data; state = FormState.Modify; txt_LoginName.Text = data.LoginName; txt_Remarks.Text = data.Remarks; staff = dalstaff.FindByRUid(data.ReguserId); if (staff != null) { aers_tbl_hospdep hospdep = dalhospdep.FindhospdepByDepId(staff.DepId); if (hospdep != null) { aers_tbl_hospital listhosp = dalhospital.hospitalFindAll().FirstOrDefault(o => o.HospId == hospdep.HospId); txt_HospId.EditValue = listhosp.HospId; this.txt_HospdepId.Text = hospdep.HospdepName; this.txt_HospdepId.Tag = hospdep.HospdepId; } txt_Name.Tag = staff.StaffId; txt_Name.Text = staff.Name; txt_RoleState.Text = staff.RoleState.ToString(); txt_Sex.SelectedValue = staff.Sex; txt_Phone.Text = staff.Phone; txt_StaffRemarks.Text = staff.Remarks; } } }
private void AddHospitalUserInfo() { UserService userservice = new UserService(); var listUser = GetUser(); foreach (var item in listUser) { //------------------------------------------------------------------------------------------------------------------------------------------------------ //以前的注册表信息导入到授权表里面 var registerdata = userservice.GetUserregiserId(); UserauthsSqlMapDao urd = new UserauthsSqlMapDao(); //授权表导入数据 登陆名,密码,以前的注册Id Userauths ur = new Userauths(); ur.AuthsId = new aers_sys_seedSqlMapDao().GetMaxID("Userauths"); ur.LoginLastTime = Common.StrToDateTime(); ur.LoginNumber = item.LoginName; ur.LoginType = 0; //院内账号类型是0; ur.Password = item.Password; ur.RegisterId = registerdata; ur.Verified = 0; ur.ReguserId = item.ReguserId; urd.Adduserauths(ur); //------------------------------------------------------------------------------------------------------------------------------------------------------ aers_tbl_staffSqlMapDao sdao = new aers_tbl_staffSqlMapDao(); aers_tbl_staff s = new aers_tbl_staff(); var sdata = sdao.FindByRUid(item.ReguserId); //根据注册ID取出以前用户表里面的数据 科室id,姓名,性别,角色 userregisterSqlMapDao urdao = new userregisterSqlMapDao(); //注册表导入姓名 userregister urr = new userregister(); urr.RegisterId = registerdata; //注册Id urr.Name = sdata.Name; //添加姓名 urdao.Updateuserregister(urr); userbasicinfoSqlMapDao ubdao = new userbasicinfoSqlMapDao(); //基本信息表导入性别 UserBasicInfo ub = new UserBasicInfo(); ub.RegisterId = registerdata; if (sdata.Sex == "107") { ub.Sex = "女"; } else if (sdata.Sex == "108") { ub.Sex = "男"; } else { ub.Sex = ""; } ub.Birthday = Common.StrToDateTime(); ubdao.Updateuserbasicinfo(ub); UserrelrecordSqlMapDao urrrdao = new UserrelrecordSqlMapDao(); //组织关系表导入科室Id Userrelrecord urrr = new Userrelrecord(); urrr.RegisterId = registerdata; urrr.DepartmentId = sdata.DepId; //科室Id urrr.Role = sdata.RoleState; //还用以前的标记 角色 aers_tbl_hospdepSqlMapDao ad = new aers_tbl_hospdepSqlMapDao(); urrr.DepartmentName = ad.FindhospdepByDepId(sdata.DepId).HospdepName; //科室姓名 var hospId = ad.FindhospdepByDepId(sdata.DepId).HospId; //医院ID // aers_tbl_hospitalSqlMapDao DDD = new aers_tbl_hospitalSqlMapDao(); //shit aers_tbl_events_ycSqlMapDao hdao = new aers_tbl_events_ycSqlMapDao(); var hdat = hdao.hospitalFindByHospId(hospId); urrr.HospitalName = hdat.HospName; //医院姓名 urrr.HospitalId = hospId; //医院Id //h.HospitalId = item.HospId; //h.Name = item.HospName; urrrdao.Updateuserrelrecord(urrr); } }