/// <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));
}