| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | //检查源单是否存在 |
|---|
| | | 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"; |
|---|
| | |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | else if (ds.Tables[0].Rows[0]["HBillStatus"].ToString() != "2") |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "审核失败!原因:源单未处于审核状态!"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | oCN.BeginTran(); |
|---|
| | | //反写源单数据 |
|---|
