コード例 #1
0
        protected void LoadUserGroup(int siteId)
        {
            var cUserGroup = new CUserGroup();

            RadComboBoxUserGroup.Text           = string.Empty;
            RadComboBoxUserGroup.DataSource     = cUserGroup.GetUserGroupList(siteId);
            RadComboBoxUserGroup.DataTextField  = "Name";
            RadComboBoxUserGroup.DataValueField = "Value";
            RadComboBoxUserGroup.DataBind();
        }
コード例 #2
0
        // POST api/usergroupapi
        public CUserGroup Post(CUserGroup value)
        {
            var user = (CSign)HttpContext.Current.Session[ConfigurationManager.AppSettings["AuthSaveKey"]];

            if (user == null)
            {
                throw new HttpResponseException(new SiginFailureMessage());
            }
            using (var dal = DalBuilder.CreateDal(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString, 0))
            {
                bool ok;
                try
                {
                    dal.Open();
                    ok = UserGroupBll.Create(dal, value, string.Format("{0}-{1}", user.UserCode, user.UserName));
                }
                catch (Exception ex)
                {
                    if (ex.Message.StartsWith("违反了 UNIQUE KEY 约束"))
                    {
                        throw new HttpResponseException(new PrimaryRepeatedMessge());
                    }
                    LogBll.Write(dal, new CLog
                    {
                        LogUser    = string.Format("{0}-{1}", user.UserCode, user.UserName),
                        LogContent = string.Format("{0}#{1}", "UserGroup.Post", ex.Message),
                        LogType    = LogType.系统异常
                    });
                    throw new HttpResponseException(new SystemExceptionMessage());
                }
                if (!ok)
                {
                    LogBll.Write(dal, new CLog
                    {
                        LogUser    = string.Format("{0}-{1}", user.UserCode, user.UserName),
                        LogContent = string.Format("新建用户组{0}-{1}", value.GroupCode, value.GroupName),
                        LogType    = LogType.操作失败
                    });
                    throw new HttpResponseException(new DealFailureMessage());
                }
                LogBll.Write(dal, new CLog
                {
                    LogUser    = string.Format("{0}-{1}", user.UserCode, user.UserName),
                    LogContent = string.Format("新建用户组{0}-{1}", value.GroupCode, value.GroupName),
                    LogType    = LogType.操作成功
                });
                dal.Close();
                return(value);
            }
        }
コード例 #3
0
        /// <summary>
        /// 删除用户组
        /// </summary>
        /// <param name="dal"></param>
        /// <param name="id"></param>
        /// <param name="hisUserGroup"></param>
        /// <returns></returns>
        public static bool Delete(IDal dal, int id, out CUserGroup hisUserGroup)
        {
            int i;

            hisUserGroup = Get(dal, id);
            if (hisUserGroup == null)
            {
                return(false);
            }

            dal.BeginTran();
            dal.Execute("UPDATE tUser SET GroupCode=null WHERE GroupCode=@GroupCode", out i,
                        dal.CreateParameter("@GroupCode", hisUserGroup.GroupCode));
            dal.Execute("DELETE FROM tUserGroupFun WHERE GroupCode=@GroupCode", out i,
                        dal.CreateParameter("@GroupCode", hisUserGroup.GroupCode));
            dal.Execute("DELETE FROM tUserGroup WHERE Id=@Id", out i,
                        dal.CreateParameter("@Id", id));
            dal.CommitTran();
            return(true);
        }
コード例 #4
0
        /// <summary>
        /// 新建用户组
        /// </summary>
        /// <param name="dal"></param>
        /// <param name="userGroup"></param>
        /// <param name="user"></param>
        /// <returns></returns>
        public static bool Create(IDal dal, CUserGroup userGroup, string user)
        {
            int i;

            dal.BeginTran();
            dal.Execute(
                "INSERT INTO tUserGroup( GroupCode ,GroupName ,BuildUser ,EditUser,GroupType) VALUES  ( @GroupCode , @GroupName,@BuildUser,@EditUser,@GroupType)",
                out i,
                dal.CreateParameter("@GroupCode", userGroup.GroupCode.Trim()),
                dal.CreateParameter("@GroupName", userGroup.GroupName.Trim()),
                dal.CreateParameter("@GroupType", (short)(userGroup.GroupType)),
                dal.CreateParameter("@BuildUser", user),
                dal.CreateParameter("@EditUser", user)
                );

            if (i == 0)
            {
                return(false);
            }
            var dt = dal.Select("SELECT Id FROM tUserGroup WHERE GroupCode =@GroupCode", out i,
                                dal.CreateParameter("@GroupCode", userGroup.GroupCode));

            if (i == 0)
            {
                return(false);
            }
            userGroup.Id = Convert.ToInt16(dt.Rows[0]["Id"]);

            foreach (var fun in userGroup.GroupFun)
            {
                fun.GroupCode = userGroup.GroupCode;
                UserGroupFunBll.Create(dal, fun, user);
            }
            dal.CommitTran();
            userGroup.Fun    = UserGroupFunBll.CountGroupFun(dal, userGroup.GroupCode);
            userGroup.People = UserBll.CountPeople(dal, userGroup.GroupCode);
            return(true);
        }
コード例 #5
0
        /// <summary>
        /// 修改用户组
        /// </summary>
        /// <param name="dal"></param>
        /// <param name="userGroup"></param>
        /// <param name="user"></param>
        /// <returns></returns>
        public static bool Update(IDal dal, CUserGroup userGroup, string user)
        {
            int i;

            dal.BeginTran();
            dal.Execute("UPDATE tUserGroup SET GroupName=@GroupName,EditUser=@EditUser,EditDate=GETDATE(),GroupType=@GroupType WHERE Id=@Id", out i,
                        dal.CreateParameter("@GroupName", userGroup.GroupName.Trim()),
                        dal.CreateParameter("@EditUser", user),
                        dal.CreateParameter("@Id", userGroup.Id),
                        dal.CreateParameter("@GroupType", userGroup.GroupType));
            if (i == 0)
            {
                return(false);
            }

            foreach (var fun in userGroup.GroupFun)
            {
                UserGroupFunBll.Update(dal, fun, user);
            }
            dal.CommitTran();
            userGroup.Fun    = UserGroupFunBll.CountGroupFun(dal, userGroup.GroupCode);
            userGroup.People = UserBll.CountPeople(dal, userGroup.GroupCode);
            return(true);
        }
