| | |
| | | public Int64 HPRDORGID; |
| | | //ææç¶æ |
| | | public bool HUseFlag; |
| | | |
| | | } |
| | | } |
| | |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | ClsXt_SystemParameter oClsXt_SystemParameter = new ClsXt_SystemParameter(); |
| | | string sCapName = oClsXt_SystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (sCapName.Contains("å¯è´")) |
| | | { |
| | | DataTable dt = getInfodatanow(oItem.HSourceID.ToString()); |
| | | if (dt.Rows.Count > 0) |
| | | { |
| | | DataRow dr = dt.Rows[0]; |
| | | oItem.HRunStatus = dr["runStu"].ToString(); |
| | | oItem.HSourceBeginQty = Convert.ToDecimal(dr["countAll"]); |
| | | } |
| | | } |
| | | DBUtility.ClsPub.CurUserName =oItem.HMaker; |
| | | oItem.HBillType = "3787"; |
| | | oItem.HBillSubType = "3787"; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | public DataTable getInfodatanow(string hsoucreID) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | string sql = $" select HMacAddr, runStu, countAll from Gy_Source t1 left join HX_LIOTsys..Info_data_now t2 on t1.HMacAddr = t2.hid where t1.hitemid={hsoucreID}"; |
| | | DataTable dt = oCn.RunProcReturn(sql, "dt").Tables[0]; |
| | | return dt; |
| | | } |
| | | |
| | | #region æ¥å·¥å¹³å°éªè¯åæ®ç¶æ |
| | | [Route("Sc_MESBeginWorkBill/GetMESBeginWorkBillStaus")] |
| | | [HttpGet] |
| | |
| | | ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HBeginWorkTime,HSourceID" + |
| | | ",HSourceInterID_Main,HSourceEntryID_Main,HSourceBillNo_Main,HSourceBillType_Main" + |
| | | ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" + |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" + |
| | | ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate,HRunStatus,HSourceBeginQty" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",getdate(),'" + omodel.HMaker+ "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" + |
| | |
| | | ",'" + omodel.HProcExchBillNo + "'," + omodel.HMaterID.ToString() + "," + omodel.HProcID.ToString() + "," + omodel.HICMOQty.ToString() + "," + omodel.HPlanQty.ToString() + ",getdate()," + omodel.HSourceID.ToString() + |
| | | ",'" + omodel.HMainSourceInterID.ToString() + "'," + omodel.HMainSourceEntryID.ToString() + ",'" + omodel.HMainSourceBillNo.ToString() + "','" + omodel.HMainSourceBillType.ToString() + "'" + |
| | | ",'" + omodel.HMainSourceInterID.ToString() + "'," + omodel.HMainSourceEntryID.ToString() + ",'" + omodel.HMainSourceBillNo.ToString() + "','" + omodel.HMainSourceBillType.ToString() + "'" + |
| | | "," + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() + "," + omodel.HEmpID.ToString() + ",'" + omodel.HBarCode + "','" + omodel.HAddr + "','" + omodel.HBarCodeMaker + "',getdate()" + |
| | | "," + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() + "," + omodel.HEmpID.ToString() + ",'" + omodel.HBarCode + "','" + omodel.HAddr + "','" + omodel.HBarCodeMaker + "',getdate(),'"+ omodel.HRunStatus + "','"+ omodel.HSourceBeginQty.ToString() + "'" + |
| | | ") "); |
| | | |
| | | //忬¡éªè¯ ä¿åæ¯å¦ åç |
| | |
| | | public String HBarCodeMaker; |
| | | public DateTime HBarCodeMakeDate; |
| | | new public string HMainSourceEntryID; |
| | | |
| | | public string HRunStatus; |
| | | public decimal HSourceBeginQty; |
| | | //public int HSourceInterID_Main; |
| | | //public int HSourceEntryID_Main; |
| | | //public string HSourceBillNo_Main; |