items.cs

小型的一个简单的系统开发的实现了简---添加--删除--修改---（vs2005和SQl2005）用到了一些JS脚本

using System;
using System.Data;
using System.Configuration;
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;

/// <summary>
/// product 的摘要说明
/// 商品操作类
/// </summary>
public class Items
{
    public Items()
    {
        //
        // TODO: 在此处添加构造函数逻辑

    }
    string item_id;
    string category_id;
    string name;
    string description;
    string quantity;
    string base_price;
    string small_image_url;
    string large_image_url;
    DataAccess.CDataAccess ExEItems = new DataAccess.CDataAccess();
    public bool Add(string item_id, string category_id, string name, string description, string quantity, string base_price, string small_image_url, string large_image_url)
    {

        string sqlstr = "insert into Items(item_id,category_id,name,description,quantity,base_price,small_image_url,large_image_url) VALUES('" + item_id + "','" + category_id + "','" + name + "','" + description + "','" + quantity + "','" + base_price + "','" + small_image_url + "','" + large_image_url + "')";

        if (ExEItems.ExecuteQuery(sqlstr))
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    public DataTable showtable()
    {

        string sqlstr = "select* from Items ";

        return ExEItems.GetDataTable(sqlstr);

    }
    public DataTable showtables()
    {

        string sqlstr = "select* from Items_View ";

        return ExEItems.GetDataTable(sqlstr);

    }
    public DataTable shotable(string item_id)
    {

        string sqlstr = "select* from Items where[item_id]='" + item_id + "' ";

        return ExEItems.GetDataTable(sqlstr);

    }

    public bool delete(string item_id)
    {
        string sqlstr = "delete [items] where[item_id]='" + item_id + "' ";

        if (ExEItems.ExecuteQuery(sqlstr))
        {
            return true;
        }
        else
        {
            return false;
        }

    }
    public bool update(string item_id, string category_id, string name, string description, string quantity, string base_price, string small_image_url, string large_image_url)
    {
        string sqlstr = "update [Items] SET item_id ='" + item_id + "',category_id='" + category_id + "',name='" + name + "',description='" + description + "',quantity='" + quantity + "',base_price='"+base_price+"',small_image_url='"+small_image_url+"',large_image_url='"+large_image_url+"' WHERE [item_id]='" + item_id + "'";

        if (ExEItems.ExecuteQuery(sqlstr))
        {
            return true;
        }
        else
        {
            return false;
        }

    }
    public bool select(string item_id)
    {
        string sqlstr = "select*from Items where[item_id]=" + item_id;

        if (ExEItems.ExecuteQuery(sqlstr))
        {
            return true;
        }
        else
        {
            return false;
        }

    }


    public DataTable SelectTable(string item_id)
    {
        string sqlstr = "select* from Items_View where item_id='" + item_id + "'";


        return ExEItems.GetDataTable(sqlstr);

    }
}