/// <summary> /// 添加菜单 /// </summary> /// <param name="name">名称</param> /// <returns></returns> public int AddMenu(string name) { var sql = "insert into menus(name) values(@name)"; var nameParameter = new SqlParameter() { Value = name, ParameterName = "@name" }; return(_sqlHelper.ChangeData(sql, nameParameter)); }
/// <summary> /// 添加用户 /// </summary> /// <param name="userName">用户名</param> /// <param name="password">密码</param> /// <param name="name">名称</param> /// <returns></returns> public int AddUser(string userName, string password, string name) { var sql = $@"insert into users(username,password,name) values(@username,@password,@name)"; var userNameParameter = new SqlParameter() { Value = userName, ParameterName = "@username" }; var passwordParameter = new SqlParameter() { Value = password, ParameterName = "@password" }; var nameParameter = new SqlParameter() { Value = name, ParameterName = "@name" }; return(_sqlHelper.ChangeData(sql, userNameParameter, passwordParameter, nameParameter)); }