.net 餐厅管理系统订单管理后端

using Restaurant.Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Restaurant.WEB
{
    public partial class OrderManage : System.Web.UI.Page
    {
        BLL.FoodManage manage = new BLL.FoodManage();
        FoodModel model = new FoodModel();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string sql = "select Customer.CID,Food.FoodID,CName,FoodName,Odate from [Restaurant].[dbo].[Order],Food,Customer where [Restaurant].[dbo].[Order].FoodID=Food.FoodID and [Restaurant].[dbo].[Order].CID=Customer.CID";
                PartPages2.Sql = sql;
            }
        }
        protected void Button_search_Click(object sender, EventArgs e)
        {
            string sql = "";
            try
            {
                string ccount = CCount.Text.ToString().Trim();
                sql = "select Customer.CID,Food.FoodID,CName,FoodName,Odate from [Restaurant].[dbo].[Order],Food,Customer where [Restaurant].[dbo].[Order].FoodID=Food.FoodID and [Restaurant].[dbo].[Order].CID=Customer.CID";
                if (ccount != "")
                {
                    sql += " and Customer.CID like '%{0}%' ";
                    sql = string.Format(sql, ccount);
                }

                PartPages2.Sql = sql;
            }
            catch (Exception ty)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>confirm('" + ty.Message + "');</script>");
            }
        }
        protected void linkOper_Click(object sender, EventArgs e)//
        {
            try
            {
                object id = Request.Form["hidId"];
                string linkId = (sender as LinkButton).ID;
                string aid = Request.QueryString["content"];
                if (linkId == "linkEdit" && !string.IsNullOrWhiteSpace((string)id))
                    Response.Write("<script>alert('无法进行该操作！');</script>");
                if (linkId == "LinkAdd")
                    Response.Write("<script>alert('无法进行该操作！');</script>");
                if (linkId == "linkDelete" && !string.IsNullOrWhiteSpace((string)id))
                {
                    Response.Write("<script>alert('无法进行该操作！');</script>");
                }
            }
            catch (Exception eq)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>confirm('" + eq.Message + "');</script>");
            }
        }
    }
}