| | |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | //瑞琪字段 ,B.HExpressNumberSub,B.HExpressSupplierSub,B.HRemark |
|---|
| | | //瑞琪字段 |
|---|
| | | sql = string.Format(@" |
|---|
| | | SELECT T3.FNAME AS FTYPENAME,M.HBILLNO,B.HINTERID,B.HENTRYID,C.FID,C.FENTRYID, D.FBILLNO,B.HQTY,CD.FRECEIVEORGID,CDOO.FNUMBER AS FRECEIVENUMBER |
|---|
| | | ,D.FSUPPLIERID,DS.FNUMBER AS FSUPPLIERNUMBER,D.FPURCHASEORGID,DOO.FNUMBER AS FPURCHASEORGNUMBER,CROO.FNUMBER AS FSETTLEORGNUMBER, |
|---|
| | | E.FPRICETIMEPOINT,E.FSETTLECURRID,EC.FNUMBER AS FSETTLECURRNUMBER,C.FMATERIALID,CM.FNUMBER AS FMATERIALNUMBER ,C.FUNITID |
|---|
| | | ,CU.FNUMBER AS FUNITNUMBER,CR.FPRICE,CR.FTAXPRICE,CR.FTAXRATE,D.FPURCHASERID,isnull(T4.FNUMBER,'') AS FPURCHASERNUMBER |
|---|
| | | |
|---|
| | | ,B.HExpressNumberSub,B.HExpressSupplierSub,B.HRemark,B.HPlanArrivalDate,B.HBoxNumber |
|---|
| | | FROM CG_POINSTOCKBILLSUB B |
|---|
| | | JOIN CG_POINSTOCKBILLMAIN M ON B.HINTERID = M.HINTERID |
|---|
| | | JOIN {0}..T_PUR_POORDERENTRY C ON B.HSOURCEINTERID = C.FID AND B.HSOURCEENTRYID = C.FENTRYID |
|---|
| | |
|---|
| | | FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//含税单价 |
|---|
| | | FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//税率 |
|---|
| | | |
|---|
| | | //FentityModel.Add("F_bsv_Text1", item["HExpressSupplierSub"].ToString());//物流单位 (瑞琪) |
|---|
| | | //FentityModel.Add("F_bsv_Text2", item["HExpressNumberSub"].ToString());//物流单号 (瑞琪) |
|---|
| | | //FentityModel.Add("FDescription", item["HRemark"].ToString());//表体备注 (瑞琪) |
|---|
| | | FentityModel.Add("F_bsv_Text1", item["HExpressSupplierSub"].ToString());//物流单位 (瑞琪) |
|---|
| | | FentityModel.Add("F_bsv_Text2", item["HExpressNumberSub"].ToString());//物流单号 (瑞琪) |
|---|
| | | FentityModel.Add("FDescription", item["HRemark"].ToString());//表体备注 (瑞琪) |
|---|
| | | FentityModel.Add("F_bsv_dhrq", item["HPlanArrivalDate"].ToString());//到货日期 (瑞琪) |
|---|
| | | FentityModel.Add("F_bsv_xh", item["HBoxNumber"].ToString());//箱号 (瑞琪) |
|---|
| | | |
|---|
| | | JArray Fentity2 = new JArray(); |
|---|
| | | JObject FentityModel2 = new JObject(); |
|---|
