Пример #1
0
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            string strId = Request.QueryString.Get("id");
            int    i     = Grid1.Rows.Count;

            ExamArrange examArrange = new ExamArrange();

            ExamBLL examBLL = new ExamBLL();

            RailExam.Model.Exam exam = examBLL.GetExam(int.Parse(strId));

            if (exam != null)
            {
                examArrange.ExamId     = int.Parse(strId);
                examArrange.PaperId    = exam.paperId;
                examArrange.UserIds    = "选择考生!";
                examArrange.JudgeIds   = "选择评卷人!";
                examArrange.BeginTime  = DateTime.Now;
                examArrange.EndTime    = DateTime.Now.AddHours(1);
                examArrange.OrderIndex = 1;
                examArrange.Memo       = "";

                ExamArrangeBLL examArrangeBLL = new ExamArrangeBLL();
                examArrangeBLL.AddExamArrange(examArrange);

                Grid1.DataBind();
            }
        }
Пример #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DataSet ds = GetDataSet();
                if (ds != null && ds.Tables.Count == 2)
                {
                    gradesGrid.DataSource = ds;
                    gradesGrid.DataBind();
                }
                else
                {
                    SessionSet.PageMessage = "数据错误!";

                    return;
                }
                string strId             = Request.QueryString.Get("eid");
                RailExam.Model.Exam exam = new RailExam.Model.Exam();
                ExamBLL             eBll = new ExamBLL();
                exam = eBll.GetExam(int.Parse(strId));
                TextBoxExamCategory.Text = exam.CategoryName;
                TextBoxExamName.Text     = exam.ExamName;
                TextBoxExamTime.Text     = exam.BeginTime.ToString() + "/" + exam.EndTime.ToString();
            }
        }
Пример #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string strId     = Request.QueryString.Get("PaperId");
            string strExamId = Request.QueryString.Get("ExamId");

            ViewState["BeginTime"] = DateTime.Now.ToString();

            ViewState["OrgID"]     = PrjPub.CurrentStudent.OrgID;
            ViewState["StudentID"] = PrjPub.StudentID;

            if (strId != null && strId != "")
            {
                try
                {
                    ExamResultBLL             examResultBLL = new ExamResultBLL();
                    RailExam.Model.ExamResult examResults   = examResultBLL.GetExamResult(int.Parse(strId), int.Parse(strExamId), PrjPub.CurrentStudent.EmployeeID);
                    if (examResults != null)
                    {
                        Response.Write("<script>alert('您已经参加过该考试!'); top.window.close();</script>");
                        return;
                    }
                }
                catch
                {
                    Pub.ShowErrorPage("无法连接路局服务器,请检查站段服务器网络连接是否正常!");
                }
                ExamBLL             examBLL = new ExamBLL();
                RailExam.Model.Exam exam    = examBLL.GetExam(int.Parse(strExamId));
                HiddenFieldExamTime.Value = DateTime.Now.AddMinutes(exam.ExamTime).ToString();
                HfExamTime.Value          = (exam.ExamTime * 60).ToString();

                FillPage(strId);
            }
        }
Пример #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ViewState["mode"] = Request.QueryString.Get("mode");
                hfMode.Value      = ViewState["mode"].ToString();

                string strId = Request.QueryString.Get("id");

                ExamBLL examBLL = new ExamBLL();

                RailExam.Model.Exam exam = examBLL.GetExam(int.Parse(strId));

                if (exam != null)
                {
                    txtPaperName.Text = exam.ExamName;
                    if (exam.paperId != 0)
                    {
                        PaperBLL paperBLL = new PaperBLL();

                        IList <RailExam.Model.Paper> paperList = paperBLL.GetPaperByPaperId(exam.paperId);

                        if (paperList != null)
                        {
                            Grid1.DataSource = paperList;
                            Grid1.DataBind();
                        }
                    }
                }
            }
            else
            {
                if (!string.IsNullOrEmpty(hfPaperId.Value))
                {
                    PaperBLL paperBLL = new PaperBLL();

                    IList <RailExam.Model.Paper> paperList = paperBLL.GetPaperByPaperId(int.Parse(hfPaperId.Value));

                    if (paperList != null)
                    {
                        Grid1.DataSource = paperList;
                        Grid1.DataBind();
                    }
                }
            }
        }
Пример #5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (PrjPub.CurrentLoginUser == null)
                {
                    Response.Redirect("/RailExamBao/Common/Error.aspx?error=Session过期请重新登录本系统!");
                    return;
                }

                if (PrjPub.IsServerCenter && SessionSet.OrganizationID != 1)
                {
                    HfUpdateRight.Value = "False";
                }
                else
                {
                    HfUpdateRight.Value = PrjPub.HasEditRight("手工评卷").ToString();
                }

                hfJudgeId.Value = PrjPub.CurrentLoginUser.EmployeeID.ToString();

                string strId = Request.QueryString.Get("eid");
                hfExamID.Value = strId;
                RailExam.Model.Exam exam = new RailExam.Model.Exam();
                ExamBLL             eBll = new ExamBLL();
                exam = eBll.GetExam(int.Parse(strId));
                TextBoxExamCategory.Text = exam.CategoryName;
                TextBoxExamName.Text     = exam.ExamName;
                TextBoxExamTime.Text     = exam.BeginTime.ToString() + "/" + exam.EndTime.ToString();
            }
            else
            {
                papersGrid.DataBind();
            }


            string strRefresh = Request.Form.Get("Refresh");

            if (strRefresh != null && strRefresh != "")
            {
                papersGrid.DataBind();
            }
        }
