/// <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));
}