/// <summary> /// 导出excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Download_Click(object sender, System.EventArgs e) { DataTable dt1 = DAL.DBHelper.ExecuteDataTable("select Balancemoney-happenmoney as qcje," + ViewState["PageColumn"].ToString() + " from " + ViewState["table"].ToString() + " where " + ViewState["condition"].ToString()); if (dt1.Rows.Count == 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000053", "没有数据,不能导出Excel!") + "')</script>"); return; } DataTable dt = new DataTable(); dt = dt1.Clone(); dt.Columns["kmtype"].DataType = typeof(String); foreach (DataRow r in dt1.Rows) { DataRow newrow = dt.NewRow(); newrow["Number"] = r["Number"]; newrow["kmtype"] = D_AccountBLL.GetKmtype(r["kmtype"].ToString()); newrow["happentime"] = DateTime.Parse(r["happentime"].ToString()).AddHours(BLL.other.Company.WordlTimeBLL.ConvertAddHours()).ToString(); newrow["qcje"] = r["qcje"]; newrow["happenmoney"] = r["happenmoney"]; newrow["Balancemoney"] = r["Balancemoney"]; newrow["remark"] = r["remark"]; dt.Rows.Add(newrow); } Excel.OutToExcel(dt, GetTran("007130", "服务机构报单账户明细"), new string[] { "number=" + GetTran("001195", "编号"), "kmtype=" + GetTran("006615", "科目"), "happentime=" + GetTran("006581", "发生时间"), "qcje=" + GetTran("006605", "期初金额"), "happenmoney=" + GetTran("006582", "发生金额"), "Balancemoney=" + GetTran("006583", "账户余额"), "remark=" + GetTran("006616", "摘要") }); }
/// <summary> /// 导出excel /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Download_Click(object sender, System.EventArgs e) { DataTable dt1 = DAL.DBHelper.ExecuteDataTable("select Balancemoney-happenmoney as qcje," + ViewState["PageColumn"].ToString() + " from " + ViewState["table"].ToString() + " where " + ViewState["condition"].ToString()); if (dt1.Rows.Count == 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000053", "没有数据,不能导出Excel!") + "')</script>"); return; } DataTable dt = new DataTable(); dt = dt1.Clone(); dt.Columns["kmtype"].DataType = typeof(String); foreach (DataRow r in dt1.Rows) { DataRow newrow = dt.NewRow(); newrow["Number"] = r["Number"]; newrow["kmtype"] = D_AccountBLL.GetKmtype(r["kmtype"].ToString()); newrow["happentime"] = GetHDate(r["happentime"].ToString()); newrow["qcje"] = r["qcje"]; newrow["happenmoney"] = r["happenmoney"]; newrow["Balancemoney"] = r["Balancemoney"]; newrow["remark"] = getMark(r["remark"].ToString()); dt.Rows.Add(newrow); } if (this.RadioButtonList1.SelectedValue == "0") { Excel.OutToExcel(dt, GetTran("010005", "消费账户明细"), new string[] { "number=" + GetTran("001195", "编号"), "kmtype=" + GetTran("006615", "科目"), "happentime=" + GetTran("006581", "发生时间"), "qcje=" + GetTran("006605", "期初金额"), "happenmoney=" + GetTran("006582", "发生金额"), "Balancemoney=" + GetTran("006583", "账户余额"), "remark=" + GetTran("006616", "摘要") }); } else if (this.RadioButtonList1.SelectedValue == "1") { Excel.OutToExcel(dt, GetTran("010006", "可用石斛积分账户明细"), new string[] { "number=" + GetTran("001195", "编号"), "kmtype=" + GetTran("006615", "科目"), "happentime=" + GetTran("006581", "发生时间"), "qcje=" + GetTran("006605", "期初金额"), "happenmoney=" + GetTran("006582", "发生金额"), "Balancemoney=" + GetTran("006583", "账户余额"), "remark=" + GetTran("006616", "摘要") }); } else if (this.RadioButtonList1.SelectedValue == "4") { Excel.OutToExcel(dt, GetTran("010007", "投资石斛积分账户明细"), new string[] { "number=" + GetTran("001195", "编号"), "kmtype=" + GetTran("006615", "科目"), "happentime=" + GetTran("006581", "发生时间"), "qcje=" + GetTran("006605", "期初金额"), "happenmoney=" + GetTran("006582", "发生金额"), "Balancemoney=" + GetTran("006583", "账户余额"), "remark=" + GetTran("006616", "摘要") }); } else if (this.RadioButtonList1.SelectedValue == "5") { Excel.OutToExcel(dt, GetTran("010008", "奖励石斛积分账户明细"), new string[] { "number=" + GetTran("001195", "编号"), "kmtype=" + GetTran("006615", "科目"), "happentime=" + GetTran("006581", "发生时间"), "qcje=" + GetTran("006605", "期初金额"), "happenmoney=" + GetTran("006582", "发生金额"), "Balancemoney=" + GetTran("006583", "账户余额"), "remark=" + GetTran("006616", "摘要") }); } }