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(); } }