Exemplo n.º 1
0
        private void GetList()
        {
            string jh_dt = txtStart.Value;
            string xq_dt = txtEnd.Value;

            DataTable dtStlGrd = tmo_order.GetOrderPlanStlGrd(1, jh_dt, xq_dt).Tables[0];

            if (dtStlGrd.Rows.Count > 0)
            {
                rptStlGrd.DataSource = dtStlGrd;
                rptStlGrd.DataBind();
                ltlStlGrdSum.Text = dtStlGrd.Compute("sum(N_WGT)", "true").ToString();
            }
            else
            {
                rptStlGrd.DataSource = null;
                rptStlGrd.DataBind();
                ltlStlGrdSum.Text = "";
            }

            DataTable dtSpec = tmo_order.GetOrderPlanStlGrd(2, jh_dt, xq_dt).Tables[0];

            if (dtSpec.Rows.Count > 0)
            {
                rptSpec.DataSource = dtSpec;
                rptSpec.DataBind();
                ltlSpecSum.Text = dtSpec.Compute("sum(N_WGT)", "true").ToString();
            }
            else
            {
                rptSpec.DataSource = null;
                rptSpec.DataBind();
                ltlSpecSum.Text = "";
            }

            DataTable dtArea = tmo_order.GetOrderPlanStlGrd(3, jh_dt, xq_dt).Tables[0];

            if (dtArea.Rows.Count > 0)
            {
                rptArea.DataSource = dtArea;
                rptArea.DataBind();
                ltlsumjk.Text     = dtArea.Compute("sum(N_WGT_JK)", "true").ToString();
                ltlsumjp.Text     = dtArea.Compute("sum(N_WGT_JP)", "true").ToString();
                ltlsumpz.Text     = dtArea.Compute("sum(N_WGT_PZ)", "true").ToString();
                ltlsum_jp_pz.Text = dtArea.Compute("sum(SUM_JP_PZ)", "true").ToString();
            }
            else
            {
                rptArea.DataSource = null;
                rptArea.DataBind();
                ltlsumjk.Text     = "";
                ltlsumjp.Text     = "";
                ltlsumpz.Text     = "";
                ltlsum_jp_pz.Text = "";
            }
        }