yuangong/diaoboQuery.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class yuangong_diaoboQuery : System.Web.UI.Page
{
    sqlConn conn = new sqlConn();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string strsql1 = "select * from cangku";
            DataSet ds1 = conn.hsggetdata(strsql1);
            this.cangku.Items.Add("请选择仓库");
            for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
            {
                this.cangku.Items.Add(ds1.Tables[0].Rows[i]["cangku"].ToString());
            }
            getinfo();


        }
    }
    private void getinfo()
    {
        string strsql = "select a.*,b.bianhao,b.chima,b.jiage,b.mianliao,b.nianfen,b.cangku from diaobo a left join shangpin  b on a.shangpinID=b.id ";
        //if (Session["shenfen"].ToString() == "经理")
        //{
        strsql += " where 1>0";
        //}
        //else
        //{
        //    strsql += " where cangku='" + Session["cangku"].ToString() + "'";

        //}
        if (this.shijian.Text != "")
        {
            strsql += " and shijian='" + shijian.Text + "'";
        }
        if (this.bianhao.Value != "")
        {
            strsql += " and bianhao='" + this.bianhao.Value + "'";
        }
        if (this.cangku.Text != "请选择仓库")
        {
            strsql += " and cangku='" + this.cangku.Text + "'";
        }
        strsql += " Order by cangku";
        DataSet ds = conn.hsggetdata(strsql);
        dlinfo.DataSource = ds.Tables[0];
        dlinfo.DataBind();

    }
    protected void dlinfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        dlinfo.PageIndex = e.NewPageIndex;