descbookcount.aspx.cs

2007年华中科技大学数据库课程设计参考程序[图书销售系统]+报告

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Collections.Generic;
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;
using OnlineBookSell.BLLFactory;
using OnlineBookSell.Model;
using OnlineBookSell.IBLL;
using OnlineBookSell.DBUtility;

public partial class ljian_admin_book_descbookcount : System.Web.UI.Page
{
    private IBookBLL ibookbll = BLLFactory.getInstance().createBookBLL();
    private static IList<BookInfo> booklist = new List<BookInfo>();

    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void list_onitemcommand(object source, RepeaterCommandEventArgs e)
    {
        for (int i = 0; i < booklist.Count; i++)
        {
            if (booklist[i].Isbn == e.CommandArgument.ToString())
                booklist.Remove(booklist[i]);
        }
        list.DataSource = booklist;
        list.DataBind();
    }
    protected void isbn_TextChanged(object sender, EventArgs e)
    {
        if (isbn.Text.Trim() != "")
        {
            using (SqlDataReader r = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, "select * from bookinfo where isbn='" + isbn.Text.Trim() + "'"))
            {
                if (r.Read())
                    add.Enabled = true;
                else
                {
                    System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.add, this.add.GetType(), "success", "alert('该书还未编目,请先编目!');", true);
                    add.Enabled = false;
                    return;
                }
            }

            BookInfo book = ibookbll.GetBookByISBN(isbn.Text.Trim());
            id.Text = book.Id.ToString();
            classid.Text = book.BookconcernID.ToString();
            bookname.Text = book.Bookname;
            bookclass.Text = book.Class1name;
            concernname.Text = book.Bookconcernname;
            bookclass.ForeColor = System.Drawing.Color.Red;
            agocost.Text = book.Cost.ToString();

            booknum.Text = "";
        
        }
    }
    protected void add2_Click(object sender, EventArgs e)
    {
        if (booklist.Count == 0)
        {
            System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.add, this.add.GetType(), "success", "alert('退货单为空,请先添加书目!');", true);
            return;
        }
        string orderid = DateTime.Now.ToString().Replace("-", "").Replace(" ", "").Replace(":", "");

        foreach (BookInfo bi in booklist)
        {
            int num = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, "insert into bookbuyout (orderid,bookid,concernid,num,cost,addtime)values('" + orderid + "'," + bi.Id + "," + bi.BookconcernID + "," + bi.Stocks + "," + bi.Cost + ",'" + DateTime.Now + "')");
            if (num <= 0)
            {
                System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.add, this.add.GetType(), "success", "alert('发生错误,请重试!');", true);
                return;
            }
        }
        System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.add2, this.add2.GetType(), "success", "alert('入库成功!');", true);
        BookInfo b = null;
        foreach (BookInfo bi in booklist)
        {
            b = ibookbll.GetBookById(bi.Id);
            b.Cost = bi.Cost;
            SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, "update book set stocks=stocks-" + bi.Stocks + " where bookid=" + bi.Id);

            
        }

    }
    protected void add_Click(object sender, EventArgs e)
    {

        foreach (BookInfo bi in booklist)
        {
            if (bi.Isbn == isbn.Text.Trim())
            {
                bi.Stocks = bi.Stocks + Convert.ToInt32(booknum.Text.Trim());
                list.DataSource = booklist;
                list.DataBind();
                return;
            }
        }

        BookInfo book = new BookInfo();
        book.Id = Convert.ToInt32(id.Text);
        book.BookconcernID = Convert.ToInt32(classid.Text);
        book.Isbn = isbn.Text.Trim();
        book.Bookname = bookname.Text.Trim();
        book.Class1name = bookclass.Text;
        book.Bookconcernname = concernname.Text;
        book.Stocks = Convert.ToInt32(booknum.Text.Trim());

        book.Cost = Convert.ToDouble(agocost.Text.Trim());
        
        booklist.Add(book);

        list.DataSource = booklist;
        list.DataBind();

        add.Enabled = false;
    }
}