/// <summary>
/// 用户登录
/// </summary>
public void Login()
{
Logger.Instance.WriteLog("开始登录");
//检索个人登录信息
UserBasicDao ubdao = new UserBasicDao();
try
{
ubdao.Select001(UserName.value, Password.value);
}
catch (Exception ex)
{
Logger.Instance.WriteLog("数据库连接异常");
Message.text = "数据库连接异常,请查看output_log.txt文件查看错误原因。";
Debug.Log(ex.ToString());
return;
}
if (ubdao.Result.Count == 1)
{
if (ubdao.Result[0].Status == "正常")
{
DataStore.UserInfo = ubdao.Result[0];
//检索用户所属组
GroupDao gDao = new GroupDao();
gDao.Select002(DataStore.UserInfo.ID);
DataStore.GPInfo = gDao.Result[0];
//检索用户所属组的权限列表
GroupAuthorityDao gaDao = new GroupAuthorityDao();
gaDao.Select001(DataStore.GPInfo.Id);
//检索权限信息
AuthorityDao aDao = new AuthorityDao();
aDao.Select001();
//将用户的权限详细信息保存下来
foreach (GroupAuthorityInfo gaInfo in gaDao.Result)
{
foreach (AuthorityInfo aInfo in aDao.Result)
{
if (gaInfo.AuthorityId == aInfo.Id)
{
DataStore.AuthorityInfos.Add(aInfo);
break;
}
}
}
Logger.Instance.WriteLog("登录成功");
Message.text = "";
LoadingUI.SetActive(true);
LoadingUI.SendMessage("LoadLevel", "EditScene");
}
}
else
{
Message.text = "登录失败，用户名或密码错误。";
}
}
private async Task SetConfigDaoAsync(string authority, CancellationToken cancellationToken, ConfigDao configDao = null, string uri = null, string description = null)
{
var dao = new AuthorityDao
{
Authority = authority,
Json = (configDao == null) ? null : JsonSerializer.Serialize(configDao),
Uri = uri,
Description = description
};
await SetConfigurationAsync(dao, cancellationToken);
}
/// <summary>
/// 初始化相关信息
/// </summary>
void Start()
{
Logger.Instance.WriteLog("加载权限信息");
AuthorityDao authDao = new AuthorityDao();
authDao.Select001();
AuthorityInfos = authDao.Result;
foreach (AuthorityInfo info in AuthorityInfos)
{
GameObject go = Instantiate(AuthorityItemPrefab) as GameObject;
go.GetComponent <AuthorityItem>().SetValue(info);
Authoritys.AddChild(go.transform);
go.transform.localScale = new Vector3(1, 1, 1);
}
}
public void Login()
{
Logger.Instance.WriteLog("用户登录");
UserBasicDao ubdDao = new UserBasicDao();
if (CurrentPassword.value.Trim() == DataStore.UserInfo.Password || HasJunction == false)
{
ubdDao.Select001(NewAccount.value.Trim(), NewPassword.value.Trim());
if (ubdDao.Result.Count == 1)
{
GroupDao gpDao = new GroupDao();
gpDao.Select002(ubdDao.Result[0].ID);
if (gpDao.Result.Count == 1)
{
DataStore.UserInfo = ubdDao.Result[0];
DataStore.GPInfo = gpDao.Result[0];
//检索用户所属组的权限列表
GroupAuthorityDao gaDao = new GroupAuthorityDao();
gaDao.Select001(DataStore.GPInfo.Id);
//检索权限信息
AuthorityDao aDao = new AuthorityDao();
aDao.Select001();
DataStore.AuthorityInfos.Clear();
//将用户的权限详细信息保存下来
foreach (GroupAuthorityInfo gaInfo in gaDao.Result)
{
foreach (AuthorityInfo aInfo in aDao.Result)
{
if (gaInfo.AuthorityId == aInfo.Id)
{
DataStore.AuthorityInfos.Add(aInfo);
break;
}
}
}
Junction.GetComponent <UIButton>().normalSprite = DefaultSprite;
HasJunction = true;
LoginInfo.GetComponent <LoginInfo>().UpdateInfo();
MainMenuPanel.GetComponent <MainMenuController>().UpdateInfo();
gameObject.SetActive(false);
}
}
}
}
// make private after new interface in use
public async Task SetConfigurationAsync(AuthorityDao config, CancellationToken cancellationToken)
{
var procedure = "authconfig.pr__set_configuration";
using (var con = _connectionProvider.GetSqlConnection())
{
var parameters = new DynamicParameters();
parameters.Add("authority", config.Authority, DbType.String);
parameters.Add("json", config.Json, DbType.String);
parameters.Add("uri", config.Uri, DbType.String);
parameters.Add("description", config.Description, DbType.String);
//await con.OpenAsync(cancellationToken);
var result = await con.QueryAsync <StatusReturn>(procedure, parameters, commandType : CommandType.StoredProcedure);
}
}
/// <summary>
/// 将给定的数据进行相关设置
/// </summary>
/// <param name="AuthInfo">Auth info.</param>
public void SetValue(GroupInfo groupInfo)
{
Logger.Instance.WriteLog("初始化用户组信息");
bool notGroupManageAuth = AuthorityHelper.NotAuthority(AuthorityHelper.USER_GROUP_MANAGEMENT);
this.groupInfo = groupInfo;
//LBLGroupName.text = groupInfo.Name;
//检索当前组的权限信息
Logger.Instance.WriteLog("检索当前组的权限信息");
GroupAuthorityDao gaDao = new GroupAuthorityDao();
gaDao.Select001(groupInfo.Id);
GroupAuthorityInfos = gaDao.Result;
//检索所有权限信息
Logger.Instance.WriteLog("检索所有权限信息");
AuthorityDao authDao = new AuthorityDao();
authDao.Select001();
AuthorityInfos = authDao.Result;
//生成权限的信息
foreach (AuthorityInfo aInfo in AuthorityInfos)
{
Logger.Instance.WriteLog("生成用户组权限的信息");
bool b = false;
////选中当前组已有的权限
foreach (GroupAuthorityInfo gaInfo in GroupAuthorityInfos)
{
if (aInfo.Id == gaInfo.AuthorityId)
{
b = true;
break;
}
}
groupUI.AddAuthority(aInfo, b);
////如果当前组已经禁用或者没有管理权限，则禁用权限选中功能
//if (notGroupManageAuth)
//{
// go.GetComponent<AuthorityItem>().Disable();
//}
}
}
public AuthorityService()
{
dao = new AuthorityDao();
}
