| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1" + sWhere + "order by åæ®å· desc ", "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1" + sWhere + " order by åæ®å· desc ", "h_v_JIT_Sc_WorkBillSortBillList"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | //æå
¥å表 |
| | | foreach (Models.Sc_WorkBillSortBillSub oSub in omodelsub) |
| | | { |
| | | oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HEntryID,HRemark,HMasterDate,HQty" + |
| | | oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ,HRemark,HMasterDate,HQty" + |
| | | ", HRptFinishQty, HTimes, HUseTimes, HBTimes, HETimes" + |
| | | ", HDateSub, HCloseMan, HEntryCloseDate, HCloseTypeSub, HColumn" + |
| | | ", HLockedSub, HComplete, HStatusTag, HIsHandModify)" + |