/// <summary>
/// 物料成套拉动明细
/// </summary>
/// <param name="JisPullGuid"></param>
/// <param name="materialPullingOrderDetailInfos"></param>
/// <returns></returns>
private string CreateCompletePullOrderDetailSql(Guid JisPullGuid, List <MaterialPullingOrderDetailInfo> materialPullingOrderDetailInfos)
{
string sql = string.Empty;
int rowNo = 0;
foreach (MaterialPullingOrderDetailInfo materialPullingOrderDetailInfo in materialPullingOrderDetailInfos)
{
rowNo += 1;
SpsPullOrderDetailInfo spsPullOrderDetailInfo = new SpsPullOrderDetailInfo();
///ORDER_FID
spsPullOrderDetailInfo.OrderFid = JisPullGuid;
///ORDER_CODE
spsPullOrderDetailInfo.OrderCode = materialPullingOrderDetailInfo.OrderNo;
///ROW_NO
spsPullOrderDetailInfo.RowNo = rowNo;
///SUPPLIER_NUM
spsPullOrderDetailInfo.SupplierNum = materialPullingOrderDetailInfo.SupplierNum;
///PART_NO
spsPullOrderDetailInfo.PartNo = materialPullingOrderDetailInfo.PartNo;
///PART_CNAME
spsPullOrderDetailInfo.PartCname = materialPullingOrderDetailInfo.PartCname;
///PART_VERSION
spsPullOrderDetailInfo.PartVersion = null;///TODO:暂时没有物料版本
///PART_ENAME
spsPullOrderDetailInfo.PartEname = materialPullingOrderDetailInfo.PartEname;
///MEASURING_UNIT_NO
spsPullOrderDetailInfo.MeasuringUnitNo = materialPullingOrderDetailInfo.Uom;
///LIGHT_ADDRESS
spsPullOrderDetailInfo.LightAddress = null;///TODO:暂时没有维护灯地址
///WORKSHOP_SECTION
spsPullOrderDetailInfo.WorkshopSection = materialPullingOrderDetailInfo.WorkshopSection;
///LOCATION
spsPullOrderDetailInfo.Location = materialPullingOrderDetailInfo.Location;
///REQUIRED_PART_QTY
spsPullOrderDetailInfo.RequiredPartQty = materialPullingOrderDetailInfo.RequirePartQty;
///CREATE_USER
spsPullOrderDetailInfo.CreateUser = loginUser;
sql += SpsPullOrderDetailDAL.GetInsertSql(spsPullOrderDetailInfo);
}
return(sql);
}
/// <summary>
/// InsertInfo
/// </summary>
/// <param name="info">对象</param>
/// <returns></returns>
public long InsertInfo(SpsPullOrderDetailInfo info)
{
return(dal.Add(info));
}
