| | |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | |
|---|
| | | //查询出站数量是否超过流转卡数量 |
|---|
| | | ds = oCN.RunProcReturn($@"select (b.HQty -sum(isnull(ou.HQty,0))-sum(isnull(ou.HBadCount,0))) HQty from Sc_ProcessExchangeBillSub b WITH(NOLOCK) |
|---|
| | | left join Sc_StationOutBillMain ou WITH(NOLOCK) on b.HInterID=ou.HProcExchInterID and b.HEntryID=ou.HProcExchEntryID |
|---|
| | | where b.HInterID={HProcExchInterID} and b.HEntryID={HProcExchEntryID} |
|---|
| | | group by b.HInterID,b.HEntryID,b.HQty", "Sc_ProcessExchangeBill_Out"); |
|---|
| | | |
|---|
| | | if (double.Parse(ds.Tables[0].Rows[0][0].ToString()) < 0) |
|---|
| | | { |
|---|
| | | oCN.RollBack(); |
|---|
| | | CustomWriteLog("流转卡:"+ HProcExchBillNo + ",出站数量超过流转卡数量!", DateTime.Now.ToString("yyyy-MM-dd")); |
|---|
| | | return false; |
|---|
| | | } |
|---|
| | | |
|---|
| | | bool flag = false; |
|---|
| | | |
|---|
| | | flag = AddXt_XtRoutBill(HInterID, HBillNo, HBadCodeSN); |
|---|
