private void AddData(HttpContext context)
{
var stuModel = new Models.Student();
stuModel.StudentId = Guid.NewGuid();
SetModelValue(stuModel, context);
stuModel.CreateTime = DateTime.Now;
stuModel.LastModifyTime = DateTime.Now;
var stuBll = new BLL.Student();
var result = false;
var msg = "";
try
{
var sysUserMo = new Models.SysUser();
var sysuserbll = new BLL.SysUser();
sysUserMo.UserRole = (int) EnumUserRole.Student;
sysUserMo.UserName = stuModel.StuName;
sysUserMo.UserId = stuModel.StudentId;
sysUserMo.UserPassWord = stuBll.GetPwd();
sysUserMo.UserAccount = stuBll.GetStuAccount();
sysuserbll.Add(sysUserMo);
result = stuBll.Add(stuModel);
if (!result)
{
msg = "保存失败！";
}
}
catch (Exception ex)
{
LogHelper.WriteLogofExceptioin(ex);
result = false;
msg = ex.Message;
}
// var str = JsonConvert.SerializeObject(new { success = result, errorMsg = msg});
context.Response.Write(msg);
}
public void Remove(Models.SysUser item)
{
DbCommand comm = this.GetCommand("SysUser_Delete");
comm.AddParameter <string>(this.Factory, "Username", item.Username);
DataTable dt = this.GetTable(comm);
this.SafeExecuteNonQuery(comm);
}
public Models.SysUser Get(Models.SysUser dummy)
{
DbCommand comm = this.GetCommand("SysUser_Get");
comm.AddParameter <string>(this.Factory, "Username", dummy.Username);
DataTable dt = this.GetTable(comm);
return(EntityBase.ParseListFromTable <SysUser>(dt).FirstOrDefault());
}
public void Add(Models.SysUser item)
{
DbCommand comm = this.GetCommand("SysUser_Insert");
comm.AddParameter <string>(this.Factory, "Username", item.Username);
comm.AddParameter <string>(this.Factory, "Fullname", item.Fullname);
comm.AddParameter <string>(this.Factory, "Password", item.Password);
comm.AddParameter <string>(this.Factory, "PasswordSalt", item.PasswordSalt);
comm.AddParameter <bool>(this.Factory, "Active", item.Active);
comm.AddParameter <bool>(this.Factory, "SysAdmin", item.SysAdmin);
this.SafeExecuteNonQuery(comm);
}
private IUserViewModel getUserList()
{
if (Session[SessionEnum.UserViewModel] != null)
{
viewModelProp = (UserViewModel)Session[SessionEnum.UserViewModel];
}
IList <Models.SysUser> userList = new List <Models.SysUser>();
string xmlFile = Server.MapPath("~/Domain/Users.xml");
XmlDocument doc = new XmlDocument();
doc.Load(xmlFile);
string emailAddress = string.Empty;
string password = string.Empty;
string firstName = string.Empty;
string lastName = string.Empty;
Models.SysUser user = null;
viewModelProp.sysUsers = userList;
XmlNodeList nodes = doc.GetElementsByTagName("User");
//Deserialize xml file into IList<Models.SysUser>
foreach (XmlNode node in nodes)
{
//create user and add to users collection...
emailAddress = node.Attributes["EmailAddress"].Value;
password = node.Attributes["Password"].Value;
firstName = node.Attributes["FirstName"].Value;
lastName = node.Attributes["LastName"].Value;
user = new Models.SysUser
{
EmailAddress = emailAddress,
Password = password,
FirstName = firstName,
LastName = lastName
};
userList.Add(user);
}
return(viewModelProp);
}
ActionResult InitLogin(Models.SysUser user, string url)
{
if (user.Freezed)
{
return(LoginFailure(5, webUILang.LoginError_UserForzen));
}
CurrentTenant = _tenantManager.GetTenantById(1);
if (CurrentTenant == null || CurrentTenant.Status == 1)
{
return(LoginFailure(2, webUILang.WebSiteClose));
}
if (CurrentTenant.ExpiredTime < DateTime.Now)
{
return(LoginFailure(6, webUILang.WeiSiteTimeOut));
}
CurrentUser = user;
//查数据库
// var rolePermissions = _roleManager.GetUserPermissionIds(user.UserId).ToArray();
var permissionIds = RetechWing.BusinessCache.SystemCache.Instance.UserPermissions(user.UserId, _roleManager.GetUserPermissionIds);
SiteConfig = SystemCache.Instance.TenantConf(user.TenantId);
if (!permissionIds.Any())
{
return(LoginFailure(6, webUILang.UserHaveNotRight));
}
user.LoginFailure = 0;
_userManager.UpdateUser(user);
SampleLoginLog.AddLoginLog(user);
#region 积分
IntegrationManager.Instence.FireIntegrationEvent(IntegrationEvents.Login, CurrentUser.UserId, CurrentTenant.TenantId);
#endregion
return(RedirectUrl(url));
}
public void Update(Models.SysUser @new, Models.SysUser old)
{
var item = @new;
item.Username = old.Username;
DbCommand comm = this.GetCommand("SysUser_Update");
comm.AddParameter <string>(this.Factory, "Username", item.Username);
comm.AddParameter <string>(this.Factory, "Fullname", item.Fullname);
comm.AddParameter <string>(this.Factory, "Password", item.Password);
comm.AddParameter <string>(this.Factory, "PasswordSalt", item.PasswordSalt);
comm.AddParameter <bool>(this.Factory, "Active", item.Active);
comm.AddParameter <bool>(this.Factory, "SysAdmin", item.SysAdmin);
this.SafeExecuteNonQuery(comm);
}
private void AddData(HttpContext context)
{
var sysUserModel = new Models.SysUser();
sysUserModel.UserId = Guid.NewGuid();
SetModelValue(sysUserModel, context);
sysUserModel.CreateTime = DateTime.Now;
var sysUserBll = new BLL.SysUser();
var result = false;
var msg = "";
try
{
if (sysUserBll.GetAccountExsist(sysUserModel.UserAccount, sysUserModel.UserId))
{
msg = "该账号已存在，请修改！";
}
else
{
result = sysUserBll.Add(sysUserModel);
if (!result)
{
msg = "保存失败！";
}
}
}
catch (Exception ex)
{
LogHelper.WriteLogofExceptioin(ex);
result = false;
msg = ex.Message;
}
// var str = JsonConvert.SerializeObject(new { success = result, errorMsg = msg});
context.Response.Write(msg);
}
private IUserViewModel getUserList()
{
if (Session[SessionEnum.UserViewModel] != null)
{
viewModelProp = (UserViewModel)Session[SessionEnum.UserViewModel];
}
IList<Models.SysUser> userList = new List<Models.SysUser>();
string xmlFile = Server.MapPath("~/Domain/Users.xml");
XmlDocument doc = new XmlDocument();
doc.Load(xmlFile);
string emailAddress = string.Empty;
string password = string.Empty;
string firstName = string.Empty;
string lastName = string.Empty;
Models.SysUser user = null;
viewModelProp.sysUsers = userList;
XmlNodeList nodes = doc.GetElementsByTagName("User");
//Deserialize xml file into IList<Models.SysUser>
foreach (XmlNode node in nodes)
{
//create user and add to users collection...
emailAddress = node.Attributes["EmailAddress"].Value;
password = node.Attributes["Password"].Value;
firstName = node.Attributes["FirstName"].Value;
lastName = node.Attributes["LastName"].Value;
user = new Models.SysUser
{
EmailAddress = emailAddress,
Password = password,
FirstName = firstName,
LastName = lastName
};
userList.Add(user);
}
return viewModelProp;
}
/// <summary>
/// Installs and seeds the database.
/// </summary>
/// <param name="username">The admin username</param>
/// <param name="password">The admin password</param>
/// <param name="email">The admin email</param>
public static void Install(string username, string password, string email)
{
// Read embedded create script
Stream str = Assembly.GetExecutingAssembly().GetManifestResourceStream(Database.ScriptRoot + ".Create.sql");
String sql = new StreamReader(str).ReadToEnd();
str.Close();
// Read embedded data script
str = Assembly.GetExecutingAssembly().GetManifestResourceStream(Database.ScriptRoot + ".Data.sql");
String data = new StreamReader(str).ReadToEnd();
str.Close();
// Split statements and execute
string[] stmts = sql.Split(new char[] { ';' });
using (IDbTransaction tx = Database.OpenTransaction()) {
// Create database from script
foreach (string stmt in stmts)
{
if (!String.IsNullOrEmpty(stmt.Trim()))
{
Models.SysUser.Execute(stmt, tx);
}
}
tx.Commit();
}
// Split statements and execute
stmts = data.Split(new char[] { ';' });
using (IDbTransaction tx = Database.OpenTransaction()) {
// Create user
Models.SysUser usr = new Models.SysUser()
{
Login = username,
Email = email,
GroupId = new Guid("7c536b66-d292-4369-8f37-948b32229b83"),
Created = DateTime.Now,
Updated = DateTime.Now
};
usr.Save(tx);
// Create user password
Models.SysUserPassword pwd = new Models.SysUserPassword()
{
Id = usr.Id,
Password = password,
IsNew = false
};
pwd.Save(tx);
// Create default data
foreach (string stmt in stmts)
{
if (!String.IsNullOrEmpty(stmt.Trim()))
{
Models.SysUser.Execute(stmt, tx);
}
}
tx.Commit();
// Fire installed event
if (OnInstalled != null)
{
OnInstalled();
}
}
}
/// <summary>
/// Installs and seeds the database.
/// </summary>
/// <param name="username">The admin username</param>
/// <param name="password">The admin password</param>
/// <param name="email">The admin email</param>
public static void Install(string username, string password, string email) {
// Read embedded create script
Stream str = Assembly.GetExecutingAssembly().GetManifestResourceStream(Database.ScriptRoot + ".Create.sql") ;
String sql = new StreamReader(str).ReadToEnd() ;
str.Close() ;
// Read embedded data script
str = Assembly.GetExecutingAssembly().GetManifestResourceStream(Database.ScriptRoot + ".Data.sql") ;
String data = new StreamReader(str).ReadToEnd() ;
str.Close() ;
// Split statements and execute
string[] stmts = sql.Split(new char[] { ';' }) ;
using (IDbTransaction tx = Database.OpenTransaction()) {
// Create database from script
foreach (string stmt in stmts) {
if (!String.IsNullOrEmpty(stmt.Trim()))
Models.SysUser.Execute(stmt, tx) ;
}
tx.Commit() ;
}
// Split statements and execute
stmts = data.Split(new char[] { ';' }) ;
using (IDbTransaction tx = Database.OpenTransaction()) {
// Create user
Models.SysUser usr = new Models.SysUser() {
Login = username,
Email = email,
GroupId = new Guid("7c536b66-d292-4369-8f37-948b32229b83"),
Created = DateTime.Now,
Updated = DateTime.Now
} ;
usr.Save(tx) ;
// Create user password
Models.SysUserPassword pwd = new Models.SysUserPassword() {
Id = usr.Id,
Password = password,
IsNew = false
} ;
pwd.Save(tx) ;
// Create default data
foreach (string stmt in stmts) {
if (!String.IsNullOrEmpty(stmt.Trim()))
Models.SysUser.Execute(stmt, tx) ;
}
tx.Commit() ;
// Fire installed event
if (OnInstalled != null)
OnInstalled();
}
}
