コード例 #1
0
ファイル: Group.cs プロジェクト: bertyang/SimpleFlow
        /// <summary>
        /// 设定群组对应的用户
        /// </summary>
        /// <param name="groupID"></param>
        /// <param name="empIDList"></param>
        public static void SetGroupUsers(string groupID, List <string> empIDList)
        {
            SqlConnection conn = new SqlConnection(Config.ConnectionString);

            try
            {
                conn.Open();
                SqlTransaction trans = conn.BeginTransaction();
                try
                {
                    SqlHelper.DeleteTable <SysGroupUser>(trans, ColumnFilterList.New("group_id", groupID));

                    //insert group_users
                    foreach (string empID in empIDList)
                    {
                        SysGroupUser entity = new SysGroupUser(groupID, empID);
                        SqlHelper.Insert(trans, entity);
                    }

                    trans.Commit();
                }
                catch (Exception ex)
                {
                    trans.Rollback();
                    throw ex;
                }
            }
            finally
            {
                conn.Close();
            }
        }
コード例 #2
0
 public ActionResult SaveGroupUser(int groupId, string user)
 {
     try
     {
         string[] listUserId = user.Split(',');
         if (listUserId.Length > 0)
         {
             for (int i = 0; i < listUserId.Length; i++)
             {
                 var model = new SysGroupUser();
                 model.CreatedBy   = WebSecurity.CurrentUserId;
                 model.CreatedDate = DateTime.Now;
                 model.GroupId     = groupId;
                 model.Orders      = 2;
                 model.UserId      = CommonHelper.Convert.ConvertToInt32(listUserId[i]);
                 model.UsedState   = Ultity.Constant.Active;
                 _sysGroupUserAction.Add(model);
             }
         }
         return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = string.Empty }));
     }
     catch (Exception exception)
     {
         Ultity.TFunction.WriteToLog(exception);
         return(Json(new
         {
             status = "fail",
             Message = Ultity.Constant.Ajax_Fail
         }));
     }
 }
コード例 #3
0
 public string RemoveUser(string OrgID, string Ids)
 {
     if (string.IsNullOrEmpty(OrgID))
     {
         return("0");
     }
     string[] idList = JsonConvert.DeserializeObject <string[]>(Ids);
     if (idList != null && idList.Length > 0)
     {
         SysGroupUser.DoBatchDelete(OrgID, idList);//* OrgID:组织结构ID
     }
     return("1");
 }
コード例 #4
0
ファイル: SysGroupUserAction.cs プロジェクト: ngotrog1507/HiE
        public int Update(SysGroupUser sysGroupUser)
        {
            return
                ((int)
                 SqlHelper.ExecuteScalar(
                     SqlConnection, CommonHelper.Config.GetFullyQualifiedName("SysGroupUser_Update"),

                     sysGroupUser.Id, sysGroupUser.GroupId, sysGroupUser.UserId, sysGroupUser.Orders,
                     sysGroupUser.UsedState,
                     CommonHelper.Null.GetNull(sysGroupUser.CreatedDate),
                     CommonHelper.Null.GetNull(sysGroupUser.CreatedBy),
                     sysGroupUser.ModifiedDate,
                     sysGroupUser.ModifiedBy));
        }
コード例 #5
0
ファイル: SysGroupUserAction.cs プロジェクト: ngotrog1507/HiE
        public int Add(SysGroupUser sysGroupUser)
        {
            var deciResult =
                (decimal)
                SqlHelper.ExecuteScalar(SqlConnection, CommonHelper.Config.GetFullyQualifiedName("SysGroupUser_Insert"),
                                        sysGroupUser.GroupId, sysGroupUser.UserId, sysGroupUser.Orders,
                                        sysGroupUser.UsedState,
                                        sysGroupUser.CreatedDate,
                                        sysGroupUser.CreatedBy,
                                        CommonHelper.Null.GetNull(sysGroupUser.ModifiedDate),
                                        CommonHelper.Null.GetNull(sysGroupUser.ModifiedBy));

            return(CommonHelper.Convert.ConvertToInt32(deciResult));
        }
