| | |
|---|
| | | //检验打印数量（HQTY）和未打印数量 |
|---|
| | | string sql = $"select HQty + isnull(HMrbQty,0) - HBarcodeCount as HNotBarcodeCount ,* from Cg_POOrderBillSub where HEntryID = {oItemSub.HSourceEntryID}"; |
|---|
| | | DataSet ds = oCn.RunProcReturn(sql, "tables"); |
|---|
| | | if (ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0][0]) < oItemSub.HQty) |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count > 0 && Convert.ToDouble(ds.Tables[0].Rows[0][0]) < oItemSub.HQty) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | |
|---|
| | | var HSupName_verify = HBarCode_verify[7]; //校验供应商 |
|---|
| | | var HSourceBillNo_verify = HBarCode_verify[8]; //校验采购订单号 |
|---|
| | | |
|---|
| | | sql = $"select * from Gy_Material where HNumber = '{HMaterNumber_verify}' and HName = '{HMaterName_verify}' and HModel = '{HMaterModel_verify}'"; |
|---|
| | | sql = $"select * from Gy_Material where HNumber = '{HMaterNumber_verify}' and HName = '{HMaterName_verify}'"; |
|---|
| | | DataSet verifyMatInfo = oCn.RunProcReturn(sql, "tables"); |
|---|
| | | |
|---|
| | | sql = $"select * from Cg_POOrderBillMain where HBillNo = '{HSourceBillNo_verify}'"; |
|---|