Пример #6
0
        protected void ButtonSave_Click(object sender, ImageClickEventArgs e)
        {
            string strId = Request.QueryString.Get("id");

            string strEndId = "";

            for (int i = 0; i < this.Grid2.Rows.Count; i++)
            {
                string strEmId = ((Label)this.Grid2.Rows[i].FindControl("LabelEmployeeID")).Text;

                if (strEndId.Length == 0)
                {
                    strEndId += strEmId;
                }
                else
                {
                    strEndId += "," + strEmId;
                }
            }

            if (strEndId == "" || strEndId == "0")
            {
                SessionSet.PageMessage = "请选择考生!";
                return;
            }

            int     PaperId = 0;
            ExamBLL examBLL = new ExamBLL();

            RailExam.Model.Exam exam = examBLL.GetExam(int.Parse(strId));
            if (exam != null)
            {
                PaperId = exam.paperId;
            }

            if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "0")
            {
                ExamArrange examArrange = new ExamArrange();
                examArrange.ExamId     = int.Parse(strId);
                examArrange.PaperId    = PaperId;
                examArrange.UserIds    = strEndId;
                examArrange.JudgeIds   = "1";
                examArrange.BeginTime  = DateTime.Now;
                examArrange.EndTime    = DateTime.Now;
                examArrange.OrderIndex = 1;
                examArrange.Memo       = "";
                ExamArrangeBLL examArrangeBLL = new ExamArrangeBLL();
                examArrangeBLL.AddExamArrange(examArrange);
                ViewState["UpdateMode"] = 1;
                SessionSet.PageMessage  = "保存成功!";
                return;
            }

            if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "1")
            {
                ExamArrangeBLL examArrangeBLL = new ExamArrangeBLL();
                examArrangeBLL.UpdateExamUser(int.Parse(strId), strEndId);
                SessionSet.PageMessage = "保存成功!";
                return;
            }
        }
