/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public LoginResult Login(LoginInfo info)
{
LoginResult result = new LoginResult();
result.Msg = "正在登录";
AccountInfoPara ap = new AccountInfoPara();
ap.UserName = info.UserName;
var list = AccountInfoBLL.Instance.GetModels(ap);
foreach (var item in list)
{
if (item.UserPwd == DN.Framework.Utility.EncryptHelper.GetMd5(info.UserPwd))
{
if (item.IsLock == 0)
{
result.State = true;
result.Msg = "登录成功";
result.Data = item;
}
else
{
result.State = false;
result.Msg = "用户被锁定";
result.Data = item;
}
}
}
if (list.Count == 0)
{
result.Msg = "用户名不存在。";
}
else if (list.Count != 0)
{
if (!result.State)
{
result.Msg = "用户名或密码不正确，请重新输入。";
}
}
LogLoginVO log = new LogLoginVO();
log.BrowseType = DN.Framework.Utility.ClientHelper.GetBrowseInfo();
log.ClientIp = DN.Framework.Utility.ClientHelper.ClientIP();
log.LoginDate = DateTime.Now;
log.LoginDesc = result.Msg;
log.LoginName = info.UserName;
log.LoginState = result.State ? 1 : 0;
LogLoginBLL.Instance.Add(log);
return result;
}
public override bool Edit(LogLoginVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginName", Value = ParameterHelper.ConvertValue(m.LoginName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginState", Value = ParameterHelper.ConvertValue(m.LoginState)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginDesc", Value = ParameterHelper.ConvertValue(m.LoginDesc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginDate", Value = ParameterHelper.ConvertValue(m.LoginDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientIp", Value = ParameterHelper.ConvertValue(m.ClientIp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BrowseType", Value = ParameterHelper.ConvertValue(m.BrowseType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginType", Value = ParameterHelper.ConvertValue(m.LoginType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override int InsertIdentityId(LogLoginVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginName", Value = ParameterHelper.ConvertValue(m.LoginName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginState", Value = ParameterHelper.ConvertValue(m.LoginState)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginDesc", Value = ParameterHelper.ConvertValue(m.LoginDesc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginDate", Value = ParameterHelper.ConvertValue(m.LoginDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientIp", Value = ParameterHelper.ConvertValue(m.ClientIp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BrowseType", Value = ParameterHelper.ConvertValue(m.BrowseType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginType", Value = ParameterHelper.ConvertValue(m.LoginType)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override string GetOtherConditionByModel(LogLoginVO m)
{
return("");
}
public override string GetOrderByModel(LogLoginVO m)
{
return("");
}
