sell_search.aspx.cs

该商品销售管理系统是一个基于WEB的适应于小型企业的管理系统！可以实现商品基本信息的查询。添加

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;
using System.Data.SqlClient;
using System.Text;
using LoginCheckClass;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //判断用户是否登陆
        //获取session值，防止直接通过URL访问页面，确保安全性
        LoginCheck a = new LoginCheck();    //实例化LoginCheck类的对象
        a.check();  //调用LoginCheck类的方法
        if (!IsPostBack)    //获取一个值，该值指示该页是否正为响应客户端回发而加载，或者它是否正被首次加载和访问。
        {
            //判断进行"商品销售查询"还是"销售退货查询"
            if (Request["type"] == "3")
            {
                Label1.Text = "销售信息";
                Label2.Text = "查询统计→销售信息查询";
                SqlDataSource1.SelectCommand = "SELECT CompanyName, CommodityName, id, Number, ManageMan,StockDate,kehu FROM SQ WHERE Type='销售信息'";

            }
            if (Request["type"] == "4")
            {
                Label1.Text = "销售退货";
                Label2.Text = "查询统计→销售退货查询";
                SqlDataSource1.SelectCommand = "SELECT CompanyName, CommodityName, id, Number, ManageMan,StockDate,kehu FROM SQ WHERE Type='销售退货'";
            }
           }

    }

    
    //返回按钮
    protected void GridView_cbtn_Click(object sender, EventArgs e)
    {
        //判断进行"商品销售查询"还是"销售退货查询"
        if (Request["type"] == "3")
        {
            Label1.Text = "销售信息";
            SqlDataSource1.SelectCommand = "SELECT CompanyName, CommodityName, id, Number, ManageMan,StockDate,kehu FROM SQ WHERE Type='销售信息'";

        }
        if (Request["type"] == "4")
        {
            Label1.Text = "销售退货";
            SqlDataSource1.SelectCommand = "SELECT CompanyName, CommodityName, id, Number, ManageMan,StockDate,kehu FROM SQ WHERE Type='销售退货'";
        }
        CheckBox.Checked = false;
        CheckBox1.Checked = false;
        CheckBox2.Checked = false;
        CheckBox8.Checked = false;
        CompanyID.Text = "";
        CommodityName.Text = "";
        Customer.Text = "";
        CompanyID.Enabled = false;
        CommodityName.Enabled = false;
        Customer.Enabled = false;
    }
    //查询按钮
    protected void GridView_ebtn_Click1(object sender, EventArgs e)
    {
        select();   //调用select方法
        GridView1.DataBind();
        if (GridView1.Rows.Count == 0)  //判断行数是否为零
        {
            Response.Write("<script>alert('没有您所要查询的内容')</script>");
        }
       
    }
    //设置chechbox与对应textbox的初始状态
    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
        if (CheckBox1.Checked == true)
        {
            CompanyID.Enabled = true;
        }
        else
        {
            CompanyID.Enabled = false;
        }

    }
    protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
    {
        if (CheckBox2.Checked == true)
        {
            CommodityName.Enabled = true;
        }
        else
        {
            CommodityName.Enabled = false;
        }
    }
    protected void CheckBox_CheckedChanged(object sender, EventArgs e)
    {
        if (CheckBox.Checked == true)
        {
            Customer.Enabled = true;
        }
        else
        {
            Customer.Enabled = false;
        }
    }
    private static readonly string _connectString = System.Configuration.ConfigurationManager.ConnectionStrings["db_sellConnectionString"].ConnectionString;
    protected void GridView_ebtn_Click(object sender, EventArgs e)
    {
         

    }

    //字符串的拼接
    void select()
    {

        StringBuilder sb = new StringBuilder(); //实例化字符串的拼接对象
        SqlConnection conn = new SqlConnection();
        SqlCommand cmd = conn.CreateCommand();
        if (this.CheckBox1.Checked == true)
        {
            sb.Append("AND SQ.CompanyName LIKE '%" + CompanyID.Text + "%' ");
        }
        if (this.CheckBox2.Checked == true)
        {
            sb.Append("AND SQ.CommodityName LIKE '%" + CommodityName.Text + "%'");

        }
        if (this.CheckBox.Checked == true)
        {
            sb.Append("AND SQ.kehu LIKE '%" + Customer.Text + "%'");
        }
        if (this.CheckBox8.Checked == true)
        {
            sb.Append("AND SQ.StockDate between '" + Convert.ToDateTime(DaintyDate3.Text) + "' and '" + Convert.ToDateTime(DaintyDate4.Text) + "'");
        }
        string s = "SELECT [Number], [StockDate], [CommodityName], [CompanyName], [kehu] ,[id] FROM [SQ] where type='" + Label1.Text + "'" + sb.ToString();
       
        
        
        
        this.SqlDataSource1.SelectCommand = s;
    }


    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        select();   //调用字符串拼接函数
    }
    protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {
        int id = (int)GridView1.DataKeys[e.NewSelectedIndex].Value;
        Session["Sell_Search_ID"] = id; //获取当前页面的ID
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        Response.Write("<script>window.open('../销售管理/Sell_open.aspx','','height=500 , width=480;');history.go(-1);</script>");  //跳转页面
    }

}