| | |
| | | |
| | | //OledbXMLReportData.GenOneRecordset(this, "select * from Customers order by CustomerID"); |
| | | //SqlXMLReportData.GenOneRecordset(this, "select * from h_v_Kf_POStockInBillList_K3 where hmainid=1781"); |
| | | SqlXMLReportData.GenOneRecordset(this, "select åºåç»ç», 徿¥åä½,åæ®å·,æ¶æä»åº,æ¥æ,ç©æä»£ç ,ç©æåç§°,è§æ ¼åå·,计éåä½,宿¶æ°é,表ä½å¤æ³¨,å¶å人,å¶åæ¥æ,å®¡æ ¸äºº from h_v_Sc_MouldProdInHouseBillList where hmainid=" + Request.Params["linterid"]+ " group by åºåç»ç»,徿¥åä½,åæ®å·,æ¶æä»åº,æ¥æ,ç©æä»£ç ,ç©æåç§°,è§æ ¼åå·,计éåä½,宿¶æ°é,表ä½å¤æ³¨,å¶å人,å¶åæ¥æ,å®¡æ ¸äºº order by åæ®å·"); |
| | | SqlXMLReportData.GenOneRecordset(this, "select åºåç»ç», 徿¥åä½,åæ®å·,æ¶æä»åº,æ¥æ,ç©æä»£ç ,ç©æåç§°,è§æ ¼åå·,计éåä½,sum(宿¶æ°é) 宿¶æ°é,表ä½å¤æ³¨,å¶å人,å¶åæ¥æ,å®¡æ ¸äºº from h_v_Sc_MouldProdInHouseBillList where hmainid=" + Request.Params["linterid"]+ " group by åºåç»ç»,徿¥åä½,åæ®å·,æ¶æä»åº,æ¥æ,ç©æä»£ç ,ç©æåç§°,è§æ ¼åå·,计éåä½,表ä½å¤æ³¨,å¶å人,å¶åæ¥æ,å®¡æ ¸äºº order by åæ®å·"); |
| | | } |
| | | </script> |
| | | </head> |