public Viwer(int id) { InitializeComponent(); db = Model.DatabaseConfigure.getConfigure(); this.ForeColor = Color.Black; this.user = db.admins.Find(id); label_username.Text = this.user.name; label_role.Text = RoleManagement.CurrentRole.rolename[this.user.role]; checkBox_enabled.Checked = this.user.enabled; checkColor(); init = true; }
public int hh(Model.admin ad) { StringBuilder sql = new StringBuilder(); sql.Append("insert into admin(_admin_name,_password) values(@name,@pwd)"); SqlParameter[] par = { new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@pwd", SqlDbType.VarChar, 50) }; par[0].Value = ad.name; par[1].Value = ad.pwd; int result = Common.DbHelperSQL.ExecuteSql(sql.ToString(), par); return(result); }
private void materialButton_addnew_Click(object sender, EventArgs e) { if (betterTextBox_username.Text.Trim() == "") { CustomControls.Alert.show("Add User", "Please Enter Username", 3000); return; } if (betterTextBox_password.Text.Trim() == "" || betterTextBox_retypepassword.Text.Trim() == "") { CustomControls.Alert.show("Add User", "Password Cannot be blank", 3000); return; } if (betterTextBox_password.Text.Trim() != betterTextBox_retypepassword.Text.Trim()) { CustomControls.Alert.show("Add User", "Please Rematch the password", 3000); return; } if (comboBox_roles.SelectedIndex < 0) { CustomControls.Alert.show("Add User", "Please Select The Role", 3000); return; } var password = CustomControls.Encrypt.EncryptString(betterTextBox_password.Text.Trim(), "need12345"); var user = new Model.admin() { name = betterTextBox_username.Text.Trim(), password = password, role = comboBox_roles.SelectedIndex, updated_at = DateTime.Now, created_at = DateTime.Now, enabled = true }; db.admins.Add(user); db.SaveChanges(); add?.Invoke(user.id); betterTextBox_username.Clear(); betterTextBox_password.Clear(); betterTextBox_retypepassword.Clear(); comboBox_roles.SelectedIndex = -1; flowLayoutPanel.Controls.Add(new Viwer(user.id)); }
/// <summary> /// 根据用户名查询相关信息 /// </summary> /// <param name="Ma">实体层admin类的对象</param> /// <returns>DataSet数据集合</returns> public DataSet QueryUserInfoByName(Model.admin Ma) { return(DALad.QueryUserInfoByName(Ma.username)); }
/// <summary> /// 修改管理员密码,语句执行成功返回true,否则返回false /// </summary> /// <param name="Cid">管理员用户Cid</param> /// <param name="del_ad">实体层类的对象</param> /// <returns>true,false</returns> public bool UpdateAdminPassword(Model.admin del_ad) { string strSQL = "update admin set password='******' where cid=" + del_ad.cid; return(db.ExecuteNonQuery(false, strSQL)); }
/// <summary> /// 修改管理员用户权限,语句执行成功返回true,否则返回false /// </summary> /// <param name="Cid">管理员用户Cid</param> /// <param name="del_ad">实体层类的对象</param> /// <returns>true,false</returns> public bool UpdateAdminAleave(Model.admin del_ad) { string strSQL = "update admin set aleave='" + del_ad.aleave + "' where cid=" + del_ad.cid; return(db.ExecuteNonQuery(false, strSQL)); }
/// <summary> /// 添加管理员用户,语句执行成功返回true,否则返回false /// </summary> /// <param name="del_ad">实体层类的对象</param> /// <returns>true,false</returns> public bool AddUser(Model.admin del_ad) { string strSQL = "insert into admin (username,password,email,aleave) values ('" + del_ad.username + "','" + del_ad.password + "','" + del_ad.useremail + "','" + del_ad.aleave + "')"; return(db.ExecuteNonQuery(false, strSQL)); }
/// <summary> /// 删除用户信息,语句执行成功返回true,否则返回false /// </summary> /// <param name="del_ad">实体层类的对象</param> /// <returns>true,false</returns> public bool DeleteAdmin(Model.admin ma) { string strSQL = "delete from admin where cid=" + ma.cid; return(db.ExecuteNonQuery(false, strSQL)); }
public int insert(Model.admin ad) { DAL.dalhhh dalhh = new DAL.dalhhh(); return(dalhh.hh(ad)); }
/// <summary> /// 根据ID修改相关信息 /// </summary> /// <param name="ma">实体层admin类的对象</param> /// <returns>true,false</returns> public bool UpdateUserInfo(Model.admin ma) { string strSQL = "update admin set username='******',password='******',email='" + ma.useremail + "',aleave='" + ma.aleave + "' where cid=" + ma.cid; return(db.ExecuteNonQuery(false, strSQL)); }
/// <summary> /// 根据用户名修改用户数据 /// </summary> /// <param name="Ma">实体层admin类的对象</param> /// <returns>bool值</returns> public bool UpdateUserInfoByName(Model.admin Ma) { return(DALad.UpdateUserInfoByName(Ma.username, Ma.password, Ma.useremail)); }
/// <summary> /// 根据ID修改相关信息 /// </summary> /// <param name="ma">实体层admin类的对象</param> /// <returns>true,false</returns> public bool UpdateUserInfo(Model.admin ma) { return(DALad.UpdateUserInfo(ma)); }
/// <summary> /// 删除用户信息,语句执行成功返回true,否则返回false /// </summary> /// <returns>true,fasle</returns> public bool DeleteAdmin(Model.admin ma) { return(DALad.DeleteAdmin(ma)); }
/// <summary> /// 添加用户,语句执行成功返回true,否则返回false /// </summary> /// <param name="M_ad">实体层admin类的对象</param> /// <returns>true,false</returns> public bool AddUser(Model.admin M_ad) { return(DALad.AddUser(M_ad)); }
/// <summary> /// 返回记录总数,用户登陆的方法 /// </summary> /// <param name="Ma">实体层admin类的对象</param> /// <returns>记录行数</returns> public int ReRowCount(Model.admin Ma) { return(DALad.ReRowCount(Ma.username, Ma.password)); }
/// <summary> /// 用户用户登陆的方法 /// </summary> /// <param name="Ma">实体层admin类的对象</param> /// <returns>数据集合</returns> public DataSet UserLogin(Model.admin Ma) { return(DALad.UserLogin(Ma.username, Ma.password)); }
/// <summary> /// 检测用户名是否存在 /// </summary> /// <param name="Ma">实体层admin类的对象</param> /// <returns>整型数据</returns> public int CheckUser(Model.admin Ma) { return(DALad.CheckUser(Ma.username)); }