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");
}
