| | |
| | | try |
| | | { |
| | | helper = new SqliteHelper(PathHelper.DatabasePath); |
| | | string sql = $"SELECT id,username,password,name From user WHERE username='{username}' and password='{password}'"; |
| | | string sql = $"SELECT id,code,username,password,name From user WHERE username='{username}' and password='{password}'"; |
| | | DataTable dt = helper.GetDataTable(sql); |
| | | if (dt == null || dt.Rows.Count <= 0) |
| | | { |
| | |
| | | } |
| | | UserInfo user = new UserInfo( |
| | | dt.Rows[0]["id"].ToString(), |
| | | dt.Rows[0]["code"].ToString(), |
| | | dt.Rows[0]["username"].ToString(), |
| | | dt.Rows[0]["name"].ToString()); |
| | | UserInfo.Login(user); |
| | |
| | | // 记住登录操作 |
| | | string userToken = |
| | | JsonUtil.Serialize( |
| | | new UserInfo(null, user.Username, user.Name, dt.Rows[0]["password"].ToString())); |
| | | new UserInfo(null, user.Code, user.Username, user.Name, dt.Rows[0]["password"].ToString())); |
| | | // 存储数据 |
| | | BinUtil.SaveStrToBin(encryptor.Encrypt(userToken), |
| | | Path.Combine(PathHelper.DatabaseFolder, "user.bin")); |