/// <summary> /// WMM-007 提交入库单 /// </summary> /// <param name="orderlist"></param> /// <param name="barCodeList"></param> /// <returns></returns> //public bool SubmitReceiveOrder(List<ReceiveAndOutputInfo> importOrderList, List<BarcodeInfo> barCodeList, bool emergencyFlag, string loginUser) //{ // ///TODO:条码状态使用枚举 // StringBuilder SqlStrBuilder = new StringBuilder(); // string receiveSqlStr = string.Empty; // string receiveDetilsSqlStr = string.Empty; // string barCodeSqlStr = string.Empty; // List<ReceiveInfo> orderList = new ReceiveDAL().GetList(string.Format("[ID] IN ({0})", string.Join(",", importOrderList.Select(w => w.OrderId).ToArray())), string.Empty); // List<ReceiveDetailInfo> detailList = new ReceiveDetailDAL().GetList(string.Format("[ID] IN ({0})", string.Join(",", importOrderList.Select(w => w.DetailId).ToArray())), string.Empty); // ///获取明细零件所有的检验模式 // List<PartInspectionModeInfo> qmischeckmodeinfolist = new PartInspectionModeDAL().GetList(string.Format("[PART_NO] IN ({0})", string.Join("','", detailList.GroupBy(w => new { w.PartNo }).Select(w => w.Key.PartNo).ToArray())), string.Empty); // ///获取检验模式变更数据 // var differencelist = from e in detailList // join o in qmischeckmodeinfolist on new { e.PartNo, B = e.SupplierNum } equals new { o.PartNo, B = o.SupplierNum } into ords // from o in ords.DefaultIfEmpty() // select new // { // e.Fid, // e.Id, // e.InspectionMode // }; // foreach (ReceiveInfo receiveInfo in orderList) // { // #region 更新入库单状态 // receiveSqlStr = @"UPDATE [LES].[TT_WMM_RECEIVE] SET [STATUS] = 50 ,[MODIFY_DATE] = GETDATE(),[MODIFY_USER] = N'{0}' WHERE [ID] ={1};"; //入库单Sql脚本拼接 // receiveSqlStr = string.Format(receiveSqlStr, loginUser, receiveInfo.Id); // SqlStrBuilder.AppendLine(receiveSqlStr); // #endregion // foreach (ReceiveDetailInfo receiveDetailInfo in detailList.Where(w => w.ReceiveFid.GetValueOrDefault() == receiveInfo.Fid.GetValueOrDefault())) // { // ReceiveAndOutputInfo orderItem = importOrderList.FirstOrDefault(w => w.DetailId == receiveDetailInfo.Id); // if (orderItem != null) // { // #region 更新实际箱数和实际数 为差异做准备 // receiveDetailInfo.ActualBoxNum = orderItem.ActualBoxNum; // receiveDetailInfo.ActualQty = orderItem.ActualQty; // #endregion // #region 扫箱更新条码信息 // if (orderItem.IsScanBox) // { // foreach (BarcodeInfo barcodeItem in barCodeList.Where(w => w.AsnRunsheetNo == receiveDetailInfo.OrderNo && w.PartNo == receiveDetailInfo.PartNo && w.SupplierNum == receiveDetailInfo.SupplierNum && w.RunsheetNo == receiveDetailInfo.RunsheetNo)) // { // barCodeSqlStr = @"UPDATE [LES].[TT_WMM_BARCODE] SET [BARCODE_STATUS] = 20,[WM_NO] = '{0}',[ZONE_NO] = '{1}',[DLOC] = '{2}', [MODIFY_USER] = N'{3}',[MODIFY_DATE] = GETDATE() WHERE [ID] = {4};";//条码表明细拼接 // barCodeSqlStr = string.Format(barCodeSqlStr, orderItem.TargetWm, orderItem.TargetZone, orderItem.TargetDloc, loginUser, barcodeItem.Id); // SqlStrBuilder.AppendLine(barCodeSqlStr); // } // } // #endregion // #region 更新入库单明细信息 // receiveDetilsSqlStr = @"UPDATE [LES].[TT_WMM_RECEIVE_DETAIL] SET [ACTUAL_BOX_NUM] = {0} , [ACTUAL_QTY] = {1} , [MODIFY_USER] = N'{2}',MODIFY_DATE = GETDATE() WHERE ID = {3};";//入库单明细Sql脚本拼接 // //更新入库单明细实际箱数、实际数量、修改人、修改时间 // receiveDetilsSqlStr = string.Format(receiveDetilsSqlStr, orderItem.ActualBoxNum, orderItem.ActualQty, loginUser, receiveDetailInfo.Id); // SqlStrBuilder.AppendLine(receiveDetilsSqlStr); // #endregion // } // else // { // #region 更新入库单明细信息 // receiveDetilsSqlStr = @"UPDATE [LES].[TT_WMM_RECEIVE_DETAIL] SET [MODIFY_USER] = N'{0}',MODIFY_DATE = GETDATE() WHERE ID = {1};";//入库单明细Sql脚本拼接 // //更新入库单明细实际箱数、实际数量、修改人、修改时间 // receiveDetilsSqlStr = string.Format(receiveDetilsSqlStr, loginUser, receiveDetailInfo.Id); // SqlStrBuilder.AppendLine(receiveDetilsSqlStr); // #endregion // } // #region 新增交易记录 // TranDetailsInfo tranInfo = new TranDetailsInfo(); // new BLL.LES.TranDetailsBLL().GetTranDetailsInfo(receiveInfo, ref tranInfo); // new BLL.LES.TranDetailsBLL().GetTranDetailsInfo(receiveDetailInfo, ref tranInfo); // string tranSqlStr = new TranDetailsDAL().GetInsertSql(tranInfo); // SqlStrBuilder.AppendLine(tranSqlStr); // #endregion // } // #region 若检验模式有变化则需要将变化的物料提交至QMIS检验任务中间表,并生成同步数据任务 // string receiveMaterialRecheckInspectMode = new ConfigDAL().GetValueByCode("RECEIVE_MATERIAL_RECHECK_INSPECT_MODE"); // if (bool.TryParse(receiveMaterialRecheckInspectMode, out bool receiveMaterialRecheckInspectModeTF)) // throw new Exception("MC:1x00000031");///系统配置错误 // if (receiveMaterialRecheckInspectModeTF) // { // #region 插入脚本初始化 // string qmisSqlStr = @"INSERT INTO [LES].[TI_IFM_QMIS_ASN_PULL_SHEET] ( //FID, //LOG_FID, //PLANT, //ASN_NO, //ORDER_NO, //PART_NO, //SUPPLIER_NO, //TOTAL_NO, //CHECK_MODE, //ARRIVAL_DATE, //ZS_FLAG, //VALID_FLAG, //PROCESS_FLAG, //PROCESS_TIME, //CREATE_USER, //CREATE_DATE, //MODIFY_USER, //MODIFY_DATE // ) // VALUES ({0});"; // #endregion // long[] ids = differencelist.Where(w => w.Fid.GetValueOrDefault() == receiveInfo.Fid.GetValueOrDefault()).Select(w => w.Id).ToArray(); // if (detailList.Where(w => ids.Contains(w.Id)).Count() > 0) // { // #region 生成日志 // Guid logFid = Guid.NewGuid();///定义日志关联键 // SqlStrBuilder.AppendLine(CommonBLL.GetCreateOutboundLogSql("QMIS", logFid, "LES-QMIS-002", receiveInfo.ReceiveNo, loginUser)); // #endregion // foreach (ReceiveDetailInfo receiveDetailInfo in detailList.Where(w => ids.Contains(w.Id))) // { // #region 生成检验中间表 // string sqltiifmqmischeckmode = "NEWID()"///FID // + ",N'" + logFid.ToString() + "'"///LOG_FID // + ",N'" + receiveInfo.Plant + "'"///Plant // + ",N'" + receiveInfo.ReceiveNo + "'"///ASN_NO // + ",N'" + receiveDetailInfo.RunsheetNo + "'"///ORDER_NO // + ",N'" + receiveDetailInfo.PartNo + "'"///PART_NO // + ",N'" + receiveDetailInfo.SupplierNum + "'"///SUPPLIER_NO // + ",N'" + receiveDetailInfo.ActualQty + "'"///TOTAL_NO // + ",'" + differencelist.FirstOrDefault(w => w.Id == receiveDetailInfo.Id).InspectionMode + "'" ///CHECK_MODE // + ",null"///ARRIVAL_DATE // + ",null"///ZS_FLAG // + ",1"///VALID_FLAG // + "," + (int)ProcessFlagResuitsConstants.Created///ORDER_STATUS // + ",null" // + ",N'" + loginUser + "'" // + ",GETDATE()"///CREATE_DATE // + ",null"///MODIFY_USER // + ",null";///MODIFY_DATE // #endregion // SqlStrBuilder.AppendLine(string.Format(qmisSqlStr, sqltiifmqmischeckmode)); // } // } // } // #endregion // #region 生成出库单 // //将入库明细中是否产生出库单标记㊵为true的数据过滤出来,系统配置中SAME_ZONE_SAME_FINAL_ZONE_VALID_FLAG相同存储区相同中转存储区验证标记, // //默认为true,控制了同一张入库单的明细中不会出现不同的出库目标存储区㊷, // //所以此时只需直接根据入库单及明细复制出相应的出库单及明细,并以出库目标存储区㊷作为出库单的目标存储区入库实际数量⑱作为出库需求数量, // //若系统配置标记为false,则将过滤出来的入库明细数据根据其出库目标存储区进行分组,并按分组情况生成多个出库单,出库单状态为已发布WMM - 011 // string sameZoneSameFinalZoneValidFlag = new ConfigDAL().GetValueByCode("SAME_ZONE_SAME_FINAL_ZONE_VALID_FLAG"); // if (bool.TryParse(sameZoneSameFinalZoneValidFlag, out bool sameZoneSameFinalZoneValidFlagTF)) // throw new Exception("MC:1x00000031");///系统配置错误 // bool isoutput = receiveInfo.IsOutput ?? false; // if (sameZoneSameFinalZoneValidFlagTF) // { // #region 根据入库单赋值出库单 // ///出库单号 // string outputNo = new SeqDefineDAL().GetCurrentCode("OUTPUT_NO"); // int rowNo = 0; // if (isoutput) // { // Guid outputFid = Guid.NewGuid(); // string finalWm = string.Empty; // string finalZone = string.Empty; // string fargetDloc = string.Empty; // foreach (ReceiveDetailInfo receiveDetailInfo in detailList.Where(w => w.ReceiveFid.GetValueOrDefault() == receiveInfo.Fid.GetValueOrDefault())) // { // ReceiveAndOutputInfo orderItem = importOrderList.FirstOrDefault(w => w.DetailId == receiveDetailInfo.Id); // rowNo++; // if (orderItem != null) // { // finalWm = receiveDetailInfo.FinalWm; // finalZone = receiveDetailInfo.FinalZone; // fargetDloc = receiveDetailInfo.Dloc; // string detailsStr = "insert into LES.[TT_WMM_OUTPUT_DETAIL] " // + "(FID, OUTPUT_FID, PLANT, SUPPLIER_NUM, WM_NO, ZONE_NO, DLOC, TRAN_NO, TARGET_WM, TARGET_ZONE, TARGET_DLOC, PART_NO, PART_CNAME, REQUIRED_BOX_NUM, REQUIRED_QTY, ACTUAL_BOX_NUM, ACTUAL_QTY, PACKAGE, PACKAGE_MODEL, BARCODE_DATA, MEASURING_UNIT_NO, IDENTIFY_PART_NO, PART_ENAME, DOCK, ASSEMBLY_LINE, BOX_PARTS, SEQUENCE_NO, PICKUP_SEQ_NO, RDC_DLOC, INHOUSE_PACKAGE, INHOUSE_PACKAGE_MODEL, SUPPLIER_NUM_SHEET, BOX_PARTS_SHEET, ORDER_NO, ITEM_NO, RUNSHEET_NO, REPACKAGE_FLAG, ROW_NO, ORIGIN_PLACE, SALE_UNIT_PRICE, PART_PRICE, PART_CLS, PICKUP_NUM, PICKUP_QTY, IS_SCAN_BOX, PACKAGE_LENGTH, PACKAGE_WIDTH, PACKAGE_HEIGHT, PERPACKAGE_GROSS_WEIGHT, COMMENTS, VALID_FLAG, CREATE_USER, CREATE_DATE) select " // + "'" + receiveDetailInfo.Fid // + "', N'" // + outputFid // + "', PLANT, SUPPLIER_NUM, N'" // + receiveDetailInfo.TargetWm // + "', N'" // + receiveDetailInfo.TargetZone // + "', N'" // + receiveDetailInfo.TargetDloc // + "', N'" // + outputNo + "', N'" // + receiveDetailInfo.FinalWm // + "', N'" // + receiveDetailInfo.FinalZone // + "', N'" // + receiveDetailInfo.Dloc + "'" // + ", PART_NO, PART_CNAME, " // + orderItem.ActualBoxNum + ", " // + orderItem.ActualQty + ", NULL, NULL, PACKAGE, PACKAGE_MODEL, NULL, MEASURING_UNIT_NO, IDENTIFY_PART_NO, PART_ENAME, DOCK, ASSEMBLY_LINE, BOX_PARTS, SEQUENCE_NO, PICKUP_SEQ_NO, RDC_DLOC, INHOUSE_PACKAGE, INHOUSE_PACKAGE_MODEL, SUPPLIER_NUM_SHEET, BOX_PARTS_SHEET, ORDER_NO, ITEM_NO" + ", N'" // + receiveInfo.ReceiveNo + "', NULL, " // + rowNo + ", ORIGIN_PLACE, NULL, NULL, PART_CLS, NULL, NULL, IS_SCAN_BOX, PACKAGE_LENGTH, PACKAGE_WIDTH, PACKAGE_HEIGHT, PERPACKAGE_GROSS_WEIGHT" // + ", NULL, 1, N'" // + loginUser + "', GETDATE() " // + "from LES.TT_WMM_RECEIVE_DETAIL with(nolock) where [FID] = N'" + receiveDetailInfo.Fid.GetValueOrDefault() + "';"; // SqlStrBuilder.AppendLine(detailsStr); // } // } // string outPutOrderStr = "insert into LES.[TT_WMM_OUTPUT] " // + "(FID, OUTPUT_NO, PLANT, SUPPLIER_NUM, WM_NO, ZONE_NO, T_WM_NO, T_ZONE_NO, T_DOCK, PART_BOX_CODE, SEND_TIME, OUTPUT_TYPE, TRAN_TIME, OUTPUT_REASON, BOOK_KEEPER, CONFIRM_FLAG, PLAN_NO, ASN_NO, RUNSHEET_NO, ASSEMBLY_LINE, PLANT_ZONE, WORKSHOP, TRANS_SUPPLIER_NUM, PART_TYPE, SUPPLIER_TYPE, RUNSHEET_CODE, ERP_FLAG, LOGICAL_PK, BUSINESS_PK, ROUTE, REQUEST_TIME, CUST_CODE, CUST_NAME, COST_CENTER, ORGANIZATION_FID, CONFIRM_USER, CONFIRM_DATE, LIABLE_USER, LIABLE_DATE, FINANCE_USER, FINANCE_DATE, SUM_PART_QTY, SUM_OF_PRICE, STATUS, CONVEYANCE, CARRIER_TEL, SUM_WEIGHT, SUM_VOLUME, PLAN_SHIPPING_TIME, PLAN_DELIVERY_TIME, COMMENTS, VALID_FLAG, CREATE_USER, CREATE_DATE) select " // + "N'" // + outputFid // + "', N'" // + outputNo // + "', PLANT, SUPPLIER_NUM, N'" // + receiveInfo.WmNo // + "', N'" // + receiveInfo.ZoneNo // + "', N'" // + finalWm // + "', N'" // + finalZone // + "'" // + ", DOCK, PART_BOX_CODE, GETDATE(), " // + (int)OutboundTypeConstants.NormalOutbound // + ", NULL, NULL, BOOK_KEEPER, NULL, NULL, NULL, N'" // + receiveInfo.ReceiveNo // + "'" // + ", NULL, NULL, NULL, NULL, NULL, SUPPLIER_TYPE, NULL, NULL, NULL, NULL" // + ", ROUTE, NULL, CUST_CODE, CUST_NAME, COST_CENTER, N'" // + receiveInfo.OrganizationFid + "', NULL, NULL, NULL, NULL, NULL, NULL" // + ", " // + importOrderList.Where(w => w.OrderId == receiveInfo.Id).Sum(w => w.ActualQty).ToString("F0") // + ", NULL, " // + (int)WmmOrderStatusConstants.Published + ", N'" // + string.Empty + "', N'" ///conveyance // + string.Empty + "'" ///carrierTel // + ", " // + receiveInfo.SumWeight + ", " // + receiveInfo.SumVolume + ", N'" // + receiveInfo.PlanShippingTime + "', N'" // + receiveInfo.PlanDeliveryTime + "', NULL, 1, N'" // + loginUser + "', GETDATE() " // + "from LES.[TT_WMM_RECEIVE] with(nolock) where [FID] = N'" // + receiveInfo.Fid.GetValueOrDefault() + "';"; // SqlStrBuilder.AppendLine(outPutOrderStr); // } // #endregion // } // else // { // #region 根据入库单分单并复制出库单 // if (isoutput) // { // var list = detailList.Where(w => w.ReceiveFid.GetValueOrDefault() == receiveInfo.Fid.GetValueOrDefault()).GroupBy(w => new { w.FinalWm, w.FinalZone, w.FinalDloc }).Select(w => new { w.Key.FinalWm, w.Key.FinalZone, w.Key.FinalDloc }); // foreach (var item in list) // { // Guid outputFid = Guid.NewGuid(); // string finalWm = string.Empty; // string finalZone = string.Empty; // string fargetDloc = string.Empty; // int rowNo = 0; // string outputNo = new SeqDefineDAL().GetCurrentCode("OUTPUT_NO"); // foreach (var receiveDetailInfo in detailList.Where(w => w.FinalWm == item.FinalWm && w.FinalZone == item.FinalZone && w.Dloc == item.FinalDloc)) // { // ReceiveAndOutputInfo orderItem = importOrderList.FirstOrDefault(w => w.DetailId == receiveDetailInfo.Id); // rowNo++; // if (orderItem != null) // { // finalWm = receiveDetailInfo.FinalWm; // finalZone = receiveDetailInfo.FinalZone; // fargetDloc = receiveDetailInfo.Dloc; // string detailsStr = "insert into LES.[TT_WMM_OUTPUT_DETAIL] " // + "(FID, OUTPUT_FID, PLANT, SUPPLIER_NUM, WM_NO, ZONE_NO, DLOC, TRAN_NO, TARGET_WM, TARGET_ZONE, TARGET_DLOC, PART_NO, PART_CNAME, REQUIRED_BOX_NUM, REQUIRED_QTY, ACTUAL_BOX_NUM, ACTUAL_QTY, PACKAGE, PACKAGE_MODEL, BARCODE_DATA, MEASURING_UNIT_NO, IDENTIFY_PART_NO, PART_ENAME, DOCK, ASSEMBLY_LINE, BOX_PARTS, SEQUENCE_NO, PICKUP_SEQ_NO, RDC_DLOC, INHOUSE_PACKAGE, INHOUSE_PACKAGE_MODEL, SUPPLIER_NUM_SHEET, BOX_PARTS_SHEET, ORDER_NO, ITEM_NO, RUNSHEET_NO, REPACKAGE_FLAG, ROW_NO, ORIGIN_PLACE, SALE_UNIT_PRICE, PART_PRICE, PART_CLS, PICKUP_NUM, PICKUP_QTY, IS_SCAN_BOX, PACKAGE_LENGTH, PACKAGE_WIDTH, PACKAGE_HEIGHT, PERPACKAGE_GROSS_WEIGHT, COMMENTS, VALID_FLAG, CREATE_USER, CREATE_DATE) select " // + "'" + receiveDetailInfo.Fid // + "', N'" // + outputFid // + "', PLANT, SUPPLIER_NUM, N'" // + receiveDetailInfo.TargetWm // + "', N'" // + receiveDetailInfo.TargetZone // + "', N'" // + receiveDetailInfo.TargetDloc // + "', N'" // + outputNo + "', N'" // + receiveDetailInfo.FinalWm // + "', N'" // + receiveDetailInfo.FinalZone // + "', N'" // + receiveDetailInfo.Dloc + "'" // + ", PART_NO, PART_CNAME, " // + orderItem.ActualBoxNum + ", " // + orderItem.ActualQty + ", NULL, NULL, PACKAGE, PACKAGE_MODEL, NULL, MEASURING_UNIT_NO, IDENTIFY_PART_NO, PART_ENAME, DOCK, ASSEMBLY_LINE, BOX_PARTS, SEQUENCE_NO, PICKUP_SEQ_NO, RDC_DLOC, INHOUSE_PACKAGE, INHOUSE_PACKAGE_MODEL, SUPPLIER_NUM_SHEET, BOX_PARTS_SHEET, ORDER_NO, ITEM_NO" + ", N'" // + receiveInfo.ReceiveNo + "', NULL, " // + rowNo + ", ORIGIN_PLACE, NULL, NULL, PART_CLS, NULL, NULL, IS_SCAN_BOX, PACKAGE_LENGTH, PACKAGE_WIDTH, PACKAGE_HEIGHT, PERPACKAGE_GROSS_WEIGHT" // + ", NULL, 1, N'" // + loginUser + "', GETDATE() " // + "from LES.TT_WMM_RECEIVE_DETAIL with(nolock) where [FID] = N'" + receiveDetailInfo.Fid.GetValueOrDefault() + "';"; // SqlStrBuilder.AppendLine(detailsStr); // } // } // string outPutOrderStr = "insert into LES.[TT_WMM_OUTPUT] " // + "(FID, OUTPUT_NO, PLANT, SUPPLIER_NUM, WM_NO, ZONE_NO, T_WM_NO, T_ZONE_NO, T_DOCK, PART_BOX_CODE, SEND_TIME, OUTPUT_TYPE, TRAN_TIME, OUTPUT_REASON, BOOK_KEEPER, CONFIRM_FLAG, PLAN_NO, ASN_NO, RUNSHEET_NO, ASSEMBLY_LINE, PLANT_ZONE, WORKSHOP, TRANS_SUPPLIER_NUM, PART_TYPE, SUPPLIER_TYPE, RUNSHEET_CODE, ERP_FLAG, LOGICAL_PK, BUSINESS_PK, ROUTE, REQUEST_TIME, CUST_CODE, CUST_NAME, COST_CENTER, ORGANIZATION_FID, CONFIRM_USER, CONFIRM_DATE, LIABLE_USER, LIABLE_DATE, FINANCE_USER, FINANCE_DATE, SUM_PART_QTY, SUM_OF_PRICE, STATUS, CONVEYANCE, CARRIER_TEL, SUM_WEIGHT, SUM_VOLUME, PLAN_SHIPPING_TIME, PLAN_DELIVERY_TIME, COMMENTS, VALID_FLAG, CREATE_USER, CREATE_DATE) select " // + "N'" // + outputFid // + "', N'" // + outputNo // + "', PLANT, SUPPLIER_NUM, N'" // + receiveInfo.WmNo // + "', N'" // + receiveInfo.ZoneNo // + "', N'" // + finalWm // + "', N'" // + finalZone // + "'" // + ", DOCK, PART_BOX_CODE, GETDATE(), " // + (int)OutboundTypeConstants.NormalOutbound // + ", NULL, NULL, BOOK_KEEPER, NULL, NULL, NULL, N'" // + receiveInfo.ReceiveNo // + "'" // + ", NULL, NULL, NULL, NULL, NULL, SUPPLIER_TYPE, NULL, NULL, NULL, NULL" // + ", ROUTE, NULL, CUST_CODE, CUST_NAME, COST_CENTER, N'" // + receiveInfo.OrganizationFid + "', NULL, NULL, NULL, NULL, NULL, NULL" // + ", " // + importOrderList.Where(w => w.OrderId == receiveInfo.Id).Sum(w => w.ActualQty).ToString("F0") // + ", NULL, " // + (int)WmmOrderStatusConstants.Published + ", N'" // + string.Empty + "', N'" ///conveyance // + string.Empty + "'" ///carrierTel // + "," // + receiveInfo.SumWeight + ", " // + receiveInfo.SumVolume + ", N'" // + receiveInfo.PlanShippingTime + "', N'" // + receiveInfo.PlanDeliveryTime + "', NULL, 1, N'" // + loginUser + "', GETDATE() " // + "from LES.[TT_WMM_RECEIVE] with(nolock) where [FID] = N'" // + receiveInfo.Fid.GetValueOrDefault() + "';"; // SqlStrBuilder.AppendLine(outPutOrderStr); // } // } // #endregion // } // #endregion // #region 器具包装随货入库交易数据 // //系统配置ENABLE_PACKAGE_MANAGEMENT_FLAG是否启用器具管理标记,默认为true,⑰以及包装型号⑲等数据产生器具包装随货入库交易数据PKG-000 // string enablePackageManagementFlag = new ConfigDAL().GetValueByCode("ENABLE_PACKAGE_MANAGEMENT_FLAG"); // if (bool.TryParse(enablePackageManagementFlag, out bool enablePackageManagementFlagTF)) // throw new Exception("MC:1x00000031");///系统配置错误 // if (enablePackageManagementFlagTF) // { // } // #endregion // #region 不满足需求物料生成新拉动单 // if (emergencyFlag) // { // ///TODO: // } // #endregion // } // using (TransactionScope trans = new TransactionScope()) // { // if (!CommonDAL.ExecuteNonQueryBySql(SqlStrBuilder.ToString())) // throw new Exception("MC:3x00000013");///TODO:提示是信息修改 // trans.Complete(); // } // return true; //} /// <summary> /// WMM-024 出库单提交 /// </summary> /// <param name="orderJsonStr"></param> /// <param name="barJsonStr"></param> /// <param name="emergencyFlag"></param> /// <param name="loginUser"></param> /// <returns></returns> //public bool SubmitOutputOrder(List<ReceiveAndOutputInfo> importOrderList, List<BarcodeInfo> barCodeList, bool emergencyFlag, string loginUser) //{ // ///TODO:条码状态使用枚举 // StringBuilder SqlStrBuilder = new StringBuilder(); // string outSqlStr = string.Empty; // string outDetilsSqlStr = string.Empty; // string barCodeSqlStr = string.Empty; // List<OutputInfo> orderList = new OutputDAL().GetList(string.Format("[ID] IN ({0})", string.Join(",", importOrderList.Select(w => w.OrderId).ToArray())), string.Empty); // List<OutputDetailInfo> detailList = new OutputDetailDAL().GetList(string.Format("[ID] IN ({0})", string.Join(",", importOrderList.Select(w => w.DetailId).ToArray())), string.Empty); // foreach (OutputInfo outputInfo in orderList) // { // outSqlStr = @"UPDATE [LES].[TT_WMM_OUTPUT] SET [STATUS] = 50 ,[MODIFY_DATE] = GETDATE(),[MODIFY_USER] = N'{0}' WHERE [ID] ={1};"; // outSqlStr = string.Format(outSqlStr, loginUser, outputInfo.Id); // SqlStrBuilder.AppendLine(outSqlStr); // ///TODO:并更新对应的拉动单或ASN单据状态 // foreach (OutputDetailInfo outDetailInfo in detailList.Where(w => w.Fid == outputInfo.Fid)) // { // ReceiveAndOutputInfo orderItem = importOrderList.FirstOrDefault(w => w.DetailId == outputInfo.Id); // if (orderItem != null) // { // #region 更新实际箱数和实际数 为差异做准备 // outDetailInfo.ActualBoxNum = orderItem.ActualBoxNum; // outDetailInfo.ActualQty = orderItem.ActualQty; // #endregion // #region 扫箱更新条码信息 // if (orderItem.IsScanBox) // { // foreach (BarcodeInfo barcodeItem in barCodeList.Where(w => w.AsnRunsheetNo == orderItem.OrderNo && w.PartNo == orderItem.PartNo && w.SupplierNum == orderItem.SupplierNum)) // { // barCodeSqlStr = "UPDATE [LES].[TT_WMM_BARCODE] SET [BARCODE_STATUS] = 40,[WM_NO] = '{0}',[ZONE_NO] = '{1}',[DLOC] = '{2}', [MODIFY_USER] = '{3}',[MODIFY_DATE] = GETDATE() WHERE [BARCODE_DATA] = '{4}'";//条码表明细拼接 // barCodeSqlStr = string.Format(barCodeSqlStr, orderItem.TargetWm, orderItem.TargetZone, orderItem.TargetDloc, loginUser, barcodeItem.BarcodeData); // SqlStrBuilder.AppendLine(barCodeSqlStr); // } // } // #endregion // #region 新增交易记录 // TranDetailsInfo tranInfo = new TranDetailsInfo(); // new BLL.LES.TranDetailsBLL().GetTranDetailsInfo(outputInfo, ref tranInfo); // new BLL.LES.TranDetailsBLL().GetTranDetailsInfo(outDetailInfo, ref tranInfo); // string tranSqlStr = new TranDetailsDAL().GetInsertSql(tranInfo); // SqlStrBuilder.AppendLine(tranSqlStr); // #endregion // } // } // } // using (TransactionScope trans = new TransactionScope()) // { // if (!CommonDAL.ExecuteNonQueryBySql(SqlStrBuilder.ToString())) // throw new Exception("MC:0x00000173");///TODO:提示信息修改 // trans.Complete(); // } // return true; //} /// <summary> /// WMM-028 拣配提交 /// </summary> /// <param name="outputIds"></param> /// <param name="barcodeIds"></param> /// <returns></returns> public bool SubmitPickupData(List <long> outputIds, List <long> barcodeIds, string loginUser) { ///TODO:状态替换为枚举 StringBuilder stringBuilder = new StringBuilder(); string outSqlStr = string.Empty; string outDetilsSqlStr = string.Empty; string barCodeSqlStr = string.Empty; List <OutputInfo> orderList = new OutputDAL().GetList(string.Format("[ID] IN ({0})", string.Join(",", outputIds)), string.Empty); List <OutputDetailInfo> detailList = new OutputDetailDAL().GetList(string.Format("[OUTPUT_FID] IN ('{0}')", string.Join("','", orderList.Select(w => w.Fid).ToArray())), string.Empty); List <BarcodeInfo> barcodelist = new BarcodeDAL().GetList(string.Format("[ID] IN ({0})", string.Join(",", barcodeIds)), string.Empty); foreach (OutputInfo outputinfo in orderList) { #region 更新出库单 outSqlStr = "UPDATE [LES].[TT_WMM_OUTPUT] SET [STATUS] = 30 ,[MODIFY_DATE] = GETDATE(),[MODIFY_USER] = '{0}' WHERE [ID] ={1};"; outSqlStr = string.Format(outSqlStr, loginUser, outputinfo.OutputId); stringBuilder.AppendLine(outSqlStr); #endregion foreach (OutputDetailInfo outputdetailinfo in detailList) { int actualBoxNum = (outputdetailinfo.ActualBoxNum ?? 0); decimal actualQty = (outputdetailinfo.ActualQty ?? 0); foreach (BarcodeInfo barcodeinfo in barcodelist.Where(w => w.AsnRunsheetNo == outputinfo.OutputNo && w.RunsheetNo == outputdetailinfo.RunsheetNo && w.PartNo == outputdetailinfo.PartNo && w.SupplierNum == outputdetailinfo.SupplierNum )) { #region 累加实出箱数和实出数量 actualBoxNum += 1; actualQty += (barcodeinfo.CurrentQty ?? 0); #endregion #region 更新标签表 barCodeSqlStr = @"UPDATE [LES].[TT_WMM_BARCODE] SET [BARCODE_STATUS] = 30,[MODIFY_USER] = N'{0}',[MODIFY_DATE] = GETDATE() WHERE [ID] = {1};";//条码表明细拼接 barCodeSqlStr = string.Format(barCodeSqlStr, loginUser, barcodeinfo.Id); stringBuilder.AppendLine(barCodeSqlStr); #endregion } #region 更新出库单明细 outDetilsSqlStr = "UPDATE [LES].[TT_WMM_OUTPUT_DETAIL] SET [PICKUP_NUM] = {0},[PICKUP_QTY] = {1},[MODIFY_DATE]= GETDATE() ,[MODIFY_USER] = N'{2}' WHERE ID = {3};"; outDetilsSqlStr = string.Format(outDetilsSqlStr, actualBoxNum, actualQty, loginUser, outputdetailinfo.Id); stringBuilder.AppendLine(outDetilsSqlStr); #endregion } } using (TransactionScope trans = new TransactionScope()) { if (!CommonDAL.ExecuteNonQueryBySql(stringBuilder.ToString())) { throw new Exception("MC:0x00000173");///TODO:提示信息修改 } trans.Complete(); } return(true); }
/// <summary> /// 发货 /// </summary> /// <param name="rowsKeyValues"></param> /// <param name="loginUser"></param> /// <returns></returns> public bool ResendInfos(List <string> rowsKeyValues, string loginUser) { ///入库单 List <OutputInfo> outputInfos = dal.GetList("[ID] in (" + string.Join(",", rowsKeyValues.ToArray()) + ")", "[ID]"); if (outputInfos.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } //int cnt = outputInfos.Count(d => d.Status.GetValueOrDefault() != (int)WmmOrderStatusConstants.Closed); //if (cnt > 0) // throw new Exception("MC:0x00000342");///状态为已关闭时才能进行发货 List <OutputDetailInfo> outputDetailInfos = new OutputDetailDAL().GetList("[OUTPUT_FID] in ('" + string.Join("','", outputInfos.Select(d => d.Fid.GetValueOrDefault()).ToArray()) + "')", string.Empty); if (outputDetailInfos.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } List <BarcodeInfo> barcodeInfos = new BarcodeDAL().GetList("" + "[CREATE_SOURCE_FID] in ('" + string.Join("','", outputDetailInfos.Select(d => d.Fid.GetValueOrDefault()).ToArray()) + "') and " + "[BARCODE_STATUS] = " + (int)BarcodeStatusConstants.Inbound + "", string.Empty); if (barcodeInfos.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } string sql = string.Empty; foreach (var outputInfo in outputInfos) { List <OutputDetailInfo> outputDetails = outputDetailInfos.Where(d => d.OutputFid.GetValueOrDefault() == outputInfo.Fid.GetValueOrDefault()).ToList(); if (outputDetails.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } List <BarcodeInfo> barcodes = barcodeInfos.Where(d => outputDetails.Select(r => r.Fid.GetValueOrDefault()).Contains(d.CreateSourceFid.GetValueOrDefault())).ToList(); if (barcodes.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } sql += CreateOutputByOutputSql( outputInfo, outputDetails, barcodes, "", "", null, loginUser, outputInfo.Fid, "", "", null, null); sql += "update [LES].[TT_WMM_OUTPUT] " + "set [STATUS] = " + (int)WmmOrderStatusConstants.Closed + ",[MODIFY_USER] = N'" + loginUser + "',[MODIFY_DATE] = GETDATE() " + "where [ID] = " + outputInfo.OutputId + ";"; } ///执行 using (TransactionScope trans = new TransactionScope()) { if (!string.IsNullOrEmpty(sql)) { CommonDAL.ExecuteNonQueryBySql(sql); } trans.Complete(); } return(true); }
/// <summary> /// 发货 /// </summary> /// <param name="rowsKeyValues"></param> /// <param name="loginUser"></param> /// <returns></returns> public bool ResendInfos(List <string> rowsKeyValues, string loginUser) { ///入库单 List <ReceiveInfo> receiveInfos = dal.GetList("[ID] in (" + string.Join(",", rowsKeyValues.ToArray()) + ")", "[ID]"); if (receiveInfos.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } //int cnt = receiveInfos.Count(d => d.Status.GetValueOrDefault() != (int)WmmOrderStatusConstants.Completed); //if (cnt > 0) // throw new Exception("MC:0x00000344");///状态为已完成时才能进行发货 List <ReceiveDetailInfo> receiveDetailInfos = new ReceiveDetailDAL().GetList("[RECEIVE_FID] in ('" + string.Join("','", receiveInfos.Select(d => d.Fid.GetValueOrDefault()).ToArray()) + "')", string.Empty); if (receiveDetailInfos.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } List <BarcodeInfo> barcodeInfos = new BarcodeDAL().GetList("" + "[CREATE_SOURCE_FID] in ('" + string.Join("','", receiveDetailInfos.Select(d => d.Fid.GetValueOrDefault()).ToArray()) + "') and " + "[BARCODE_STATUS] = " + (int)BarcodeStatusConstants.Inbound + "", string.Empty); if (barcodeInfos.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } string sql = string.Empty; foreach (var receiveInfo in receiveInfos) { List <ReceiveDetailInfo> receiveDetails = receiveDetailInfos.Where(d => d.ReceiveFid.GetValueOrDefault() == receiveInfo.Fid.GetValueOrDefault()).ToList(); if (receiveDetails.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } List <BarcodeInfo> barcodes = barcodeInfos.Where(d => receiveDetails.Select(r => r.Fid.GetValueOrDefault()).Contains(d.CreateSourceFid.GetValueOrDefault())).ToList(); if (barcodes.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } sql += OutputBLL.CreateOutputByReceiveSql( receiveInfo, ///入库单 receiveDetails, ///入库单明细 barcodes, ///标签 string.Empty, ///目标仓库 string.Empty, ///目标存储区 null, ///出库类型 loginUser, ///操作用户 //receiveInfo.OrganizationFid,///操作机构 Guid.NewGuid(), string.Empty, ///承运人 string.Empty, ///联系电话 null, ///计划发货时间 null); ///计划到达时间 sql += "update [LES].[TT_WMM_RECEIVE] " + "set [STATUS] = " + (int)WmmOrderStatusConstants.Closed + ",[MODIFY_USER] = N'" + loginUser + "',[MODIFY_DATE] = GETDATE() " + "where [ID] = " + receiveInfo.ReceiveId + ";"; } ///执行 using (TransactionScope trans = new TransactionScope()) { if (!string.IsNullOrEmpty(sql)) { CommonDAL.ExecuteNonQueryBySql(sql); } trans.Complete(); } return(true); }
/// <summary> /// 发布(提交) /// </summary> /// <param name="id"></param> /// <param name="loginUser"></param> /// <returns></returns> public bool ReleaseInfos(List <string> rowsKeyValues, string loginUser) { ///入库单 List <VmiReceiveInfo> vmiReceiveInfos = dal.GetList("[ID] in (" + string.Join(",", rowsKeyValues.ToArray()) + ")", "[ID]"); if (vmiReceiveInfos.Count == 0) { throw new Exception("MC:0x00000084");///数据错误 } ///入库单明细 List <VmiReceiveDetailInfo> vmiReceiveDetailInfos = new VmiReceiveDetailDAL().GetList("[RECEIVE_FID] in ('" + string.Join("','", vmiReceiveInfos.Select(d => d.Fid.GetValueOrDefault()).ToArray()) + "')", "[ID]"); if (vmiReceiveDetailInfos.Count == 0) { throw new Exception("MC:0x00000367");///入库单没有明细 } ///获取系统配置 Dictionary <string, string> configs = new ConfigDAL().GetValuesByCodes(new string[] { "RELEASE_VMI_RECEIVE_ACTUAL_QTY_EQUALS_REQUIRED", "MANUAL_VMI_RECEIVE_ORDER_RELEASE_CREATE_BARCODE", "RELEASE_VMI_RECEIVE_LOAD_PART_INSPECTION_MODE" }); ///已生成的标签 List <BarcodeInfo> barcodeInfos = new BarcodeDAL().GetList("" + "[BARCODE_STATUS] = " + (int)BarcodeStatusConstants.Created + " and " + "[CREATE_SOURCE_FID] in ('" + string.Join("','", vmiReceiveDetailInfos.Select(d => d.Fid.GetValueOrDefault()).ToArray()) + "')", string.Empty); ///执行语句 StringBuilder @string = new StringBuilder(); foreach (var vmiReceiveInfo in vmiReceiveInfos) { ///一般手工创建入库单会用到此功能,入库单必须为10.已创建状态⑫ if (vmiReceiveInfo.Status.GetValueOrDefault() != (int)WmmOrderStatusConstants.Created) { throw new Exception("MC:0x00000683");///状态必须为已创建 } ///VMI入库单明细 List <VmiReceiveDetailInfo> vmiReceiveDetails = vmiReceiveDetailInfos.Where(d => d.ReceiveFid.GetValueOrDefault() == vmiReceiveInfo.Fid.GetValueOrDefault()).ToList(); ///VMI入库单对应的标签数据 List <BarcodeInfo> barcodes = barcodeInfos.Where(d => vmiReceiveDetails.Select(f => f.Fid.GetValueOrDefault()).Contains(d.CreateSourceFid.GetValueOrDefault())).ToList(); ///将VMI入库单明细对象转换为普通入库单对象,方便后续函数处理 List <ReceiveDetailInfo> receiveDetailInfos = ReceiveDetailBLL.GetReceiveDetailInfos(vmiReceiveDetails); ///手工创建VMI入库单时创建条码标签 configs.TryGetValue("MANUAL_VMI_RECEIVE_ORDER_RELEASE_CREATE_BARCODE", out string manual_vmi_receive_order_release_create_barcode); if (!string.IsNullOrEmpty(manual_vmi_receive_order_release_create_barcode) && manual_vmi_receive_order_release_create_barcode.ToLower() == "true") { @string.AppendLine(MaterialPullingCommonBLL.GetCreateBarcodesSql(receiveDetailInfos, barcodes, loginUser)); } /// ReceiveInfo receiveInfo = ReceiveBLL.CreateReceiveInfo(loginUser); ///VmiReceiveInfo -> ReceiveInfo ReceiveBLL.GetReceiveInfo(vmiReceiveInfo, ref receiveInfo); ///VMI入库单发布时是否加载物料检验模式,TODO:此处函数内有与入库单共用的系统配置 configs.TryGetValue("RELEASE_VMI_RECEIVE_LOAD_PART_INSPECTION_MODE", out string release_vmi_receive_load_part_inspection_mode); if (!string.IsNullOrEmpty(release_vmi_receive_load_part_inspection_mode) && release_vmi_receive_load_part_inspection_mode.ToLower() == "true") { @string.AppendLine(PartInspectionModeBLL.LoadInspectionMode(ref receiveInfo, ref receiveDetailInfos, loginUser)); } ///行号更新 int rowNo = 0; ///发布VMI入库单时实收数量默认等于需求数量 configs.TryGetValue("RELEASE_VMI_RECEIVE_ACTUAL_QTY_EQUALS_REQUIRED", out string release_vmi_receive_actual_qty_equals_required); foreach (var receiveDetailInfo in receiveDetailInfos) { if (!string.IsNullOrEmpty(release_vmi_receive_actual_qty_equals_required) && release_vmi_receive_actual_qty_equals_required.ToLower() == "true") { if (receiveDetailInfo.ActualBoxNum == null) { receiveDetailInfo.ActualBoxNum = receiveDetailInfo.RequiredBoxNum; } if (receiveDetailInfo.ActualQty == null) { receiveDetailInfo.ActualQty = receiveDetailInfo.RequiredQty; } } ///更新入库单明细需要注意不能覆盖明细中原内容 @string.AppendLine("update [LES].[TT_WMM_VMI_RECEIVE_DETAIL] set " + "[ROW_NO] = " + ++rowNo + "," + (receiveDetailInfo.ActualBoxNum == null ? string.Empty : "[ACTUAL_BOX_NUM] = " + receiveDetailInfo.ActualBoxNum.GetValueOrDefault() + ",") + (receiveDetailInfo.ActualQty == null ? string.Empty : "[ACTUAL_QTY] = " + receiveDetailInfo.ActualQty.GetValueOrDefault() + ",") + (receiveDetailInfo.InspectionMode == null ? string.Empty : "[INSPECTION_MODE] = " + receiveDetailInfo.InspectionMode.GetValueOrDefault() + ",") + (string.IsNullOrEmpty(receiveDetailInfo.SupplierNum) ? "[SUPPLIER_NUM] = N'" + receiveInfo.SupplierNum + "'," : string.Empty) + "[WM_NO] = N'" + receiveInfo.WmNo + "'," + "[ZONE_NO] = N'" + receiveInfo.ZoneName + "'," + "[TARGET_WM] = N'" + receiveInfo.WmNo + "'," + "[TARGET_ZONE] = N'" + receiveInfo.ZoneNo + "'," + (string.IsNullOrEmpty(receiveDetailInfo.RunsheetNo) ? "[RUNSHEET_NO] = N'" + receiveInfo.RunsheetNo + "'," : string.Empty) + "[MODIFY_DATE] = GETDATE()," + "[MODIFY_USER] = N'" + loginUser + "' where " + "[ID] = " + receiveDetailInfo.Id + ";"); } ///更新入库单 @string.AppendLine("update [LES].[TT_WMM_VMI_RECEIVE] set " + "[SUM_PART_QTY] = " + vmiReceiveDetails.Sum(d => d.RequiredQty.GetValueOrDefault()) + "," + "[SUM_OF_PRICE] = " + vmiReceiveDetails.Sum(d => d.PartPrice.GetValueOrDefault()) + "," + "[SUM_WEIGHT] = " + vmiReceiveDetails.Sum(d => d.SumWeight.GetValueOrDefault()) + "," + "[SUM_VOLUME] = " + vmiReceiveDetails.Sum(d => d.SumVolume.GetValueOrDefault()) + "," + "[SUM_PACKAGE_QTY] = " + vmiReceiveDetails.Sum(d => d.RequiredBoxNum.GetValueOrDefault()) + "," + //"[INSPECTION_FLAG] = " + (receiveInfo.InspectionFlag.GetValueOrDefault() ? 1 : 0) + "," + "[STATUS] = " + (int)WmmOrderStatusConstants.Published + "," + "[MODIFY_USER] = N'" + loginUser + "' ," + "[MODIFY_DATE] = GETDATE() where " + "[ID] = " + vmiReceiveInfo.Id + ";"); } ///删除已删除VMI入库单明细的标签 @string.AppendLine("update [LES].[TT_WMM_BARCODE] " + "set [VALID_FLAG] = 0 " + "where [CREATE_SOURCE_FID] in (select [FID] from [LES].[TT_WMM_VMI_RECEIVE_DETAIL] with(nolock) " + "where [VALID_FLAG] = 0 and [RECEIVE_FID] in ('" + string.Join("','", vmiReceiveInfos.Select(d => d.Fid.GetValueOrDefault()).ToArray()) + "'));"); ///执行 using (TransactionScope trans = new TransactionScope()) { if (@string.Length > 0) { CommonDAL.ExecuteNonQueryBySql(@string.ToString()); } trans.Complete(); } return(true); }