/// <summary>
/// 连接Redis服务器
/// </summary>
/// <param name="conndetail">服务器地址信息对象</param>
/// <returns></returns>
public IDatabase connectionRedis(Conndetail conndetail)
{
ConnectionMultiplexer redisClient = ConnectionMultiplexer.Connect(conndetail.ServerHost);
IDatabase db = redisClient.GetDatabase();
return(db);
}
public SqlConnection ConnectionSQL(Conndetail conndetail)
{
SqlAction sqlAction = new SqlAction();
SqlConnection connet = sqlAction.ConneSql(conndetail);
return(connet);
}
public IDatabase ConnectionRedis(Conndetail conndetail)
{
RedisModel redis = new RedisModel();
IDatabase db = redis.connectionRedis(conndetail);
return(db);
}
public Conndetail ConnectionDb()
{
Conndetail conndetail = new Conndetail();
//conndetail.ServerHost = "10.12.2.61";
conndetail.ServerHost = "127.0.0.1";
conndetail.DBName = "TestDemo";
conndetail.DbUser = "******";
conndetail.DbPassword = "******";
return(conndetail);
}
/// <summary>
/// 连接SQL数据库的方法
/// </summary>
/// <param name="conndetail">传入连接信息：用户名，密码，数据库</param>
public SqlConnection ConneSql(Conndetail conndetail)
{
//拼接连接字符串
string connstr = String.Format($"Server={conndetail.ServerHost}; Database={conndetail.DBName}; uid={conndetail.DbUser}; pwd={conndetail.DbPassword};");
SqlConnection connection = new SqlConnection(connstr);
try
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
Console.WriteLine("数据库连接成功");
}
catch (Exception e)
{
Console.WriteLine("数据库连接异常！！！！");
Console.WriteLine(e.Message);
}
return(connection);
}
public void StartAction()
{
Connection connection = new Connection();
FunctionSQL functionSQL = new FunctionSQL();
FunctionAuthority functionAuthority = new FunctionAuthority();
Conndetail conndetail = connection.ConnectionDb();
var connSql = connection.ConnectionSQL(conndetail);
var connRedis = connection.ConnectionRedis(conndetail);
servermenu.Startmenu();
Console.Write("请选择功能：");
int code = int.Parse(Console.ReadLine());
if (code == 1)
{
Console.Clear();
FunctionFolder folder = new FunctionFolder();
Console.Write(@"输入项目文件存放的路径(如：D:\ D:\test )：");
string localpath = Console.ReadLine();
Console.Write("输入项目名称：");
string projectName = Console.ReadLine();
folder.CreateProject(localpath, projectName, connSql);
}
else if (code == 2)
{
Console.Clear();
}
else if (code == 3)
{
Console.Clear();
List <ProjectInfo> projects = functionSQL.SearchProject(connSql);
List <GroupNameInfo> groupNames = functionSQL.SearchGroupName(connSql);
Console.WriteLine("---------------------------------------------");
Console.WriteLine("项目列表");
Console.WriteLine("---------------------------------------------");
Console.WriteLine("项目编号 \t\t\t 项目名称");
Console.WriteLine("---------------------------------------------");
for (int i = 0; i < projects.Count; i++)
{
Console.WriteLine($"|{projects[i].ProjectCode}| \t\t\t |{projects[i].ProjectName}|");
}
Console.WriteLine("---------------------------------------------");
Console.WriteLine("人员列表");
Console.WriteLine("---------------------------------------------");
Console.WriteLine("小组编号 \t\t\t 小组人员");
Console.WriteLine("---------------------------------------------");
foreach (var useritem in groupNames)
{
Console.WriteLine($"|{useritem.GroupName}| \t\t\t |{useritem.UserName}|");
}
Console.WriteLine("---------------------------------------------");
while (true)
{
Console.WriteLine("---------------------------------------------");
Console.Write("输入要配置客户端访问权限的项目编号，输入'quit'结束：");
string projectCode = Console.ReadLine();
Console.WriteLine("---------------------------------------------");
if (projectCode == "quit")
{
break;
}
else
{
while (true)
{
Console.Write("输入小组编号对该小组编号进行项目访问授权,输入'end'结束：");
string groupCode = Console.ReadLine();
if (groupCode == "end")
{
break;
}
functionAuthority.AuthorityAssign(projectCode, groupCode, connRedis);
}
}
Console.WriteLine("---------------------------------------------");
functionAuthority.AuthorityAssignresult(projectCode, connRedis);
Console.WriteLine();
Console.WriteLine("---------------------------------------------");
}
//functionAuthority.AuthorityAssign()
}
else if (code == 0)
{
Environment.Exit(0);
}
else
{
Console.WriteLine("请输入正确的功能编号选择功能！");
StartAction();
}
}