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 int Insert(aers_tbl_staff data)
{
aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao();
data.StaffId = dal.GetMaxID("staff");
String stmtId = "aers_tbl_staff_Insert";
Hashtable ht = new Hashtable();
ht.Add("StaffId", data.StaffId);
ht.Add("ReguserId", data.ReguserId);
ht.Add("DepId", data.DepId);
ht.Add("Name", data.Name);
ht.Add("RoleState", data.RoleState);
ht.Add("Sex", data.Sex);
ht.Add("Position", data.Position);
ht.Add("Phone", data.Phone);
ht.Add("Address", data.Address);
ht.Add("IDNumber", data.IDNumber);
ht.Add("IsFlag", data.IsFlag);
ht.Add("Remarks", data.Remarks);
ht.Add("OperatorId", data.OperatorId);
ht.Add("OperatorDate", data.OperatorDate);
ht.Add("HeadImg", data.HeadImg);
try
{
ExecuteInsert(stmtId, ht);
return(1);
}
catch (Exception ex)
{
return(0);
}
}
public aers_tbl_staff FindByPhoneNumber(string PhoneNumber)
{
String stmtId = "aers_tbl_staff_FindByPhoneNumber";
Hashtable ht = new Hashtable();
ht.Add("Phone", PhoneNumber);
aers_tbl_staff result = ExecuteQueryForObject <aers_tbl_staff>(stmtId, ht);
return(result);
}
/// <summary>
/// 根据注册用户编码查询注册用户信息
/// </summary>
/// <param name="reguserId">注册用户编码</param>
/// <returns>注册用户信息实体</returns>
public aers_tbl_staff FindByRUid(string ruid)
{
String stmtId = "aers_tbl_staff_FindByReguserId";
Hashtable ht = new Hashtable();
ht.Add("ReguserId", ruid);
aers_tbl_staff result = ExecuteQueryForObject <aers_tbl_staff>(stmtId, ht);
return(result);
}
public aers_tbl_staff staffFindByStaffId(string StaffId)
{
String stmtId = "aers_tbl_staff_Find";
Hashtable ht = new Hashtable();
ht.Add("StaffId", StaffId);
aers_tbl_staff result = ExecuteQueryForObject <aers_tbl_staff>(stmtId, ht);
return(result);
}
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 picdelete_Click(object sender, EventArgs e)
{
if (this.gridView1.FocusedRowHandle >= 0)
{
aers_tbl_staff data = this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as aers_tbl_staff;
if ((MessageBox.Show("确定要删除吗？", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes))
{
int i = dal.Delete(data.ReguserId);
if (i > 0)
{
DataBind();
}
else
{
MessageBox.Show("删除失败！");
}
}
}
}
public int Update(aers_tbl_staff data)
{
String stmtId = "aers_tbl_staff_Update";
Hashtable ht = new Hashtable();
ht.Add("DepId", data.DepId);
ht.Add("Name", data.Name);
ht.Add("RoleState", data.RoleState);
ht.Add("Sex", data.Sex);
ht.Add("Position", data.Position);
ht.Add("Phone", data.Phone);
ht.Add("Address", data.Address);
ht.Add("IDNumber", data.IDNumber);
ht.Add("IsFlag", data.IsFlag);
ht.Add("Remarks", data.Remarks);
ht.Add("OperatorId", data.OperatorId);
ht.Add("OperatorDate", data.OperatorDate);
ht.Add("ReguserId", data.ReguserId);
ht.Add("HeadImg", data.HeadImg);
int i = ExecuteUpdate(stmtId, ht);
return(i);
}
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);
}
}
/// <summary>
/// 根据注册用户编码查询注册用户信息
/// </summary>
/// <param name="reguserId">注册用户编码</param>
/// <returns>注册用户信息实体</returns>
public IList <aers_tbl_registereduser> FindAll(string HospID)
{
String stmtId = "aers_tbl_registereduser_FindAll";
Hashtable ht = new Hashtable();
if (!string.IsNullOrEmpty(HospID))
{
stmtId = "aers_tbl_registereduser_ByHospId";
ht.Add("HospId", HospID);
}
IList <aers_tbl_registereduser> list = ExecuteQueryForList <aers_tbl_registereduser>(stmtId, ht);
aers_tbl_registereduserSqlMapDao dal = new aers_tbl_registereduserSqlMapDao();
aers_tbl_staffSqlMapDao dalstaff = new aers_tbl_staffSqlMapDao();
aers_tbl_events_ycSqlMapDao dalhospital = new aers_tbl_events_ycSqlMapDao();
aers_tbl_hospdepSqlMapDao dalhospdep = new aers_tbl_hospdepSqlMapDao();
IList <aers_tbl_hospital> listhospital = dalhospital.hospitalFindAll();
IList <aers_tbl_hospdep> listhospdep = dalhospdep.hospdepFindAll();
IList <aers_tbl_staff> liststaff = dalstaff.staffFindAll();
foreach (aers_tbl_registereduser item in list)
{
if (item.LoginName == null)
{
item.LoginName = "";
}
aers_tbl_staff sta = liststaff.FirstOrDefault(o => o.ReguserId == item.ReguserId);
if (sta != null)
{
item.StaffId = sta.StaffId;
item.DepId = sta.DepId;
item.Name = sta.Name;
item.RoleState = sta.RoleState;
item.Position = sta.Position;
item.Phone = sta.Phone;
item.Address = sta.Address;
item.IDNumber = sta.IDNumber;
item.StaffRemarks = sta.Remarks;
if (sta.RoleState != null)
{
if (sta.RoleState.Contains("147"))
{
item.RoleState = "省厅";
}
else if (sta.RoleState.Contains("148"))
{
item.RoleState = "区域";
}
else if (sta.RoleState.Contains("145"))
{
item.RoleState = "护理部";
}
else if (sta.RoleState.Contains("146"))
{
item.RoleState = "护士长";
}
else if (sta.RoleState.Contains("402"))
{
item.RoleState = "护士";
}
else
{
item.RoleState = "未知状态";
}
}
if (sta.Sex == "107")
{
item.Sex = "女";
}
else if (sta.Sex == "108")
{
item.Sex = "男";
}
else
{
item.Sex = "未知";
}
}
else
{
item.StaffId = "";
item.DepId = "";
item.Name = "";
item.Position = "";
item.Phone = "";
item.Address = "";
item.IDNumber = "";
item.StaffRemarks = "";
item.RoleState = "";
item.Sex = "";
item.RoleState = "未知状态";
}
aers_tbl_hospdep of = listhospdep.FirstOrDefault(o => o.HospdepId == item.DepId);
if (of != null)
{
item.HospdepName = of.HospdepName;
aers_tbl_hospital hosp = listhospital.FirstOrDefault(o => o.HospId == of.HospId);
if (hosp != null)
{
item.HospId = hosp.HospId;
item.HospName = hosp.HospName;
item.hospitalAddress = hosp.Address;
item.hospitalPhone = hosp.Phone;
item.Contact = hosp.Contact;
item.Grade = hosp.Grade;
item.Validitytime = hosp.Validitytime;
}
}
else
{
item.HospdepName = "";
item.HospId = "";
item.HospName = "";
item.hospitalAddress = "";
item.hospitalPhone = "";
item.Contact = "";
item.Grade = "";
}
}
return(list);
}
private void btnAdd_Click(object sender, EventArgs e)
{
registereduser.LoginName = txt_LoginName.Text.Trim();
if (!string.IsNullOrEmpty(txt_Password.Text.Trim()))
{
registereduser.Password = txt_Password.Text.Trim();
}
registereduser.Remarks = txt_Remarks.Text.Trim();
registereduser.OperatorId = MainForm.user.ReUId;
registereduser.OperatorDate = DateTime.Now;
if (string.IsNullOrEmpty(registereduser.LoginName))
{
MessageBox.Show("用户名不能为空！");
return;
}
aers_tbl_registereduser check = dal.Uniquenessverification(registereduser.LoginName);
if (state == FormState.Add)
{
if (string.IsNullOrEmpty(registereduser.Password))
{
MessageBox.Show("密码不能为空！");
return;
}
if (check != null)
{
MessageBox.Show("用户名已存在！");
return;
}
}
if (staff == null)
{
staff = new aers_tbl_staff();
}
if (txt_HospId.EditValue == null)
{
MessageBox.Show("请选择医院");
return;
}
if (txt_HospdepId.SelectedRow == null || string.IsNullOrEmpty(txt_HospdepId.SelectedRow["HospdepId"].ToString()))
{
if (txt_HospdepId.Tag != null)
{
staff.DepId = txt_HospdepId.Tag.ToString();
}
else
{
MessageBox.Show("请选择科室");
return;
}
}
else
{
staff.DepId = txt_HospdepId.SelectedRow["HospdepId"].ToString();
}
staff.Name = txt_Name.Text;
staff.RoleState = txt_RoleState.Text;
staff.IDNumber = "";
staff.Position = "";
staff.Address = "";
staff.Sex = txt_Sex.SelectedValue.ToString();
if (!string.IsNullOrEmpty(txt_Phone.Text.Trim()))
{
staff.Phone = txt_Phone.Text;
}
if (!string.IsNullOrEmpty(txt_StaffRemarks.Text.Trim()))
{
staff.Remarks = txt_StaffRemarks.Text;
}
staff.OperatorId = MainForm.user.ReUId;
staff.OperatorDate = DateTime.Now;
if (string.IsNullOrEmpty(staff.Name))
{
MessageBox.Show("姓名不能为空！");
return;
}
if (staff.RoleState == "")
{
MessageBox.Show("请选择权限！");
return;
}
if (state == FormState.Add)
{
string ReguserId = dal.Insert(registereduser);
if (!string.IsNullOrEmpty(ReguserId))
{
check = dal.Uniquenessverification(registereduser.LoginName);
staff.ReguserId = check.ReguserId;
int i;
if (dalstaff.FindByRUid(check.ReguserId) == null)
{
i = dalstaff.Insert(staff);
}
else
{
i = dalstaff.Update(staff);
}
if (i > 0)
{
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("人员信息增加失败！");
}
}
else
{
MessageBox.Show("增加失败！");
}
}
else
{
int i = dal.Update(registereduser);
if (i > 0)
{
staff.ReguserId = registereduser.ReguserId;
i = dalstaff.Update(staff);
if (i > 0)
{
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("人员信息修改失败！");
}
}
else
{
MessageBox.Show("修改失败！");
}
}
}
