/// <summary>
/// 更新数据
/// </summary>
/// <param name = "item">要更新的实体对象</param>
/// <param name="tm">事务管理对象</param>
/// <return>受影响的行数</return>
public virtual int UpdateUser(OrganizeEO item, TransactionManager tm = null)
{
const string sql = @"UPDATE organize SET Ur_Name=@Ur_Name, Ur_UserName=@Ur_UserName, Ur_PassWord=@Ur_PassWord, Ur_zone=@Ur_zone, Ur_people=@Ur_people, Ur_Contact=@Ur_Contact, Ur_percent=@Ur_percent, Ur_bankName=@Ur_bankName,Ur_bank=@Ur_bank,Ur_bankNo=@Ur_bankNo,Ur_introducer=@Ur_introducer,Ur_errorlogin=@Ur_errorlogin, Ur_lockTime=@Ur_lockTime, Ur_lockBindIp=@Ur_lockBindIp, Ur_text1=@Ur_text1, Ur_text2=@Ur_text2 WHERE Ur_id=@Ur_id";
return(Database.CreateSqlDao(sql)
.AddInParameter("@Ur_Name", item.UrName != null ? (object)item.UrName : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_UserName", item.UrUserName != null ? (object)item.UrUserName : DBNull.Value, DbType.String, 100)
.AddInParameter("@Ur_PassWord", item.UrPassWord != null ? (object)item.UrPassWord : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_zone", item.UrZone != null ? (object)item.UrZone : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_people", item.UrPeople != null ? (object)item.UrPeople : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_Contact", item.UrContact != null ? (object)item.UrContact : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_percent", item.UrPercent != null ? (object)item.UrPercent : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_bankName", item.UrBankName != null ? (object)item.UrBankName : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_bank", item.UrBank != null ? (object)item.UrBank : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_bankNo", item.UrBankNo != null ? (object)item.UrBankNo : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_introducer", item.UrIntroducer != null ? (object)item.UrIntroducer : DBNull.Value, DbType.String, 50)
.AddInParameter("@Ur_addTime", item.UrAddTime, DbType.DateTime, 8)
.AddInParameter("@Ur_state", item.UrState, DbType.AnsiStringFixedLength, 1)
.AddInParameter("@Ur_del", item.UrDel, DbType.AnsiStringFixedLength, 1)
.AddInParameter("@Ur_errorlogin", item.UrErrorlogin != null ? (object)item.UrErrorlogin : DBNull.Value, DbType.String, 100)
.AddInParameter("@Ur_lockTime", item.UrLockTime, DbType.DateTime, 8)
.AddInParameter("@Ur_lockBindIp", item.UrLockBindIp != null ? (object)item.UrLockBindIp : DBNull.Value, DbType.String, 500)
.AddInParameter("@Ur_text1", item.UrText1 != null ? (object)item.UrText1 : DBNull.Value, DbType.String, 100)
.AddInParameter("@Ur_text2", item.UrText2 != null ? (object)item.UrText2 : DBNull.Value, DbType.String, 100)
.AddInParameter("@Ur_id", item.UrId, DbType.String, 50)
.ExecNonQuery(tm));
//return 0;
}
/// <summary>
/// 加载用户角色信息
/// </summary>
private void LoadRoleUser()
{
IList <MySqlParameter> parm = new List <MySqlParameter>();
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" Ur_id= @Rl_name ");
parm.Add(new MySqlParameter("@Rl_name", Request.QueryString["Urid"]));
DataTable dt = rluManage.GetTable(strWhere.ToString(), parm);
OrganizeEO userEO = userManage.GetUser(Request.QueryString["Urid"]);
try
{
ddlUserLeave.SelectedValue = userEO.UrText1;
}
catch { }
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < this.cblRoles.Items.Count; i++)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
if (this.cblRoles.Items[i].Value == dt.Rows[j]["Rl_id"].ToString())
{
this.cblRoles.Items[i].Selected = true;
}
}
}
}
SetRoleListColor();
}
/// <summary>
/// 加载角色信息
/// </summary>
private void LoadRoles()
{
OrganizeEO userEO = GetOrgnizeUser();
int leave = GetUserLeave(); // 获取用户等级
// 根据级别绑定用户可选的级别信息
BindddlUserLeave(leave);
// 判断开发管理员以上的用户可以对任何用户进行编辑
if (leave >= 90)
{
this.cblRoles.DataSource = rlManage.Get(" Rl_del = 0", null);
}
else
{
IList <MySqlParameter> parm = new List <MySqlParameter>();
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" Rl_id in ( select Rl_id from roleuser where Ur_id =@Ur_id ) and Rl_del = 0 and Rl_name <> @UserEditName ");
parm.Add(new MySqlParameter("@Ur_id", GetUserID()));
parm.Add(new MySqlParameter("@UserEditName", ConfigurationManager.AppSettings["UserEditName"].ToString()));
this.cblRoles.DataSource = rlManage.Get(strWhere.ToString(), parm);
//this.cblRoles.DataSource = rlManage.Get(" Rl_id in ( select Rl_id from roleuser where Ur_id = '" + GetUserID() + "') and Rl_del = 0 and Rl_name <> '" + ConfigurationManager.AppSettings["UserEditName"].ToString() + "' ");
// 根据用户级别判断该用户是否有用户账号管理的权限
cbAccountManagement.Enabled = false;
cbAccountManagement.SelectedValue = userEO.UrId;
}
this.cblRoles.DataTextField = "Rlname";
this.cblRoles.DataValueField = "RlId";
this.cblRoles.DataBind();
if (this.cblRoles.Items.Count == 0)
{
this.lkRoleEdit.Visible = true;
}
}
/// <summary>
/// 获取机构用户基本信息
/// </summary>
/// <returns></returns>
public OrganizeEO GetOrgnizeUser()
{
OrganizeEO usersEO = new OrganizeEO();
if (GetUserID() != "")
{
usersEO = organizeManage.GetUser(GetUserID());
}
return(usersEO);
}
/// <summary>
/// 加载
/// </summary>
private void Loads()
{
OrganizeEO usersEO = new OrganizeEO();
usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]);
if (!string.IsNullOrEmpty(usersEO.UrId))
{
this.lblUser.Text = usersEO.UrUserName;//显示用户账号
}
}
/// <summary>
/// 根据用户名和密码查询用户信息
/// </summary>
/// <param name="username">用户名</param>
/// <param name="password">密码</param>
/// <returns></returns>
public OrganizeEO GetUser(string username, string password)
{
OrganizeEO UsersEO = new OrganizeEO();
foreach (OrganizeEO tsersEOs in usersMO.Get(" Ur_loginName = @Ur_loginName and Ur_pass = @Ur_pass and Ur_del = 0 ", username, password))
{
UsersEO = tsersEOs;
break;
}
return(UsersEO);
}
/// <summary>
/// 加载用户信息
/// </summary>
private void LoadUsers()
{
OrganizeEO usersEO = new OrganizeEO();
int leave = GetUserLeave(); // 获取用户级别
usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]);
if (!string.IsNullOrEmpty(usersEO.UrId))
{
this.txtOrganizeNo.Text = usersEO.UrNo;
this.txtOrganizeName.Text = usersEO.UrName;
this.txtLoginName.Text = usersEO.UrUserName;
this.hfLoginName.Value = usersEO.UrUserName;
this.txtZone.Text = usersEO.UrZone;
this.txtPeople.Text = usersEO.UrPeople;
this.txtContact.Text = usersEO.UrContact;
this.txtBack.Text = usersEO.UrBank;
this.txtBackName.Text = usersEO.UrBankName;
this.txtBackNo.Text = usersEO.UrBankNo;
this.txtPercent.Text = usersEO.UrPercent;
this.txtIntroducer.Text = usersEO.UrIntroducer;
this.txtUserIps.Text = usersEO.UrLockBindIp;
this.rblState.SelectedValue = usersEO.UrState;
this.ddlUserLeave.Text = usersEO.UrText1; // 用户级别
}
this.trPass.Visible = false;
if (leave >= 90)
{
this.cbk_password.Visible = true;
}
// 加载用户账号归属
if (usersEO.UrText2 != null)
{
foreach (string AccountManagementmessage in usersEO.UrText2.Split(';'))
{
if (AccountManagementmessage != "")
{
for (int i = 0; i < this.cbAccountManagement.Items.Count; i++)
{
if (this.cbAccountManagement.Items[i].Value == AccountManagementmessage)
{
this.cbAccountManagement.Items[i].Selected = true;
}
}
}
}
}
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int EditUser(OrganizeEO item)
{
return(usersMO.UpdateUser(item));
}
/// <summary>
/// 创建用户
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int AddUser(OrganizeEO item)
{
return(usersMO.Add(item));
}
/// <summary>
/// 添加、修改数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOK_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
#region 验证表单合法性
if (this.CheckForms() == false)
{
CloseDivImplementation();
return;
}
#endregion
#region 初始化数据
OrganizeEO usersEO = new OrganizeEO();
RoleuserEO rluEO = new RoleuserEO();
if (Request.QueryString["State"] == "U")
{
usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]);
if (cbk_password.Checked)
{
usersEO.UrPassWord = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密
}
}
usersEO.UrNo = this.txtOrganizeNo.Text.Trim();
usersEO.UrName = this.txtOrganizeName.Text.Trim();
usersEO.UrUserName = this.txtLoginName.Text.Trim();
//usersEO.UrDepartment = this.ddlDepartment.SelectedValue;
usersEO.UrZone = this.txtZone.Text.Trim();
usersEO.UrPeople = this.txtPeople.Text.Trim();
usersEO.UrContact = this.txtContact.Text.Trim();
usersEO.UrBank = this.txtBack.Text.Trim();
usersEO.UrBankName = this.txtBackName.Text.Trim();
usersEO.UrBankNo = this.txtBackNo.Text.Trim();
usersEO.UrPercent = this.txtPercent.Text.Trim();
usersEO.UrIntroducer = this.txtIntroducer.Text.Trim();
usersEO.UrState = this.rblState.SelectedValue;
usersEO.UrLockBindIp = this.txtUserIps.Text.ToString().Trim();
usersEO.UrText1 = this.ddlUserLeave.Text.ToString().Trim(); // 用户级别
#endregion
#region 设置用户账号归属管理
//用户角色信息
int itemCount = 0; // 选择的数量
string strAccountManagement = "";
for (int i = 0; i < this.cbAccountManagement.Items.Count; i++)
{
if (this.cbAccountManagement.Items[i].Selected)
{
strAccountManagement += this.cbAccountManagement.Items[i].Value;
strAccountManagement += ";";
itemCount++;
}
}
usersEO.UrText2 = strAccountManagement;
if (itemCount > 5)
{
this.divAlert.Visible = true;
this.lblAlert.Text = "账号管理归属最多选择4个人";
CloseDivImplementation();
return;
}
#endregion
#region 创建用户
if (Request.QueryString["State"] == "A")
{
//判断用户账号是否存在
if (this.CheckUserLoginName() == false)
{
//Jswork.Alert("用户账号【" + this.txtLoginName.Text.Trim() + "】已存在", this.Page);
this.divAlert.Visible = true;
this.lblAlert.Text = Resources.Resource.User_account1 + this.txtLoginName.Text.Trim() + Resources.Resource.Already_exist;
CloseDivImplementation();
return;
}
//用户信息
usersEO.UrId = GetBigGuid();
usersEO.UrPassWord = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密
usersEO.UrDel = "0";
usersEO.UrIntroducer = GetUserID();
usersEO.UrAddTime = DateTime.Now;
usersEO.UrLockTime = DateTime.Now;
//用户角色信息
for (int i = 0; i < this.cblRoles.Items.Count; i++)
{
if (this.cblRoles.Items[i].Selected)
{
rluEO.UrId = usersEO.UrId;
rluEO.RlId = this.cblRoles.Items[i].Value;
rluEO.RuAddUser = GetUserID();
rluEO.RuAddTime = DateTime.Now;
rluManage.AddRoleUser(rluEO);
}
}
if (userManage.AddUser(usersEO) > 0)
{
//插入操作日志
InsertLog(Resources.Resource.Create_user, string.Format("username:{0},id:{1}", usersEO.UrName, usersEO.UrId), 4, GetPlatformIdByValue(1));
CloseDivImplementation();
Jswork.Alert(Resources.Resource.User_information_creation_success, "OrganizersList.aspx");
}
else
{
//Jswork.Alert("用户信息创建失败", this.Page);
this.divAlert.Visible = true;
this.lblAlert.Text = Resources.Resource.User_information_creation_failed;//"用户信息创建失败";
}
}
#endregion
#region 修改用户
if (Request.QueryString["State"] == "U")
{
//修改时判断账号是否存在
if (hfLoginName.Value != this.txtLoginName.Text.Trim())
{
//判断用户账号是否存在
if (this.CheckUserLoginName() == false)
{
//Jswork.Alert("用户账号【" + this.txtLoginName.Text.Trim() + "】已存在", this.Page);
this.divAlert.Visible = true;
//this.lblAlert.Text = "用户账号【" + this.txtLoginName.Text.Trim() + "】已存在";
this.lblAlert.Text = Resources.Resource.User_account1 + this.txtLoginName.Text.Trim() + Resources.Resource.Already_exist;
CloseDivImplementation();
return;
}
}
//用户角色信息
rluManage.RemoveByPK(Request.QueryString["Urid"]); //插入用户角色关系表数据前先删除数据
for (int i = 0; i < this.cblRoles.Items.Count; i++)
{
if (this.cblRoles.Items[i].Selected)
{
rluEO.UrId = usersEO.UrId;
rluEO.RlId = this.cblRoles.Items[i].Value;
rluEO.RuAddUser = GetUserID();
rluEO.RuAddTime = DateTime.Now;
rluManage.AddRoleUser(rluEO);
}
}
if (userManage.EditUser(usersEO) > 0)
{
if (usersEO.UrState == "0") // 启用状态
{
UserUnFreeZing(usersEO.UrId, DateTime.Now.AddMonths(-1));
}
//插入操作日志
InsertLog(Resources.Resource.Modify_user, string.Format("username:{0},id:{1}", usersEO.UrName, usersEO.UrId), 2, GetPlatformIdByValue(1));
CloseDivImplementation();
Jswork.Alert(Resources.Resource.Success_of_user_information_modification, "OrganizersList.aspx");
}
else
{
//Jswork.Alert("用户信息修改失败", this.Page);
this.divAlert.Visible = true;
this.lblAlert.Text = Resources.Resource.User_information_modification_failed;//"用户信息修改失败";
}
}
#endregion
CloseDivImplementation();
}
}
