| | |
| | | <publishTime>02/02/2024 10:30:06</publishTime> |
| | | </File> |
| | | <File Include="views/åºç¡èµæ/å
¬ç¨åºç¡èµæ/xmlLBM_Sc_ProcessExchangeArrangement.aspx"> |
| | | <publishTime>09/22/2023 08:58:26</publishTime> |
| | | <publishTime>02/24/2025 09:02:28</publishTime> |
| | | </File> |
| | | <File Include="views/åºç¡èµæ/å
¬ç¨åºç¡èµæ/xmlLBM_Sc_ProcessExchangeBillList.aspx"> |
| | | <publishTime>12/18/2024 09:58:22</publishTime> |
| | |
| | | //â
ç¹å«æç¤ºâ
ï¼ |
| | | //ä¸åçæ°æ®åºåºè¯¥éç¨ä¸åçæ¥è¡¨XMLæ°æ®çæç±»ï¼SQL Serveræ°æ®åºç¨SqlXMLReportDataï¼Oracleæ°æ®åºç¨OracleXMLReportData |
| | | //OledbXMLReportDataéåäºAccessçæ¬å°æ°æ®åºï¼ä¸ºäºæ¼ç¤ºæ¹ä¾¿ï¼è¿éä»Grid++ReportçAccessä¾åæ°æ®åºä¸è·åæ¥è¡¨æ°æ® |
| | | SqlXMLReportData.GenOneRecordset(this, @" select a.HICMOBillNo ç产订åå·,a.HBillNo æå¼å¡,a.HMainSourceBillNo æµè½¬å¡å·,a.HMakeDate æ¥æ,m.HNumber é¢è²,m.HName è²å·,m.HModel è§æ ¼,cu.HName 客æ·,e.HName ä¸å¡å,b.sumCount åªæ° ,isnull(HmaterOutqty,0) éé ,s.HName çäº§èµæº |
| | | SqlXMLReportData.GenOneRecordset(this, @" select a.HICMOBillNo ç产订åå·,a.HBillNo æå¼å¡,a.HMainSourceBillNo æµè½¬å¡å·,a.HMakeDate æ¥æ,m.HNumber é¢è²,m.HName è²å·,m.HModel è§æ ¼,m.HWeight å
é,cu.HName 客æ·,e.HName ä¸å¡å,b.sumCount åªæ° ,isnull(HmaterOutqty,0) éé ,s.HName çäº§èµæº |
| | | from Sc_ProcessExchangeBillMain a |
| | | left join |
| | | ( select HICMOBillNo,count(*) sumCount |