| | |
|---|
| | | Value = ''; |
|---|
| | | } |
|---|
| | | |
|---|
| | | Value = "Where HStopFlag=0 and ( HNumber like '%" + Value + "%' or HName like '%" + Value + "%' ) " + getSWhereByHUser(); |
|---|
| | | Value = "Where HStopFlag=0 and ( HNumber like '%" + Value + "%' or HName like '%" + Value + "%' ) " + getSWhereByHUser() + addSWhereByOpenType(); |
|---|
| | | |
|---|
| | | $.ajax({ |
|---|
| | | type: "get", |
|---|
| | |
|---|
| | | return res; |
|---|
| | | } |
|---|
| | | //#endregion |
|---|
| | | |
|---|
| | | //#region å¤ææ¯ç´æ¥æå¼é¡µé¢è¿æ¯å
¶å®é¡µé¢éè¿éæ©æé®æå¼ï¼å¹¶æ¾ç¤ºç¸åºæ°æ® |
|---|
| | | function addSWhereByOpenType() { |
|---|
| | | //è·ååæ° |
|---|
| | | var params = getUrlVars(); |
|---|
| | | |
|---|
| | | var openType = params[params[1]]; //ä»åæ°ä¸è·å æå¼æ¹å¼ 1ç´æ¥æå¼ 2å
¶å®é¡µé¢éè¿éæ©æé®æå¼ 3æ ¹æ®éå
¥çèåå
ç ï¼æ¾ç¤ºç»å®è¯¥èåçç¨æ·æå
³èçå®¢æ· |
|---|
| | | var HEmpID = params[params[2]]; //èåID |
|---|
| | | var addSWhere = ""; |
|---|
| | | |
|---|
| | | if (openType == 3 && HEmpID!=0) { |
|---|
| | | addSWhere = " and HItemID in (select b.HCusID HItemID from Gy_Czygl as a inner join Gy_UserCustomerRelation as b on a.Czybm = b.HUserID where a.HEmpID = " + HEmpID + ") " |
|---|
| | | } |
|---|
| | | return addSWhere; |
|---|
| | | } |
|---|
| | | //#endregion |
|---|
| | | }); |
|---|
| | | </script> |
|---|
| | | |
|---|
