| | |
|---|
| | | 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.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.HDeptID,D.HName HDeptName, A.HSendMan,a.HCenterID HCenterID,wo.HName HCenterName, |
|---|
| | | A.HReceiveMan,A.HCopyMan,A.HHasten, |
|---|
| | | A.HLevel,A.HMaterNumber,A.HMaterName,A.HMaterModel, |
|---|
| | | B.HReadFlag, A.HMaker,A.HMakeDate,A.HUpDater,A.HUpDateDate,A.HChecker,A.HCheckDate,A.HCloseMan,A.HCloseDate,A.HDeleteMan,A.HDeleteDate, |
|---|
| | |
|---|
| | | 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 |
|---|
| | | left join Gy_WorkCenter wo on a.HCenterID=wo.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) |
|---|
| | |
|---|
| | | { |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | |
|---|
| | | string sql = "select a.HSourceBillNo 流转卡号,a.HSourceBillType 流转卡类型,a.HSourceInterID 流转卡主内码,a.HSourceEntryID 流转卡子内码,b.HNumber 物料代码,b.HName 物料名称,b.HModel 规格型号,a.HPlanQty 计划数量,a.HSourceID,c.HName 生产资源 from Sc_ICMOBillStatus_Tmp a " + |
|---|
| | | string sql = "select a.HSourceBillNo 流转卡号,a.HSourceBillType 流转卡类型,a.HSourceInterID 流转卡主内码,a.HSourceEntryID 流转卡子内码,b.HNumber 物料代码,b.HName 物料名称,b.HModel 规格型号,a.HDatePlanQty 计划数量,a.HSourceID,c.HName 生产资源 from Sc_ICMOBillStatus_Tmp a " + |
|---|
| | | "left join Gy_Material b on a.HMaterID=b.HItemID left join Gy_Source c on a.HSourceID=c.HItemID where HSourceBillNo='" + HSourceBill + "'"; |
|---|
| | | ds = oCN.RunProcReturn(sql, "Sc_ICMOBillStatus_Tmp"); |
|---|
| | | |
|---|
