public string Insert(aers_tbl_registereduser data)
{
aers_sys_seedSqlMapDao dal = new aers_sys_seedSqlMapDao();
data.ReguserId = dal.GetMaxID("registereduser");
String stmtId = "aers_tbl_registereduser_Insert";
Hashtable ht = new Hashtable();
ht.Add("ReguserId", data.ReguserId);
ht.Add("LoginName", data.LoginName);
ht.Add("Password", data.Password);
ht.Add("IsFlag", data.IsFlag);
ht.Add("Remarks", data.Remarks);
ht.Add("OperatorId", data.OperatorId);
ht.Add("OperatorDate", data.OperatorDate);
try
{
ExecuteInsert(stmtId, ht);
return(data.ReguserId);
}
catch (Exception ex)
{
return("");
}
}
//
public aers_tbl_registereduser FindByLoginName(string LoginName)
{
String stmtId = "aers_tbl_registereduser_FindByLoginName";
Hashtable ht = new Hashtable();
ht.Add("LoginName", LoginName);
aers_tbl_registereduser result = ExecuteQueryForObject <aers_tbl_registereduser>(stmtId, ht);
return(result);
}
/// <summary>
/// 根据注册用户编码查询注册用户信息
/// </summary>
/// <param name="reguserId">注册用户编码</param>
/// <returns>注册用户信息实体</returns>
public aers_tbl_registereduser Find(string reguserId)
{
String stmtId = "aers_tbl_registereduser_Find";
Hashtable ht = new Hashtable();
ht.Add("ReguserId", reguserId);
aers_tbl_registereduser result = ExecuteQueryForObject <aers_tbl_registereduser>(stmtId, ht);
return(result);
}
/// <summary>
/// 检查用户名是否存在
/// </summary>
/// <param name="loginName">登录检查的用户名称</param>
/// <param name="aers_registereduser">用户基本信息</param>
/// <returns>是/否存在</returns>
public aers_tbl_registereduser Uniquenessverification(string loginName)
{
String stmtId = "aers_tbl_registereduser_FindByLoginName";
Hashtable ht = new Hashtable();
ht.Add("LoginName", loginName);
aers_tbl_registereduser aers_registereduser = ExecuteQueryForObject <aers_tbl_registereduser>(stmtId, ht);
return(aers_registereduser);
}
public int UpdatePwd(aers_tbl_registereduser data)
{
String stmtId = "aers_tbl_registereduser_UpdatePwd";
Hashtable ht = new Hashtable();
ht.Add("ReguserId", data.ReguserId);
ht.Add("Password", data.Password);
ht.Add("OperatorDate", DateTime.Now);
int i = ExecuteUpdate(stmtId, ht);
return(i);
}
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;
}
}
}
public int Update(aers_tbl_registereduser data)
{
String stmtId = "aers_tbl_registereduser_Update";
Hashtable ht = new Hashtable();
ht.Add("ReguserId", data.ReguserId);
ht.Add("LoginName", data.LoginName);
ht.Add("Password", data.Password);
ht.Add("IsFlag", data.IsFlag);
ht.Add("Remarks", data.Remarks);
ht.Add("OperatorId", data.OperatorId);
ht.Add("OperatorDate", data.OperatorDate);
int i = ExecuteUpdate(stmtId, ht);
return(i);
}
private void picdelete_Click(object sender, EventArgs e)
{
if (this.gridView1.FocusedRowHandle >= 0)
{
aers_tbl_registereduser data = this.gridView1.GetRow(this.gridView1.FocusedRowHandle) as aers_tbl_registereduser;
if ((MessageBox.Show("确定要删除吗？", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes))
{
int i = dal.Delete(data.ReguserId);
if (i > 0)
{
DataBind();
}
else
{
MessageBox.Show("删除失败！");
}
}
}
}
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("修改失败！");
}
}
}
