/// <summary> /// 获取所有用户 /// </summary> /// <returns></returns> public List <Model_用户> GetAllUser() { sql = "select * from " + DBTablesName.T_USER + " where username not in ('root','admin') order by delete_mark"; List <Model_用户> list = new List <Model_用户>(); DataSet ds = db.Query(sql); if (ds != null) { DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { Model_用户 m = new Model_用户(); DataRow d = dt.Rows[i]; m.ID = Convert.ToInt32(d[0].ToString()); m.序号 = i + 1; m.用户名 = d[1].ToString(); m.真实姓名 = d[2].ToString(); m.手机号码 = d[4].ToString(); m.用户权限 = RollbackAuthority(d[5].ToString()); m.日期 = Convert.ToDateTime(d[6].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); m.用户说明 = d[7].ToString(); m.是否使用 = Convert.ToInt32(d[8].ToString()) == 0 ? "正使用" : "停用"; list.Add(m); } } return(list); }
private void Button_停用_Click(object sender, RoutedEventArgs e) { if (DataGrid_权限设置.SelectedItem != null) { Model_用户 m = DataGrid_权限设置.SelectedItem as Model_用户; if (m.是否使用.Equals("停用")) { MessageBoxCommon.Show("当前用户已经停用,请勿重复操作!"); return; } string messageBoxText = "用户停用后,将不能登录!"; string caption = "注意"; bool? result = false; result = MessageBoxDel.Show(caption, messageBoxText); if (result == false) { return; } bool flag = vm.StopUse(m.ID); if (flag) { mrc.日志 = "进行停用了用户名:" + m.用户名; vmr.Insert(mrc); FreshData(); } else { MessageBoxCommon.Show("操作失败!请联系管理员"); } } else { MessageBoxCommon.Show("请选择需要停用的用户"); } }
/// <summary> /// 设置用户数据 /// </summary> /// <returns></returns> private Model_用户 SetUserInfo() { Model_用户 m = new Model_用户(); m.ID = id; m.真实姓名 = TextBox_真实姓名.Text.Trim(); m.权限值 = ComboBox_用户权限.SelectedIndex - 1; m.用户说明 = TextBox_用户说明.Text.Trim(); return(m); }
private void InitData(int i) { Model_用户 m = new Model_用户(); m = vm.GetUserInfo(i); TextBox_用户名.Text = m.用户名; TextBox_真实姓名.Text = m.真实姓名; ComboBox_用户权限.Text = m.用户权限; TextBox_用户说明.Text = m.用户说明; }
private Model_用户 SetData() { Model_用户 m = new Model_用户(); m.用户名 = TextBox_用户名.Text.Trim(); m.密码 = Secure.TranslatePassword(TextBox_用户密码.SecurePassword); m.真实姓名 = TextBox_真实姓名.Text.Trim(); m.权限值 = ComboBox_用户权限.SelectedIndex - 1; m.创建日期 = DateTime.Now; m.用户说明 = TextBox_用户说明.Text.Trim(); return(m); }
/// <summary> /// 根据账号获取用户信息 /// </summary> /// <param name="username"></param> /// <returns></returns> public Model_用户 GetUserInfo(string username) { Model_用户 m = new Model_用户(); sql = "select * from " + DBTablesName.T_USER + " where username='******'"; DataSet ds = db.Query(sql); DataRow d = ds.Tables[0].Rows[0]; m.真实姓名 = d[2].ToString(); m.用户权限 = RollbackAuthority(d[5].ToString()); m.权限值 = Int32.Parse(d[5].ToString()); m.用户说明 = d[7].ToString(); return(m); }
/// <summary> /// 根据ID获取一个用户 /// </summary> /// <param name="id"></param> /// <returns></returns> public Model_用户 GetUserInfo(int id) { Model_用户 m = new Model_用户(); sql = "select * from " + DBTablesName.T_USER + " where userid=" + id; DataSet ds = db.Query(sql); DataRow d = ds.Tables[0].Rows[0]; m.用户名 = d[1].ToString(); m.真实姓名 = d[2].ToString(); m.用户权限 = RollbackAuthority(d[5].ToString()); m.用户说明 = d[7].ToString(); return(m); }
private void Button_修改_Click(object sender, RoutedEventArgs e) { if (DataGrid_权限设置.SelectedItem != null) { Model_用户 m = DataGrid_权限设置.SelectedItem as Model_用户; Pop.系统管理.Page_修改用户 p = new Pop.系统管理.Page_修改用户(m.ID); this.Grid_Pop弹出.Visibility = Visibility; this.Frame_系统管理_Pop.Content = p; p.CloseEvent += new Pop.系统管理.Page_系统管理_CloseEventHandle(CloseGrid); } else { MessageBoxCommon.Show("请选择需要修改的用户"); } }
private void Button_PopCommit_Click(object sender, RoutedEventArgs e) { if (ComboBox_用户权限.SelectedIndex == 0) { MessageBoxCommon.Show("请选择用户权限"); ComboBox_用户权限.Focus(); return; } Model_用户 m = SetUserInfo(); bool flag = vm.Update(m); if (flag) { _mr.日志 = "修改用户:" + m.用户名 + "相关信息"; vmr.Insert(_mr); NowClose(this, e); } else { MessageBoxCommon.Show("修改用户失败,请联系管理员!"); } }
private void Button_PopCommit_Click(object sender, RoutedEventArgs e) { if (!Validate()) { return; } Model_用户 m = SetData(); List <Model_用户> lm = new List <Model_用户>(); lm.Add(m); bool flag = vm.Insert(lm); if (flag) { _mr.日志 = "新增用户:" + m.用户名; vmr.Insert(_mr); NowClose(this, e); } else { MessageBoxCommon.Show("添加用户失败!"); } }
public bool Update(Model_用户 m) { sql = "update " + DBTablesName.T_USER + " set realname='" + m.真实姓名 + "',authority=" + m.权限值 + ",comments='" + m.用户说明 + "' where userid=" + m.ID; return(db.Excute(sql)); }