コード例 #6
0
        protected void RefreshData(object sender, StoreReadDataEventArgs e)
        {
            int start    = e.Start;
            int pageSize = e.Limit;
            int total    = 0;

            //查询条件
            string Where = " 1=1 ";
            string Name  = Request["UserQuery"] + "";

            Name = Name.Replace("输入姓名简拼", "");
            if (!string.IsNullOrEmpty(Name))
            {
                Where += " and SysUserName like '%" + Name + "%' or (" + GetPinyinWhereString("SysUserName", Name) + ")  ";
            }

            if (e.Parameters.GetParameter("PID") != null)
            {
                var PID = e.Parameters.GetParameter("PID").Value;
                if (PID == "root")
                {
                }
                else
                {
                    Where += " and SysGroupID='" + PID + "' ";
                    SysGroupUser[] SysOUserEnt = DataHelper.GetPageList <SysGroupUser>(start, pageSize, new Order[] { new Order("CreateTime", false) }, out total, Expression.Sql(Where));
                    e.Total = total;
                    IList <SysUser> UserList = SysGroupUser.GetUsersByEnts(SysOUserEnt);
                    foreach (var item in SysOUserEnt)
                    {
                        var ent = UserList.Where(ten => ten.ID == item.SysUserID).First();
                        if (ent != null)
                        {
                            UserList.Add(ent);
                        }
                    }
                    UserStore.Data = UserList;
                    UserStore.DataBind();
                    return;
                }
            }
            //默认情况
            SysUser[] Arr = DataHelper.GetPageList <SysUser>(start, pageSize, new Order[] { new Order("CreateTime", false) }, out total, Expression.Sql(Where));
            e.Total        = total;
            UserStore.Data = Arr;
            UserStore.DataBind();
        }
コード例 #7
0
        public string RefUserToOrg(string Json, string PID)
        {
            var OrgEnt = SysGroupOrRole.Find(PID);
            var Ents   = JSON.Deserialize <SysUser[]>(Json);

            foreach (var item in Ents)
            {
                //去除重复
                int a = SysGroupUser.GetCount(Expression.Sql("SysUserID='" + item.ID + "' and SysGroupID='" + OrgEnt.ID + "'"));
                if (a > 0)
                {
                    continue;
                }

                SysGroupUser OrgUsr = new SysGroupUser();
                OrgUsr.SysGroupID   = OrgEnt.ID;
                OrgUsr.SysGroupName = OrgEnt.GroupName;
                OrgUsr.SysUserID    = item.ID;
                OrgUsr.SysUserName  = item.Name;
                OrgUsr.DoCreate();
            }
            return("1");
        }
コード例 #8
0
        public string DeleteData(string ID)
        {
            var Ent = SysGroupOrRole.Find(ID);
            //删除相关联的数据
            var GUEnts  = SysGroupUser.FindAllByProperties(SysGroupUser.Prop_SysGroupID, Ent.ID);
            var OrgEnts = SysOrgRefGroupOrRole.FindAllByProperty(SysOrgRefGroupOrRole.Prop_GroupOrRoleID, Ent.ID);

            if (GUEnts.Length > 0)
            {
                foreach (var item in GUEnts)
                {
                    item.DoDelete();
                }
            }
            if (OrgEnts.Length > 0)
            {
                foreach (var item in OrgEnts)
                {
                    item.DoDelete();
                }
            }
            Ent.DoDelete();
            return("1");
        }
