/// <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);
        }
Exemple #2
0
 /// <summary>
 /// 添加拉动单明细
 /// </summary>
 /// <param name="jisPullOrderDetailInfo"></param>
 /// <returns></returns>
 public string GetInsertSql(JisPullOrderDetailInfo jisPullOrderDetailInfo)
 {
     return(JisPullOrderDetailDAL.GetInsertSql(jisPullOrderDetailInfo));
 }