public MethodResult <UserTdm> Login(string username, string password)
{
return(DbSessionManager.Execute <MethodResult <UserTdm> >((IDbSession sess) => {
UserTdm u = userWorker.FindByUserName(sess, username);
if (null == u || String.IsNullOrEmpty(password))
{
return MethodResult <UserTdm> .Failed("用户名或密码错误！");
}
if (u.Kind == UserKind.Virtual)
{
return MethodResult <UserTdm> .Failed("账户不存在！");
}
if (u.RowState != RowState.Normal ||
(u.Locked && u.TimeLocked > DateTime.Now))
{
return MethodResult <UserTdm> .Failed("账户已经被锁定，请稍后再试！");
}
password = password.MD5();
if (password == u.Password)
{
userWorker.SetLoginSuccess(sess, u.Id);
return MethodResult <UserTdm> .Successful(u);
}
userWorker.SetLoginFailed(sess, u.Id, u.FailCount > WebApp.PasswordFailCount);
return MethodResult <UserTdm> .Failed("用户名或密码错误！");
}));
}
public void RemoveFromRole(long userId, long roleId)
{
DbSessionManager.Execute <int>((IDbSession sess) => {
roleWorker.RemoveFromRole(sess, userId, roleId);
return(0);
});
}
public OAuthTdm FindByOpenId(OAuthKind kind, string openId)
{
return(DbSessionManager.Execute <OAuthTdm>((IDbSession sess) =>
{
return oauthWorker.FindByOpenId(sess, kind, openId);
}));
}
public void Update(OAuthTdm tdm)
{
DbSessionManager.ExecuteWithTrans <int>((IDbSession sess) =>
{
return(oauthWorker.Update(sess, tdm));
});
}
/// <summary>
/// For User,Menu And API
/// </summary>
/// <param name="sess"></param>
/// <param name="userId"></param>
/// <returns></returns>
public List <ModuleTdm> GetUserModules(long userId)
{
return(DbSessionManager.Execute <List <ModuleTdm> >((IDbSession sess) =>
{
return moduleWorker.GetUserModules(sess, userId);
}));
}
/// <summary>
/// 含MENU And API for Anonymous
/// </summary>
/// <param name="sess"></param>
/// <returns></returns>
public List <ModuleTdm> GetAnonymModules()
{
return(DbSessionManager.Execute <List <ModuleTdm> >((IDbSession sess) =>
{
return moduleWorker.GetAnonymModules(sess);
}));
}
public void Update(UserTdm user)
{
DbSessionManager.Execute <int>((IDbSession sess) => {
userWorker.Update(sess, user);
return(0);
});
}
private static void DatabaseInit()
{
//SqliteConnectionStringBuilder scb = new SqliteConnectionStringBuilder();
//scb.DataSource = AppConfig.DbFile;
////scb.Mode = SqliteOpenMode.ReadWriteCreate;
//scb.Mode = SqliteOpenMode.ReadWrite;
////配置数据库名
//optionsBuilder.UseSqlite(scb.ConnectionString);
//FbConnectionStringBuilder scb = new FbConnectionStringBuilder();
//scb.Charset = "UTF8";
//scb.Dialect = 3;
//scb.Port = 3050;
//scb.Pooling = true;
//scb.Password = "******";
//scb.ServerType = FbServerType.Default;
//scb.UserID = "sysdba";
//scb.DataSource = "127.0.0.1";
//scb.Database = AppConfig.DbFile;
//optionsBuilder.UseFirebird(scb.ConnectionString);
NpgsqlConnectionStringBuilder scb = new NpgsqlConnectionStringBuilder();
scb.Host = WebApp.DbHost;
scb.Port = WebApp.DbPort;
scb.Database = WebApp.DbName;
scb.Encoding = "utf-8";
scb.Username = WebApp.DbUser;
scb.Password = WebApp.DbPwd;
scb.Pooling = true;
DbSessionManager.Init(new PostgreSqlSessionFactory(scb));
}
//public UserTdm FindByUsername(string uname)
//{
// return DbSessionManager.Execute<UserTdm>((IDbSession sess)=>{
// return userWorker.FindByUserName(sess,uname);
// });
//}
public void Save(TextbookTdm textbook)
{
DbSessionManager.Execute <int>((IDbSession sess) =>
{
textBookWorker.Save(sess, textbook);
return(0);
});
}
public void Save(UserTdm user, List <long> roleIds)
{
DbSessionManager.ExecuteWithTrans <int>((IDbSession sess) => {
userWorker.Save(sess, user);
foreach (var i in roleIds)
{
roleWorker.AddToRole(sess, user.Id, i);
}
return(0);
});
}
public void Save(OAuthTdm tdm)
{
DbSessionManager.ExecuteWithTrans <int>((IDbSession sess) =>
{
UserTdm user = new UserTdm();
user.Id = sess.GetNextSequence("sys_user__id__seq");
user.UserName = "******" + user.Id.ToString();
user.NickName = String.IsNullOrEmpty(tdm.NickName)? user.UserName: tdm.NickName;
user.Password = "******".MD5();
// userId.Avatar = "";
user.Gender = tdm.Gender;
userWorker.Save(sess, user);
tdm.Id = sess.GetNextSequence("sys_oauth__id__seq");
tdm.UserId = user.Id;
oauthWorker.Save(sess, tdm);
roleWorker.AddToRole(sess, user.Id, WebApp.UsersRoleId);
return(0);
});
}
public List <SubjectTdm> GetAll()
{
return(DbSessionManager.Execute <List <SubjectTdm> >((IDbSession sess) => {
return subjectWorker.GetAll(sess);
}));
}
public SubjectTdm FindById(long id)
{
return(DbSessionManager.Execute <SubjectTdm>((IDbSession sess) => {
return subjectWorker.FindById(sess, id);
}));
}
public EditionTdm FindById(long id)
{
return(DbSessionManager.Execute <EditionTdm>((IDbSession sess) => {
return editionWorker.FindById(sess, id);
}));
}
public List <TextbookTdm> GetAll()
{
return(DbSessionManager.Execute <List <TextbookTdm> >((IDbSession sess) => {
return textBookWorker.GetAll(sess);
}));
}
public TextbookTdm FindById(long id)
{
return(DbSessionManager.Execute <TextbookTdm>((IDbSession sess) => {
return textBookWorker.FindById(sess, id);
}));
}
public List <EditionTdm> GetAll()
{
return(DbSessionManager.Execute <List <EditionTdm> >((IDbSession sess) => {
return editionWorker.GetAll(sess);
}));
}
public PublishTdm FindById(long id)
{
return(DbSessionManager.Execute <PublishTdm>((IDbSession sess) => {
return publishWorker.FindById(sess, id);
}));
}
public GradeTdm FindById(long id)
{
return(DbSessionManager.Execute <GradeTdm>((IDbSession sess) => {
return gradeWorker.FindById(sess, id);
}));
}
public List <PublishTdm> GetAll()
{
return(DbSessionManager.Execute <List <PublishTdm> >((IDbSession sess) => {
return publishWorker.GetAll(sess);
}));
}
public List <GradeTdm> GetAll()
{
return(DbSessionManager.Execute <List <GradeTdm> >((IDbSession sess) => {
return gradeWorker.GetAll(sess);
}));
}
public UserTdm FindByUsername(string uname)
{
return(DbSessionManager.Execute <UserTdm>((IDbSession sess) => {
return userWorker.FindByUserName(sess, uname);
}));
}
private static void DatabaseDestroy()
{
DbSessionManager.Destory();
}
public UserTdm FindById(long id)
{
return(DbSessionManager.Execute <UserTdm>((IDbSession sess) => {
return userWorker.FindById(sess, id);
}));
}
