protected void ExportExcel_Btn_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); OfficeHelper helper = new OfficeHelper(); DataTable demodt = new DataTable(); InitDataColums(demodt); DataTable dt = SelByWhere(); foreach (DataRow dtrow in dt.Rows) { DataRow dr = demodt.NewRow(); dr["PaymentID"] = dtrow["PaymentID"]; dr["UserName"] = dtrow["UserName"]; dr["PaymentNum"] = dtrow["PaymentNum"]; dr["PayPlatName"] = dtrow["PayPlatName"]; dr["MoneyPay"] = dtrow["MoneyPay"]; dr["MoneyTrue"] = dtrow["MoneyTrue"]; dr["StatusStr"] = dtrow["Status"]; dr["CStatusStr"] = dtrow["CStatus"]; dr["SuccessTime"] = dtrow["SuccessTime"]; demodt.Rows.Add(dr); } string columnames = "ID,会员名,订单号,支付平台,金额,实际金额,交易状态,处理结果,完成时间"; SafeSC.DownStr(helper.ExportExcel(demodt, columnames), DateTime.Now.ToString("yyyyMMdd") + "充值信息表.xls"); }
public void ContentManage_ToExcel() { VM_ContentManage vm = FillVMContentManage(ref err); if (!string.IsNullOrEmpty(err)) { function.WriteErrMsg(err); return; } DataTable dt = vm.setting.dt; dt.Columns.Add("ShowTitle"); dt.Columns.Add("ShowElite"); dt.Columns.Add("ShowStatus"); foreach (DataRow dr in dt.Rows) { dr["ShowTitle"] = NodeID == 0 ? "[" + dr["NodeName"] + "]" + dr["Title"] : dr["Title"]; dr["ShowElite"] = conhelp.GetElite(dr["EliteLevel"].ToString()); dr["ShowStatus"] = conhelp.GetStatus(DataConvert.CLng(dr["Status"])); } DataTable newDt = dt.DefaultView.ToTable(false, "GeneralID,ShowTitle,Inputer,Hits,ShowElite,ShowStatus,CreateTime,UpDateTime".Split(',')); string columnames = "ID,标题,录入者,点击数,推荐,状态,添加时间,修改时间"; M_Node nodeMod = nodeBll.SelReturnModel(NodeID); string nodename = nodeMod == null ? "" : "[" + nodeMod.NodeName + "]"; SafeSC.DownStr(OfficeHelper.ExportExcel(newDt, columnames), DateTime.Now.ToString("yyyyMMdd") + nodename + "内容管理表.xls"); }
protected void ExportExcel_Btn_Click(object sender, EventArgs e) { OfficeHelper helper = new OfficeHelper(); DataTable dt = SelByWhere(); DataTable newDt = dt.DefaultView.ToTable(false, "PaymentID,UserName,PaymentNum,PayPlatName,MoneyPay,MoneyTrue,Status,CStatus,SuccessTime".Split(',')); string columnames = "ID,会员名,订单号,支付平台,金额,实际金额,交易状态,处理结果,完成时间"; SafeSC.DownStr(helper.ExportExcel(newDt, columnames), DateTime.Now.ToString("yyyyMMdd") + "充值信息表.xls"); }
protected void EGV_RowCommand(object sender, GridViewCommandEventArgs e) { int id = DataConvert.CLng(e.CommandArgument); //LinkButton StatBtn = (LinkButton)e.Item.FindControl("StatBtn"); //LinkButton PayBtn = (LinkButton).FindControl("PayBtn"); DataTable lclData = new DataTable(); switch (e.CommandName.ToLower()) { case "save": { string sql = lclData.Rows[0]["Sqlstr"].ToString(); if (!string.IsNullOrEmpty(sql)) { string filename = ""; DateTime dt = Convert.ToDateTime(lclData.Rows[0]["AddTime"]); filename = dt.ToString("yyyyMMddHHmmss"); string path1 = "T-sql/" + dt.Year.ToString() + "/" + dt.Month.ToString() + "/" + dt.Day.ToString() + "/"; string path = "/" + SiteConfig.SiteOption.UploadDir + "/" + path1; try { creatfile(filename, sql, path); } catch { Directory.CreateDirectory(MapPath(path)); creatfile(filename, sql, path); } ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('生成成功!');</script>"); function.WriteSuccessMsg("生成成功"); } else { function.WriteErrMsg("无任何SQL语句"); } } break; case "download": { string sql = lclData.Rows[0]["Sqlstr"].ToString(); SafeSC.DownStr(sql, "Script.sql"); } break; case "del": function.WriteSuccessMsg("删除成功"); break; } MyBind(); }
//Excel下载 protected void DownExcel_Btn_Click(object sender, EventArgs e) { M_Pub_Excel excelMod = new M_Pub_Excel(); B_Pub_Excel excelBll = new B_Pub_Excel(); int pubid = Convert.ToInt32(Request.QueryString["PubID"]); M_Pub pubinfo = pub.GetSelect(pubid); excelMod = excelBll.SelByTbName(pubinfo.PubTableName); if (excelMod == null) { function.WriteErrMsg("尚未为表:" + pubinfo.PubTableName + "指定导出规则,请先<a href='PubExcel.aspx'>点此设定导出规则</a>"); } OfficeHelper ofHelper = new OfficeHelper(); SafeSC.DownStr(ofHelper.GetExcelByDT(GetDT(), excelMod.Fields, excelMod.CNames), "互动回复.xls"); }
protected void ExportExcel_Btn_Click(object sender, EventArgs e) { DataTable dt = SelByWhere(); dt.Columns.Add("CStatusStr"); dt.Columns.Add("StatusStr"); foreach (DataRow dr in dt.Rows) { bool cstatus = DataConverter.CBool(dr["cstatus"].ToString()); dr["CStatusStr"] = cstatus ? "已处理" : "未处理"; int status = DataConverter.CLng(dr["status"]); dr["StatusStr"] = status == 3 ? "已结束" : "未完成"; } DataTable newDt = dt.DefaultView.ToTable(false, "PaymentID,UserName,PaymentNum,PayPlatName,MoneyPay,MoneyTrue,StatusStr,CStatusStr,SuccessTime".Split(',')); string columnames = "ID,会员名,订单号,支付平台,金额,实际金额,交易状态,处理结果,完成时间"; SafeSC.DownStr(OfficeHelper.ExportExcel(newDt, columnames), DateTime.Now.ToString("yyyyMMdd") + "充值信息表.xls"); }