/// <summary> /// /// </summary> private void ShowInfo() { if (model != null) { this.lblid.Text = model.id.ToString(); this.lblmode.Text = bll.GetModeText(model.mode); this.lbltrade_no.Text = model.trade_no; this.lblout_trade_no.Text = model.out_trade_no; this.lblservice.Text = model.service; this.lbluserid.Text = model.userid.ToString(); this.lblsign_type.Text = model.sign_type; this.lblreturn_url.Text = model.return_url; this.lblbankCode.Text = model.bankCode; this.lblbankName.Text = model.bankName; this.lblbankBranch.Text = model.bankBranch; this.lblbankAccountName.Text = model.bankAccountName; this.lblbankAccount.Text = model.bankAccount; this.lblamount.Text = model.amount.ToString(); this.lblcharge.Text = model.charge.ToString(); this.lbladdTime.Text = model.addTime.ToString(); this.lblprocessingTime.Text = model.processingTime.ToString(); this.lblaudit_status.Text = bll.GetAuditStatusText(model.audit_status); this.lblpayment_status.Text = bll.GetPaymentStatusText(model.payment_status); this.lblis_cancel.Text = model.is_cancel ? "是" : "否"; //this.lblext1.Text = model.ext1; //this.lblext2.Text = model.ext2; //this.lblext3.Text = model.ext3; this.lblremark.Text = model.remark; this.lbltranApi.Text = model.tranApi.ToString(); this.lblnotifyTimes.Text = model.notifyTimes.ToString(); this.lblnotifystatus.Text = model.notifystatus.ToString(); this.lblcallbackText.Text = model.callbackText; this.lbllotno.Text = model.lotno; this.lblserial.Text = model.serial.ToString(); if (model.is_cancel == false) { btn_cancel.Visible = (model.issure == 1) && (model.audit_status == 1); btnAudits.Visible = (model.issure == 1) && (model.audit_status == 1); btnRefuse.Visible = (model.issure == 1) && (model.audit_status == 1); if (model.audit_status == 2) { btnpaysuccess.Visible = (model.payment_status == 1); btnpayfail.Visible = (model.payment_status == 1); } } } }
protected void btnExport_Click(object sender, EventArgs e) { try { DataSet ds = GetData(); if (ds != null) { DataTable data = ds.Tables[1]; data.Columns.Add("sName", typeof(string)); foreach (DataRow dr in data.Rows) { dr["sName"] = stlAgtBLL.GetPaymentStatusText(dr["payment_status"]); } data.AcceptChanges(); data.TableName = "Rpt"; string path = Server.MapPath("~/common/template/xls/SettledAgent.xls"); Aspose.Cells.WorkbookDesigner designer = new Aspose.Cells.WorkbookDesigner(); designer.Workbook = new Workbook(path); //数据源 designer.SetDataSource(data); designer.Process(); designer.Workbook.Save(this.Response , DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls" , ContentDisposition.Attachment , designer.Workbook.SaveOptions); } } catch (Exception ex) { AlertAndRedirect(ex.Message); } }