/// <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", "摘要")
});
}
}
