sellgoodssearch.ascx.cs

用vs2005和sql2000实现的小型超市管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 System.Data.SqlClient;
public partial class control_sellgoodssearch : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }






    protected void Button1_Click(object sender, EventArgs e)
    {
        string Sql = " ";
        if (CheckBox1.Checked)
        {
            Sql = Sql + "and 客户姓名 like '%" + txtclient.Text + "%' ";
        }
        if (CheckBox2.Checked)
        {
            Sql = Sql + "and 商品名称 like '%" + txtspname.Text + "%' ";
        }

        if (CheckBox4.Checked)
        {
            Sql = Sql + "and 销售日期  between '" + txttimef.Text + "' and '" + txttimel.Text + "'";
        }
        Session["sql"] = Sql;
     
    }
}