orders.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>
/// Orders 的摘要说明
/// 订单操作
/// </summary>
public class Orders
{
    public Orders()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //

    }


         

    //添加订单
     DataAccess.CDataAccess ExEOrders = new DataAccess.CDataAccess();
    public bool Add(string order_id, string item_id, string cust_id, string quantity, string base_price, string order_date)
   {
        string sqistr = "insert into [Orders] VALUES('" + order_id + "','" + item_id + "','" + cust_id + "','" + quantity + "','" + base_price + "','" + order_date + "')";

        if (ExEOrders.ExecuteQuery(sqistr))
        {
            return true;
        }
        else
        {
            return false;
        }

    }
    //显示订单
    public DataTable xs()
    {
        string sqlstr = "select* from All_view ";


        return ExEOrders.GetDataTable(sqlstr);



    }

    public DataTable TD()
    {
        string sqlstr = "select* from Orders";


        return ExEOrders.GetDataTable(sqlstr);



    }
    public DataTable show(string order_id)
    {
        string sqlstr = "select* from Orders where [order_id]='" + order_id + "'";


        return ExEOrders.GetDataTable(sqlstr);



    }
    //删除订单
    public bool delete(string order_id)
    {
        string sqistr = "delete  [Orders] where[order_id]='" + order_id + "'";

        if (ExEOrders.ExecuteQuery(sqistr))
        {
            return true;
        }
        else
        {
            return false;
        }

    }
    //修改订单
    public bool Edit(string order_id, string item_id, string cust_id, string quantity, string base_price, string order_date)
    {

        string sqistr = "update [Orders] SET item_id ='" + item_id + "',cust_id='" + cust_id + "',quantity='" + quantity + "',base_price='" + base_price + "',order_date='" + order_date + "' WHERE [order_id]='" + order_id + "'";
        if (ExEOrders.ExecuteQuery(sqistr))
        {
            return true;
        }
        else
        {
            return false;
        }



    }
}