/// <summary> /// 添加一个用户到在线用户表 /// </summary> public bool Add(FoWoSoft.Data.Model.Users user, Guid uniqueID) { if (user == null) { return(false); } var onList = GetAll(); bool isadd = false; var onUser = onList.Find(p => p.ID == user.ID); if (onUser == null) { isadd = true; onUser = new FoWoSoft.Data.Model.OnlineUsers(); var station = new UsersRelation().GetMainByUserID(user.ID); if (station != null) { onUser.OrgName = new Organize().GetAllParentNames(station.OrganizeID); } } onUser.ID = user.ID; onUser.ClientInfo = string.Concat("操作系统:", FoWoSoft.Utility.Tools.GetOSName(), " 浏览器:", FoWoSoft.Utility.Tools.GetBrowse()); onUser.IP = FoWoSoft.Utility.Tools.GetIPAddress(); onUser.LastPage = ""; onUser.LoginTime = FoWoSoft.Utility.DateTimeNew.Now; onUser.UniqueID = uniqueID; onUser.UserName = user.Name; if (isadd) { onList.Add(onUser); } set(onList); return(true); }
protected void Page_Load(object sender, EventArgs e) { this.Account.Attributes.Add("validate_url", "CheckAccount.ashx"); FoWoSoft.Platform.Organize borganize = new FoWoSoft.Platform.Organize(); FoWoSoft.Platform.Users busers = new FoWoSoft.Platform.Users(); string id = Request.QueryString["id"]; string name = string.Empty; string account = string.Empty; string status = string.Empty; string note = string.Empty; Guid parentID; if (IsPostBack && id.IsGuid(out parentID)) { name = Request.Form["Name"]; account = Request.Form["Account"]; status = Request.Form["Status"]; note = Request.Form["Note"]; Guid userID = Guid.NewGuid(); string userXML = string.Empty; using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { //添加人员 FoWoSoft.Data.Model.Users user = new FoWoSoft.Data.Model.Users(); user.Account = account.Trim(); user.Name = name.Trim(); user.Note = note.IsNullOrEmpty() ? null : note; user.Password = busers.GetUserEncryptionPassword(userID.ToString(), busers.GetInitPassword()); user.Sort = 1; user.Status = status.IsInt() ? status.ToInt() : 0; user.ID = userID; busers.Add(user); //添加关系 FoWoSoft.Data.Model.UsersRelation userRelation = new FoWoSoft.Data.Model.UsersRelation(); userRelation.IsMain = 1; userRelation.OrganizeID = parentID; userRelation.Sort = new FoWoSoft.Platform.UsersRelation().GetMaxSort(parentID); userRelation.UserID = userID; new FoWoSoft.Platform.UsersRelation().Add(userRelation); //更新父级[ChildsLength]字段 borganize.UpdateChildsLength(parentID); //更新角色 new FoWoSoft.Platform.UsersRole().UpdateByUserID(userID); userXML = user.Serialize(); scope.Complete(); } FoWoSoft.Platform.Log.Add("添加了人员", userXML, FoWoSoft.Platform.Log.Types.组织机构); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('添加成功!');parent.frames[0].reLoad('" + id + "');window.location=window.location;", true); } this.StatusRadios.Text = borganize.GetStatusRadio("Status", "0", "validate=\"radio\""); }
public FoWoSoft.Data.Model.Users CreateNewUser(string userid) { var user = new FoWoSoft.Platform.Users().GetByAccount(userid); if (user != null) { return(user); } //根据UserId获取从远程用户信息 var userInfoEdu = new EduWebService().GetUser(userid); if (userInfoEdu == null) { return(null); } //更新用户信息 user = new FoWoSoft.Data.Model.Users() { Account = userid, ID = Guid.NewGuid(), Name = userInfoEdu.XM, Status = 0, Password = "******", Sort = 1, Note = "" }; new FoWoSoft.Platform.Users().Add(user); //创建组织关系 var guidId = new FoWoSoft.Platform.Guid_id().Get(userInfoEdu.BMBH); new FoWoSoft.Platform.UsersRelation().Add(new FoWoSoft.Data.Model.UsersRelation() { OrganizeID = guidId.GuidId, UserID = user.ID, Sort = 1, IsMain = 1 }); //更新组织下人员的个数 new FoWoSoft.Platform.Organize().UpdateChildsLength(guidId.GuidId); //创建用户角色 new FoWoSoft.Platform.UsersRole().Add(new FoWoSoft.Data.Model.UsersRole() { RoleID = Guid.Parse("0CF2ABB1-5F90-4FB3-8FA9-B53628B92879"), MemberID = user.ID, IsDefault = true }); return(user); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">FoWoSoft.Data.Model.Users实体类</param> public int Update(FoWoSoft.Data.Model.Users model) { string sql = @"UPDATE Users SET Name=@Name,Account=@Account,Password=@Password,Status=@Status,Sort=@Sort,Note=@Note WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Name", SqlDbType.NVarChar, 100) { Value = model.Name }, new SqlParameter("@Account", SqlDbType.VarChar, 255) { Value = model.Account }, new SqlParameter("@Password", SqlDbType.VarChar, 500) { Value = model.Password }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = model.Note }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">FoWoSoft.Data.Model.Users实体类</param> /// <returns>操作所影响的行数</returns> public int Add(FoWoSoft.Data.Model.Users model) { string sql = @"INSERT INTO Users (ID,Name,Account,Password,Status,Sort,Note) VALUES(@ID,@Name,@Account,@Password,@Status,@Sort,@Note)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Name", SqlDbType.NVarChar, 100) { Value = model.Name }, new SqlParameter("@Account", SqlDbType.VarChar, 255) { Value = model.Account }, new SqlParameter("@Password", SqlDbType.VarChar, 500) { Value = model.Password }, new SqlParameter("@Status", SqlDbType.Int, -1) { Value = model.Status }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = model.Note } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <FoWoSoft.Data.Model.Users> DataReaderToList(SqlDataReader dataReader) { List <FoWoSoft.Data.Model.Users> List = new List <FoWoSoft.Data.Model.Users>(); FoWoSoft.Data.Model.Users model = null; while (dataReader.Read()) { model = new FoWoSoft.Data.Model.Users(); model.ID = dataReader.GetGuid(0); model.Name = dataReader.GetString(1); model.Account = dataReader.GetString(2); model.Password = dataReader.GetString(3); model.Status = dataReader.GetInt32(4); model.Sort = dataReader.GetInt32(5); if (!dataReader.IsDBNull(6)) { model.Note = dataReader.GetString(6); } List.Add(model); } return(List); }
/// <summary> /// 更新 /// </summary> public int Update(FoWoSoft.Data.Model.Users model) { return(dataUsers.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(FoWoSoft.Data.Model.Users model) { return(dataUsers.Add(model)); }
/// <summary> /// 记录日志 /// </summary> /// <param name="err"></param> public static void Add(string title, string contents, Types type = Types.其它分类, string oldXML = "", string newXML = "", FoWoSoft.Data.Model.Users user = null) { if (user == null) { user = Platform.Users.CurrentUser; } FoWoSoft.Data.Model.Log log = new FoWoSoft.Data.Model.Log(); log.Contents = contents; log.ID = Guid.NewGuid(); log.IPAddress = FoWoSoft.Utility.Tools.GetIPAddress(); log.Others = string.Format("操作系统:{0} 浏览器:{1}", FoWoSoft.Utility.Tools.GetOSName(), FoWoSoft.Utility.Tools.GetBrowse()); log.Title = title; log.OldXml = oldXML.IsNullOrEmpty() ? null : oldXML; log.NewXml = newXML.IsNullOrEmpty() ? null : newXML; log.Type = type.ToString(); log.URL = System.Web.HttpContext.Current.Request.Url.ToString(); if (user != null) { log.UserID = user.ID; log.UserName = user.Name; } log.WriteTime = FoWoSoft.Utility.DateTimeNew.Now; Add(log); }
protected void Page_Load(object sender, EventArgs e) { FoWoSoft.Platform.Organize borganize = new FoWoSoft.Platform.Organize(); FoWoSoft.Platform.Users busers = new FoWoSoft.Platform.Users(); FoWoSoft.Platform.UsersRelation buserRelation = new FoWoSoft.Platform.UsersRelation(); FoWoSoft.Data.Model.Users user = null; FoWoSoft.Data.Model.Organize organize = null; string id = Request.QueryString["id"]; string parentID = Request.QueryString["parentid"]; string parentString = string.Empty; this.Account.Attributes.Add("validate_url", "CheckAccount.ashx?id=" + id); Guid userID, organizeID; if (id.IsGuid(out userID)) { user = busers.Get(userID); if (user != null) { //所在组织字符串 System.Text.StringBuilder sb = new System.Text.StringBuilder(); var userRelations = buserRelation.GetAllByUserID(user.ID).OrderByDescending(p => p.IsMain); foreach (var userRelation in userRelations) { sb.Append("<div style='margin:3px 0;'>"); sb.Append(borganize.GetAllParentNames(userRelation.OrganizeID, true)); if (userRelation.IsMain == 0) { sb.Append("<span style='color:#999'> [兼职]</span>"); } sb.Append("</div>"); } this.ParentString.Text = sb.ToString(); var roles = new FoWoSoft.Platform.UsersRole().GetByUserIDFromCache(userID); FoWoSoft.Platform.Role brole = new FoWoSoft.Platform.Role(); System.Text.StringBuilder rolesb = new System.Text.StringBuilder(); foreach (var role in roles) { var role1 = brole.Get(role.RoleID); if (role1 == null) { continue; } rolesb.Append(role1.Name); rolesb.Append(","); } this.RoleString.Text = rolesb.ToString().TrimEnd(','); } } if (parentID.IsGuid(out organizeID)) { organize = borganize.Get(organizeID); } if (IsPostBack) { #region 保存 if (!Request.Form["Save"].IsNullOrEmpty() && user != null) { string name = Request.Form["Name"]; string account = Request.Form["Account"]; string status = Request.Form["Status"]; string note = Request.Form["Note"]; string oldXML = user.Serialize(); user.Name = name.Trim(); user.Account = account.Trim(); user.Status = status.ToInt(1); user.Note = note.IsNullOrEmpty() ? null : note.Trim(); busers.Update(user); FoWoSoft.Platform.Log.Add("修改了用户", "", FoWoSoft.Platform.Log.Types.组织机构, oldXML, user.Serialize()); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('保存成功!');parent.frames[0].reLoad('" + parentID + "');", true); } #endregion #region 除用户 if (!Request.Form["DeleteBut"].IsNullOrEmpty() && user != null && organize != null) { using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { var urs = buserRelation.GetAllByUserID(user.ID); busers.Delete(user.ID); buserRelation.DeleteByUserID(user.ID); new FoWoSoft.Platform.UsersInfo().Delete(user.ID); new FoWoSoft.Platform.UsersRole().DeleteByUserID(user.ID); //更新父级[ChildsLength]字段 foreach (var ur in urs) { borganize.UpdateChildsLength(ur.OrganizeID); } scope.Complete(); } string refreshID = parentID; string url = string.Empty; var users = borganize.GetAllUsers(refreshID.ToGuid()); if (users.Count > 0) { url = "User.aspx?id=" + users.Last().ID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "&parentid=" + parentID; } else { refreshID = organize.ParentID == Guid.Empty ? organize.ID.ToString() : organize.ParentID.ToString(); url = "Body.aspx?id=" + parentID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "&parentid=" + organize.ParentID; } FoWoSoft.Platform.Log.Add("删除了用户", user.Serialize(), FoWoSoft.Platform.Log.Types.组织机构); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('删除成功');parent.frames[0].reLoad('" + refreshID + "');window.location='" + url + "'", true); new FoWoSoft.Platform.AppLibrary().ClearUseMemberCache(); } #endregion #region 初始化密码 if (!Request.Form["InitPass"].IsNullOrEmpty() && user != null) { string initpass = busers.GetInitPassword(); busers.InitPassword(user.ID); FoWoSoft.Platform.Log.Add("初始化了用户密码", user.Serialize(), FoWoSoft.Platform.Log.Types.组织机构); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('密码已初始化为:" + initpass + "');", true); } #endregion #region 调动 if (!Request.Form["Move1"].IsNullOrEmpty() && user != null) { string moveto = Request.Form["movetostation"]; string movetostationjz = Request.Form["movetostationjz"]; Guid moveToID; if (moveto.IsGuid(out moveToID)) { using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { var us = buserRelation.GetAllByUserID(user.ID); if ("1" != movetostationjz) { buserRelation.DeleteByUserID(user.ID); } FoWoSoft.Data.Model.UsersRelation ur = new FoWoSoft.Data.Model.UsersRelation(); ur.UserID = user.ID; ur.OrganizeID = moveToID; ur.IsMain = "1" == movetostationjz ? 0 : 1; ur.Sort = buserRelation.GetMaxSort(moveToID); buserRelation.Add(ur); foreach (var u in us) { borganize.UpdateChildsLength(u.OrganizeID); } borganize.UpdateChildsLength(organizeID); borganize.UpdateChildsLength(moveToID); scope.Complete(); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('调动成功!');parent.frames[0].reLoad('" + parentID + "');parent.frames[0].reLoad('" + moveto + "')", true); } FoWoSoft.Platform.Log.Add(("1" == movetostationjz ? "兼职" : "全职") + "调动了人员的岗位", "将人员调往岗位(" + moveto + ")", FoWoSoft.Platform.Log.Types.组织机构); new FoWoSoft.Platform.AppLibrary().ClearUseMemberCache(); } } #endregion } if (user != null) { this.Name.Value = user.Name; this.Account.Value = user.Account; this.Note.Value = user.Note; } this.StatusRadios.Text = borganize.GetStatusRadio("Status", user != null ? user.Status.ToString() : "", "validate=\"radio\""); }