コード例 #9
0
ファイル: SysUserController.cs プロジェクト: ngotrog1507/HiE
        public ActionResult AddTeacher(SysUser sysModel)
        {
            if (sysModel.Id == 0)
            {
                sysModel.UserName = sysModel.UserName.Trim();
                sysModel.FullName = string.IsNullOrEmpty(sysModel.FullName) ? string.Empty : sysModel.FullName.Trim();
                if (!WebSecurity.UserExists(sysModel.UserName))
                {
                    try
                    {
                        //Create User Membership
                        if (AuthorizeUser.IsAction(Ultity.Constant.Add) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
                        {
                            WebSecurity.CreateUserAndAccount(sysModel.UserName.Trim(), sysModel.Password.Trim());

                            //Get UserByName
                            int userId = WebSecurity.GetUserId(sysModel.UserName);
                            if (userId > 0)
                            {
                                //Create CoreSys User
                                try
                                {
                                    #region + Thêm vào bảng SysUser
                                    var model = new SysUser();
                                    model.Id          = userId;
                                    model.UserId      = userId;
                                    model.CreatedBy   = WebSecurity.CurrentUserId;
                                    model.FullName    = sysModel.FullName.Trim();
                                    model.UserName    = sysModel.UserName.Trim();
                                    model.Email       = sysModel.Email;
                                    model.ImageUrl    = sysModel.ImageUrl;
                                    model.Phone       = sysModel.Phone;
                                    model.Summary     = sysModel.Summary;
                                    model.Host        = sysModel.Host;
                                    model.Gender      = sysModel.Gender;
                                    model.BCoin       = 0;
                                    model.UsedState   = sysModel.UsedState;
                                    model.CreatedDate = DateTime.Now;
                                    _sysAction.Insert(model);
                                    #endregion

                                    #region +Thêm vào nhóm Giáo viên
                                    var sysGroupUser = new SysGroupUser();
                                    sysGroupUser.CreatedBy   = WebSecurity.CurrentUserId;
                                    sysGroupUser.CreatedDate = DateTime.Now;
                                    sysGroupUser.GroupId     = 20;
                                    sysGroupUser.Orders      = 2;
                                    sysGroupUser.UserId      = userId;
                                    sysGroupUser.UsedState   = Ultity.Constant.Active;
                                    new SysGroupUserAction().Add(sysGroupUser);
                                    #endregion
                                }
                                catch (Exception exception)
                                {
                                    ((SimpleMembershipProvider)Membership.Provider).DeleteUser(sysModel.UserName.Trim(), true);
                                    new SysAdminAction <SysUser>().Deletes("UserId=" + userId);
                                }
                            }
                            return(Json(new { status = "success" }));
                        }
                        return(Json(new { status = "error", Message = "Đã tồn tại Username này trong hệ thống !" }));
                    }
                    catch (Exception exception)
                    {
                        Ultity.TFunction.WriteToLog(exception);
                        return(Json(new { status = "error", Message = "Đã tồn tại Username này trong hệ thống !" }));
                    }
                }
                else
                {
                    return(Json(new { status = "exits", Message = "Đã tồn tại Username này trong hệ thống !" }));
                }
            }
            else
            {
                //Get User By Id
                SysUser item = _sysAction.GetById(sysModel.Id);
                if (item != null)
                {
                    if (!string.IsNullOrEmpty(sysModel.Password))
                    {
                        var token = WebSecurity.GeneratePasswordResetToken(sysModel.UserName);
                        // link directed to an action with form to capture password
                        WebSecurity.ResetPassword(token, sysModel.Password);
                    }
                    if (AuthorizeUser.IsAction(Ultity.Constant.Edit) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
                    {
                        item.ModifiedBy   = WebSecurity.CurrentUserId;
                        item.FullName     = sysModel.FullName.Trim();
                        item.Email        = sysModel.Email;
                        item.Phone        = sysModel.Phone;
                        item.Host         = sysModel.Host;
                        item.BCoin        = sysModel.BCoin;
                        item.Gender       = sysModel.Gender;
                        item.Summary      = sysModel.Summary;
                        item.ImageUrl     = sysModel.ImageUrl;
                        item.UsedState    = sysModel.UsedState;
                        item.ModifiedDate = DateTime.Now;
                        item.CreatedDate  = DateTime.Now;
                        _sysAction.Update(item);
                    }
                }
            }

            return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Fail }));
        }
コード例 #10
0
        public void Update(string BranchID,int GroupID,string UserID)
        {
            SysGroupUser item = new SysGroupUser();
            item.MarkOld();
            item.IsLoaded = true;

            item.BranchID = BranchID;

            item.GroupID = GroupID;

            item.UserID = UserID;

            item.Save(UserName);
        }
コード例 #11
0
        public void Insert(string BranchID,int GroupID,string UserID)
        {
            SysGroupUser item = new SysGroupUser();

            item.BranchID = BranchID;

            item.GroupID = GroupID;

            item.UserID = UserID;

            item.Save(UserName);
        }