提料信息缺失报表:增加判断,若客户是宝工,则增加 对 供应商绑定业务员的过滤
| | |
| | | |
| | | var sql = "select * from h_v_Cg_PODemandPlanConfigBillReportForLack where 1=1 " + sWhere; |
| | | |
| | | if (defaintOperationByCompanyName()) { |
| | | sql += " and (ISNULL(FStaffId,0) = 0 or FStaffId in (select HEmpID from Gy_Czygl where Czymc = '" + sessionStorage["HUserName"] + "') or '" + sessionStorage["HUserName"] + "' = 'admin') "; |
| | | } |
| | | |
| | | get_Display(sql); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | |
| | | } |
| | | //#endregion |
| | | |
| | | //#region è·åå
¬å¸åï¼æ ¹æ®å
¬å¸è¿è¡å®å¶åå¼å |
| | | function defaintOperationByCompanyName() { |
| | | var result = false; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Xt_getInfo/getCompanyName', |
| | | async: false, |
| | | type: "GET", |
| | | data: {}, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | if (data1.data == "å®å·¥") { |
| | | result = true; |
| | | } |
| | | } |
| | | }, error: function (e) { |
| | | } |
| | | }); |
| | | return result; |
| | | } |
| | | //#endregion |
| | | |
| | | //#region å·æ° |
| | | function get_Refresh() { |
| | | $("#btnSearch").trigger('click'); |