| | |
| | | <script src="../../../layuiadmin/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/soulTable.slim.js"></script> |
| | | <script src="../../../layuiadmin/PageTitle.js"></script> |
| | | <script src="../../../layuiadmin/common.js"></script> |
| | | |
| | | |
| | | </head> |
| | |
| | | //åå§åç»ç» |
| | | Organ(); |
| | | //æ¥è¯¢ |
| | | if (addSWhereByOpenType()) { //addSWhereByOpenType()æ¹æ³å¤ææ¯å¦å
¶å®é¡µé¢æå¼æ¬é¡µé¢ï¼è¥æ¯åå¤çè¿æ»¤æ¡ä»¶ï¼å¹¶è¿åtrue |
| | | get_FastQuery(2); |
| | | } else { |
| | | get_FastQuery(1); |
| | | } |
| | | //æ¥è¯¢å½åç»å½ç¨æ·ææ²¡æå¨å½å模å设置é»è®¤è¿æ»¤æ¹æ¡ |
| | | get_DefaultModule(); |
| | | } |
| | |
| | | //#region å¿«éè¿æ»¤ |
| | | function get_FastQuery(number) { |
| | | ////è·åç»å½è´¦æ·å¯¹åºèååç§° |
| | | |
| | | let openType = addSWhereByOpenType() |
| | | var HUserName = getHEmpByHUserName(); |
| | | if (HUserName != "" && HUserName != null) { |
| | | sWhere = " and æ±æ¥äºº = N'" + HUserName + "' OR æ¥æ¶äºº = N'" + HUserName + "' OR æé人 like N'%" |
| | | sWhere += " and æ±æ¥äºº = N'" + HUserName + "' OR æ¥æ¶äºº = N'" + HUserName + "' OR æé人 like N'%" |
| | | + HUserName + "%'"; |
| | | } |
| | | |
| | | |
| | | var HOrgID = ""; |
| | | var HBillNo = $("#HBillNo").val(); //åæ®å· |
| | |
| | | } |
| | | sWhere += " and " + ColName2 + " " + com2; |
| | | } |
| | | if (number == 1) { |
| | | if (openType == false) { |
| | | HOrgID = sessionStorage["OrganizationID"]; |
| | | } |
| | | else { |
| | |
| | | var params = getUrlVars(); |
| | | var openType = params[params[0]]; //ä»åæ°ä¸è·å æå¼æ¹å¼ 1ç´æ¥æå¼ 2å
¶å®é¡µé¢éè¿éæ©æé®æå¼ |
| | | var HOrgID = params[params[1]]; |
| | | var Employee = params[params[2]]; // èå |
| | | var DateInfo = params[params[3]]; // æ¥æä¿¡æ¯ |
| | | if (isEmpty(Employee) === false && isEmpty(DateInfo) === false) { |
| | | let EmployeeDecode = decodeURIComponent(Employee) |
| | | debugger |
| | | $('#HReportEmp').val(EmployeeDecode) |
| | | if (DateInfo.length == 7) { //å¹´æ |
| | | sWhere += " and æ¥æ >= CAST(N'" + DateInfo + "' + '-01' AS DATE) and æ¥æ < DATEADD(MONTH, 1, CAST(N'" + DateInfo + "' + '-01' AS DATE))" |
| | | } else if (DateInfo.length == 10) { //å¹´ææ¥ |
| | | sWhere += " and æ¥æ >= CAST(N'" + DateInfo + "' AS DATE) and æ¥æ < DATEADD(DAY, 1, CAST(N'" + DateInfo + "' AS DATE))" |
| | | } |
| | | } |
| | | if (openType == 2) { |
| | | sWhere += " and ISNULL(å
³é人,'') = '' and ISNULL(ä½åºäºº,'') = '' "; |
| | | $("#HOrgID").val(HOrgID); |