public bool saveRoleRelUser(RoleRelUser roleRelUser) { bool saveMark = true; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_role_reluser (uuid,role_no,user_id,op_user,create_time)"); strSql.Append("values(@uuid,@roleno,@userid,@opuser,@createtime)"); MySqlParameter[] parameters = { new MySqlParameter("@uuid", MySqlDbType.VarChar, 900), new MySqlParameter("@roleno", MySqlDbType.VarChar, 900), new MySqlParameter("@userid", MySqlDbType.VarChar, 900), new MySqlParameter("@opuser", MySqlDbType.VarChar, 900), new MySqlParameter("@createtime", MySqlDbType.VarChar, 900) }; parameters[0].Value = roleRelUser.Uuid; parameters[1].Value = roleRelUser.Roleno; parameters[2].Value = roleRelUser.Userid; parameters[3].Value = roleRelUser.Opuser; parameters[4].Value = roleRelUser.Createtime; int rows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { saveMark = true; } else { saveMark = false; } return(saveMark); }
/// <summary> /// 保存roleRelUser /// </summary> /// <param name="roleRelUser"></param> /// <returns></returns> public bool saveRoleRelUser(RoleRelUser roleRelUser) { RoleRelUser reRoleRelUser = null; roleRelUser.Uuid = Auxiliary.Get_UUID(); roleRelUser.Opuser = Auxiliary.loginName; roleRelUser.Createtime = Auxiliary.Get_CurrentTime(); return(roleRelUserDao.saveRoleRelUser(roleRelUser)); }
private void button1_Click(object sender, EventArgs e) { RoleRelUser roleRelUser = new RoleRelUser(); roleRelUser.Userid = this.textBox3.Text.ToString().Trim(); roleRelUser.Roleno = this.comboBox1.SelectedValue.ToString().Trim(); if (!roleRelUserService.checkAdd(roleRelUser)) { if (roleRelUserService.saveRoleRelUser(roleRelUser)) { this.displayList(roleRelUser.Userid); MessageBox.Show("角色分配成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("該用戶已經存在該角色!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public bool exists(RoleRelUser roleRelUser) { bool repeatJudge = false; StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from t_role_reluser where role_no=@roleNo and user_id=@userID and del_flag is null"); MySqlParameter[] parameters = { new MySqlParameter("@roleNo", MySqlDbType.VarChar, 900), new MySqlParameter("@userID", MySqlDbType.VarChar, 900), }; parameters[0].Value = roleRelUser.Roleno; parameters[1].Value = roleRelUser.Userid; int rows = int.Parse(SQLHelper.ExecuteScalar(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters).ToString().Trim()); if (rows > 0) { repeatJudge = true; } return(repeatJudge); }
/// <summary> /// 檢查該用戶角色是否存在 /// </summary> /// <param name="roleRelUser"></param> /// <returns></returns> public bool checkAdd(RoleRelUser roleRelUser) { return(roleRelUserDao.exists(roleRelUser)); }