/// <summary>
/// 打开数据库
/// </summary>
/// <returns></returns>
//public bool OpenDataBase() {
// try {
// //创建数据库连接对象
// using (SqlConnection sqlConn = new SqlConnection(SQLServer_Connector._connectString)) {
// //打开连接
// sqlConn.Open();
// sqlConn.Close();
// return true;
// }
// }
// catch {
// return false;
// }
//}
#endregion
#region 查找 ok 实际上多频道数据库仅仅是查询即可
/// <summary>
/// 根据用户唯一ID查找用户信息
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public static UserInfo query(String uid)
{
UserInfo userInfo = null;
if (uid.Length != 0)
{
//后面拼写查询语句要用到窗体的信息
SqlConnection con = new SqlConnection(SQLServer_Connector._connectString); //创建数据库连接类的对象
con.Open(); //将连接打开
SqlCommand cmd = con.CreateCommand(); //执行con对象的函数，返回一个SqlCommand类型的对象
//把输入的数据拼接成sql语句，并交给cmd对象
//cmd.CommandText = "select*from users where name='" + user + "'and pwd='" + pwd + "'";
cmd.CommandText = "select * from UserInfo where strUserID='" + uid + "'";
//用cmd的函数执行语句，返回SqlDataReader对象dr,dr就是返回的结果集（也就是数据库中查询到的表数据）
SqlDataReader dr = cmd.ExecuteReader();
var jsonStr = SQLServer_Connector.toJSONStr(dr);
userInfo = JsonConvert.DeserializeObject <UserInfo>(jsonStr);
con.Close();//用完后关闭连接，以免影响其他程序访问
}
if (userInfo == null)
{
MessageBox.Show("抱歉，未查询到用户！");
}
return(userInfo);
}
private void buttonFindFromReg_Click(object sender, EventArgs e)
{
//string _baseKey = "HARDWARE";
//string _subKey = @"Dayang\dydatabase\NetManageDBSetting";
//RegisterInfo registerInfo = new RegisterInfo("178.20.10.85", "Net2Dynetmanage2019", "sa", "lq612176()", 00000001);
//Register register = new Register(_baseKey, _subKey, registerInfo);
//RegisterInfoVO registerInfoVO = register.GetInfoFromRegedit();
string _baseKey = "HARDWARE";
string _subKey = @"Dayang\dydatabase\NetManageDBSetting";
RegisterInfo registerInfo = new RegisterInfo("178.20.10.85", "Net2Dynetmanage2019", "sa", "lq612176()", 00000001);
Auth auth = new Auth(_baseKey, _subKey, registerInfo);
RegisterInfoVO registerInfoVO = auth.authCheck(SQLServer_Connector.query("2926C8D1-D7AF-4E85-939E-AB1759F69744"));//ok，校验用户信息
//TODO 这边需要做的是将
if (registerInfoVO != null) // 人脸或者密码校验通过
{
return;
}
// 继续人脸校验或者密码校验
}
private void button4_Click(object sender, EventArgs e)
{
string _connString = "server=178.20.10.85;database=Net2Dynetmanage2019;uid=sa;pwd=lq612176()";
SQLServer_Connector con = new SQLServer_Connector(_connString);
//con.query();
}
