| | |
| | | } |
| | | |
| | | //检查源单是否存在 |
| | | string sql = "select * from Sc_ICMOBillSub where HInterID = " + oBill.omodel.HMainSourceInterID + " and HEntryID =" + oBill.omodel.HMainSourceEntryID; |
| | | ds = oCN.RunProcReturn(sql, "Sc_ICMOBillSub"); |
| | | string sql = "select * from Sc_ICMOBillMain as a " + |
| | | " inner join Sc_ICMOBillSub as b on a.HInterID = b.HInterID " + |
| | | " where b.HInterID = " + oBill.omodel.HMainSourceInterID + " and b.HEntryID =" + oBill.omodel.HMainSourceEntryID; |
| | | ds = oCN.RunProcReturn(sql, "Sc_ICMOBill"); |
| | | if(ds==null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |