Exemplo n.º 1
0
        /// <summary>
        /// 库管员
        /// </summary>
        /// <returns></returns>
        public bool GetKG()
        {
            ECommerce.Admin.DAL.SYS_RoleInfo sysRoleDal = new ECommerce.Admin.DAL.SYS_RoleInfo();          //用户角色关系表

            bool resVisit = false;

            VerifyPage("", false);
            var user = Session["CurrentUser"] as ECommerce.Admin.Model.OrgUsers;

            if (user != null)
            {
                List <SqlParameter> parameters = new List <SqlParameter>();
                string sqlWhe    = " Role_Id in (select Role_Id from dbo.SYS_RoleInfo where Role_Name like '%库管%' or Role_Name like '%物流经理%') and UID=@UID";
                var    parameter = new SqlParameter("@UID", DbType.AnsiString);
                parameter.Value = user.UId;
                parameters.Add(parameter);
                DataSet dts = sysRoleDal.GetListAdmin(sqlWhe, parameters);
                if (dts != null)
                {
                    if (dts.Tables[0].Rows.Count > 0)
                    {
                        resVisit = true;
                    }
                }
            }
            return(resVisit);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 库管员
        /// </summary>
        /// <returns></returns>
        public bool GetKG()
        {
            ECommerce.Admin.DAL.SYS_RoleInfo sysRoleDal = new ECommerce.Admin.DAL.SYS_RoleInfo();          //用户角色关系表

            bool resVisit = false;
            VerifyPage("", false);
            var user = Session["CurrentUser"] as ECommerce.Admin.Model.OrgUsers;
            if (user != null)
            {
                List<SqlParameter> parameters = new List<SqlParameter>();
                string sqlWhe = " Role_Id in (select Role_Id from dbo.SYS_RoleInfo where Role_Name like '%库管%' or Role_Name like '%物流经理%') and UID=@UID";
                var parameter = new SqlParameter("@UID", DbType.AnsiString);
                parameter.Value = user.UId;
                parameters.Add(parameter);
                DataSet dts = sysRoleDal.GetListAdmin(sqlWhe, parameters);
                if (dts != null)
                {
                    if (dts.Tables[0].Rows.Count > 0)
                    {
                        resVisit = true;
                    }
                }
            }
            return resVisit;
        }