Ejemplo n.º 1
0
    /// <summary>
    /// 绑定Grid
    /// </summary>
    protected void BindGrid()
    {
        BTallyBillBB tallyBillBB = new BTallyBillBB();
        DataSet ds = new DataSet();

        string strwhere = " 1=1 ";

        if (!string.IsNullOrEmpty(this.ddlWare.SelectedValue))
        {
            strwhere += " and  wareNo='" + this.ddlWare.SelectedValue + "'";
        }

        if (!string.IsNullOrEmpty(this.ddlWarelocater.SelectedValue))
        {
            strwhere += " and  wareLocatorNo='" + this.ddlWarelocater.SelectedValue + "'";
        }

        if (!string.IsNullOrEmpty(this.txtPllateno.Text.Trim()))
        {
            strwhere += " and palletNo like '%" + this.txtPllateno.Text.Trim().Replace("'","''") + "%'";
        }

        try
        {
            ds = tallyBillBB.GetVList(strwhere);
            this.grid.DataSource = ds.Tables[0];
            this.grid.DataBind();

            //赋值记录条数、页面总数
            this.Label3.Text = ds.Tables[0].Rows.Count.ToString();
            this.Label2.Text = this.grid.PageCount.ToString();
            this.currPage.Text = (this.grid.PageIndex + 1).ToString();
        }
        finally
        {
            tallyBillBB.Dispose();
        }
    }
Ejemplo n.º 2
0
    public DataTable GetTallyBill(string strPalletNo)
    {
        BTallyBillBB tallyBillBB = new BTallyBillBB();

        try
        {
            DataTable dt = new DataTable();

            dt = tallyBillBB.GetVList("palletNo='" + strPalletNo + "' and isInStock=0").Tables[0];
            return dt;
        }
        finally
        {
            tallyBillBB.Dispose();
        }
    }