| | |
|---|
| | | sub = JsonConvert.DeserializeObject<List<Model.ClsSc_AssemblyBillSub>>(sSubStr); |
|---|
| | | |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_Sc_SNBarcodeProcCtrl_S '" + omodel.HBarCode_P + "'," + omodel.HProcID, "h_v_Gy_QualifiedRecordsList"); |
|---|
| | | if (ClsPub.isInt(ds.Tables[0].Rows.Count) == 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = "查无数据!"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | else if (ds.Tables[0].Rows[0]["HBack"].ToString() == "2") |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | | objJsonResult.count = 0; |
|---|
| | | objJsonResult.Message = ds.Tables[0].Rows[0]["HBackRemark"].ToString() + "！"; |
|---|
| | | objJsonResult.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | } |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_QualifiedRecordsList WITH(NOLOCK) where 产品条码='" + omodel.HBarCode_P + "' and HProcExchInterID="+ omodel .HProcExchInterID+ " and HProcExchEntryID="+ omodel.HProcExchEntryID + " and HProcID="+ omodel.HProcID, "h_v_Gy_QualifiedRecordsList"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count > 0) |
|---|
| | |
|---|
| | | |
|---|
| | | sMainStr = "[" + sMainStr + "]"; |
|---|
| | | List<StationBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<StationBill>>(sMainStr); |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("select HCenterID from Sc_ProcessExchangeBillSub WITH(NOLOCK) where HInterID=" + list[0].HProcExchInterID + " and HEntryID=" + list[0].HProcExchEntryID, "Sc_ProcessExchangeBillSub"); |
|---|
| | | if (ds.Tables[0].Rows.Count > 0) |
|---|
| | | { |
|---|
| | | list[0].HCenterID = long.Parse(ds.Tables[0].Rows[0]["HCenterID"].ToString()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | long HMainInterID = 0; |
|---|
| | | string BillType = "3791"; |
|---|
| | | string HBillSubType = "3791"; |
|---|
| | |
|---|
| | | values({HInterID}, '{HBillNo}', {(ds.Tables[0].Rows.Count == 0 ? 1 : int.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()) + 1)}, '{omodel.HBarCode_P}', 1, GETDATE(), '', " + HProcExchInterID + ","+ HProcExchEntryID + ", '"+ HProcExchBillNo + "', '', 0, 0)"); |
|---|
| | | |
|---|
| | | //反写工序出站单的合格数量 |
|---|
| | | oCN.RunProc("update Sc_StationOutBillMain set HQty+=1 where HProcExchInterID='" + HProcExchInterID + "' and HProcExchEntryID=" + HProcExchEntryID); |
|---|
| | | oCN.RunProc("update Sc_StationOutBillMain set HQty+=1 where HProcExchInterID='" + HProcExchInterID + "' and HProcExchEntryID=" + HProcExchEntryID+ " and HInterID=" + HInterID); |
|---|
| | | |
|---|
| | | oCN.Commit(); |
|---|
| | | |
|---|
