Merge branch 'master' of http://101.37.171.70:10101/r/MESWMS-LayUI
| | |
| | | //ä¸åçæ°æ®åºåºè¯¥éç¨ä¸åçæ¥è¡¨XMLæ°æ®çæç±»ï¼SQL Serveræ°æ®åºç¨SqlXMLReportDataï¼Oracleæ°æ®åºç¨OracleXMLReportData |
| | | //OledbXMLReportDataéåäºAccessçæ¬å°æ°æ®åºï¼ä¸ºäºæ¼ç¤ºæ¹ä¾¿ï¼è¿éä»Grid++ReportçAccessä¾åæ°æ®åºä¸è·åæ¥è¡¨æ°æ® |
| | | |
| | | SqlXMLReportData.GenOneRecordset(this, "select a.HItemID 设å¤ç¼å·,a.HName 设å¤åç§°,g.HName æå±è½¦é´,e.HName 责任人 from Gy_Source a left join Gy_Department g on a.HDeptID=g.HItemID left join Gy_Employee e on a.HEmpID=e.HItemID where a.HItemID=" + Request.Params["linterid"]); |
| | | SqlXMLReportData.GenOneRecordset(this, "select a.hnumber çäº§èµæºç¼ç ,a.HItemID 设å¤ç¼å·,a.HName 设å¤åç§°,g.HName æå±è½¦é´,e.HName 责任人 from Gy_Source a left join Gy_Department g on a.HDeptID=g.HItemID left join Gy_Employee e on a.HEmpID=e.HItemID where a.HItemID in(" + Request.Params["linterid"]+")"); |
| | | } |
| | | </script> |
| | | </head> |
| | |
| | | , { field: 'ç产任å¡åæ°é', title: 'çäº§è®¢åæ°é', totalRow: true } |
| | | , { field: '计éåä½', title: '计éåä½' } |
| | | , { field: 'æ¯å¦ä¸æ¨çææµè½¬å¡', title: 'æ¯å¦ä¸æ¨çææµè½¬å¡', sort: true } |
| | | , { field: 'æ¯å¦ååºå', title: 'æ¯å¦ååºå', sort: true } |
| | | , { field: 'å¶å人', title: 'å¶å人' } |
| | | , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ' } |
| | | , { field: 'ç¶æ', title: 'ç¶æ', sort: true } |
| | |
| | | table.render(option); |
| | | |
| | | //å·æ°è¡¨æ ¼æ°æ® |
| | | //DisPlay_HideColumn(); |
| | | DisPlay_HideColumn(); |
| | | |
| | | if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { |
| | | ColFilter(); |