/// <summary> /// 添加和修改 /// </summary> /// <param name="updateDel"></param> /// <param name="curPage"></param> /// <param name="is4Modify"></param> /// <param name="model"></param> public FrmAddAuthUser(Action <int> updateDel, int curPage, bool is4Modify = false, SteelManagement.Model.AuthUser model = null) { this.StartPosition = FormStartPosition.CenterParent; InitializeComponent(); _updateDel = updateDel; _curPage = curPage; _is4Modify = is4Modify; _model = model; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SteelManagement.Model.AuthUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AuthUser set "); strSql.Append("UserName=@UserName,"); strSql.Append("Account=@Account,"); strSql.Append("Password=@Password,"); strSql.Append("UserMobile=@UserMobile,"); strSql.Append("DepartmentId=@DepartmentId,"); strSql.Append("UserLevel=@UserLevel,"); strSql.Append("Privilege=@Privilege"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.VarChar, 100), new SqlParameter("@Account", SqlDbType.VarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 100), new SqlParameter("@UserMobile", SqlDbType.VarChar, 50), new SqlParameter("@DepartmentId", SqlDbType.Int, 4), new SqlParameter("@UserLevel", SqlDbType.Int, 4), new SqlParameter("@Privilege", SqlDbType.Int, 4), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.UserName; parameters[1].Value = model.Account; parameters[2].Value = model.Password; parameters[3].Value = model.UserMobile; parameters[4].Value = model.DepartmentId; parameters[5].Value = model.UserLevel; parameters[6].Value = model.Privilege; parameters[7].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public SteelManagement.Model.AuthUser DataRowToModel(DataRow row) { SteelManagement.Model.AuthUser model = new SteelManagement.Model.AuthUser(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["Account"] != null) { model.Account = row["Account"].ToString(); } if (row["Password"] != null) { model.Password = row["Password"].ToString(); } if (row["UserMobile"] != null) { model.UserMobile = row["UserMobile"].ToString(); } if (row["DepartmentId"] != null && row["DepartmentId"].ToString() != "") { model.DepartmentId = int.Parse(row["DepartmentId"].ToString()); } if (row["UserLevel"] != null && row["UserLevel"].ToString() != "") { model.UserLevel = int.Parse(row["UserLevel"].ToString()); } if (row["Privilege"] != null && row["Privilege"].ToString() != "") { model.Privilege = int.Parse(row["Privilege"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SteelManagement.Model.AuthUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AuthUser("); strSql.Append("UserName,Account,Password,UserMobile,DepartmentId,UserLevel,Privilege)"); strSql.Append(" values ("); strSql.Append("@UserName,@Account,@Password,@UserMobile,@DepartmentId,@UserLevel,@Privilege)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.VarChar, 100), new SqlParameter("@Account", SqlDbType.VarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 100), new SqlParameter("@UserMobile", SqlDbType.VarChar, 50), new SqlParameter("@DepartmentId", SqlDbType.Int, 4), new SqlParameter("@UserLevel", SqlDbType.Int, 4), new SqlParameter("@Privilege", SqlDbType.Int, 4) }; parameters[0].Value = model.UserName; parameters[1].Value = model.Account; parameters[2].Value = model.Password; parameters[3].Value = model.UserMobile; parameters[4].Value = model.DepartmentId; parameters[5].Value = model.UserLevel; parameters[6].Value = model.Privilege; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public SteelManagement.Model.AuthUser GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,UserName,Account,Password,UserMobile,DepartmentId,UserLevel,Privilege from AuthUser "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; SteelManagement.Model.AuthUser model = new SteelManagement.Model.AuthUser(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void btnOK_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtUserName.Text) || string.IsNullOrEmpty(txtAccount.Text) || string.IsNullOrEmpty(txtPassword.Text) ) { MessageBoxEx.Show("除手机号外都必须填写!"); return; } if (_is4Modify) { _model.UserName = txtUserName.Text; _model.Account = txtAccount.Text; _model.Password = txtPassword.Text; _model.UserMobile = txtUserMobile.Text; if ((ChkBoxsToPrevilege() != _model.Privilege || (GetUserLevelByRbtns()) != _model.UserLevel) && GlobalUtils.LoginUser.UserLevel != 0) { MessageBoxEx.Show("不能修改自己的权限信息,请联系管理员!"); return; } _model.Privilege = ChkBoxsToPrevilege(); _model.UserLevel = GetUserLevelByRbtns(); //执行负责项目更改 var userChecked = _bllProjectChecker.GetUserCheckProjects(_model.UserName); foreach (var item in chkProjects.CheckBoxItems) { if ( (item.Checked && (userChecked == null || userChecked.Count <= 0)) || (item.Checked && !userChecked.Contains(item.Text))) //原来没有现在有 { Model.ProjectChecker model = new Model.ProjectChecker(); model.EntryTime = DateTime.Now; model.Project = item.Text; model.UserName = _model.UserName; model.UserId = _model.Id; if (_bllProjectChecker.Add(model) < 1) { MessageBoxEx.Show(text: "修改失败!"); return; } } if (userChecked == null || userChecked.Count <= 0) { continue; } if (!item.Checked && userChecked.Contains(item.Text)) //原来有现在没有 { if (!_bllProjectChecker.Delete(_model.UserName, item.Text)) { MessageBoxEx.Show(text: "修改失败!"); return; } } } if (!_bllAuthUser.Update(_model)) { MessageBoxEx.Show("更新失败,请稍后重试!"); return; } MessageBoxEx.Show("更新成功!"); _updateDel(_curPage); this.DialogResult = DialogResult.OK; this.Close(); if (GlobalUtils.LoginUser.Account == _model.Account) //修改的自己的账号重启程序 { MessageBoxEx.Show("修改了自己的信息,即将重启系统!"); GlobalUtils.StartExe(Application.ExecutablePath); Application.ExitThread(); } } else //新增 { if (GlobalUtils.LoginUser.UserLevel != 0) { MessageBoxEx.Show("只有管理员才有权限添加用户!"); return; } var existedModel = _bllAuthUser.GetModelList(string.Format(" UserName='******' or Account='{1}' ", txtUserName.Text, txtAccount.Text)); if (existedModel != null && existedModel.Count > 0) { MessageBoxEx.Show("用户名或登陆账号重复!"); return; } SteelManagement.Model.AuthUser model = new SteelManagement.Model.AuthUser(); try { model.UserName = txtUserName.Text; model.Account = txtAccount.Text; model.Password = txtPassword.Text; model.UserMobile = txtUserMobile.Text; model.Privilege = ChkBoxsToPrevilege(); model.UserLevel = GetUserLevelByRbtns(); //新增的时候不让修改审核项目 if (_bllAuthUser.Add(model) <= 0) { MessageBoxEx.Show("添加失败,请稍后重试!"); return; } MessageBoxEx.Show("添加成功"); _updateDel(_curPage); this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception) { MessageBoxEx.Show("请检查输入是否有误!"); //throw; } } }