protected void PurorderdetailRepeaterbind() { string sqltext = ""; string orderno = gloabsheetno; sqltext = "select A.*,B.BJSJ from VIEW_TBMP_ACCOUNTS AS A LEFT JOIN (select PTC,BJSJ,rn from (select *,row_number() over(partition by PTC order by ISAGAIN) as rn from View_TBQM_APLYFORITEM) as a where rn<=1 )B ON A.TA_PTC=B.PTC WHERE TA_DOCNUM='" + gloabsheetno + "' order by TA_DOCNUM DESC,PIC_JGNUM desc"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); PurorderdetailRepeater.DataSource = dt; PurorderdetailRepeater.DataBind(); if (PurorderdetailRepeater.Items.Count > 0) { NoDataPane.Visible = false; } else { NoDataPane.Visible = true; } }
protected void PurorderdetailRepeaterbind() { string sqltext = ""; string orderno = gloabsheetno; sqltext = "select B.BJSJ, TO_DOCNUM, TO_BJDOCNUM, TO_PTC, TO_ZDR, TO_ZDTIME, TO_SUPPLYID, TO_AMOUNT, CONVERT(varchar(12) , TO_JHQ,23) as TO_JHQ, CONVERT(varchar(12) , TO_SJJHQ,23) as TO_SJJHQ, TO_NOTE, TO_STATE, PIC_SHEETNO, PIC_JGNUM, PIC_JSNUM, PIC_BJSTATUS, PIC_WXTYPE, PIC_TUHAO, PIC_MNAME, PIC_ZXNUM, PIC_SUPPLYTIME, PIC_PRICE, TO_ZDRNAME, PIC_PTCODE, TO_PROCESS, TO_UWGHT, TO_MONEY, TO_SUPPLYNAME, TO_ENGNAME, TO_TOTALNOTE from VIEW_TBMP_Order AS A LEFT JOIN (select PTC,BJSJ,rn from (select *,row_number() over(partition by PTC order by ISAGAIN) as rn from View_TBQM_APLYFORITEM) as a where rn<=1 ) as B ON A.TO_PTC=B.PTC WHERE TO_DOCNUM='" + gloabsheetno + "' ORDER BY TO_DOCNUM DESC,TO_BJDOCNUM DESC,TO_PTC DESC"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); PurorderdetailRepeater.DataSource = dt; PurorderdetailRepeater.DataBind(); if (PurorderdetailRepeater.Items.Count > 0) { NoDataPane.Visible = false; } else { NoDataPane.Visible = true; } }
protected void PurorderdetailRepeaterbind() { string sqltext = ""; string orderno = gloabsheetno; sqltext = "SELECT orderno as PO_SHEETNO,picno as PO_ICLSHEETNO,ptcode as PO_PCODE ," + "marid as PO_MARID,marnm as PO_MARNAME,margg as PO_GUIGE,marcz as PO_CAIZHI," + "margb as PO_GUOBIAO,marunit as PO_UNIT,convert(float,num) as PO_QUANTITY,convert(float,zxnum) as PO_ZXNUM," + "convert(float,fznum) as PO_FZNUM,convert(float,zxfznum) as PO_ZXFZNUM,marfzunit as PO_FZUNIT,PO_PZ,cgtimerq as PO_CGTIMERQ," + "convert(float,recgdnum) as PO_RECGDNUM,recdate as PO_RECDATE,convert(float,price) as PO_UPRICE,convert(float,ctprice) as PO_CTAXUPRICE," + "convert(float,amount) as PO_AMOUNT,taxrate as PO_TAXRATE,convert(float,ctamount) as PO_TOTALPRICE," + "detailnote as PO_NOTE,planmode as PO_PMODE,ptcode as PO_PTCODE,PO_MASHAPE,length as PO_LENGTH," + "width as PO_WIDTH,keycoms as PO_KEYCOMS,detailstate as PO_STATE,detailcstate as PO_CSTATE," + "engid as PO_ENGID,PO_TUHAO,MWEIGHT,GUIGE " + "FROM (select * from ((select * from View_TBPC_PURORDERDETAIL_PLAN)a left join (select MWEIGHT,GUIGE,ID as TBMA_ID from TBMA_MATERIAL)b on a.marid=b.TBMA_ID))c WHERE orderno='" + orderno + "' and detailcstate='0' order by ptcode,marnm,margg asc"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); //DataView dv = null; //if (Tb_MARNAME.Text != "") //{ // dv = dt.DefaultView; // dv.RowFilter = "PO_MARNAME like '%" + Tb_MARNAME.Text + "%'"; //对dataView进行筛选 // dt = dv.ToTable(); //} //if (Tb_MARGG.Text != "") //{ // dv = dt.DefaultView; // dv.RowFilter = "PO_GUIGE like '%" + Tb_MARGG.Text + "%'"; //对dataView进行筛选 // dt = dv.ToTable(); //} PurorderdetailRepeater.DataSource = dt; PurorderdetailRepeater.DataBind(); if (PurorderdetailRepeater.Items.Count > 0) { NoDataPane.Visible = false; } else { NoDataPane.Visible = true; } }