private IList <DssExportHistory> ConvertList(IList list, DssOutboundControl dssOutboundControl)
{
IList <DssExportHistory> result = new List <DssExportHistory>();
if (list != null && list.Count > 0)
{
foreach (object obj in list)
{
DssExportHistory dssExportHistory = commonOutboundMgr.ConvertLocationTransactionToDssExportHistory(obj, dssOutboundControl);
dssExportHistory.Qty = -dssExportHistory.Qty; //修正数量
dssExportHistory.KeyCode = dssExportHistory.OrderNo; //订单号
dssExportHistory.ReferenceLocation = dssOutboundControl.UndefinedString1; //客户库位
if (dssExportHistory.Location != null && dssExportHistory.ReferenceLocation != null &&
dssExportHistory.Location.Trim().ToUpper() == dssExportHistory.ReferenceLocation.Trim().ToUpper())
{
continue;
}
result.Add(dssExportHistory);
}
}
return(result);
}
protected override object Serialize(object obj)
{
DssExportHistory dssExportHistory = (DssExportHistory)obj;
DateTime effDate = dssExportHistory.EffectiveDate.HasValue ? dssExportHistory.EffectiveDate.Value : DateTime.Today;
string[] line1 = new string[]
{
DssHelper.GetEventValue(dssExportHistory.EventCode),
dssExportHistory.PartyFrom, //QAD:Site
dssExportHistory.KeyCode,
!string.IsNullOrEmpty(dssExportHistory.DefinedString3) ? dssExportHistory.DefinedString3 : dssExportHistory.PartyTo, //客户
null,
null,
null
};
string[] line2 = new string[]
{
DssHelper.GetEventValue(dssExportHistory.EventCode),
dssExportHistory.Item,//零件号
null,
null,
dssExportHistory.Qty.ToString("0.########"), //数量
dssExportHistory.PartyFrom, //QAD:Site
dssExportHistory.Location //客户库位
};
string[][] data = new string[][] { line1, line2 };
return(new object[] { effDate, data });
}
protected IList <DssExportHistory> ConvertList(IList list, DssOutboundControl dssOutboundControl)
{
IList <DssExportHistory> result = new List <DssExportHistory>();
if (list != null && list.Count > 0)
{
foreach (object obj in list)
{
DssExportHistory dssExportHistory = commonOutboundMgr.ConvertLocationTransactionToDssExportHistory(obj, dssOutboundControl);
dssExportHistory.KeyCode = dssExportHistory.OrderNo;//订单号
#region 账户、分账户、成本中心、项目
dssExportHistory.DefinedString1 = null; //账户
dssExportHistory.DefinedString2 = null; //分账户
dssExportHistory.DefinedString3 = null; //成本中心
dssExportHistory.DefinedString4 = null; //项目
this.GetAccount(dssExportHistory);
#endregion
result.Add(dssExportHistory);
}
}
return(result);
}
/// <summary>
/// ISS-UNP 计划外出库
/// </summary>
/// <param name="list"></param>
/// <param name="dssOutboundControl"></param>
/// <param name="isFLag">是</param>
/// <returns></returns>
protected IList <DssExportHistory> ConvertList(IList list, DssOutboundControl dssOutboundControl, bool isFLag)
{
IList <DssExportHistory> result = new List <DssExportHistory>();
if (list != null && list.Count > 0)
{
foreach (object obj in list)
{
DssExportHistory dssExportHistory = commonOutboundMgr.ConvertLocationTransactionToDssExportHistory(obj, dssOutboundControl);
//add djin 20120910
if ((string)((object[])obj)[4] == "Reject" && ((object[])obj).Length > 9)
{
dssExportHistory.PartyTo = locMgr.LoadLocation((string)((object[])obj)[9]).Region.Code;
}
dssExportHistory.KeyCode = dssExportHistory.OrderNo;//订单号
#region 账户、分账户、成本中心、项目
dssExportHistory.DefinedString1 = null; //账户
dssExportHistory.DefinedString2 = null; //分账户
dssExportHistory.DefinedString3 = null; //成本中心
dssExportHistory.DefinedString4 = null; //项目
this.GetAccount(dssExportHistory);
#endregion
result.Add(dssExportHistory);
}
}
return(result);
}
protected override object Serialize(object obj)
{
DssExportHistory dssExportHistory = (DssExportHistory)obj;
DateTime effDate = dssExportHistory.EffectiveDate.HasValue ? dssExportHistory.EffectiveDate.Value : DateTime.Today;
string[] line1 = new string[]
{
DssHelper.GetEventValue(dssExportHistory.EventCode),
dssExportHistory.PartyTo, //客户
DssHelper.FormatDate(effDate, dssExportHistory.DssOutboundControl.ExternalSystem.Code), //生效日期
dssExportHistory.PartyFrom, //QAD:Site
//"",//零件号
dssExportHistory.Item
};
string[] line2 = new string[]
{
DssHelper.GetEventValue(dssExportHistory.EventCode),
dssExportHistory.Item, //零件号
dssExportHistory.Qty.ToString("0.########"), //数量
dssExportHistory.PartyFrom, //QAD:Site
dssExportHistory.Location //客户库位
};
string[][] data = new string[][] { line1, line2 };
return(new object[] { effDate, data });
}
protected override object Serialize(object obj)
{
DssExportHistory dssExportHistory = (DssExportHistory)obj;
DateTime effDate = dssExportHistory.EffectiveDate.HasValue ? dssExportHistory.EffectiveDate.Value : DateTime.Today;
string[] line1 = new string[]
{
DssHelper.GetEventValue(dssExportHistory.EventCode),
dssExportHistory.DefinedString1, //开票通知单号
dssExportHistory.ReceiptNo, //收货单号
null, //Line
dssExportHistory.Item, //零件号
dssExportHistory.PartyFrom, //供应商
dssExportHistory.Qty.ToString("0.########"), //数量
dssExportHistory.DefinedString2, //币种
dssExportHistory.DefinedString3, //发票单价
dssExportHistory.Uom, //单位
dssExportHistory.DefinedString4, //采购单价
dssExportHistory.DefinedString5, //金额
dssExportHistory.OrderNo, //订单号
DssHelper.FormatDate(effDate, dssExportHistory.DssOutboundControl.ExternalSystem.Code), //收货日期
dssExportHistory.Location, //库位
null //排程单号
};
string[][] data = new string[][] { line1 };
return(new object[] { effDate, data });
}
public DssExportHistory ConvertLocationTransactionToDssExportHistory(object obj, DssOutboundControl dssOutboundControl)
{
DssExportHistory dssExportHistory = new DssExportHistory();
dssExportHistory.DssOutboundControl = dssOutboundControl;
dssExportHistory.EventCode = BusinessConstants.DSS_EVENT_CODE_CREATE;
dssExportHistory.IsActive = true;
dssExportHistory.CreateDate = DateTime.Now;
dssExportHistory.OriginalId = (int)((object[])obj)[0];
dssExportHistory.OrderNo = (string)((object[])obj)[1];
dssExportHistory.ReceiptNo = (string)((object[])obj)[2];
dssExportHistory.Item = (string)((object[])obj)[3];
dssExportHistory.Location = (string)((object[])obj)[4];
dssExportHistory.Qty = (decimal)((object[])obj)[5];
dssExportHistory.EffectiveDate = (DateTime)((object[])obj)[6];
dssExportHistory.PartyFrom = (string)((object[])obj)[7];
dssExportHistory.PartyTo = (string)((object[])obj)[8];
//记录RefLoc
if (((object[])obj).Length > 9)
{
dssExportHistory.ReferenceLocation = (string)((object[])obj)[9];
}
return(dssExportHistory);
}
protected override object GetOutboundData(DssExportHistory dssExportHistory)
{
if (!commonOutboundMgr.CheckBillStatusValid(dssExportHistory.DefinedString1))
{
throw new BusinessErrorException("状态不合法");
}
return((object)dssExportHistory);
}
private void GetLoctransInfo(DssExportHistory dssExportHistory)
{
OrderLocationTransaction orderLocationTransaction =
commonOutboundMgr.GetOrderLocationTransactionInfo(dssExportHistory.OrderNo, dssExportHistory.Item, BusinessConstants.IO_TYPE_IN);
if (orderLocationTransaction != null)
{
dssExportHistory.Location = orderLocationTransaction.Location != null ? orderLocationTransaction.Location.Code : null; //收货库位
dssExportHistory.PartyTo = orderLocationTransaction.OrderDetail.OrderHead.PartyTo.Code; //收货区域
}
}
protected override object Serialize(object obj)
{
DssExportHistory dssExportHistory = (DssExportHistory)obj;
DateTime effDate = dssExportHistory.EffectiveDate.HasValue ? dssExportHistory.EffectiveDate.Value : DateTime.Today;
log.Debug("Now write data:" + dssExportHistory.Location + "," + dssExportHistory.Item + "," + dssExportHistory.Qty.ToString("0.##"));
string[] line1 = new string[]
{
DssHelper.GetEventValue(dssExportHistory.EventCode),
dssExportHistory.UndefinedString2, //雇员
DssHelper.FormatDate(effDate, dssExportHistory.DssOutboundControl.ExternalSystem.Code), //生效日期
dssExportHistory.PartyTo, //QAD:Site
dssExportHistory.Item, //零件号
dssExportHistory.UndefinedString3, //工序
null,
null,
null,
dssExportHistory.Qty.ToString("0.##"), //数量
null, // dssExportHistory.DefinedString1,//废品数
null, // dssExportHistory.DefinedString2,//次品数
null,
dssExportHistory.PartyTo, //QAD:Site
dssExportHistory.Location //库位
};
List <string[]> dataList = new List <string[]>();
dataList.Add(line1);
IList <DssExportHistoryDetail> dssExportHistoryDetailList = dssExportHistory.DssExportHistoryDetails;
if (dssExportHistory.DssExportHistoryDetails != null && dssExportHistory.DssExportHistoryDetails.Count > 0)
{
foreach (DssExportHistoryDetail dssExportHistoryDetail in dssExportHistoryDetailList)
{
string[] line2 = new string[]
{
DssHelper.GetEventValue(dssExportHistory.EventCode),
dssExportHistoryDetail.Item, //零件号
dssExportHistory.UndefinedString3, //工序
dssExportHistoryDetail.Qty.ToString("0.####"), //数量
dssExportHistory.PartyFrom, //QAD:Site
dssExportHistoryDetail.Location //库位
};
dataList.Add(line2);
}
}
string[][] data = dataList.ToArray();
return(new object[] { effDate, data });
}
private void GetAccount(DssExportHistory dssExportHistory)
{
MiscOrder miscOrder = miscOrderMgr.LoadMiscOrder(dssExportHistory.OrderNo);
if (miscOrder != null)
{
dssExportHistory.DefinedString1 = miscOrder.SubjectList.SubjectCode; //账户
dssExportHistory.DefinedString2 = miscOrder.SubjectList.AccountCode; //分账户
dssExportHistory.DefinedString3 = miscOrder.SubjectList.CostCenterCode; //成本中心
dssExportHistory.DefinedString4 = miscOrder.ProjectCode; //项目
}
}
protected override object GetOutboundData(DssExportHistory dssExportHistory)
{
if (dssExportHistory.ReferenceLocation == null || dssExportHistory.ReferenceLocation.Trim() == string.Empty)
{
throw new BusinessErrorException("目的库位为空");
}
if (dssExportHistory.Location == null || dssExportHistory.Location.Trim() == string.Empty)
{
throw new BusinessErrorException("来源库位为空");
}
return((object)dssExportHistory);
}
private void GetLoctransInfo(DssExportHistory dssExportHistory)
{
OrderLocationTransaction orderLocationTransaction =
commonOutboundMgr.GetOrderLocationTransactionInfo(dssExportHistory.OrderNo, dssExportHistory.Item, BusinessConstants.IO_TYPE_OUT);
if (orderLocationTransaction != null)
{
//dssExportHistory.Location = orderLocationTransaction.Location != null ? orderLocationTransaction.Location.Code : null;//发出库位
dssExportHistory.PartyFrom = orderLocationTransaction.OrderDetail.OrderHead.PartyFrom.Code;//发出区域
}
else
{
////归档库查找
//DetachedCriteria criteria = DetachedCriteria.For(typeof(OrderLocationTransaction));
//criteria.CreateAlias("OrderDetail", "od");
//criteria.Add(Expression.Eq("od.OrderHead.OrderNo", dssExportHistory.OrderNo));
//criteria.Add(Expression.Eq("Item.Code", dssExportHistory.Item));
//criteria.Add(Expression.Eq("IOType", BusinessConstants.IO_TYPE_OUT));
//IList<OrderLocationTransaction> result = archCriteriaMgr.FindAll<OrderLocationTransaction>(criteria);
//if (result != null && result.Count > 0)
//{
// orderLocationTransaction= result[0];
// dssExportHistory.PartyFrom = orderLocationTransaction.OrderDetail.OrderHead.PartyFrom.Code;//发出区域
//}
//else
//{
//}
try
{
SqlParameter[] sqlParameter = new SqlParameter[3];
sqlParameter[0] = new SqlParameter("@Item", SqlDbType.VarChar, 50);
sqlParameter[0].Value = dssExportHistory.Item;
sqlParameter[1] = new SqlParameter("@OrderNo", SqlDbType.VarChar, 50);
sqlParameter[1].Value = dssExportHistory.OrderNo;
sqlParameter[2] = new SqlParameter("@PartyFrom", SqlDbType.VarChar, 50);
sqlParameter[2].Direction = ParameterDirection.InputOutput;
sqlHelperDao.ExecuteStoredProcedure("GetPartyFrom", sqlParameter);
dssExportHistory.PartyFrom = sqlParameter[2].Value.ToString();
}
catch (Exception)
{
dssExportHistory.PartyFrom = string.Empty;
}
}
}
public override void CreateDssExportHistory(DssExportHistory dssExportHistory)
{
base.CreateDssExportHistory(dssExportHistory);
#region Create details
if (dssExportHistory.DssExportHistoryDetails != null && dssExportHistory.DssExportHistoryDetails.Count > 0)
{
foreach (var dssExportHistoryDetail in dssExportHistory.DssExportHistoryDetails)
{
dssExportHistoryDetail.MstrId = dssExportHistory.Id;
this.dssExportHistoryDetailMgr.CreateDssExportHistoryDetail(dssExportHistoryDetail);
}
}
#endregion
}
protected virtual void ObjectMapping(DssExportHistory dssExportHistory)
{
string entityParty = BusinessConstants.DSS_ENTITY_PARTY;
string entityLocation = BusinessConstants.DSS_ENTITY_LOCATION;
string entitySite = BusinessConstants.DSS_ENTITY_SITE;
string defaultSite = dssExportHistory.DssOutboundControl.ExternalSystem.UndefinedString1;
string extSysCode = dssExportHistory.DssOutboundControl.ExternalSystem.Code;
string location = dssExportHistory.Location;
string refLocation = dssExportHistory.ReferenceLocation;
string partyFrom = dssExportHistory.PartyFrom;
string partyTo = dssExportHistory.PartyTo;
if (partyFrom == BusinessConstants.SYSTEM_REGION)
{
if (refLocation != null && refLocation != BusinessConstants.SYSTEM_LOCATION_INSPECT && refLocation != BusinessConstants.SYSTEM_LOCATION_REJECT)
{
partyFrom = locationMgr.LoadLocation(refLocation).Region.Code;
}
else if (location != BusinessConstants.SYSTEM_LOCATION_INSPECT && location != BusinessConstants.SYSTEM_LOCATION_REJECT)
{
partyFrom = locationMgr.LoadLocation(location).Region.Code;
}
}
if (partyTo == BusinessConstants.SYSTEM_REGION)
{
if (location != BusinessConstants.SYSTEM_LOCATION_INSPECT && location != BusinessConstants.SYSTEM_LOCATION_REJECT)
{
partyTo = locationMgr.LoadLocation(location).Region.Code;
}
else if (refLocation != null && refLocation != BusinessConstants.SYSTEM_LOCATION_INSPECT && refLocation != BusinessConstants.SYSTEM_LOCATION_REJECT)
{
partyTo = locationMgr.LoadLocation(refLocation).Region.Code;
}
}
//供应商,来源区域 => Site
dssExportHistory.PartyFrom = this.GetMappingExternalCode(entityParty, extSysCode, partyFrom, entitySite, partyFrom);
//客户,目的区域 => Site
dssExportHistory.PartyTo = this.GetMappingExternalCode(entityParty, extSysCode, partyTo, entitySite, partyTo);
//库位
dssExportHistory.Location = this.GetMappingExternalCode(entityLocation, extSysCode, location, location);
//移库来源库位
if (dssExportHistory.ReferenceLocation != null && dssExportHistory.ReferenceLocation.Trim() != string.Empty)
{
dssExportHistory.ReferenceLocation = this.GetMappingExternalCode(entityLocation, extSysCode, refLocation, refLocation);
}
}
public static string GetBillKeyCode(DssExportHistory dssExportHistory, string billNo)
{
if (dssExportHistory.DssOutboundControl.ExternalSystem.Code == BusinessConstants.DSS_SYSTEM_CODE_QAD)
{
string prefix = billNo.Substring(0, 1);
if (dssExportHistory.DssOutboundControl.ExternalSystem.Prefix2 != null && dssExportHistory.DssOutboundControl.ExternalSystem.Prefix2.Trim() != string.Empty)
{
prefix = dssExportHistory.DssOutboundControl.ExternalSystem.Prefix2;
}
string keyCode = prefix + billNo.Remove(0, billNo.Length - 7);
return(keyCode);
}
return(billNo);
}
//protected override object Serialize(object obj)
//{
// throw new NotImplementedException();
//}
#region Private Method
private IList <DssExportHistory> ConvertList(IList <BillDetail> list, DssOutboundControl dssOutboundControl)
{
DetachedCriteria criteria = DetachedCriteria.For(typeof(DssObjectMapping))
.Add(Expression.Eq("Entity", "BillTo")).Add(Expression.Eq("ExternalSystem", "QAD"))
.Add(Expression.Eq("ExternalEntity", "ShipTo"));
IList <DssObjectMapping> dom = criteriaMgr.FindAll <DssObjectMapping>(criteria);
IList <DssExportHistory> result = new List <DssExportHistory>();
if (list != null && list.Count > 0)
{
foreach (BillDetail billDetail in list)
{
DssExportHistory dssExportHistory = new DssExportHistory();
dssExportHistory.DssOutboundControl = dssOutboundControl;
dssExportHistory.EventCode = BusinessConstants.DSS_EVENT_CODE_CREATE;
dssExportHistory.IsActive = true;
dssExportHistory.CreateDate = DateTime.Now;
dssExportHistory.OriginalId = billDetail.Id;
dssExportHistory.OrderNo = billDetail.ActingBill.OrderNo;
dssExportHistory.ReceiptNo = billDetail.ActingBill.ReceiptNo;
dssExportHistory.Item = billDetail.ActingBill.Item.Code;
dssExportHistory.Location = dssExportHistory.DssOutboundControl.UndefinedString1;//客户库位
dssExportHistory.Qty = billDetail.BilledQty;
//dssExportHistory.EffectiveDate = billDetail.Bill.CreateDate.Date;
dssExportHistory.EffectiveDate = DateTime.Now;
dssExportHistory.PartyTo = billDetail.Bill.BillAddress.Party.Code; //客户
dssExportHistory.DefinedString1 = billDetail.Bill.BillNo; //开票通知单号
dssExportHistory.DefinedString2 = billDetail.Bill.BillAddress.Code; //BillTo
if (dom != null && dom.Count > 0)
{
DssObjectMapping sd = dom.Where(d => d.Code == billDetail.Bill.BillAddress.Code).FirstOrDefault();
dssExportHistory.DefinedString3 = sd.ExternalCode; //Map到shipto
}
dssExportHistory.KeyCode = DssHelper.GetBillKeyCode(dssExportHistory, billDetail.Bill.BillNo);
this.GetLoctransInfo(dssExportHistory);
result.Add(dssExportHistory);
}
}
return(result);
}
private IList <DssExportHistory> ConvertList(IList list, DssOutboundControl dssOutboundControl)
{
IList <DssExportHistory> result = new List <DssExportHistory>();
if (list != null && list.Count > 0)
{
foreach (object obj in list)
{
DssExportHistory dssExportHistory = new DssExportHistory();
dssExportHistory.DssOutboundControl = dssOutboundControl;
dssExportHistory.EventCode = BusinessConstants.DSS_EVENT_CODE_CREATE;
dssExportHistory.IsActive = true;
dssExportHistory.CreateDate = DateTime.Now;
dssExportHistory.OriginalId = (int)((object[])obj)[0];
dssExportHistory.OrderNo = (string)((object[])obj)[1];
dssExportHistory.ReceiptNo = (string)((object[])obj)[2];
dssExportHistory.Item = (string)((object[])obj)[3];
dssExportHistory.Qty = (decimal)((object[])obj)[4];
dssExportHistory.EffectiveDate = (DateTime)((object[])obj)[5];
dssExportHistory.PartyFrom = (string)((object[])obj)[6];
if ((string)((object[])obj)[8] == BusinessConstants.SYSTEM_LOCATION_REJECT)
{
dssExportHistory.PartyTo = (string)((object[])obj)[7];
// this.GetLoctransInfo(dssExportHistory);
this.GetLoctransInfo(dssExportHistory, true);//10-15上线
dssExportHistory.KeyCode = orderHeadMgr.LoadOrderHead(dssExportHistory.OrderNo).ExternalOrderNo;
}
else
{
dssExportHistory.PartyTo = (string)((object[])obj)[6];
this.GetLoctransInfo(dssExportHistory);
dssExportHistory.KeyCode = this.GetKeyCode(dssExportHistory, dssExportHistory.ReceiptNo);
}
result.Add(dssExportHistory);
}
}
return(result);
}
protected override object GetOutboundData(DssExportHistory dssExportHistory)
{
//if (dssExportHistory.Comments != "ISS-UNP2RCT-TR")
//{
if (dssExportHistory.ReferenceLocation == null || dssExportHistory.ReferenceLocation.Trim() == string.Empty)
{
dssExportHistory.Comments = "来源库位为空";
throw new BusinessErrorException("来源库位为空");
}
//}
if (dssExportHistory.Location == null || dssExportHistory.Location.Trim() == string.Empty)
{
throw new BusinessErrorException("目的库位为空");
}
return((object)dssExportHistory);
}
private string GetKeyCode(DssExportHistory dssExportHistory, string receiptNo)
{
if (dssExportHistory.DssOutboundControl.ExternalSystem.Code == BusinessConstants.DSS_SYSTEM_CODE_QAD)
{
//string prefix = receiptNo.Substring(0, 1);
//if (dssExportHistory.DssOutboundControl.ExternalSystem.Prefix1 != null && dssExportHistory.DssOutboundControl.ExternalSystem.Prefix1.Trim() != string.Empty)
// prefix = dssExportHistory.DssOutboundControl.ExternalSystem.Prefix1;
//string keyCode = prefix + dssExportHistory.ReceiptNo.Remove(0, receiptNo.Length - 5);
//return numberControlMgr.GenerateNumber(keyCode, 2);
return(this.GetIpNo(receiptNo));
}
else
{
return(receiptNo);
}
}
private IList <DssExportHistory> ConvertList(IList <BillDetail> list, DssOutboundControl dssOutboundControl)
{
IList <DssExportHistory> result = new List <DssExportHistory>();
if (list != null && list.Count > 0)
{
foreach (BillDetail billDetail in list)
{
DssExportHistory dssExportHistory = new DssExportHistory();
dssExportHistory.DssOutboundControl = dssOutboundControl;
dssExportHistory.EventCode = BusinessConstants.DSS_EVENT_CODE_CREATE;
dssExportHistory.IsActive = true;
dssExportHistory.CreateDate = DateTime.Now;
dssExportHistory.OriginalId = billDetail.Id;
dssExportHistory.OrderNo = billDetail.ActingBill.OrderNo;
dssExportHistory.ReceiptNo = billDetail.ActingBill.ReceiptNo;
dssExportHistory.Item = billDetail.ActingBill.Item.Code;
dssExportHistory.Uom = billDetail.ActingBill.Uom.Code;
dssExportHistory.Qty = billDetail.BilledQty;
dssExportHistory.EffectiveDate = billDetail.ActingBill.EffectiveDate;
dssExportHistory.PartyFrom = billDetail.Bill.BillAddress.Party.Code; //供应商
dssExportHistory.DefinedString1 = billDetail.Bill.BillNo; //开票通知单号
dssExportHistory.DefinedString2 = billDetail.Currency.Code; //币种
dssExportHistory.DefinedString3 = billDetail.UnitPrice.ToString("0.########"); //发票单价
dssExportHistory.DefinedString4 = billDetail.UnitPrice.ToString("0.########"); //采购单价
dssExportHistory.DefinedString5 = billDetail.OrderAmount.ToString("0.########"); //金额
dssExportHistory.KeyCode = DssHelper.GetBillKeyCode(dssExportHistory, billDetail.Bill.BillNo);
this.GetLoctransInfo(dssExportHistory);
result.Add(dssExportHistory);
}
}
return(result);
}
protected override object Serialize(object obj)
{
DssExportHistory dssExportHistory = (DssExportHistory)obj;
DateTime effDate = dssExportHistory.EffectiveDate.HasValue ? dssExportHistory.EffectiveDate.Value : DateTime.Today;
string[] line1 = new string[]
{
DssHelper.GetEventValue(dssExportHistory.EventCode),
dssExportHistory.Item, //零件号
dssExportHistory.Qty.ToString("0.########"), //数量
dssExportHistory.PartyTo, //QAD:Site
dssExportHistory.Location, //库位
dssExportHistory.KeyCode, //单号
DssHelper.FormatDate(effDate, dssExportHistory.DssOutboundControl.ExternalSystem.Code), //生效日期
dssExportHistory.DefinedString1, //账户
dssExportHistory.DefinedString2, //分账户
dssExportHistory.DefinedString3, //成本中心
dssExportHistory.DefinedString4 //项目
};
string[][] data = new string[][] { line1 };
return(new object[] { effDate, data });
}
protected override object Serialize(object obj)
{
DssExportHistory dssExportHistory = (DssExportHistory)obj;
DateTime effDate = dssExportHistory.EffectiveDate.HasValue ? dssExportHistory.EffectiveDate.Value : DateTime.Today;
log.Debug("Now write data:" + dssExportHistory.Item + "," + dssExportHistory.ReferenceLocation + "," + dssExportHistory.Location + "," + dssExportHistory.Qty);
string[] line1 = new string[]
{
DssHelper.GetEventValue(dssExportHistory.EventCode),
dssExportHistory.Item, //零件号
dssExportHistory.Qty.ToString("0.########"), //数量
DssHelper.FormatDate(effDate, dssExportHistory.DssOutboundControl.ExternalSystem.Code), //生效日期
dssExportHistory.KeyCode, //收货单号
dssExportHistory.PartyFrom, //QAD:Site
dssExportHistory.Location, //来源库位
dssExportHistory.PartyFrom, //QAD:Site,销售对应QAD移库,所以取来源区域
dssExportHistory.ReferenceLocation //目的库位
};
string[][] data = new string[][] { line1 };
return(new object[] { effDate, data });
}
protected abstract object GetOutboundData(DssExportHistory dssExportHistory);
protected override object GetOutboundData(DssExportHistory dssExportHistory)
{
return(dssExportHistory);
}
public virtual void DeleteDssExportHistory(DssExportHistory entity)
{
Delete(entity);
}
public virtual void UpdateDssExportHistory(DssExportHistory entity)
{
Update(entity);
}
public virtual void CreateDssExportHistory(DssExportHistory entity)
{
Create(entity);
}
public virtual void DeleteDssExportHistory(DssExportHistory entity)
{
entityDao.DeleteDssExportHistory(entity);
}
public virtual void UpdateDssExportHistory(DssExportHistory entity)
{
entityDao.UpdateDssExportHistory(entity);
}
