protected void btnExportExcel_Click(object sender, System.EventArgs e) { int year = System.Convert.ToInt32(this.dropYear.SelectedValue); PCPettyCashService pCPettyCashService = new PCPettyCashService(); DataTable monthCash = pCPettyCashService.GetMonthCash(year, this.userCode); for (int i = 0; i < monthCash.Rows.Count; i++) { DataRow dataRow = monthCash.Rows[i]; dataRow["Matter"] = dataRow["Matter"].ToString().Replace("<br />", ";\t"); } string[] headerName = new string[] { "序号", "日期", "事项", "借款金额" }; string[] fieldName = new string[] { "No", "Date", "Matter", "Cash" }; string[] totalField = new string[] { "Cash" }; ExcelHelper.ExportExcel(monthCash, headerName, fieldName, totalField, this.lblTitle.Text + ".xls", base.Request.Browser.Browser); }
private void BindGvwMonthCash(int year, string userCode) { PCPettyCashService pCPettyCashService = new PCPettyCashService(); this.gvwMonthCash.DataSource = pCPettyCashService.GetMonthCash(year, userCode); this.gvwMonthCash.DataBind(); }