示例#1
0
        protected override void PageLoad()
        {
            base.PageLoad();
            base.Title = "岗位学习进度分析";
            base.CheckUserPower("ReadEMSReport", PowerCheckType.Single);

            if (CompanyID < 0)
            {
                CompanyID = base.UserCompanyID;
            }
            CompanyInfo company = CompanyBLL.ReadCompany(CompanyID);

            PostList = PostBLL.ReadPostListByPostId(company.Post);
            if (base.ExistsSonCompany)
            {
                userGroupList = AdminGroupBLL.ReadAdminGroupList(CompanyID, UserBLL.ReadUserGroupIDByCompanyID(base.SonCompanyID));
            }
            else
            {
                userGroupList = AdminGroupBLL.ReadAdminGroupList(CompanyID, UserBLL.ReadUserGroupIDByCompanyID(CompanyID.ToString()));
            }

            //用户权限组默认给考试人员
            if (string.IsNullOrEmpty(groupID))
            {
                groupID = "36";
            }

            if (Action == "Search")
            {
                ReportContentHtml = HtmlOut1(company);
            }
        }
示例#2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                int groupID = RequestHelper.GetQueryString <int>("ID");
                if (groupID != int.MinValue)
                {
                    CheckAdminPower("ReadAdminGroup", PowerCheckType.Single);
                    AdminGroupInfo adminGroup = AdminGroupBLL.Read(groupID);
                    Name.Text = adminGroup.Name;
                    Note.Text = adminGroup.Note;
                    power     = adminGroup.Power;
                }
                if (groupID == 1)
                {
                    //如果是超级管理员组则不能修改权限
                    //SubmitButton.Visible = false;
                }
            }

            //绑定权限列表
            XmlHelper xh = new XmlHelper(ServerHelper.MapPath("~/Config/AdminPower.Config"));
            XmlNode   xn = xh.ReadNode("Config");

            foreach (XmlNode temp in xn.ChildNodes)
            {
                PowerInfo power = new PowerInfo();
                power.Text = temp.Attributes["Text"].Value;
                power.Key  = temp.Attributes["Key"].Value;
                power.XML  = temp.InnerXml;
                channelPowerList.Add(power);
            }
        }
示例#3
0
        protected void SubmitButton_Click(object sender, EventArgs E)
        {
            AdminGroupInfo adminGroup = new AdminGroupInfo();

            adminGroup.ID    = RequestHelper.GetQueryString <int>("ID");
            adminGroup.Name  = this.Name.Text;
            adminGroup.Note  = this.Note.Text;
            adminGroup.State = int.Parse(this.State.Text);
            adminGroup.Power = RequestHelper.GetForm <string>("Rights").Replace(",", "|");
            if (adminGroup.Power != string.Empty)
            {
                adminGroup.Power = "|" + adminGroup.Power + "|";
            }
            string alertMessage = ShopLanguage.ReadLanguage("UpdateOK");

            if (adminGroup.ID == -2147483648)
            {
                base.CheckAdminPower("AddAdminGroup", PowerCheckType.Single);
                int id = AdminGroupBLL.AddAdminGroup(adminGroup);
                AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("AdminGroup"), id);
            }
            else
            {
                base.CheckAdminPower("UpdateAdminGroup", PowerCheckType.Single);
                AdminGroupBLL.UpdateAdminGroup(adminGroup);
                AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("AdminGroup"), adminGroup.ID);
                alertMessage = ShopLanguage.ReadLanguage("UpdateOK");
            }
            AdminBasePage.Alert(alertMessage, RequestHelper.RawUrl);
        }
示例#4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.Page.IsPostBack)
            {
                int queryString = RequestHelper.GetQueryString <int>("ID");
                if (queryString != -2147483648)
                {
                    base.CheckAdminPower("ReadAdminGroup", PowerCheckType.Single);
                    AdminGroupInfo info = AdminGroupBLL.ReadAdminGroupCache(queryString);
                    this.Name.Text  = info.Name;
                    this.Note.Text  = info.Note;
                    this.State.Text = info.State.ToString();
                    this.power      = info.Power;
                }
            }
            XmlNode node = new XmlHelper(ServerHelper.MapPath("/Config/AdminPower.Config")).ReadNode("Config");

            foreach (XmlNode node2 in node.ChildNodes)
            {
                PowerInfo item = new PowerInfo();
                item.Text = node2.Attributes["Text"].Value;
                item.Key  = node2.Attributes["Key"].Value;
                item.XML  = node2.InnerXml;
                this.channelPowerList.Add(item);
            }
        }
