| | |
| | | } |
| | | #endregion |
| | | |
| | | #region 获取车间号 |
| | | [Route("Gy_Material/Get_HDepartment")] |
| | | [HttpGet] |
| | | public object Get_HDepartment() |
| | | { |
| | | try |
| | | { |
| | | DataSet oDs = new DataSet(); |
| | | //========== |
| | | oDs = oCN.RunProcReturn("select top(20) HItemID , HName from Gy_Department", "Gy_Department"); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "获取成功!"; |
| | | objJsonResult.data = oDs.Tables[0]; |
| | | return objJsonResult; ; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "删除失败!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | /// <summary> |
| | | /// 获取项目列表 |
| | | /// </summary> |
| | |
| | | lsmain = oListModels.getObjectByJson_Gy_Material(msg1); |
| | | |
| | | oBill.oModel = lsmain[0]; |
| | | LogService.Write("物料同步插件,保存方法执行完成异常:"+ msg1); |
| | | //保存 |
| | | bool bResult = oBill.AddNewApi(); |
| | | if (bResult) |
| | |
| | | //进行需要进行的作废/反作废操作 |
| | | if (IsAudit == 0) //作废提交 |
| | | { |
| | | string sql_deleteBeforeCtrl = "exec h_p_Gy_BarCodeBill_Cancelltion_Before " + HInterID; |
| | | DataSet ds_deleteBeforeCtrl = oCN.RunProcReturn(sql_deleteBeforeCtrl, "h_p_Gy_BarCodeBill_Cancelltion_Before"); |
| | | if (ds_deleteBeforeCtrl == null || ds_deleteBeforeCtrl.Tables.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "作废失败:条码作废前控制失败!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | }else if(ds_deleteBeforeCtrl.Tables[0].Rows[0]["HBack"].ToString() != "0") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "作废失败:" + ds_deleteBeforeCtrl.Tables[0].Rows[0]["HRemark"].ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.BeginTran(); |
| | | |
| | | //作废条码 |
| | |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | string HBarCode = ds.Tables[0].Rows[0]["HBarCode"].ToString(); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','反作废条码:" + HBarCode + "','WMS系统-条码档案列表模块','" + DBUtility.ClsPub.IPAddress + "','反作废'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "[0000-1-043]反作废成功"; |
| | | objJsonResult.data = null; |
| | | oCN.Commit(); |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "[0000-1-042]反作废失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | oCN.RollBack(); |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "[0000-1-044]作废失败或者反作废失败!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region 条码主档维护 批量作废/批量反作废 |
| | | /// <summary> |
| | | /// </summary> |
| | | /// <param name="HInterID">单据ID</param> |
| | | /// <param name="IsAudit">作废(0),反作废(1)</param> |
| | | /// <param name="CurUserName">作废人</param> |
| | | /// <returns></returns> |
| | | [Route("Gy_BarCodeBillList/DeleteBatchGy_BarCodeBillList")] |
| | | [HttpGet] |
| | | public object DeleteBatchGy_BarCodeBillList(string HInterID, int IsAudit, string CurUserName) |
| | | { |
| | | string ModRightNameCheck = "Gy_BarCodeBillList_Delete"; |
| | | DBUtility.ClsPub.CurUserName = CurUserName; |
| | | try |
| | | { |
| | | //检查权限 |
| | | if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "[0000-1-063]作废/反作废失败!无权限!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //HInterID数据判断 |
| | | if (HInterID.Length<=0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "未选择需要作废/反作废 的条码"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | Int64 lngBillKey = 0; |
| | | lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterID进行类型的转换 |
| | | |
| | | //进行需要进行的作废/反作废操作 |
| | | if (IsAudit == 0) //作废提交 |
| | | { |
| | | string sql_deleteBeforeCtrl = "exec h_p_Gy_BarCodeBill_Cancelltion_Before '" + HInterID + "'"; |
| | | DataSet ds_deleteBeforeCtrl = oCN.RunProcReturn(sql_deleteBeforeCtrl, "h_p_Gy_BarCodeBill_Cancelltion_Before"); |
| | | if (ds_deleteBeforeCtrl == null || ds_deleteBeforeCtrl.Tables.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "作废失败:条码作废前控制失败!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else if (ds_deleteBeforeCtrl.Tables[0].Rows[0]["HBack"].ToString() != "0") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "作废失败:" + ds_deleteBeforeCtrl.Tables[0].Rows[0]["HRemark"].ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.BeginTran(); |
| | | |
| | | //作废条码 |
| | | oCN.RunProc("update Gy_BarCodeBill set HStopflag=1,HDeleteMan='" + CurUserName + "',HDeleteDate=getdate() where HItemID in (" + HInterID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | string sql = "select * from Gy_BarCodeBill where HItemID in (" + HInterID + ")"; |
| | | ds = oCN.RunProcReturn(sql, "Gy_BarCodeBill"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | string HBarCode = ""; |
| | | for(int i = 0; i < ds.Tables[0].Rows.Count; i++) |
| | | { |
| | | HBarCode = ds.Tables[0].Rows[0]["HBarCode"].ToString() + ";"; |
| | | } |
| | | |
| | | |
| | | //添加操作日志 |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','作废条码:" + HBarCode + "','WMS系统-条码档案列表模块','" + DBUtility.ClsPub.IPAddress + "','作废'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "[0000-1-040]作废成功"; |
| | | objJsonResult.data = null; |
| | | |
| | | oCN.Commit(); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "[0000-1-042]作废失败!原因:" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | |
| | | oCN.RollBack(); |
| | | } |
| | | |
| | | |
| | | return objJsonResult; |
| | | } |
| | | if (IsAudit == 1) //反关闭提交 |
| | | { |
| | | oCN.BeginTran(); |
| | | |
| | | //#region 反作废条码前进行判断 |
| | | ////反作废条码前进行判断------------------------------------------------------------------------------------------------------------------------------------------------------ |
| | | ////-------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| | | //DataSet DS = oCN.RunProcReturn("exec h_p_Gy_BarCodeBill_UnCancelltion '" + HInterID + "','N'", "h_p_Gy_BarCodeBill_UnCancelltion", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //if (DS == null || DS.Tables[0].Rows.Count <= 0) |
| | | //{ |
| | | // oCN.RollBack(); |
| | | |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "[0000-1-042]反作废失败,原因:反作废条码前判断发生错误!"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | //else |
| | | //{ |
| | | // if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) == "1") |
| | | // { |
| | | // oCN.RollBack(); |
| | | |
| | | // objJsonResult.code = "1"; |
| | | // objJsonResult.count = 1; |
| | | // objJsonResult.Message = "[0000-1-042]反作废失败,原因:" + DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]); |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | //} |
| | | ////-------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| | | ////-------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| | | //#endregion |
| | | |
| | | //反作废条码 |
| | | oCN.RunProc("update Gy_BarCodeBill set HStopflag=0,HDeleteMan='',HDeleteDate=null where HItemID in (" + HInterID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | //增加操作日志 |
| | | string sql = "select * from Gy_BarCodeBill where HItemID in (" + HInterID + ")"; |
| | | ds = oCN.RunProcReturn(sql, "Gy_BarCodeBill"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | string HBarCode = ""; |
| | | for (int i = 0; i < ds.Tables[0].Rows.Count; i++) |
| | | { |
| | | HBarCode = ds.Tables[0].Rows[0]["HBarCode"].ToString() + ";"; |
| | | } |
| | | |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','反作废条码:" + HBarCode + "','WMS系统-条码档案列表模块','" + DBUtility.ClsPub.IPAddress + "','反作废'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | objJsonResult.code = "1"; |
| | |
| | | int HNowSPID = mainList[0].HNowSPID; |
| | | string HMouldUseStatus = mainList[0].HMouldUseStatus; |
| | | int HUSEORGID = mainList[0].HUSEORGID; |
| | | DateTime HNextMainDate = mainList[0].HNextMainDate; |
| | | //若MAINDI重复则重新获取 |
| | | oCN.BeginTran(); |
| | | |
| | |
| | | ",HNowWHID=" + HNowWHID + |
| | | ",HNowSPID=" + HNowSPID + |
| | | ",HInitLife='" + HInitLife + |
| | | "',HNextMainDate='" + HNextMainDate + |
| | | "',HMouldUseStatus='" + HMouldUseStatus + |
| | | "' where HInterID=" + HInterID.ToString()); |
| | | |
| | |
| | | #region [同步基础资料] |
| | | [Route("Gy_Material/Gy_MaterialViewApi")] |
| | | [HttpGet] |
| | | public json Gy_MaterialViewApi(string Number, string Type) |
| | | public json Gy_MaterialViewApi(string Number, string Type, string HUseOrgID) |
| | | { |
| | | string sql = string.Empty; |
| | | string sReturn = ""; |
| | |
| | | { |
| | | #region [公有云模式,调用WEBAPI的方式进行更新] |
| | | var json = new |
| | | // { |
| | | // CreateOrgId = 0, |
| | | // Number = Number, |
| | | // Id = "" |
| | | // }; |
| | | { |
| | | CreateOrgId = 0, |
| | | Number = Number, |
| | | Id = "" |
| | | FormId= "BD_MATERIAL", |
| | | FieldKeys= "FMASTERID,FNUMBER,FNAME,FSPECIFICATION,FFORBIDSTATUS,FErpClsID,FBaseUnitId,FLENGTH,FWIDTH,FHEIGHT,FNETWEIGHT,FGROSSWEIGHT,FOldNumber,FSTOCKPLACEID,FPLANMODE,FCREATEDATE,FCREATEORGID,FUSEORGID,FISBATCHMANAGE,FCheckIncoming,FIsEnable1,FIsKFPeriod,FAuxUnitID,FSNUNIT,FBaseUnitId,FSaleUnitId,FSalePriceUnitId,FPerUnitStandHour,FStdLaborPrePareTime,FStdMachinePrepareTime", |
| | | FilterString= $@"FNUMBER='{Number}' AND FUSEORGID={HUseOrgID}", |
| | | OrderString= "", |
| | | TopRowCount= 0, |
| | | StartRow= 0, |
| | | Limit= 0 |
| | | }; |
| | | #region [金蝶部分] |
| | | //登录金蝶 |
| | | var loginRet = InvokeHelper.Login(); |
| | | |
| | | #region [金蝶部分] |
| | | //登录金蝶 |
| | | var loginRet = InvokeHelper.Login(); |
| | | var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); |
| | | //判断是否登录成功 |
| | | if (isSuccess < 0) |
| | |
| | | return objJsonResult; |
| | | } |
| | | //查看 获取数据 |
| | | var _result = InvokeHelper.View("BD_MATERIAL", JsonConvert.SerializeObject(json)); |
| | | var _saveObj = JObject.Parse(_result); |
| | | var _result = InvokeHelper.Query("BD_MATERIAL", JsonConvert.SerializeObject(json)); |
| | | var _saveObj = JArray.Parse(_result); |
| | | //判断数据是否获取成功 |
| | | if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | // if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | // { |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "金蝶物料同步失败jsonRoot:" + _result; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | if (_saveObj.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "金蝶物料同步失败jsonRoot:" + _result; |
| | | objJsonResult.Message = "金蝶客户同步失败,使用组织对应的物料代码无对应的物料"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | |
| | | #region [表数据赋值] |
| | | var jsonData = new |
| | | // { |
| | | // HItemID = _saveObj["Result"]["Result"]["Id"], |
| | | // HERPItemID = _saveObj["Result"]["Result"]["Id"], |
| | | // HNumber = _saveObj["Result"]["Result"]["Number"], |
| | | // HName = _saveObj["Result"]["Result"]["Name"][1]["Value"], |
| | | // HModel = _saveObj["Result"]["Result"]["Specification"][0]["Value"], |
| | | // HShortNumber = _saveObj["Result"]["Result"]["Number"], |
| | | // HParentID = 0, |
| | | // HLevel = 1, |
| | | // HEndFlag = 1, |
| | | // HStopflag = _saveObj["Result"]["Result"]["ForbidStatus"].ToString() == "A" ? 0 : 1 , |
| | | // HRemark = "CLD-ERP导入", |
| | | // HMaterClsID = _saveObj["Result"]["Result"]["MaterialBase"][0]["ErpClsID"], |
| | | // HUnitID = _saveObj["Result"]["Result"]["MaterialBase"][0]["BaseUnitId_Id"], |
| | | // HUnitGroupID = 0, |
| | | // HLength = _saveObj["Result"]["Result"]["MaterialBase"][0]["LENGTH"], |
| | | // HWidth = _saveObj["Result"]["Result"]["MaterialBase"][0]["WIDTH"], |
| | | // HHeight = _saveObj["Result"]["Result"]["MaterialBase"][0]["HEIGHT"], |
| | | // HJQty = _saveObj["Result"]["Result"]["MaterialBase"][0]["NETWEIGHT"], |
| | | // HMQty = _saveObj["Result"]["Result"]["MaterialBase"][0]["GROSSWEIGHT"], |
| | | // HOldMaterNumber = _saveObj["Result"]["Result"]["OldNumber"], |
| | | // HWHID = 0, |
| | | // HSPID = _saveObj["Result"]["Result"]["MaterialStock"][0]["StockPlaceId_Id"], |
| | | // HPlanMode = _saveObj["Result"]["Result"]["MaterialPlan"][0]["PlanMode"], |
| | | // HUseFlag = "未检验", |
| | | // HMakeTime = _saveObj["Result"]["Result"]["CreateDate"], |
| | | // HMinPickQty = 0, |
| | | // HCREATEORGID = _saveObj["Result"]["Result"]["CreateOrgId_Id"], |
| | | // HUSEORGID = _saveObj["Result"]["Result"]["UseOrgId_Id"], |
| | | // HBatchManager = _saveObj["Result"]["Result"]["MaterialStock"][0]["IsBatchManage"].ToString() == "false" ? 0 : 1, |
| | | // HCHECKINCOMING = _saveObj["Result"]["Result"]["MaterialQM"][0]["CheckIncoming"].ToString() == "false" ? 0 : 1, |
| | | // HAuxPropFlag = _saveObj["Result"]["Result"]["MaterialAuxPty"][0]["IsEnable1"].ToString() == "false" ? 0 : 1, |
| | | // HISKFPERIOD = _saveObj["Result"]["Result"]["MaterialStock"][0]["IsKFPeriod"].ToString() == "false" ? 0 : 1, |
| | | // HAuxUnitID = _saveObj["Result"]["Result"]["MaterialStock"][0]["AuxUnitID_Id"], |
| | | // HSNUnitID = _saveObj["Result"]["Result"]["MaterialStock"][0]["SNUnit_Id"], |
| | | // HBASEUNITID = _saveObj["Result"]["Result"]["MaterialBase"][0]["BaseUnitId_Id"], |
| | | // HSALEUNITID = _saveObj["Result"]["Result"]["MaterialSale"][0]["SaleUnitId_Id"], |
| | | // HSALEPRICEUNITID = _saveObj["Result"]["Result"]["MaterialSale"][0]["SalePriceUnitId_Id"], |
| | | // HPERUNITSTANDHOUR = _saveObj["Result"]["Result"]["MaterialProduce"][0]["PerUnitStandHour"], |
| | | // HSTDLABORPREPARETIME = _saveObj["Result"]["Result"]["MaterialProduce"][0]["StdLaborPrePareTime"], |
| | | // HSTDMACHINEPREPARETIME = _saveObj["Result"]["Result"]["MaterialProduce"][0]["StdMachinePrepareTime"] |
| | | // }; |
| | | { |
| | | HItemID = _saveObj["Result"]["Result"]["Id"], |
| | | HERPItemID = _saveObj["Result"]["Result"]["Id"], |
| | | HNumber = _saveObj["Result"]["Result"]["Number"], |
| | | HName = _saveObj["Result"]["Result"]["Name"][1]["Value"], |
| | | HModel = _saveObj["Result"]["Result"]["Specification"][0]["Value"], |
| | | HShortNumber = _saveObj["Result"]["Result"]["Number"], |
| | | HParentID = 0, |
| | | HLevel = 1, |
| | | HEndFlag = 1, |
| | | HStopflag = _saveObj["Result"]["Result"]["ForbidStatus"].ToString() == "A" ? 0 : 1 , |
| | | HRemark = "CLD-ERP导入", |
| | | HMaterClsID = _saveObj["Result"]["Result"]["MaterialBase"][0]["ErpClsID"], |
| | | HUnitID = _saveObj["Result"]["Result"]["MaterialBase"][0]["BaseUnitId_Id"], |
| | | HUnitGroupID = 0, |
| | | HLength = _saveObj["Result"]["Result"]["MaterialBase"][0]["LENGTH"], |
| | | HWidth = _saveObj["Result"]["Result"]["MaterialBase"][0]["WIDTH"], |
| | | HHeight = _saveObj["Result"]["Result"]["MaterialBase"][0]["HEIGHT"], |
| | | HJQty = _saveObj["Result"]["Result"]["MaterialBase"][0]["NETWEIGHT"], |
| | | HMQty = _saveObj["Result"]["Result"]["MaterialBase"][0]["GROSSWEIGHT"], |
| | | HOldMaterNumber = _saveObj["Result"]["Result"]["OldNumber"], |
| | | HWHID = 0, |
| | | HSPID = _saveObj["Result"]["Result"]["MaterialStock"][0]["StockPlaceId_Id"], |
| | | HPlanMode = _saveObj["Result"]["Result"]["MaterialPlan"][0]["PlanMode"], |
| | | HUseFlag = "未检验", |
| | | HMakeTime = _saveObj["Result"]["Result"]["CreateDate"], |
| | | HMinPickQty = 0, |
| | | HCREATEORGID = _saveObj["Result"]["Result"]["CreateOrgId_Id"], |
| | | HUSEORGID = _saveObj["Result"]["Result"]["UseOrgId_Id"], |
| | | HBatchManager = _saveObj["Result"]["Result"]["MaterialStock"][0]["IsBatchManage"].ToString() == "false" ? 0 : 1, |
| | | HCHECKINCOMING = _saveObj["Result"]["Result"]["MaterialQM"][0]["CheckIncoming"].ToString() == "false" ? 0 : 1, |
| | | HAuxPropFlag = _saveObj["Result"]["Result"]["MaterialAuxPty"][0]["IsEnable1"].ToString() == "false" ? 0 : 1, |
| | | HISKFPERIOD = _saveObj["Result"]["Result"]["MaterialStock"][0]["IsKFPeriod"].ToString() == "false" ? 0 : 1, |
| | | HAuxUnitID = _saveObj["Result"]["Result"]["MaterialStock"][0]["AuxUnitID_Id"], |
| | | HSNUnitID = _saveObj["Result"]["Result"]["MaterialStock"][0]["SNUnit_Id"], |
| | | HBASEUNITID = _saveObj["Result"]["Result"]["MaterialBase"][0]["BaseUnitId_Id"], |
| | | HSALEUNITID = _saveObj["Result"]["Result"]["MaterialSale"][0]["SaleUnitId_Id"], |
| | | HSALEPRICEUNITID = _saveObj["Result"]["Result"]["MaterialSale"][0]["SalePriceUnitId_Id"], |
| | | HPERUNITSTANDHOUR = _saveObj["Result"]["Result"]["MaterialProduce"][0]["PerUnitStandHour"], |
| | | HSTDLABORPREPARETIME = _saveObj["Result"]["Result"]["MaterialProduce"][0]["StdLaborPrePareTime"], |
| | | HSTDMACHINEPREPARETIME = _saveObj["Result"]["Result"]["MaterialProduce"][0]["StdMachinePrepareTime"] |
| | | HItemID = _saveObj[0][0], // 对应FMASTERID |
| | | HERPItemID = _saveObj[0][0], // 对应FMASTERID |
| | | HNumber = _saveObj[0][1], // 对应FNUMBER |
| | | HName = _saveObj[0][2], // 对应FNAME |
| | | HModel = _saveObj[0][3], // 对应FSPECIFICATION |
| | | HShortNumber = _saveObj[0][1], // 对应FNUMBER |
| | | HParentID = 0, |
| | | HLevel = 1, |
| | | HEndFlag = 1, |
| | | HStopflag = _saveObj[0][4].ToString() == "A" ? 0 : 1, // 对应FFORBIDSTATUS |
| | | HRemark = "CLD-ERP导入", |
| | | HMaterClsID = _saveObj[0][5], // 对应FErpClsID |
| | | HUnitID = _saveObj[0][6], // 对应FBaseUnitId |
| | | HUnitGroupID = 0, |
| | | HLength = _saveObj[0][7], // 对应FLENGTH |
| | | HWidth = _saveObj[0][8], // 对应FWIDTH |
| | | HHeight = _saveObj[0][9], // 对应FHEIGHT |
| | | HJQty = _saveObj[0][10], // 对应FNETWEIGHT |
| | | HMQty = _saveObj[0][11], // 对应FGROSSWEIGHT |
| | | HOldMaterNumber = _saveObj[0][12], // 对应FOldNumber |
| | | HWHID = 0, |
| | | HSPID = _saveObj[0][13], // 对应FSTOCKPLACEID |
| | | HPlanMode = _saveObj[0][14], // 对应FPLANMODE |
| | | HUseFlag = "未检验", |
| | | HMakeTime = _saveObj[0][15], // 对应FCREATEDATE |
| | | HMinPickQty = 0, |
| | | HCREATEORGID = _saveObj[0][16], // 对应FCREATEORGID |
| | | HUSEORGID = _saveObj[0][17], // 对应FUSEORGID |
| | | HBatchManager = (bool)_saveObj[0][18] ? 1 : 0, // 对应FISBATCHMANAGE |
| | | HCHECKINCOMING = (bool)_saveObj[0][19] ? 1 : 0, // 对应FCheckIncoming |
| | | HAuxPropFlag = (bool)_saveObj[0][20] ? 1 : 0, // 对应FIsEnable1 |
| | | HISKFPERIOD = (bool)_saveObj[0][21] ? 1 : 0, // 对应FIsKFPeriod |
| | | HAuxUnitID = _saveObj[0][22], // 对应FAuxUnitID |
| | | HSNUnitID = _saveObj[0][23], // 对应FSNUNIT |
| | | HBASEUNITID = _saveObj[0][24], // 对应FBaseUnitId |
| | | HSALEUNITID = _saveObj[0][25], // 对应FSaleUnitId |
| | | HSALEPRICEUNITID = _saveObj[0][26], // 对应FSalePriceUnitId |
| | | HPERUNITSTANDHOUR = _saveObj[0][27], // 对应FPerUnitStandHour |
| | | HSTDLABORPREPARETIME = _saveObj[0][28], // 对应FStdLaborPrePareTime |
| | | HSTDMACHINEPREPARETIME = _saveObj[0][29] // 对应FStdMachinePrepareTime |
| | | }; |
| | | #endregion |
| | | // 删除主表对应数据 |