| | |
| | | |
| | | function dy_PL(rest) { |
| | | var HInterID = rest[num].HInterID.toString(); |
| | | var sWhere = "select cast( b.æµæ°´å· as float) æµæ°´å·,ç产订åå·,a.ç产æ°é,a.æµè½¬å¡æ°é,a.产å代ç ,a.åæ®å·,case when ISNULL(a.çäº§è§æ ¼,'')='' then a.产åè§æ ¼ else a.çäº§è§æ ¼ end 产åè§æ ¼,a.产ååç§°,a.æ¥æ,a.åæ®å·,b.å·¥åºä»£ç ,b.å·¥åºåç§°,a.æ¹å·,b.å·¥èºå·¥ä½ä¸å¿,b.å·¥èºå·¥èºåæ°,a.ç产车é´,b.工段åç§°,b.çäº§è®¢åæ°é from h_v_Sc_ProcessExchangeBillQuery a left join h_v_Sc_ProcessExchangeBillQuerySub b on a.hmainid=b.hmainid where b.hmainid in(" + HInterID + ") and b.å·¥åºä»£ç != '9999' order by cast(b.æµæ°´å· as int)" |
| | | var sWhere = "select cast( b.æµæ°´å· as float) æµæ°´å·,ç产订åå·,a.éå®è®¢åå·,a.ç产æ°é,a.æµè½¬å¡æ°é,a.产å代ç ,a.åæ®å·,case when ISNULL(a.çäº§è§æ ¼,'')='' then a.产åè§æ ¼ else a.çäº§è§æ ¼ end 产åè§æ ¼,a.产ååç§°,a.æ¥æ,a.åæ®å·,b.å·¥åºä»£ç ,b.å·¥åºåç§°,a.æ¹å·,b.å·¥èºå·¥ä½ä¸å¿,b.å·¥èºå·¥èºåæ°,a.ç产车é´,b.工段åç§°,b.çäº§è®¢åæ°é from h_v_Sc_ProcessExchangeBillQuery a left join h_v_Sc_ProcessExchangeBillQuerySub b on a.hmainid=b.hmainid where b.hmainid in(" + HInterID + ") and b.å·¥åºä»£ç != '9999' order by cast(b.æµæ°´å· as int)" |
| | | |
| | | $.ajax({ |
| | | type: "GET", |