示例#5
0
        protected void SubmitButton_Click(object sender, EventArgs E)
        {
            AdminGroupInfo adminGroup = new AdminGroupInfo();

            adminGroup.Id    = RequestHelper.GetQueryString <int>("ID");
            adminGroup.Name  = Name.Text;
            adminGroup.Power = RequestHelper.GetForm <string>("Rights").Replace(",", "|");
            adminGroup.Note  = Note.Text;
            if (adminGroup.Power != string.Empty)
            {
                adminGroup.Power = "|" + adminGroup.Power + "|";
            }
            string alertMessage = ShopLanguage.ReadLanguage("UpdateOK");

            if (adminGroup.Id == int.MinValue)
            {
                CheckAdminPower("AddAdminGroup", PowerCheckType.Single);
                int id = AdminGroupBLL.Add(adminGroup);
                AdminLogBLL.Add(ShopLanguage.ReadLanguage("AddRecord"), ShopLanguage.ReadLanguage("AdminGroup"), id);
            }
            else
            {
                CheckAdminPower("UpdateAdminGroup", PowerCheckType.Single);
                AdminGroupInfo tmpAdminGroup = AdminGroupBLL.Read(adminGroup.Id);
                adminGroup.AdminCount = tmpAdminGroup.AdminCount;
                adminGroup.AddDate    = tmpAdminGroup.AddDate;
                adminGroup.IP         = tmpAdminGroup.IP;

                AdminGroupBLL.Update(adminGroup);
                AdminLogBLL.Add(ShopLanguage.ReadLanguage("UpdateRecord"), ShopLanguage.ReadLanguage("AdminGroup"), adminGroup.Id);
                alertMessage = ShopLanguage.ReadLanguage("UpdateOK");
            }
            ScriptHelper.Alert(alertMessage, RequestHelper.RawUrl);
        }
示例#6
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         GroupID.DataSource     = AdminGroupBLL.ReadList();
         GroupID.DataTextField  = "Name";
         GroupID.DataValueField = "ID";
         GroupID.DataBind();
         int tempAdminID = RequestHelper.GetQueryString <int>("ID");
         if (tempAdminID != int.MinValue)
         {
             CheckAdminPower("ReadAdmin", PowerCheckType.Single);
             pageAdmin = AdminBLL.Read(tempAdminID);
             if (pageAdmin.Id == 1 || pageAdmin.Name.ToLower() == "admin")
             {
                 Email.Enabled   = false;
                 GroupID.Enabled = false;
                 Status.Enabled  = false;
             }
             GroupID.Text      = pageAdmin.GroupId.ToString();
             Name.Text         = pageAdmin.Name;
             Name.Enabled      = false;
             Email.Text        = pageAdmin.Email;
             NoteBook.Text     = pageAdmin.NoteBook;
             Add.Visible       = false;
             AddStatus.Visible = true;
             Status.Text       = pageAdmin.Status.ToString();
         }
     }
 }
示例#7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!this.Page.IsPostBack)
     {
         base.CheckAdminPower("ReadAdminGroup", PowerCheckType.Single);
         base.BindControl(AdminGroupBLL.ReadAdminGroupCacheList(), this.RecordList);
     }
 }
示例#8
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         CheckAdminPower("ReadAdminGroup", PowerCheckType.Single);
         BindControl(AdminGroupBLL.ReadList(), RecordList);
     }
 }
示例#9
0
        protected void DeleteButton_Click(object sender, EventArgs e)
        {
            base.CheckAdminPower("DeleteAdminGroup", PowerCheckType.Single);
            string intsForm = RequestHelper.GetIntsForm("SelectID");

            if (intsForm != string.Empty)
            {
                AdminGroupBLL.DeleteAdminGroup(intsForm);
                AdminLogBLL.AddAdminLog(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("AdminGroup"), intsForm);
                ScriptHelper.Alert(ShopLanguage.ReadLanguage("DeleteOK"), RequestHelper.RawUrl);
            }
        }
