/// <summary> /// 排序拉动明细 /// </summary> /// <param name="JisPullGuid"></param> /// <param name="materialPullingOrderDetailInfos"></param> /// <returns></returns> private string CreateJisPullOrderDetailSql(Guid JisPullGuid, List <MaterialPullingOrderDetailInfo> materialPullingOrderDetailInfos) { string sql = string.Empty; int rowNo = 0; foreach (MaterialPullingOrderDetailInfo materialPullingOrderDetailInfo in materialPullingOrderDetailInfos) { rowNo += 1; JisPullOrderDetailInfo jisPullOrderDetailInfo = new JisPullOrderDetailInfo(); ///ORDER_FID jisPullOrderDetailInfo.OrderFid = JisPullGuid; ///ORDER_CODE jisPullOrderDetailInfo.OrderCode = materialPullingOrderDetailInfo.OrderNo; ///ROW_NO jisPullOrderDetailInfo.RowNo = rowNo; ///SUPPLIER_NUM jisPullOrderDetailInfo.SupplierNum = materialPullingOrderDetailInfo.SupplierNum; ///PART_NO jisPullOrderDetailInfo.PartNo = materialPullingOrderDetailInfo.PartNo; ///PART_CNAME jisPullOrderDetailInfo.PartCname = materialPullingOrderDetailInfo.PartCname; ///PART_VERSION TODO: 物料版本 jisPullOrderDetailInfo.PartVersion = null; ///PART_ENAME jisPullOrderDetailInfo.PartEname = materialPullingOrderDetailInfo.PartEname; ///MEASURING_UNIT_NO jisPullOrderDetailInfo.MeasuringUnitNo = materialPullingOrderDetailInfo.Uom; ///VEHICHE_MODEL_NO 车型编号 jisPullOrderDetailInfo.VehicheModelNo = materialPullingOrderDetailInfo.VehicheModelNo; ///DAY_VEHICHE_SEQ_NO 当日车辆序号 jisPullOrderDetailInfo.DayVehicheSeqNo = materialPullingOrderDetailInfo.DayVehicheSeqNo.GetValueOrDefault(); ///PRODUCTION_NO 生产订单号 jisPullOrderDetailInfo.ProductionNo = materialPullingOrderDetailInfo.ProduceNo; ///INSPECTION_MODE 检验模式 jisPullOrderDetailInfo.InspectionMode = null; ///INSPECTION_FLAG 是否检验 jisPullOrderDetailInfo.InspectionFlag = null; ///REQUIRED_PART_QTY jisPullOrderDetailInfo.RequiredPartQty = materialPullingOrderDetailInfo.RequirePartQty; ///CREATE_USER jisPullOrderDetailInfo.CreateUser = loginUser; sql += JisPullOrderDetailDAL.GetInsertSql(jisPullOrderDetailInfo); } return(sql); }
/// <summary> /// 添加拉动单明细 /// </summary> /// <param name="jisPullOrderDetailInfo"></param> /// <returns></returns> public string GetInsertSql(JisPullOrderDetailInfo jisPullOrderDetailInfo) { return(JisPullOrderDetailDAL.GetInsertSql(jisPullOrderDetailInfo)); }