private void RptBind(string _strWhere, string _order) { int pageSize = GetPageSize(30); //每页数量 int page = MyRequest.GetQueryInt("page", 1); int start_index = pageSize * (page - 1) + 1; int end_index = pageSize * page; BLL.CCOM.View_User_CEE bll = new BLL.CCOM.View_User_CEE(); //计算数量 int totalCount = bll.GetRecordCount(_strWhere); // txtSearchResult.Text = "本次命中" + totalCount.ToString() + "条"; //绑定当页 this.rptList.DataSource = bll.GetListByPage(_strWhere, _order, start_index, end_index); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("CEEScoreList.aspx", "fun_id={0}&page={1}&keywords={2}&pro_id={3}", DESEncrypt.Encrypt(this.fun_id), "__id__", this.txtKeywords.Text, DESEncrypt.Encrypt(this.ddlProvince.SelectedValue)); this.PageContent.InnerHtml = Utils.OutPageList(pageSize, page, totalCount, pageUrl, 8, true); }
protected void exportexcel_ServerClick(object sender, EventArgs e) { string order = "UP_CCOM_number asc"; string strWhere = CombSqlTxt(this.keywords); try { var bll = new BLL.CCOM.View_User_CEE(); List <Model.CCOM.View_User_CEE> modelList = bll.GetModelList(strWhere + " order by " + order); DataSet ds = new DataSet(); ds.Tables.Clear(); DataTable dt = ds.Tables.Add("Sheet1"); DataRow dr; DataColumn column; column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "序号"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "考生号"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "姓名"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "高考报名号"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "专业方向"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "考生类型:文/理"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "语文"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "数学"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "外语"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "综合分"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "附加分"; ds.Tables["Sheet1"].Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "总分"; ds.Tables["Sheet1"].Columns.Add(column); /* * //增加只导出选择部分学生的功能 * bool exprotAll = true; * for (int i = 0; i < rptList.Items.Count; i++) * { * CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); * if (cb.Checked == true) * { * exprotAll = false; * break; * } * } */ //int count = exprotAll == true ? modelList.Count : rptList.Items.Count; int count = modelList.Count; for (int i = 0, num = 1; i < count; i++, num++) { /* * //如果只导出部分学生且未选中,则跳过 * if (exprotAll == false) * { * CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); * if (cb.Checked == false) * { * //增加序号 * num--; * continue; * } * } */ dr = ds.Tables["Sheet1"].NewRow(); dr["序号"] = num.ToString(); dr["考生号"] = modelList[i].UP_CCOM_number; dr["姓名"] = modelList[i].User_realname; dr["高考报名号"] = modelList[i].UP_CEE_number; dr["专业方向"] = GetAgencyName(modelList[i].Agency_id.ToString()); dr["考生类型:文/理"] = GetWenOrLi(modelList[i].CEE_type.ToString()); if (modelList[i].CEE_Chinese_score.ToString() != "" && modelList[i].CEE_Chinese_score.ToString() != null) { dr["语文"] = ((decimal)modelList[i].CEE_Chinese_score).ToString("#.##"); } if (modelList[i].CEE_Math_score.ToString() != "" && modelList[i].CEE_Math_score.ToString() != null) { dr["数学"] = ((decimal)modelList[i].CEE_Math_score).ToString("#.##"); } if (modelList[i].CEE_English_score.ToString() != "" && modelList[i].CEE_English_score.ToString() != null) { dr["外语"] = ((decimal)modelList[i].CEE_English_score).ToString("#.##"); } if (modelList[i].CEE_comprehensive_score.ToString() != "" && modelList[i].CEE_comprehensive_score.ToString() != null) { dr["综合"] = ((decimal)modelList[i].CEE_comprehensive_score).ToString("#.##"); } if (modelList[i].CEE_extra_score.ToString() != "" && modelList[i].CEE_extra_score.ToString() != null) { dr["附加分"] = ((decimal)modelList[i].CEE_extra_score).ToString("#.##"); } if (modelList[i].CEE_score.ToString() != "" && modelList[i].CEE_score.ToString() != null) { dr["总分"] = ((decimal)modelList[i].CEE_score).ToString("#.##"); } ds.Tables["Sheet1"].Rows.Add(dr); } DataToExcel.ExportToExcel(ds, Server.MapPath("/upload/excel/"), this.ddlProvince.SelectedItem.Text + "_高考分数_" + DateTime.Now.ToFileTime().ToString() + ".xlsx", this.Page); } catch { JscriptMsg("导出高考分数出错", "", "Error"); } }