示例#10
0
        protected void DeleteButton_Click(object sender, EventArgs e)
        {
            CheckAdminPower("DeleteAdminGroup", PowerCheckType.Single);
            string deleteID = RequestHelper.GetIntsForm("SelectID");

            string[] ids = RequestHelper.GetIntsForm("SelectID").Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
            if (ids.Length > 0)
            {
                AdminGroupBLL.Delete(Array.ConvertAll <string, int>(ids, k => Convert.ToInt32(k)));
                AdminLogBLL.Add(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("AdminGroup"), deleteID);
                ScriptHelper.Alert(ShopLanguage.ReadLanguage("DeleteOK"), RequestHelper.RawUrl);
            }
        }
示例#11
0
        protected override void PageLoad()
        {
            base.PageLoad();
            base.Title = "最小学习量达成分析表";
            base.CheckUserPower("ReadEMSReport", PowerCheckType.Single);

            if (companyID < 0)
            {
                companyID = base.UserCompanyID;
            }
            CompanyInfo company = CompanyBLL.ReadCompany(companyID);

            companyName = company.CompanyName;
            postList    = PostBLL.ReadPostListByPostId(company.Post);
            if (base.ExistsSonCompany)
            {
                userGroupList = AdminGroupBLL.ReadAdminGroupList(companyID, UserBLL.ReadUserGroupIDByCompanyID(base.SonCompanyID));
            }
            else
            {
                userGroupList = AdminGroupBLL.ReadAdminGroupList(companyID, UserBLL.ReadUserGroupIDByCompanyID(companyID.ToString()));
            }

            //设置默认岗位(去除待考岗位)
            //if (string.IsNullOrEmpty(PostIdCondition)) PostIdCondition = StringHelper.SubString(company.Post, "197");
            //if (string.IsNullOrEmpty(StudyPostIdCondition)) StudyPostIdCondition = StringHelper.SubString(company.Post, "197");
            //用户权限组默认给考试人员
            if (string.IsNullOrEmpty(groupID))
            {
                groupID = "36";
            }

            if (action == "Search")
            {
                //if (base.CompareUserPower("ManageGroupCompany", PowerCheckType.Single))
                if (!string.IsNullOrEmpty(searchCourseName))
                {
                    reportContentHtml = GetReportList();
                }
            }
        }
示例#12
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!this.Page.IsPostBack)
     {
         this.GroupID.DataSource     = AdminGroupBLL.ReadAdminGroupList();
         this.GroupID.DataTextField  = "Name";
         this.GroupID.DataValueField = "ID";
         this.GroupID.DataBind();
         int queryString = RequestHelper.GetQueryString <int>("ID");
         if (queryString != -2147483648)
         {
             base.CheckAdminPower("ReadAdmin", PowerCheckType.Single);
             AdminInfo info = AdminBLL.ReadAdmin(queryString);
             this.GroupID.Text = info.GroupID.ToString();
             this.Name.Text    = info.Name;
             this.Name.Enabled = false;
             this.Email.Text   = info.Email;
             this.Add.Visible  = false;
         }
     }
 }
示例#13
0
        /// <summary>
        /// 比较权限类的字符串
        /// </summary>
        /// <param name="powerString">比较字符串,用','隔开</param>
        /// <param name="powerCheckType">比较类型</param>
        /// <returns></returns>
        public bool CompareUserPower(string powerString, PowerCheckType powerCheckType)
        {
            string power    = AdminGroupBLL.ReadAdminGroupCache(this.UserGroupID).Power;
            bool   flag     = false;
            string powerKey = ShopConfig.ReadConfigInfo().PowerKey;

            switch (powerCheckType)
            {
            case PowerCheckType.Single:
                if (power.IndexOf("|" + powerKey + powerString + "|") > -1)
                {
                    flag = true;
                }
                break;

            case PowerCheckType.OR:
                foreach (string str2 in powerString.Split(new char[] { ',' }))
                {
                    if (power.IndexOf("|" + powerKey + str2 + "|") > -1)
                    {
                        flag = true;
                        break;
                    }
                }
                break;

            case PowerCheckType.AND:
                flag = true;
                foreach (string str2 in powerString.Split(new char[] { ',' }))
                {
                    if (power.IndexOf("|" + powerKey + str2 + "|") == -1)
                    {
                        flag = false;
                        break;
                    }
                }
                break;
            }
            return(flag);
        }
