| | |
| | | columns.push({ field: 'æ¨æ¥æ°é', title: 'æ¨æ¥æ°é' }); |
| | | columns.push({ field: 'ä¼å
级', title: 'ä¼å
级', width: 150, edit: 'text', sort: true }); |
| | | columns.push({ field: 'çäº§èµæº', title: 'çäº§èµæº', width: 150, edit: 'text', event: "HSourceID" }); |
| | | columns.push({ field: 'æä½å·¥', title: 'æä½å·¥', width: 150, edit: 'text', event: "HEmpID" }); |
| | | |
| | | columns.push({ field: '使ç¨å·¥è£
', title: '使ç¨å·¥è£
', width: 150 }); |
| | | columns.push({ |
| | | field: Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd'), title: Format(myDate.getTime() + 0 * oneday, 'MM.dd'), edit: 'text', width: 70, templet: function (d) { |
| | | return DayColor(d[Format(myDate.getTime() + 0 * oneday, 'yyyy/MM/dd')], d[Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd')], d, Format(myDate.getTime() + 0 * oneday, 'yyyy-MM-dd')); |
| | |
| | | columns.push({ field: 'HEmpID', title: 'HEmpID', hide: true }); |
| | | columns.push({ field: 'æåæ±æ¥æ°é', title: 'æåæ±æ¥æ°é', width: 150, edit: 'text', sort: true }); |
| | | columns.push({ field: 'éå®å·¥å', title: 'éå®å·¥å', width: 150, sort: true, filter: true });//0 |
| | | columns.push({ field: 'HMouldID', title: 'HMouldID', width: 150, hide: true }); |
| | | columns.push({ field: 'æä½å·¥', title: 'æä½å·¥', width: 150, edit: 'text', event: "HEmpID" }); |
| | | columns.push({ fixed: 'right', title: 'æä½', toolbar: '#barDemo' }); |
| | | option_columns = columns; |
| | | option = { |
| | |
| | | }); |
| | | |
| | | //æ ¹æ®è½¦é´å 餿²¡æéå®çæ°æ® |
| | | var sql = "delete from Sc_WorkBillSortBillSub where HMasterDate>=convert(varchar(10) ,DATEADD(DAY," + HPlanDay + ",GETDATE()),20) and HInterID in(select HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + " and HLockOrder != 1 )"; |
| | | var sql = "delete from Sc_WorkBillSortBillSub where HLockedSub != 1 and HInterID in (select HInterID from Sc_WorkBillSortBillMain where HWorkShopID=" + HWorkShopID + " and HLockOrder != 1 )"; |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Gy_SOPBillList/UpDelSQL', |
| | | type: "GET", |
| | |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | ds = data1.data |
| | | option.data[i]["HMouldID"] = data1.data[0].HMouldID; |
| | | option.data[i]["使ç¨å·¥è£
"] = data1.data[0].使ç¨å·¥è£
; |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | ds = data1.data |
| | | option.data[i]["HMouldID"] = data1.data[0].HMouldID; |
| | | option.data[i]["使ç¨å·¥è£
"] = data1.data[0].使ç¨å·¥è£
; |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |