/// <summary> /// 绑定数据 /// </summary> protected void BindData() { //当前登录人站段ID int _OrgId = PrjPub.CurrentLoginUser.StationOrgID; //等1:路局 等于0:站段 int _SuitRangeId = PrjPub.CurrentLoginUser.SuitRange; //考试开始时间 if (string.IsNullOrEmpty(dateStartDateTime.DateValue.ToString())) { SessionSet.PageMessage = "请选择有效开始日期!"; } DateTime _DateFrom = Convert.ToDateTime(dateStartDateTime.DateValue); //考试结束时间 if (string.IsNullOrEmpty(dateEndDateTime.DateValue.ToString())) { SessionSet.PageMessage = "请选择有效结束日期!"; } DateTime _DateTo = Convert.ToDateTime(dateEndDateTime.DateValue); beginTime.Value = _DateFrom.ToString(); endTime.Value = _DateTo.ToString(); int style = Convert.ToInt32(ddlStyle.SelectedValue); RandomExamCountStatisticBLL objBll = new RandomExamCountStatisticBLL(); IList <RailExam.Model.RandomExamCountStatistic> objList = objBll.GetCountWithOrg(_SuitRangeId, _OrgId, _DateFrom, _DateTo, PrjPub.GetRailSystemId(), style); examsGrid.DataSource = objList; examsGrid.DataBind(); }
private void OutPut() { RandomExamCountStatisticBLL objBll = new RandomExamCountStatisticBLL(); //I当前登录人ID int _OrgId = PrjPub.CurrentLoginUser.StationOrgID; //等1:路局 等于0:站段 int _SuitRangeId = PrjPub.CurrentLoginUser.SuitRange; //考试开始时间 DateTime _DateFrom = Convert.ToDateTime(dateStartDateTime.DateValue); //考试结束时间 DateTime _DateTo = Convert.ToDateTime(dateEndDateTime.DateValue); int style = Convert.ToInt32(ddlStyle.SelectedValue); IList <RailExam.Model.RandomExamCountStatistic> objList = objBll.GetCountWithOrg(_SuitRangeId, _OrgId, _DateFrom, _DateTo, PrjPub.GetRailSystemId(), style); Excel.Application objApp = new Excel.ApplicationClass(); Excel.Workbooks objbooks = objApp.Workbooks; Excel.Workbook objbook = objbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet); Excel.Worksheet objSheet = (Excel.Worksheet)objbook.Worksheets[1]; //取得sheet1 Excel.Range range; string filename = ""; try { //生成.xls文件完整路径名 filename = Server.MapPath("/RailExamBao/Excel/Count.xls"); if (File.Exists(filename.ToString())) { File.Delete(filename.ToString()); } //将所得到的表的列名,赋值给单元格 objSheet.Cells[1, 1] = "序号"; objSheet.Cells[1, 2] = "站段单位"; range = objSheet.get_Range(objSheet.Cells[1, 2], objSheet.Cells[1, 4]); range.Merge(0); objSheet.Cells[1, 5] = "考试次数"; objSheet.Cells[1, 6] = "参考人次"; //同样方法处理数据 for (int i = 0; i < objList.Count; i++) { objSheet.Cells[2 + i, 1] = i + 1; objSheet.Cells[2 + i, 2] = objList[i].OrgName; range = objSheet.get_Range(objSheet.Cells[2 + i, 2], objSheet.Cells[2 + i, 4]); range.Merge(0); objSheet.Cells[2 + i, 5] = objList[i].ExamCount; objSheet.Cells[2 + i, 6] = objList[i].EmployeeCount; } //不可见,即后台处理 objApp.Visible = false; objbook.Saved = true; objbook.SaveCopyAs(filename); } catch { SessionSet.PageMessage = "系统错误,导出Excel文件失败!"; } finally { objbook.Close(Type.Missing, filename, Type.Missing); objbooks.Close(); objApp.Application.Workbooks.Close(); objApp.Application.Quit(); objApp.Quit(); GC.Collect(); } }