示例#14
0
        ///<summary>
        ///检查用户权限
        ///</summary>
        ///<param name="powerKey">权限的前缀</param>
        ///<param name="powerString">要检查的权限值</param>
        ///<param name="checktype">检查类型</param>
        ///<returns></returns>
        private void CheckAdminPower(string powerKey, string powerString, PowerCheckType powerCheckType, ref int adminID)
        {
            string power = AdminGroupBLL.Read(Cookies.Admin.GetGroupID(false)).Power;
            //检查权限
            bool checkPower = false;

            switch (powerCheckType)
            {
            case PowerCheckType.Single:
                if (power.IndexOf("|" + powerKey + powerString + "|") > -1)
                {
                    checkPower = true;
                }
                break;

            case PowerCheckType.OR:
                foreach (string TempPowerString in powerString.Split(','))
                {
                    if (power.IndexOf("|" + powerKey + TempPowerString + "|") > -1)
                    {
                        checkPower = true;
                        break;
                    }
                }
                break;

            case PowerCheckType.AND:
                checkPower = true;
                foreach (string TempPowerString in powerString.Split(','))
                {
                    if (power.IndexOf("|" + powerKey + TempPowerString + "|") == -1)
                    {
                        checkPower = false;
                        break;
                    }
                }
                break;

            default:
                break;
            }
            if (checkPower)
            {
                //是否需要检查具有操作别人的权限
                bool      needOther = false;
                Hashtable ht        = ReadAllNeedOther();
                foreach (DictionaryEntry dic in ht)
                {
                    if (dic.Key.ToString() == powerString)
                    {
                        needOther = Convert.ToBoolean(dic.Value);
                        if (!needOther)
                        {
                            break;
                        }
                    }
                }

                // 检查是否具有操作别人的权限
                if (needOther)
                {
                    if (power.IndexOf("|" + powerKey + "ManageOther|") > -1)
                    {
                        adminID = int.MinValue;
                    }
                    else
                    {
                        adminID = Cookies.Admin.GetAdminID(false);
                    }
                }
                else
                {
                    adminID = int.MinValue;
                }
            }
            else
            {
                adminID = -1;
            }
            if (adminID == -1)
            {
                ScriptHelper.AlertFront(ShopLanguage.ReadLanguage("NoPower"));
            }
        }
