| | |
| | | |
| | | function dy(rest) { |
| | | var HInterID = rest[num].hmainid.toString(); |
| | | var sWhere = "select cast((cast( b.æµæ°´å· as float)/10) as decimal(6,1)) æµæ°´å·,ç产订åå·,a.ç产æ°é,a.æåå·,a.æµè½¬å¡æ°é,a.äº¤è´§æ¥æ,a.产å代ç ,a.åæ®å·,a.产åè§æ ¼,a.产ååç§°,a.æ¥æ,a.计åå®å·¥æ¥æ,a.åæ®å·,b.å·¥åºåç§°,b.模å
·ç¼å·,b.å·¥èºåæ°,b.å 工说æ,a.å¹
宽,a.å
é,a.ç½å¯è¦æ±,a.åºé¨å¤æ³¨,a.客æ·,a.ä¸å¡å,a.æ¯é«,a.寸æ°ç»ç»,a.å
¨æ¯é¿,a.å¯å¸å¯åº¦,a.æ¯çº±åç§°åè§æ ¼,a.åºä¸,a.è¾
æ°é,a.è¾
å©åä½,a.å®åæµæ,a.äº¤è´§æ¥æ,a.æè²è¦æ± from h_v_Sc_ProcessExchangeBillQuery a left join h_v_Sc_ProcessExchangeBillQuerySub b on a.hmainid=b.hmainid where b.hmainid in(" + HInterID + ") order by cast(b.æµæ°´å· as int)"; |
| | | var sWhere = "select cast((cast( b.æµæ°´å· as float)/10) as decimal(6,1)) æµæ°´å·,ç产订åå·,a.ç产æ°é,a.æåå·,a.æµè½¬å¡æ°é,a.äº¤è´§æ¥æ,a.产å代ç ,a.åæ®å·,a.产åè§æ ¼,a.产ååç§°,a.æ¥æ,a.计åå®å·¥æ¥æ,a.åæ®å·,b.å·¥åºåç§°,b.模å
·ç¼å·,b.å·¥èºåæ°,b.å 工说æ,case when ISNULL(a.ç产å¹
宽,0)=0 then a.å¹
宽 else a.ç产å¹
宽 end å¹
宽,case when ISNULL(a.ç产å
é,0) = 0 then a.å
é else a.ç产å
é end å
é,case when ISNULL(a.ç产ç½å¯è¦æ±,'')='' then a.ç½å¯è¦æ± else a.ç产ç½å¯è¦æ± end ç½å¯è¦æ±,a.åºé¨å¤æ³¨,a.客æ·,a.ä¸å¡å,a.æ¯é«,a.寸æ°ç»ç»,a.å
¨æ¯é¿,a.å¯å¸å¯åº¦,a.æ¯çº±åç§°åè§æ ¼,a.åºä¸,a.è¾
æ°é,a.è¾
å©åä½,a.å®åæµæ,a.äº¤è´§æ¥æ,a.æè²è¦æ± from h_v_Sc_ProcessExchangeBillQuery a left join h_v_Sc_ProcessExchangeBillQuerySub b on a.hmainid=b.hmainid where b.hmainid in(" + HInterID + ") order by cast(b.æµæ°´å· as int)"; |
| | | $.ajax({ |
| | | type: "GET", |
| | | url: GetWEBURL() + "/Gy_SOPBillList/WindowPrintList", //æ¹æ³æå¨é¡µé¢åæ¹æ³å |