manage/pay.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Text;
using System.Text.RegularExpressions;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class manage_pay : System.Web.UI.Page
{
    protected StringBuilder list=new StringBuilder(1000);
    protected void Page_Load(object sender, EventArgs e)
    {
        //验证权限
        if (Session.Contents["purview"] == null)
            Response.Redirect("../");
        else if (!Regex.IsMatch((string)Session.Contents["purview"], ",pay,"))
            Server.Transfer("default.aspx");

        SqlStore sql = new SqlStore();

        if (Request.QueryString["author"] != null && Request.QueryString["author"]!="")
            sql.ClearingDel(Request.QueryString["author"]);

        DataTableCollection tables = sql.Tables("n_Clearing_List").Tables;
        foreach (DataRow author in tables[0].Rows)
        {
            list.Append("<ul class=\"author\"><li class=\"user\">作者:" + author["username"] + "</li><li class=\"time\">注册:" + author["registertime"] + "</li><li class=\"time\">登陆:" + author["lastlytime"] + "</li><li class=\"hits\">登陆次数:" + author["loginnum"] + "</li><li class=\"alipayname\">姓名:" + author["alipayname"] + "</li><li class=\"alipayaccounts\">支付宝:" + author["alipayaccounts"] + "</li><li class=\"pirce\">金额:" + author["amount"] + "</li></ul>");
            foreach (DataRow report in tables[1].Select(""))
            {
                list.Append("<ul class=\"report\"><li class=\"tid\">书号:" + report["tid"] + "</li><li class=\"time\">起始:" + report["startdate"] + "</li><li class=\"time\">结束:" + report["enddate"] + "</li><li class=\"hits\">历史点击:" + report["historyhits"] + "</li><li class=\"hits\">结算点击:" + report["hits"] + "</li><li class=\"pirce\">金额:" + report["price"] + "</li><li class=\"other\">支付:" + report["pay"] + "</li></ul>");
                foreach (DataRow book in tables[2].Select(""))
                    list.Append("<ul class=\"book\"><li class=\"title\">标题:<a href=\"/novel/" + report["tid"] + "/\" target=\"_blank\">" + book["title"] + "</a></li><li class=\"time\">发布:" + book["addtime"] + "</li><li class=\"time\">更新:" + book["updatetime"] + "</li><li class=\"hits\">历史点击:" + book["hits"] + "</li><li class=\"other\">章节:" + book["cnumber"] + "</li><li class=\"other\">字数:" + book["length"] + "</li><li class=\"other\">封面:" + book["iscover"] + "</li><li class=\"other\">完结:" + book["isfinish"] + "</li></ul>");
            }
            list.Append("<div class=\"Pay\"><input type=\"button\" value=\"已支付\" onclick=\"if(confirm('确定稿酬已经打给作者了吗?')) location='pay.aspx?author=" +Server.UrlEncode(author["username"].ToString())+"'\" /></div>");
        }
    }
}