示例#15
0
        protected override void PageLoad()
        {
            base.PageLoad();
            base.Title = "最小学习量达成分析表";
            base.CheckUserPower("ReadEMSReport", PowerCheckType.Single);

            string    logPath = ServerHelper.MapPath(@"\Log\");
            TxtLog    log     = new TxtLog(logPath);
            Stopwatch time2   = new Stopwatch();

            time2.Start();

            if (CompanyID < 0)
            {
                CompanyID = base.UserCompanyID;
            }
            CompanyInfo company = CompanyBLL.ReadCompany(CompanyID);

            PostList = PostBLL.ReadPostListByPostId(company.Post);
            if (base.ExistsSonCompany)
            {
                userGroupList = AdminGroupBLL.ReadAdminGroupList(CompanyID, UserBLL.ReadUserGroupIDByCompanyID(base.SonCompanyID));
            }
            else
            {
                userGroupList = AdminGroupBLL.ReadAdminGroupList(CompanyID, UserBLL.ReadUserGroupIDByCompanyID(CompanyID.ToString()));
            }

            //设置默认岗位(去除待考岗位)
            //if (string.IsNullOrEmpty(PostIdCondition)) PostIdCondition = StringHelper.SubString(company.Post, "197");
            //if (string.IsNullOrEmpty(StudyPostIdCondition)) StudyPostIdCondition = StringHelper.SubString(company.Post, "197");
            //用户权限组默认给考试人员
            if (string.IsNullOrEmpty(groupID))
            {
                groupID = "36";
            }

            if (Action == "Search")
            {
                if (EndDate == DateTime.MinValue)
                {
                    EndDate = DateTime.Today;
                }
                EndDate = ShopCommon.SearchEndDate(EndDate);

                if (base.CompareUserPower("ManageGroupCompany", PowerCheckType.Single) && base.IsGroupCompany(company.GroupId))
                {
                    List <CompanyInfo> sonCompanyList = base.SonCompanyList;
                    //减少使用递归方法的频率
                    if (CompanyID != base.UserCompanyID)
                    {
                        sonCompanyList = CompanyBLL.ReadCompanyListByCompanyId(CompanyBLL.ReadCompanyIdList(CompanyID.ToString()));
                    }

                    GroupResult.Add(company.CompanySimpleName + "合计");
                    GroupResult.Add(0);
                    GroupResult.Add(0);
                    GroupResult.Add(0);
                    GroupResult.Add("");
                    GroupResult.Add("");
                    StringBuilder TotalTable = new StringBuilder();
                    TotalTable.AppendLine("<table class=\"evaluation_sheet\">");
                    TotalTable.AppendLine("<tr>");
                    TotalTable.AppendLine("<th colspan=\"5\">" + company.CompanySimpleName + " [" + StartDate.ToString("d") + "—" + EndDate.AddDays(-1).ToString("d") + "]");
                    TotalTable.Append("</th>");
                    TotalTable.AppendLine("</tr>");
                    TotalTable.AppendLine("<tr>");
                    TotalTable.AppendLine("<th>公司名</th>");
                    TotalTable.AppendLine("<th>参加岗位考试人数</th>");
                    TotalTable.AppendLine("<th>最小学习量<br />学习达标人数</th>");
                    TotalTable.AppendLine("<th>最小学习量<br />学习未达标人数</th>");
                    TotalTable.AppendLine("<th>最小学习量<br />学习达成率</th>");
                    TotalTable.AppendLine("</tr>");
                    foreach (CompanyInfo info in sonCompanyList)
                    {
                        if (info.CompanyId != CompanyID && !string.IsNullOrEmpty(info.PostStartDate.ToString()) && Convert.ToDateTime(info.PostStartDate) < EndDate)
                        {
                            TotalTable.Append(HtmlOut1(info, "TotalTable"));
                        }
                    }
                    TotalTable.AppendLine("<tr>");
                    TotalTable.AppendLine("<td>" + GroupResult[0] + "</td>");
                    TotalTable.AppendLine("<td>" + GroupResult[1] + "</td>");
                    TotalTable.AppendLine("<td>" + GroupResult[2] + "</td>");
                    TotalTable.AppendLine("<td>" + GroupResult[3] + "</td>");
                    TotalTable.AppendLine("<td>" + (double.Parse(GroupResult[2].ToString()) / double.Parse(GroupResult[1].ToString())).ToString("P") + "</td>");
                    TotalTable.AppendLine("</tr>");
                    TotalTable.AppendLine("</table>");
                    TotalTable.Append("<div style=\"line-height:25px; text-align:left; font-size:14px;\"><p style=\"text-align:left;  font-size:14px; line-heigh:30px; margin-top:20px;\">4S店每人每周完成1-2小时的基础学习,将带动公司提升“百年老店”运营,建议高标为100%,低标为70%。");
                    if (!string.IsNullOrEmpty(GroupResult[4].ToString()))
                    {
                        TotalTable.Append("<br /><br />目前:<span style=\"color:#00b050;\">" + GroupResult[4] + "</span> 达至 <span style=\"color:#00b050;\">100%</span> ,表现良好,予以肯定。");
                    }
                    if (!string.IsNullOrEmpty(GroupResult[5].ToString()))
                    {
                        TotalTable.Append("<br /><br /><span style=\"color:#FF0000;\">" + GroupResult[5] + "</span> 达成率尚不足 <span style=\"color:#FF0000;\">70%</span> ,请相关部门领导关注下属自主学习时间的妥善安排。");
                    }
                    TotalTable.Append("</p></div>\r\n");
                    ReportContentHtml = TotalTable.ToString();
                }
                else
                {
                    ReportContentHtml = HtmlOut1(company, "");
                }
            }

            time2.Stop();
            log.Write("总执行时间为:" + time2.Elapsed.TotalSeconds);
        }
示例#16
0
        private void CheckAdminPower(string powerKey, string powerString, PowerCheckType powerCheckType, ref int adminID)
        {
            string power = AdminGroupBLL.ReadAdminGroupCache(Cookies.Admin.GetGroupID(false)).Power;
            bool   flag  = false;

            switch (powerCheckType)
            {
            case PowerCheckType.Single:
                if (power.IndexOf("|" + powerKey + powerString + "|") > -1)
                {
                    flag = true;
                }
                break;

            case PowerCheckType.OR:
                foreach (string str2 in powerString.Split(new char[] { ',' }))
                {
                    if (power.IndexOf("|" + powerKey + str2 + "|") > -1)
                    {
                        flag = true;
                        break;
                    }
                }
                break;

            case PowerCheckType.AND:
                flag = true;
                foreach (string str2 in powerString.Split(new char[] { ',' }))
                {
                    if (power.IndexOf("|" + powerKey + str2 + "|") == -1)
                    {
                        flag = false;
                        break;
                    }
                }
                break;
            }
            if (!flag)
            {
                adminID = -1;
            }
            else
            {
                bool      flag2     = false;
                Hashtable hashtable = this.ReadAllNeedOther();
                foreach (DictionaryEntry entry in hashtable)
                {
                    if (entry.Key.ToString() == powerString)
                    {
                        flag2 = Convert.ToBoolean(entry.Value);
                        if (!flag2)
                        {
                            break;
                        }
                    }
                }
                if (flag2)
                {
                    if (power.IndexOf("|" + powerKey + "ManageOther|") > -1)
                    {
                        adminID = -2147483648;
                    }
                    else
                    {
                        adminID = Cookies.Admin.GetAdminID(false);
                    }
                }
                else
                {
                    adminID = -2147483648;
                }
            }
            if (adminID == -1)
            {
                ScriptHelper.Alert(ShopLanguage.ReadLanguage("NoPower"));
            }
        }
示例#17
0
        protected void ExcelOut1(int CompanyId)
        {
            string fileName = "Demo" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls";
            //生成Excel开始
            string FilePath = "~/xml/" + fileName;

            XlsDocument xls = new XlsDocument(); //创建空xls文档

            xls.FileName = fileName;             //保存路径,如果直接发送到客户端的话只需要名称 生成名称
            //设置指定工作页跨行跨列结束

            //创建列样式创建列时引用
            XF cellXF = xls.NewXF();

            cellXF.VerticalAlignment   = VerticalAlignments.Centered;
            cellXF.HorizontalAlignment = HorizontalAlignments.Centered;
            cellXF.Font.Height         = 24 * 12;
            cellXF.Font.Bold           = true;
            //cellXF.Pattern = 1;//设定单元格填充风格。如果设定为0,则是纯色填充
            //cellXF.PatternBackgroundColor = Colors.Red;//填充的背景底色
            //cellXF.PatternColor = Colors.Red;//设定填充线条的颜色
            //创建列样式结束

            //设置指定工作页跨行跨列
            MergeArea ma = new MergeArea(1, 1, 1, 8);//合并单元格 行与列

            //创建数据
            string sonCompanyID = CompanyBLL.ReadCompanyIdList(CompanyId.ToString());

            List <CompanyInfo> companyList = CompanyBLL.ReadCompanyListByCompanyId(sonCompanyID);

            foreach (CompanyInfo company in companyList)
            {
                Worksheet sheet = xls.Workbook.Worksheets.AddNamed(company.CompanySimpleName); //创建一个工作页为Dome
                sheet.AddMergeArea(ma);

                //创建列
                Cells cells = sheet.Cells; //获得指定工作页列集合
                //列操作基本
                Cell cell = cells.Add(1, 1, company.CompanyName, cellXF);

                //设置XY居中
                cell.HorizontalAlignment = HorizontalAlignments.Centered;
                cell.VerticalAlignment   = VerticalAlignments.Centered;
                //设置字体
                cell.Font.Bold       = true;               //设置粗体
                cell.Font.ColorIndex = 0;                  //设置颜色码
                cell.Font.FontFamily = FontFamilies.Roman; //设置字体 默认为宋体
                //创建列结束

                UserSearchInfo userSearch = new UserSearchInfo();
                userSearch.InCompanyID   = company.CompanyId.ToString();
                userSearch.StatusNoEqual = (int)UserState.Del;
                List <UserInfo> userList = UserBLL.SearchUserList(userSearch);
                int             LineNum  = 3;
                if (userList.Count > 0)
                {
                    cells.Add(2, 1, "序号");
                    cells.Add(2, 2, "姓名");
                    cells.Add(2, 3, "手机");
                    cells.Add(2, 4, "用户ID");
                    cells.Add(2, 5, "学习岗位");
                    cells.Add(2, 6, "帐户类型");
                    cells.Add(2, 7, "最近登陆时间");
                    cells.Add(2, 8, "状态");
                    foreach (UserInfo Info in userList)
                    {
                        cells.Add(LineNum, 1, LineNum - 2);
                        cells.Add(LineNum, 2, Info.RealName);
                        cells.Add(LineNum, 3, Info.Mobile);
                        cells.Add(LineNum, 4, Info.UserName);
                        cells.Add(LineNum, 5, PostBLL.ReadPost(Info.StudyPostID).PostName);
                        cells.Add(LineNum, 6, AdminGroupBLL.ReadAdminGroupCache(Info.GroupID).Name);
                        cells.Add(LineNum, 7, Info.RegisterDate == Info.LastLoginDate ? "" : Info.LastLoginDate.ToString());
                        cells.Add(LineNum, 8, EnumHelper.ReadEnumChineseName <UserState>(Info.Status));

                        LineNum = LineNum + 1;
                    }
                }
            }
            //
            //生成保存到服务器如果存在不会覆盖并且报异常所以先删除在保存新的
            //ScriptHelper.Alert(Server.MapPath("~/Demo.xls"));
            if (File.Exists(Server.MapPath(FilePath)))
            {
                File.Delete(Server.MapPath(FilePath));//删除
            }
            //保存文档
            xls.Save(Server.MapPath(FilePath)); //保存到服务器
            xls.Send();                         //发送到客户端
        }
示例#18
0
        protected void Page_Load(object sender, EventArgs e)
        {
            this.PostStart.Visible = false;
            if (!this.Page.IsPostBack)
            {
                //this.UserRegion.DataSource = RegionBLL.ReadRegionUnlimitClass();

                if (userID != -2147483648)
                {
                    base.CheckAdminPower("ReadUser", PowerCheckType.Single);

                    UserInfo info = UserBLL.ReadUser(userID);
                    companyID = info.CompanyID;
                    CompanyInfo company = CompanyBLL.ReadCompany(info.CompanyID);
                    CompanyName.Value = company.CompanyName;

                    this.GroupID.DataSource     = AdminGroupBLL.ReadAdminGroupList(companyID);
                    this.GroupID.DataTextField  = "Name";
                    this.GroupID.DataValueField = "ID";
                    this.GroupID.DataBind();
                    this.GroupID.Items.Insert(0, new ListItem("请选择管理组", "0"));

                    List <PostInfo> postList = PostBLL.ReadPostListByPostId(company.Post);
                    PostList.DataSource     = postList;
                    PostList.DataTextField  = "PostName";
                    PostList.DataValueField = "PostId";
                    PostList.DataBind();
                    PostList.Items.Insert(0, new ListItem("请选择岗位", "0"));

                    StudyPostId.DataSource     = postList;
                    StudyPostId.DataTextField  = "PostName";
                    StudyPostId.DataValueField = "PostId";
                    StudyPostId.DataBind();
                    StudyPostId.Items.Insert(0, new ListItem("请选择岗位", "0"));

                    Department.DataSource     = PostBLL.ReadPostListByPostId(PostBLL.ReadDepartmentIdStrByPostId(company.Post));
                    Department.DataTextField  = "PostName";
                    Department.DataValueField = "PostId";
                    Department.DataBind();
                    Department.Items.Insert(0, new ListItem("请选择部门", "0"));

                    this.RealName.Text         = info.RealName;
                    this.UserName.Text         = info.UserName;
                    this.GroupID.SelectedValue = info.GroupID.ToString();
                    this.UserPassword.Text     = info.UserPassword;
                    this.Email.Text            = info.Email;
                    this.Sex.Text    = info.Sex.ToString();
                    this.Tel.Text    = info.Tel;
                    this.Mobile.Text = info.Mobile;
                    this.Status.Text = info.Status.ToString();
                    this.Department.SelectedValue  = info.Department.ToString();
                    this.PostList.SelectedValue    = info.WorkingPostID.ToString();
                    this.PostName.Text             = info.PostName;
                    this.StudyPostId.SelectedValue = info.StudyPostID.ToString();
                    this.PostStartDate.Text        = info.PostStartDate.ToString("d");
                    this.PostStart.Visible         = true;
                    this.RegDate.Value             = info.RegisterDate.ToString("d");
                    //this.Introduce.Text = info.Introduce;
                    //this.Photo.Text = info.Photo;
                    //this.MSN.Text = info.MSN;
                    //this.QQ.Text = info.QQ;
                    //this.UserRegion.ClassID = info.RegionID;
                    //this.Address.Text = info.Address;
                    //this.Birthday.Text = info.Birthday;
                    //this.UserName.Enabled = false;
                    this.Add.Visible = false;
                }
            }
        }