| | |
| | | { |
| | | DBUtility.ClsPub.CurUserName = UserName; |
| | | //缂栬緫鏉冮檺 |
| | | if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Delete", 1, true, DBUtility.ClsPub.CurUserName)) |
| | | if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | try |
| | | { |
| | | //瀹℃牳鏉冮檺 |
| | | if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, true, CurUserName)) |
| | | if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | string refSav = sArray[2].ToString(); |
| | | DBUtility.ClsPub.CurUserName = UserName; |
| | | //淇濆瓨鏉冮檺 |
| | | if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Edit", 1, true, DBUtility.ClsPub.CurUserName)) |
| | | if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Edit", 1, false, DBUtility.ClsPub.CurUserName)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | ,b.HSourceInterID,b.HSourceEntryID,b.HSourceBillNo,b.HSourceBillType |
| | | from Sc_ProcessReportMain a |
| | | inner join Sc_ProcessReportSub b on a.HInterID=B.HInterID |
| | | inner join (select max(HProcNo) HProcNo |
| | | inner join (select max(HProcNo) HProcNo,max(HProcID) HProcID |
| | | from Sc_ProcessPlanSub group by HBillNo,HSourceBillNo) |
| | | pr on b.HProcID=pr.HProcNo |
| | | pr on b.HProcID=pr.HProcID |
| | | left join Gy_Process p on b.HProcID=p.HItemID |
| | | left join Gy_Material m on a.HMaterID=m.hitemid |
| | | left join Gy_Source s on b.HSourceID=s.HItemID |
| | |
| | | { |
| | | string StrMessage = ""; |
| | | //瀹℃牳鏉冮檺 |
| | | if (!WebClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName, ref StrMessage)) |
| | | if (!WebClsPub.Security_Log(ModRightNameCheck, 1, false, CurUserName, ref StrMessage)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |