Exemplo n.º 1
0
    /// <summary>
    /// 绑定Grid
    /// </summary>
    protected void BindGrid()
    {
        TSBarrivebillBB arriveBillBB = new TSBarrivebillBB();

        try
        {
            string strWhere = this.StrWhere;
            DataSet ds = new DataSet();

            //到货通知单编号
            if (txtBillNo.Text.Trim() != "")
            {
                strWhere += " and  arrivebillNo like '%" + txtBillNo.Text.Replace("'", "''") + "%'";
            }

            //是否收货完成
            if (this.ddlIsFinishReceive.SelectedValue != "")
            {
                if (this.ddlIsFinishReceive.SelectedValue == "1")//收货完成
                {
                    strWhere += " and not exists(select 1 from dbo.BArriveDetail  as t where t.arriveBillNo=dbo.TSBArriveBill.arriveBillNo and t.isFinishReceive=0)";
                }
                else//未收货完成
                {
                    strWhere += " and exists(select 1 from dbo.BArriveDetail as t where t.arriveBillNo=dbo.TSBArriveBill.arriveBillNo and t.isFinishReceive=0)";
                }
            }

            ds = arriveBillBB.GetList(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
        {
            arriveBillBB.Dispose();
        }
    }
Exemplo n.º 2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.StrWhere = "1=1";
            string id= Request.QueryString["id"];

            BArriveDetailBB arriveDetailBB = new BArriveDetailBB();
            TSBarrivebillBB arriveBillBB = new TSBarrivebillBB();
            DataSet ds = new DataSet();

            try
            {
                TSBarrivebillData data = arriveBillBB.GetModel(Convert.ToInt32(id));
                this.IdValue =  data.arriveBillNo;
                this.StrWhere = " arriveBillNo='" + data.arriveBillNo + "'";
                txtBillNo.Text = data.arriveBillNo;
                this.DtDetail = arriveDetailBB.GetTSVList(this.StrWhere).Tables[0];
            }
            finally
            {
                arriveDetailBB.Dispose();
            }

            this.BindGrid();
        }

        InitPageData();
    }
Exemplo n.º 3
0
 private void ShowArriveBillNo()
 {
     TSBarrivebillBB bb = new TSBarrivebillBB();
     lbCheckBillNo.Text = bb.GetCurrentArriveBillNo();
 }