| | |
| | | return new ApiResult<DataSet> { code = -1, msg = "ID不能为空" }; |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | string sql =string.Format(@"select A.HInterID,b.HEntryID,A.HBillStatus,A.HBillNo,A.HDate,A.HContext,A.HDescription,A.HRemark, |
| | | A.HQty,A.HSendType, |
| | | A.HQty,A.HSendType,a.HForm,a.HChangeNote,a.HNote,a.HBadProcMan,f1.HName HBadProcManName, |
| | | a.HQEMan,f2.HName HQEManName,a.HSourceID,s.HName HSourceName,a.HShiftsID,s1.HName HShiftsName, |
| | | A.HDeptID,D.HName HDeptName, A.HSendMan, |
| | | A.HReceiveMan,A.HCopyMan,A.HHasten, |
| | | A.HLevel,A.HMaterNumber,A.HMaterName,A.HMaterModel, |
| | |
| | | left join Gy_Department D on A.HDeptID=D.HItemID |
| | | left join Gy_Employee f on A.HHandleEmpID=f.HItemID |
| | | left join Gy_ErrMsgBackType g on A.HErrMsgBackTypeID=g.HItemID |
| | | left join Gy_Employee f1 on a.HBadProcMan=f1.HItemID |
| | | left join Gy_Employee f2 on a.HQEMan=f2.HItemID |
| | | left join Gy_Source s on a.HSourceID=s.HItemID |
| | | left join Gy_Shifts s1 on a.HShiftsID=s1.HItemID |
| | | where A.HInterID='" + HID + "' and b.HEntryID='" + HEntryID + "'"); |
| | | var dataSet = oCN.RunProcReturn(sql, "OA_ErrMsgBackBillMain"); |
| | | if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) |