/// <summary>
/// 绑定用户数据
/// </summary>
private void BindUsers()
{
UsersEO usersEO = GetUser(); // 获取登录用户的信息
int leave = GetUserLeave(); // 获取用户级别
StringBuilder strWhere = new StringBuilder();
IList <MySqlParameter> parm = new List <MySqlParameter>();
string beginTime = this.txtBeginTime.Text.Trim();
string endTime = this.txtEndTime.Text.Trim();
string queryId = this.txtdId.Text.Trim();
int curGameId = 0;
if (!string.IsNullOrEmpty(Session["currentgameid"].ToString()))
{
curGameId = Convert.ToInt32(Session["currentgameid"].ToString());
}
if (curGameId != 0)
{
this.txtdId.Visible = false;
bool isFirst = true;
strWhere.Append(string.Format(" Wx_duid = '{0}'", curGameId));
if (!string.IsNullOrEmpty(beginTime))
{
strWhere.Append(string.Format(" And Wx_bindtime > '{0}'", beginTime));
isFirst = false;
}
if (!string.IsNullOrEmpty(endTime))
{
if (isFirst)
{
strWhere.Append(string.Format(" And Wx_bindtime < '{0}'", endTime));
}
else
{
strWhere.Append(string.Format(" And Wx_bindtime < '{0}'", endTime));
}
}
}
else
{
//管理员
this.txtdId.Visible = true;
bool isQuereIdNull = true;
if (!string.IsNullOrEmpty(queryId))
{
strWhere.Append(string.Format(" Wx_duid = '{0}'", queryId));
isQuereIdNull = false;
}
if (!string.IsNullOrEmpty(beginTime))
{
if (isQuereIdNull)
{
strWhere.Append(string.Format(" Wx_bindtime > '{0}'", beginTime));
}
else
{
strWhere.Append(string.Format(" And Wx_bindtime > '{0}'", beginTime));
}
}
if (!string.IsNullOrEmpty(endTime))
{
strWhere.Append(string.Format(" And Wx_bindtime < '{0}'", endTime));
}
}
DataView view = wxUserManage.GetTable(strWhere.ToString(), parm).DefaultView;
string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
view.Sort = sort;
this.gvUsers.DataSource = view;
this.gvUsers.DataBind();
}
/// <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 初始化数据
UsersEO usersEO = new UsersEO();
RoleuserEO rluEO = new RoleuserEO();
if (Request.QueryString["State"] == "U")
{
usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]);
if (cbk_password.Checked)
{
usersEO.UrPass = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密
}
}
usersEO.UrLoginName = this.txtLoginName.Text.Trim();
usersEO.UrName = this.txtName.Text.Trim();
usersEO.UrParent = this.txtParent.Text.Trim();
usersEO.UrPhone = "";//this.txtPhone.Text.Trim();
usersEO.UrZone = this.txtZone.Text.Trim();
usersEO.UrPeople = this.txtContactPeople.Text.Trim();
usersEO.UrContact = this.txtContact.Text.Trim();
usersEO.UrGameId = this.txtGameId.Text.Trim();
usersEO.UrDiamondNum = this.txtDiamondNum.Text.Trim();
usersEO.UrBankName = ""; //this.txtBankName.Text.Trim();
usersEO.UrBank = ""; //this.txtBank.Text.Trim();
usersEO.UrPercent = this.txtPercent.Text.Trim();
usersEO.UrBankNo = ""; //this.txtBankNo.Text.Trim();
usersEO.UrIntroducer = ""; //this.txtIntrdouce.Text.Trim();
usersEO.UrName = this.txtName.Text.Trim();
usersEO.UrName = this.txtName.Text.Trim();
usersEO.UrRolestate = this.ddlDepartment.SelectedIndex.ToString();
usersEO.UrDepartment = this.ddlDepartment.SelectedIndex.ToString();
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.UrPass = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密
usersEO.UrDel = "0";
usersEO.UrAddUser = 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, "UsersList.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, "UsersList.aspx");
}
else
{
//Jswork.Alert("用户信息修改失败", this.Page);
this.divAlert.Visible = true;
this.lblAlert.Text = Resources.Resource.User_information_modification_failed;//"用户信息修改失败";
}
}
#endregion
CloseDivImplementation();
}
}
private void BindUsers1()
{
UsersEO usersEO = GetUser(); // 获取登录用户的信息
int leave = GetUserLeave(); // 获取用户级别
StringBuilder strWhere = new StringBuilder();
IList <MySqlParameter> parm = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(this.ddlRoleName.SelectedValue)) // 角色
{
strWhere.Append("( ");
}
strWhere.Append(" ( 1=1 ");
if (!string.IsNullOrEmpty(this.txtLoginName.Text.Trim()))
{
//strWhere.Append(string.Format(" And AUser.Ur_loginName like '%{0}%'",this.txtLoginName.Text.Trim()));
strWhere.Append(" And AUser.Ur_loginName like @Cnname");
parm.Add(new MySqlParameter("@Cnname", "%" + this.txtLoginName.Text.Trim() + "%"));
}
if (!string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
//strWhere.Append(string.Format(" And AUser.Ur_name like '%{0}%'", this.txtName.Text.Trim()));
strWhere.Append(" And AUser.Ur_name like @Nnname");
parm.Add(new MySqlParameter("@Nnname", "%" + this.txtName.Text.Trim() + "%"));
}
if (!string.IsNullOrEmpty(this.ddlDepartment.SelectedValue))
{
//strWhere.Append(string.Format(" And AUser.Ur_department = '{0}' ", ddlDepartment.SelectedValue));
strWhere.Append(" And AUser.Ur_department= @Snname");
parm.Add(new MySqlParameter("@Snname", ddlDepartment.SelectedValue));
}
//strWhere.Append(string.Format(" And AUser.Ur_state = '{0}'", this.rblState.SelectedValue));//0启用1停用2冻结 默认0
strWhere.Append(" And AUser.Ur_state = @RBnname");
parm.Add(new MySqlParameter("@RBnname", this.rblState.SelectedValue));
if (leave < 200)
{
strWhere.Append(" And cast(AUser.Ur_text1 as signed ) <= @Bnname");
parm.Add(new MySqlParameter("@Bnname", Convert.ToInt32(usersEO.UrText1)));
//strWhere.Append(string.Format(" And cast(AUser.Ur_text1 as int ) <= {0} ", Convert.ToInt32(usersEO.UrText1)));
}
if (leave < 90) // 根据用户账号管理权限显示归属内的账号
{
//strWhere.Append(" And AUser.Ur_text2 like '%" + usersEO.UrId + ";%' ");
strWhere.Append(" And AUser.Ur_text2 like @URnname");
parm.Add(new MySqlParameter("@URnname", usersEO.UrId));
}
strWhere.Append(" And AUser.Ur_del = 0 ) ");
if (leave >= 80) // 显示自己的账号
{
//strWhere.Append(" or AUser.Ur_id = '" + usersEO.UrId + "' ");
strWhere.Append(" or AUser.Ur_id = @URID");
parm.Add(new MySqlParameter("@URID", usersEO.UrId));
}
if (!string.IsNullOrEmpty(this.ddlRoleName.SelectedValue)) // 角色
{
//strWhere.Append(" ) " + " and ARole.Rl_id = '" + this.ddlRoleName.SelectedValue + "' and cast(AUser.Ur_text1 as int ) <= 90 ");
strWhere.Append(" ) and 'ARole.Rl_id' = @RONAME and cast(AUser.Ur_text1 as signed ) <= 90");
parm.Add(new MySqlParameter("@RONAME", this.ddlRoleName.SelectedValue));
}
DataView view = userManage.GetList(strWhere.ToString(), parm).DefaultView;
string sort = (string)ViewState["SortOrder"] + " " + (string)ViewState["OrderDire"];
view.Sort = sort;
this.gvUsers.DataSource = view;
this.gvUsers.DataBind();
}
/// <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
//判断用户账号是否存在
if (this.CheckUserLoginName() == false)
{
ShowCommonDlg("账户名已存在！");
CloseDivImplementation();
return;
}
#region 初始化数据
UsersEO usersEO = new UsersEO();
RoleuserEO rluEO = new RoleuserEO();
//if (Request.QueryString["State"] == "U")
//{
// usersEO = userManage.GetUserByPK(Request.QueryString["Urid"]);
// if (cbk_password.Checked)
// {
// }
//}
usersEO.UrPass = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密
usersEO.UrLoginName = this.txtLoginName.Text.Trim();
usersEO.UrName = this.txtName.Text.Trim();
usersEO.UrParent = this.txtParent.Text.Trim();
usersEO.UrPhone = "";//this.txtPhone.Text.Trim();
usersEO.UrZone = this.txtZone.Text.Trim();
usersEO.UrPeople = this.txtContactPeople.Text.Trim();
usersEO.UrContact = this.txtContact.Text.Trim();
usersEO.UrGameId = this.txtGameId.Text.Trim();
usersEO.UrDiamondNum = "0";
usersEO.UrBankName = ""; //this.txtBankName.Text.Trim();
usersEO.UrBank = ""; //this.txtBank.Text.Trim();
usersEO.UrPercent = "0";
usersEO.UrBankNo = ""; //this.txtBankNo.Text.Trim();
usersEO.UrIntroducer = ""; //this.txtIntrdouce.Text.Trim();
usersEO.UrRolestate = "3";
usersEO.UrDepartment = "3";
usersEO.UrState = "0";
usersEO.UrLockBindIp = "";
usersEO.UrText1 = "0"; // 用户级别
#endregion
#region 创建用户
//if (Request.QueryString["State"] == "A")
{
//用户信息
usersEO.UrId = GetBigGuid();
usersEO.UrPass = MdUtil.ToMd5Hash(this.txtPass.Text.Trim());//密码MD5加密
usersEO.UrDel = "0";
usersEO.UrAddUser = 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 = "0468a29f20160413170700";//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("代理信息创建成功!", "UsersAgentList.aspx"); //ShowCommonDlg("代理信息创建成功！");
}
else
{
//Jswork.Alert("用户信息创建失败", this.Page);
//this.divAlert.Visible = true;
//this.lblAlert.Text = Resources.Resource.User_information_creation_failed;//"用户信息创建失败";
ShowCommonDlg("代理信息创建失败！");
}
}
#endregion
CloseDivImplementation();
}
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int EditUser(UsersEO item)
{
return(usersMO.UpdateUser(item));
}
/// <summary>
/// 创建用户
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int AddUser(UsersEO item)
{
return(usersMO.Add(item));
}
