private void GridViewBind()
{
if (!base.IsPostBack)
{
if (this.ShowOptions != 0)
{
this.EgvBankroll.Columns[0].Visible = false;
this.EgvBankroll.Columns[8].Visible = false;
this.EgvBankroll.Columns[1].HeaderText = "付款人";
this.EgvInvoice.Columns[6].Visible = false;
this.EgvInvoice.Columns[7].HeaderText = "开票时间";
this.EgvDeliverItem.Columns[8].Visible = true;
}
if (this.OrderId != "0")
{
this.EgvBankroll.DataSource = BankrollItem.GetList(0, 0, 10, 5, this.OrderId);
this.EgvInvoice.DataSource = Invoice.GetList(0, 0, 5, this.OrderId, 0);
this.EgvDeliverItem.DataSource = DeliverItem.GetList(0, 0, 8, this.OrderId, 0);
this.EgvTransferLog.DataSource = TransferLog.GetList(0, 0, "10", "OrderID", this.OrderId);
this.EgvBankroll.DataBind();
this.EgvInvoice.DataBind();
this.EgvDeliverItem.DataBind();
this.EgvTransferLog.DataBind();
if (string.IsNullOrEmpty(this.ClientName))
{
this.EgvService.DataSource = null;
this.EgvComplain.DataSource = null;
}
else
{
this.EgvService.DataSource = Service.GetListByClientName(0, 0x7fffffff, this.ClientName);
this.EgvComplain.DataSource = Complain.GetListByClientName(0, 0x7fffffff, this.ClientName);
}
this.EgvService.DataBind();
this.EgvComplain.DataBind();
this.FeedbackDataBind();
this.GdvPaymentLogList.DataSource = PaymentLog.GetListByOrderId(DataConverter.CLng(this.OrderId));
this.GdvPaymentLogList.DataBind();
}
}
}
protected void BtnExportExcel_Click(object sender, EventArgs e)
{
IList <BankrollItemInfo> list = BankrollItem.GetList(0, 0x7fffffff, 11, 0, this.GetKeywords());
StringBuilder builder = new StringBuilder();
base.Response.Clear();
base.Response.AppendHeader("content-disposition", "attachment;filename=BankrollItemList.xls");
base.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
base.Response.ContentType = "application/vnd.xls";
builder.Append("<table border='1' cellspacing='1' style='border-collapse: collapse;table-layout:fixed' id='AutoNumber1' height='32'><tr>");
builder.Append("<td align='center'><b>交易时间</b></td>");
builder.Append("<td align='center'><b>客户名称</b></td>");
builder.Append("<td align='center'><b>用户名</b></td>");
builder.Append("<td align='center'><b>交易方式</b></td>");
builder.Append("<td align='center'><b>币种</b></td>");
builder.Append("<td align='center'><b>收入金额</b></td>");
builder.Append("<td align='center'><b>支出金额</b></td>");
builder.Append("<td align='center'><b>摘要</b></td>");
builder.Append("<td align='center'><b>银行名称</b></td>");
builder.Append("<td align='center'><b>备注/说明</b></td></tr>");
foreach (BankrollItemInfo info in list)
{
builder.Append("<tr>");
builder.Append("<td align='center'>" + info.DateAndTime.ToString() + "</td>");
builder.Append("<td align='center'>" + DataSecurity.HtmlEncode(info.ClientName) + "</td>");
builder.Append("<td align='center'>" + DataSecurity.HtmlEncode(info.UserName) + "</td>");
builder.Append("<td align='center'>" + this.GetMoneyType(info.MoneyType) + "</td>");
builder.Append("<td align='center'>" + this.GetCurrencyType(info.CurrencyType) + "</td>");
builder.Append("<td align='center'>" + ((info.Money > 0M) ? info.Money.ToString() : "") + "</td>");
builder.Append("<td align='center'>" + ((info.Money < 0M) ? Math.Abs(info.Money).ToString() : "") + "</td>");
builder.Append("<td align='center'>" + ((info.Money > 0M) ? "收入" : "支出") + "</td>");
builder.Append("<td align='center'>" + ((info.MoneyType == 3) ? DataSecurity.HtmlEncode(PayPlatform.GetPayPlatformById(info.EBankId).PayPlatformName) : DataSecurity.HtmlEncode(info.Bank)) + "</td>");
builder.Append("<td align='center'>" + DataSecurity.HtmlEncode(info.Remark) + "</td>");
builder.Append("</tr>");
}
base.Response.Write(builder.ToString());
base.Response.End();
}