コード例 #6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //http://localhost:12358/TF_WebH5/login.aspx?rUser=d3lz&rPwd=d3lz
        if (Request.Cookies["m_username"] != null)
        {
            sUserName = Request.Cookies["m_username"].Value;
            sUserName = System.Web.HttpUtility.UrlDecode(sUserName);
        }
        try
        {
            string sLoginType = "1";
            if (Request.Cookies["m_logintype"] != null)
            {
                sLoginType = Request.Cookies["m_logintype"].Value;
            }
            object sUserID = Session["m_userid"];
            if (sUserID == null)
            {
                Response.Write(BllCommon.Transferlocation());
                return;
            }
            if (!IsPostBack)
            {
                //获取车组
                if (sLoginType == "1")
                {
                    DataSet          ds          = BllVehicle.GetVehGroupFromLogin(Convert.ToInt32(sUserID));
                    List <CVehGroup> lstVehGroup = new List <CVehGroup>();
                    Hashtable        htGroupPID  = new Hashtable();
                    Hashtable        htGroupID   = new Hashtable();
                    if (ds != null && ds.Tables.Count > 0)
                    {
                        foreach (DataRow dr in ds.Tables[0].Rows)
                        {
                            string id  = "G" + dr["VehGroupID"];
                            string PID = "G" + dr["fVehGroupID"];
                            if (!htGroupPID.ContainsKey(PID))
                            {
                                htGroupPID.Add(PID, id);
                            }
                            if (!htGroupID.ContainsKey(id))
                            {
                                htGroupID.Add(id, PID);
                            }
                        }
                        foreach (DataRow dr in ds.Tables[0].Rows)
                        {
                            CVehGroup vehGroup = new CVehGroup();
                            vehGroup.id       = "G" + dr["VehGroupID"];
                            vehGroup.name     = dr["VehGroupName"].ToString();
                            vehGroup.PID      = "G" + dr["fVehGroupID"];
                            vehGroup.HasChild = 0;
                            vehGroup.Root     = 0;
                            if (htGroupPID.ContainsKey(vehGroup.id))
                            {
                                vehGroup.HasChild = 1;
                            }
                            if (!htGroupID.ContainsKey(vehGroup.PID))
                            {
                                vehGroup.Root = 1;
                            }
                            lstVehGroup.Add(vehGroup);
                        }
                    }
                    string json5 = JsonHelper.SerializeObject(lstVehGroup);
                    sVehGroup = json5;

                    //获取用户信息
                    int     iGroupID    = -1;
                    DataSet dsUserGroup = BllVehicle.GetUserGroupFromLogin(Convert.ToInt32(sUserID));
                    if (dsUserGroup == null || dsUserGroup.Tables.Count == 0 || dsUserGroup.Tables[0].Rows.Count == 0)
                    {
                        CUserGroup cModel = new CUserGroup();
                        cModel.HasChild = 0;
                        cModel.id       = "U_User";
                        cModel.name     = "用户管理";
                        cModel.PID      = "";
                        cModel.Root     = 1;
                        List <CUserGroup> lstUserGroup = new List <CUserGroup>();
                        lstUserGroup.Add(cModel);
                        string jsonUserGroup = JsonHelper.SerializeObject(lstUserGroup);
                        sUserGroup = jsonUserGroup;
                    }
                    else
                    {
                        List <CUserGroup> lstUserGroup = new List <CUserGroup>();
                        CUserGroup        cModel       = new CUserGroup();
                        cModel.HasChild = 0;
                        cModel.id       = "M_User";
                        cModel.name     = "用户管理";
                        cModel.PID      = "";
                        cModel.Root     = 1;
                        lstUserGroup.Add(cModel);
                        foreach (DataRow dr in dsUserGroup.Tables[0].Rows)
                        {
                            cModel          = new CUserGroup();
                            cModel.HasChild = 0;
                            iGroupID        = Convert.ToInt32(dr["UserGroupID"]);
                            cModel.id       = "U" + dr["UserGroupID"].ToString();
                            cModel.name     = dr["UserGroupName"].ToString();
                            cModel.PID      = "M_User";
                            cModel.Root     = 1;
                            lstUserGroup.Add(cModel);
                        }
                        string jsonUserGroup = JsonHelper.SerializeObject(lstUserGroup);
                        sUserGroup = jsonUserGroup;
                    }
                    //获取用户
                    DataSet dsUser = BllVehicle.GetUserFromLogin(Convert.ToInt32(sUserID), iGroupID);
                    if (dsUser == null || dsUser.Tables.Count == 0 || dsUser.Tables[0].Rows.Count == 0)
                    {
                        List <CUser> lstUser  = new List <CUser>();
                        string       jsonUser = JsonHelper.SerializeObject(lstUser);
                        sUser = jsonUser;
                    }
                    else
                    {
                        List <CUser> lstUser = new List <CUser>();
                        foreach (DataRow dr in dsUser.Tables[0].Rows)
                        {
                            if (sUserID.Equals(dr["UserID"].ToString()))
                            {
                                sUserType = dr["UserTypeID"].ToString();
                                break;
                            }
                        }
                        foreach (DataRow dr in dsUser.Tables[0].Rows)
                        {
                            if (sUserType == "1" || sUserID.Equals(dr["UserID"].ToString()))
                            {
                                CUser cModel = new CUser();
                                cModel.HasChild = 0;
                                cModel.id       = "R" + dr["UserID"].ToString();
                                cModel.name     = dr["UserName"].ToString();
                                cModel.PID      = "U" + dr["UserGroupID"].ToString();
                                lstUser.Add(cModel);
                            }
                        }
                        string jsonUser = JsonHelper.SerializeObject(lstUser);
                        sUser = jsonUser;
                    }
                }
                else
                {
                    List <CVehGroup> lstVehGroup = new List <CVehGroup>();
                    CVehGroup        vehGroup    = new CVehGroup();
                    vehGroup.id       = "G0";
                    vehGroup.name     = "我的车辆";
                    vehGroup.PID      = "G-1";
                    vehGroup.HasChild = 0;
                    vehGroup.Root     = 1;
                    lstVehGroup.Add(vehGroup);
                    string json5 = JsonHelper.SerializeObject(lstVehGroup);
                    sVehGroup = json5;
                }
            }
        }
        catch (Exception Exception)
        {
        }
    }