| | |
|---|
| | | string sql = string.Format(@"select 流水号 HProcNo,HProcID,工序代码 HProcNumber,工序名称 HProcName,加工说明 HWorkRemark,HCenterID,工作中心代码 HCenterNumber, |
|---|
| | | 工作中心 HCenterName,HSupID,供应商代码 HSupNumber,供应商 HSupName,isEntrust HSupFlag,计划数量 HQty,加工单价 HOutPrice, 表体备注 HRemark, |
|---|
| | | 进站关联数量 HRelationQty_In,出站关联数量 HRelationQty_Out,委外工单数量 HRelationQty_WWOrder,不合格数量 HRelationQty_Bad,超额比例 HOverRate, |
|---|
| | | 良率 HPassRate,累计良率 HSumPassRate,图纸编号 HPicNum,本工序确认记录 HProcCheckNote,工艺参数 HTechnologyParameter,HDeptID, |
|---|
| | | 加工车间代码 HDeptNumber,加工车间 HDeptName,出站报废关联数量 HRelationQty_OutBad,SN过站控制 HSNCtrl |
|---|
| | | 良率 HPassRate,累计良率 HSumPassRate,图纸编号 HPicNum,本工序确认记录 HProcCheckNote,工艺参数 HTechnologyParameter,HDeptID,HSourceID, |
|---|
| | | 加工车间代码 HDeptNumber,加工车间 HDeptName,出站报废关联数量 HRelationQty_OutBad,SN过站控制 HSNCtrl,HRoutingInterID HRoutingBillMainID,HRoutingEntryID HRoutingBillEntryID |
|---|
| | | from h_v_Sc_ProcessExchangeBillQuerySub"); |
|---|
| | | ds = oCN.RunProcReturn(sql+ " where hmainid="+ HInterID + " order by cast(流水号 as int) ", "h_v_Sc_ProcessExchangeBillQuerySub"); |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | |
|---|
| | | res.count = CountConstant.FAIL; |
|---|
| | | res.Message = "Exception！" + e.ToString(); |
|---|
| | | res.data = null; |
|---|
| | | return objJsonResult; |
|---|
| | | return res; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | |
|---|
| | | HProQty = oItemSub.HProQty; |
|---|
| | | |
|---|
| | | sql = "select * from h_v_Sc_ProcessExchangeBill_BatchSplit where hmainid = " + oItemSub.HICMOInterID + " and hentryid = " |
|---|
| | | + oItemSub.HICMOEntryID; |
|---|
| | | + oItemSub.HICMOEntryID + " and HRoutingID = " + oItemSub.HRoutingInterID.ToString(); |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessExchangeBill_BatchSplit"); |
|---|
| | | //主表赋值 |
|---|
| | | if (ds.Tables[0].Rows.Count > 0 && ds != null) |
|---|
| | |
|---|
| | | oItemSubs.HDeptID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[i]["HDeptID"]); |
|---|
| | | oItemSubs.HDeptNumber = ds.Tables[0].Rows[i]["HDeptNumber"].ToString(); |
|---|
| | | oItemSubs.HGroupID = 0; |
|---|
| | | oItemSubs.HGroupNumber = ""; |
|---|
| | | oItemSubs.HGroupNumber = oItemSub.HGroupNumber; |
|---|
| | | oItemSubs.HWorkerID = 0; |
|---|
| | | oItemSubs.HWorkerNumber = ""; |
|---|
| | | oItemSubs.HSourceID = 0; |
|---|
| | |
|---|
| | | oItemSubs.HSeOrderInterID = 0; |
|---|
| | | oItemSubs.HSeOrderEntryID = 0; |
|---|
| | | oItemSubs.HSNCtrl = false; |
|---|
| | | oItemSubs.HRoutingBillMainID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[i]["HRoutingID"]); |
|---|
| | | oItemSubs.HRoutingBillEntryID = Pub_Class.ClsPub.isLong(ds.Tables[0].Rows[i]["HRoutingEntryID"]); |
|---|
| | | |
|---|
| | | oBill.DetailColl.Add(oItemSubs);//添加明细行值 |
|---|
| | | } |
|---|
