MyXm.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial  class MyXm : System.Web.UI.Page
{
    SqlData da = new SqlData();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindToComment();
        }
    }
    private void bindToComment()
    {
        string sql = @"SELECT a.*,b.typename,c.id,mtime FROM Book a
                        INNER JOIN dbo.Booktype  b ON a.booktypeid=b.typeid
                        inner JOIN userbook c ON a.barcode=c.bookid AND c.userid='" + Session["uname"] + @"'
                        ORDER BY intime DESC";
        DataTable dt = da.datesetExecute(sql, "tbBook").Tables[0];

        rptComment.DataSource = dt;
        rptComment.DataBind();

    }

    protected void rptComment_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "duih")
        {
            var bookid = "" + e.CommandArgument;
            if (Session["uname"] == null)
            {
                Response.Redirect("Default.aspx");
                return;
            }
            //string sql = @"select integral from users where username =" + Session["uname"];
            //var jifen = Convert.ToInt32("" + da.ExecuteScalar(sql));
            //if (jifen < 50)
            //{
            //    Common.ShowMessage.Show(Page, "Error", "该书兑换积分不能小于50..");
            //}
            //else
            //{
            var sql = @"insert into userbook values('" + Session["uname"] + "','" + bookid + "')";
            da.ExecuteSQL(sql);
            Common.ShowMessage.Show(Page, "Error", "购买成功..");
            //}
        }
    }
    protected void rptComment_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        ListItemType objItemType = (ListItemType)e.Item.ItemType;
        if (objItemType == ListItemType.Item || objItemType == ListItemType.AlternatingItem)
        {