Пример #7
0
        protected void btnOutPut_Click(object sender, ImageClickEventArgs e)
        {
            DataSet   ds = GetDataSet();
            DataTable dt = ds.Tables[0];

            int    orgID   = Convert.ToInt32(Request.QueryString.Get("OrgID"));
            string OrgName = "";

            if (orgID != 1)
            {
                OrganizationBLL orgBll = new OrganizationBLL();
                Organization    org    = orgBll.GetOrganization(orgID);
                OrgName = org.ShortName;
            }

            string  strExamName = "";
            string  strExamTime = "";
            string  qsExamId    = Request.QueryString.Get("eid");
            ExamBLL examBll     = new ExamBLL();

            RailExam.Model.Exam exam = examBll.GetExam(int.Parse(qsExamId));
            if (exam != null)
            {
                strExamName = exam.ExamName;
                strExamTime = exam.BeginTime.ToString() + "--" + exam.EndTime.ToString();
            }

            SpreadsheetClass xlsheet = new SpreadsheetClass();
            Worksheet        ws      = (Worksheet)xlsheet.Worksheets[1];

            ws.Cells.Font.set_Size(10);
            ws.Cells.Font.set_Name("宋体");

            ws.Cells[1, 1] = PrjPub.GetRailName() + OrgName;
            Range rang1 = ws.get_Range(ws.Cells[1, 1], ws.Cells[2, 13]);

            rang1.set_MergeCells(true);
            rang1.set_HorizontalAlignment(XlHAlign.xlHAlignCenter);
            rang1.Font.set_Bold(true);
            rang1.Font.set_Size(17);
            rang1.Font.set_Name("宋体");


            ws.Cells[3, 1] = strExamName + "学员成绩登记表";

            rang1 = ws.get_Range(ws.Cells[3, 1], ws.Cells[3, 13]);
            rang1.set_MergeCells(true);
            rang1.set_HorizontalAlignment(XlHAlign.xlHAlignCenter);
            rang1.Font.set_Bold(true);
            rang1.Font.set_Size(12);
            rang1.Font.set_Name("宋体");

            ws.Cells[4, 1] = "考试日期: " + strExamTime;
            rang1          = ws.get_Range(ws.Cells[4, 1], ws.Cells[4, 13]);
            rang1.set_MergeCells(true);
            rang1.set_HorizontalAlignment(XlHAlign.xlHAlignRight);
            rang1.Font.set_Name("宋体");


            //write headertext
            ws.Cells[5, 1] = "序号";
            ((Range)ws.Cells[5, 1]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter);


            ws.Cells[5, 2] = "姓名";
            ws.get_Range(ws.Cells[5, 2], ws.Cells[5, 4]).set_MergeCells(true);
            ws.get_Range(ws.Cells[5, 2], ws.Cells[5, 4]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter);

            ws.Cells[5, 5] = "组织机构(车间)";
            ws.get_Range(ws.Cells[5, 5], ws.Cells[5, 7]).set_MergeCells(true);
            ws.get_Range(ws.Cells[5, 5], ws.Cells[5, 7]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter);

            ws.Cells[5, 8] = "职名";
            ws.get_Range(ws.Cells[5, 8], ws.Cells[5, 10]).set_MergeCells(true);
            ws.get_Range(ws.Cells[5, 8], ws.Cells[5, 10]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter);

            ws.Cells[5, 11] = "分数";
            ws.get_Range(ws.Cells[5, 11], ws.Cells[5, 13]).set_MergeCells(true);
            ws.get_Range(ws.Cells[5, 11], ws.Cells[5, 13]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter);


            decimal decScore = 0;

            for (int j = 0; j < dt.Rows.Count; j++)
            {
                ws.Cells[6 + j, 1] = j + 1;

                ws.Cells[6 + j, 2] = dt.Rows[j]["ExamineeName"].ToString();
                ws.get_Range(ws.Cells[6 + j, 2], ws.Cells[6 + j, 4]).set_MergeCells(true);
                ws.get_Range(ws.Cells[6 + j, 2], ws.Cells[6 + j, 4]).set_HorizontalAlignment(XlHAlign.xlHAlignLeft);

                ws.Cells[6 + j, 5] = dt.Rows[j]["OrganizationName"].ToString();
                ws.get_Range(ws.Cells[6 + j, 5], ws.Cells[6 + j, 7]).set_MergeCells(true);
                ws.get_Range(ws.Cells[6 + j, 5], ws.Cells[6 + j, 7]).set_HorizontalAlignment(XlHAlign.xlHAlignLeft);


                ws.Cells[6 + j, 8] = dt.Rows[j]["PostName"].ToString();
                ws.get_Range(ws.Cells[6 + j, 8], ws.Cells[6 + j, 10]).set_MergeCells(true);
                ws.get_Range(ws.Cells[6 + j, 8], ws.Cells[6 + j, 10]).set_HorizontalAlignment(XlHAlign.xlHAlignLeft);

                decScore           += decimal.Parse(dt.Rows[j]["Score"].ToString());
                ws.Cells[6 + j, 11] = dt.Rows[j]["Score"].ToString();
                ws.get_Range(ws.Cells[6 + j, 11], ws.Cells[6 + j, 13]).set_MergeCells(true);
                ws.get_Range(ws.Cells[6 + j, 11], ws.Cells[6 + j, 13]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter);
            }

            decimal dec1 = 0;

            if (dt.Rows.Count > 0)
            {
                dec1 = decScore / dt.Rows.Count;
            }

            ws.Cells[6 + dt.Rows.Count, 1] = "平均分:";
            ((Range)ws.Cells[5, 1]).set_HorizontalAlignment(XlHAlign.xlHAlignCenter);

            ws.Cells[6 + dt.Rows.Count, 2] = dec1.ToString("0.00");
            ws.get_Range(ws.Cells[6 + dt.Rows.Count, 2], ws.Cells[6 + dt.Rows.Count, 13]).set_MergeCells(true);
            ws.get_Range(ws.Cells[6 + dt.Rows.Count, 2], ws.Cells[6 + dt.Rows.Count, 13]).set_HorizontalAlignment(XlHAlign.xlHAlignRight);



            for (int k = 1; k <= 13; k++)
            {
                for (int j = 5; j <= 6 + dt.Rows.Count; j++)
                {
                    ((Range)ws.Cells[j, k]).BorderAround(1, XlBorderWeight.xlThin, XlColorIndex.xlColorIndexAutomatic, Missing.Value);
                }
            }

            ws.Name = "1-1";
            ws.Cells.Columns.AutoFit();

            try
            {
                ((Worksheet)xlsheet.Worksheets[1]).Activate();

                string path = Server.MapPath("../Excel/Excel.xls");
                if (File.Exists(path))
                {
                    File.Delete(path);
                }
                xlsheet.Export(path, SheetExportActionEnum.ssExportActionNone, SheetExportFormat.ssExportAsAppropriate);

                System.IO.FileInfo file = new System.IO.FileInfo(path);
                this.Response.Clear();
                this.Response.Buffer          = true;
                this.Response.Charset         = "utf-7";
                this.Response.ContentEncoding = System.Text.Encoding.UTF7;
                // 添加头信息,为"文件下载/另存为"对话框指定默认文件名
                this.Response.AddHeader("Content-Disposition", "attachment; filename=" + "Excel.xls");
                // 添加头信息,指定文件大小,让浏览器能够显示下载进度
                this.Response.AddHeader("Content-Length", file.Length.ToString());

                // 指定返回的是一个不能被客户端读取的流,必须被下载
                this.Response.ContentType = "application/ms-excel";

                // 把文件流发送到客户端
                this.Response.WriteFile(file.FullName);
            }
            catch
            {
                SessionSet.PageMessage = "系统错误,导出Excel文件失败!";
            }
        }