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;
}
}
