public ServiceResult Run(RunMethod runMethod)
{
/*------ Get WebService URL and UserName and Password ------*/
SAPWebServiceEntity webServiceEntity = System.Configuration.ConfigurationManager.GetSection("MOBOMTransferConfig") as SAPWebServiceEntity;
if (webServiceEntity == null)
{
return(new ServiceResult(false, "没有维护MOBOMTransferConfig对应的Service地址", this.m_Argument.TransactionCode));
}
#region Begin for Prepare input Paremente
// Prepare input parameter
DT_MES_POBOM_REQ moBOMParameter = new DT_MES_POBOM_REQ();
moBOMParameter.Mocode = this.m_Argument.MOCodeList;
moBOMParameter.Transaction_code = this.m_Argument.TransactionCode;
#endregion
// Serialize the Input Parameter
string xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_POBOM_REQ), moBOMParameter);
#region For Request Log
DBDateTime requestDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
SAPDataTransferLog log = new SAPDataTransferLog();
// new trans
TransferFacade transferFacade = new TransferFacade(DomainDataProviderManager.DomainDataProvider());
log.JobID = TransferFacade.MOMaterialTransferJobID;
log.TransactionCode = this.m_Argument.TransactionCode;
log.TransactionSequence = 1;
log.RequestDate = requestDateTime.DBDate;
log.RequestTime = requestDateTime.DBTime;
log.RequestContent = xmlFilePath;
log.OrganizationID = InternalVariables.MS_OrganizationID;
log.SendRecordCount = 1;
transferFacade.AddSAPDataTransferLog(log);
#endregion
#region Begin for Calling WebService
// Call Web Service through MaterialServiceClientProxy
DT_MES_POBOM_RESP returnValue;
try
{
MOBOMServiceClientProxy clientProxy = new MOBOMServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
returnValue = clientProxy.MI_MES_POBOM_REQ(moBOMParameter);
clientProxy.Dispose();
clientProxy = null;
//Serialize the output Parameter
xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Response.xml",
typeof(DT_MES_POBOM_RESP), returnValue);
// Update Log
DBDateTime responseDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.ResponseDate = responseDateTime.DBDate;
log.ResponseTime = responseDateTime.DBTime;
log.ResponseContent = xmlFilePath;
transferFacade.UpdateSAPDataTransferLog(log);
}
catch (Exception e)
{
log.Result = "Fail";
log.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, e.Message, log.TransactionCode));
}
#endregion
if (string.Compare(returnValue.FLAG, "Y", true) == 0)
{
int moBOMCount = returnValue.POCONFIRM_LIST.Length;
if (runMethod == RunMethod.Manually)
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = false;
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection();
this.DataProvider.BeginTransaction();
}
try
{
#region Main flow
MOFacade moBOMFacade = new MOFacade(this.DataProvider);
MOBOM moBOM;
DT_MES_POBOM_RESPPOCONFIRM_LIST moBOMObject;
for (int j = 0; j < this.m_Argument.MOCodeList.Length; j++)
{
moBOMFacade.DeleteMOBOMByMOCode(this.m_Argument.MOCodeList[j].ToUpper());
for (int i = 0; i < moBOMCount; i++)
{
if (string.Compare(returnValue.POCONFIRM_LIST[i].MOCODE, this.m_Argument.MOCodeList[j], true) != 0)
{
continue;
}
else
{
moBOMObject = returnValue.POCONFIRM_LIST[i];
moBOM = moBOMFacade.CreateNewMOBOM();
moBOM.MOCode = moBOMObject.MOCODE;
moBOM.ItemCode = InternalVariables.MatchItemCode(moBOMObject.ITEMCODE);
moBOM.MOBOMItemCode = InternalVariables.MatchItemCode(moBOMObject.MOBITEMCODE);
//moBOM.MOBOMItemName = moBOMObject.MOBITEMDESC;
//moBOM.MOBOMItemDescription = moBOMObject.MOBITEMDESC;
moBOM.MOBOMItemName = "";
moBOM.MOBOMItemDescription = "";
moBOM.MOBOMItemQty = decimal.Parse(moBOMObject.MOBITEMQTY);
moBOM.MOBOMSourceItemCode = InternalVariables.MatchItemCode(moBOMObject.MOBITEMCODE);
moBOM.MOBOMItemUOM = moBOMObject.MOBOMITEMUOM;
moBOM.Sequence = moBOMFacade.GetMOBOMMaxSequence(moBOMObject.MOCODE);
moBOM.MOBOMItemStatus = "0";
moBOM.MOBOMItemEffectiveDate = 20080101;
moBOM.MOBOMItemEffectiveTime = 1;
moBOM.MOBOMItemInvalidDate = 29991231;
moBOM.MOBOMItemInvalidTime = 1;
moBOM.MaintainUser = "******";
moBOM.MOBOMItemECN = "";
moBOM.MOBOMItemLocation = "";
moBOM.MOBOMItemVersion = "";
moBOM.MOBOMItemControlType = "";
moBOM.EAttribute1 = "";
moBOM.OPCode = "";
moBOM.MoBOM = moBOMObject.MOBOM;
moBOM.MOBOMLine = moBOMObject.MOBOMLINE;
moBOM.MOFactory = moBOMObject.MOFAC;
moBOM.MOResource = moBOMObject.MORESOURCE;
moBOMFacade.AddMOBOM(moBOM);
}
}
}
if (runMethod == RunMethod.Manually)
{
this.DataProvider.CommitTransaction();
}
#endregion
log.Result = "OK";
log.ErrorMessage = "";
}
catch (Exception ex)
{
if (runMethod == RunMethod.Manually)
{
this.DataProvider.RollbackTransaction();
}
// Log
log.Result = "Fail";
log.ErrorMessage = ex.Message;
}
finally
{
if (runMethod == RunMethod.Manually)
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection();
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = true;
}
}
log.ReceivedRecordCount = moBOMCount;
DBDateTime finishedDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.FinishedDate = finishedDateTime.DBDate;
log.FinishedTime = finishedDateTime.DBTime;
transferFacade.UpdateSAPDataTransferLog(log);
if (log.Result == "OK")
{
return(new ServiceResult(true, "", log.TransactionCode));
}
else
{
return(new ServiceResult(false, log.ErrorMessage, log.TransactionCode));
}
}
else // status!="OK"
{
log.Result = "Fail";
log.ErrorMessage = returnValue.message;
log.ReceivedRecordCount = 0;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, log.ErrorMessage, log.TransactionCode));
}
}
private ServiceResult RunOne(SAPWebServiceEntity webServiceEntity, SAPMaterialTrans sapMaterialTrans, DT_MES_TRANSFERPOST_REQ req)
{
string xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_TRANSFERPOST_REQ), req);
#region TransferLog
DBDateTime dateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
SAPDataTransferLog materialIssueLog = new SAPDataTransferLog();
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
materialIssueLog.JobID = TransferFacade.MaterialIssueJobID;
materialIssueLog.TransactionCode = this.m_Argument.TransactionCode;
materialIssueLog.TransactionSequence = 1;
materialIssueLog.RequestDate = dateTime.DBDate;
materialIssueLog.RequestTime = dateTime.DBTime;
materialIssueLog.RequestContent = xmlFilePath;
materialIssueLog.OrganizationID = 2000;
materialIssueLog.SendRecordCount = 1;
transferFacade.AddSAPDataTransferLog(materialIssueLog);
#endregion
#region Begin for Calling WebService
try
{
MaterialIssueServiceClientProxy clientProxy = new MaterialIssueServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
clientProxy.MI_MES_TRANSFERPOST_REQ(req);
clientProxy.Dispose();
clientProxy = null;
}
catch (Exception e)
{
materialIssueLog.Result = "Fail";
materialIssueLog.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(materialIssueLog);
return(new ServiceResult(false, e.Message, materialIssueLog.TransactionCode));
}
#endregion
#region Update tblsapmaterialtrans
if (sapMaterialTrans != null)
{
InventoryFacade inventoryFacade = new InventoryFacade(this.DataProvider);
try
{
sapMaterialTrans.Flag = FlagStatus.FlagStatus_POST;
sapMaterialTrans.TransactionCode = this.m_Argument.TransactionCode;
inventoryFacade.UpdateSAPMaterialTrans(sapMaterialTrans);
}
catch (Exception ex)
{
return(new ServiceResult(false, ex.Message, this.m_Argument.TransactionCode));
}
}
#endregion
return(new ServiceResult(true, "", this.m_Argument.TransactionCode));
}
public void Receive(MATISSUE_REQ request)
{
((SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = false;
((SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection();
try
{
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
SAPDataTransferLog log;
DBDateTime currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
string xmlFilePath;
if (request.TransactionCode == null || request.TransactionCode == string.Empty)
{
// New Log
log = transferFacade.CreateNewSAPDataTransferLog();
//log.ErrorMessage
//log.FinishedDate
//log.FinishedTime
log.JobID = TransferFacade.MaterialIssueJobID;
log.OrganizationID = 2000;
log.ReceivedRecordCount = (request.IssueList == null || request.IssueList.Count == 0) ? 0 : request.IssueList.Count;
log.TransactionCode = TransferFacade.MaterialIssueJobID + "_"
+ currentDateTime.DBDate.ToString() + "_"
+ currentDateTime.DBTime.ToString()
+ DateTime.Now.Millisecond.ToString();
log.TransactionSequence = 1;
xmlFilePath = SerializeUtil.SerializeFile(log.TransactionCode + "_Response.xml",
typeof(MATISSUE_REQ), request);
log.RequestContent = xmlFilePath;
log.RequestDate = currentDateTime.DBDate;
log.RequestTime = currentDateTime.DBTime;
//log.Result
log.SendRecordCount = 0;
transferFacade.AddSAPDataTransferLog(log);
request.TransactionCode = log.TransactionCode;
}
else
{
// Update log
log = transferFacade.GetSAPDataTransferLog(request.TransactionCode, 1) as SAPDataTransferLog;
//log.ErrorMessage
//log.FinishedDate
//log.FinishedTime
log.ReceivedRecordCount = (request.IssueList == null || request.IssueList.Count == 0) ? 0 : request.IssueList.Count;
xmlFilePath = SerializeUtil.SerializeFile(log.TransactionCode + "_Response.xml",
typeof(MATISSUE_REQ), request);
log.ResponseContent = xmlFilePath;
log.ResponseDate = currentDateTime.DBDate;
log.ResponseTime = currentDateTime.DBTime;
//log.Result
transferFacade.UpdateSAPDataTransferLog(log);
}
if (request.IssueList == null || request.IssueList.Count == 0)
{
log.Result = "Fail";
log.ErrorMessage = "Raw Issue list is null.";
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
return;
}
else
{
MaterialStockFacade msf = new MaterialStockFacade(this.DataProvider);
RawIssue4SAP rawIssue4SAP;
InventoryFacade inventoryFacade = new InventoryFacade(this.DataProvider);
List <SAPMaterialTrans> confirmSAPMaterialTransList = new List <SAPMaterialTrans>();
try
{
this.DataProvider.BeginTransaction();
foreach (MES_MATISSUE matIssue in request.IssueList)
{
rawIssue4SAP = msf.CreateNewRawIssue4SAP();
rawIssue4SAP.ErrorMessage = matIssue.ErrorMessage;
rawIssue4SAP.Flag = matIssue.Flag;
rawIssue4SAP.MaintainDate = currentDateTime.DBDate;
rawIssue4SAP.MaintainTime = currentDateTime.DBTime;
rawIssue4SAP.MaintainUser = "******";
rawIssue4SAP.MaterialDocument = matIssue.MaterialDocument;
rawIssue4SAP.MaterialDocumentYear = matIssue.MaterialDocumentYear;
rawIssue4SAP.TransactionCode = request.TransactionCode;
rawIssue4SAP.VendorCode = matIssue.VendorCode;
msf.AddRawIssue4SAP(rawIssue4SAP);
if (string.Compare(matIssue.Flag, "Y", true) == 0) // Post OK
{
object[] sapMaterialTransList = inventoryFacade.QuerySAPMaterialTrans(request.TransactionCode);
if (sapMaterialTransList != null)
{
foreach (SAPMaterialTrans sapMaterialTrans in sapMaterialTransList)
{
if (sapMaterialTrans.Flag == FlagStatus.FlagStatus_POST)
{
confirmSAPMaterialTransList.Add(sapMaterialTrans);
}
}
}
}
}
this.DataProvider.CommitTransaction();
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
log.Result = "Fail";
log.ErrorMessage = ex.Message;
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
}
try
{
log.Result = "OK";
log.ErrorMessage = "";
currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.FinishedDate = currentDateTime.DBDate;
log.FinishedTime = currentDateTime.DBTime;
transferFacade.UpdateSAPDataTransferLog(log);
foreach (SAPMaterialTrans sapMaterialTrans in confirmSAPMaterialTransList)
{
sapMaterialTrans.Flag = FlagStatus.FlagStatus_SAP;
inventoryFacade.UpdateSAPMaterialTrans(sapMaterialTrans);
}
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
log.Result = "Fail";
log.ErrorMessage = ex.Message;
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
((SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection();
((SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = true;
}
}
private ServiceResult RunOne(SAPWebServiceEntity webServiceEntity, MaterialReceive materialReceive, DT_MES_SOURCESTOCK_REQ materialPOParameter)
{
IQCFacade iqcFacade = new IQCFacade(this.DataProvider);
string xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_SOURCESTOCK_REQ), materialPOParameter);
#region TransferLog
DBDateTime dateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
SAPDataTransferLog materialPOLog = new SAPDataTransferLog();
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
materialPOLog.JobID = TransferFacade.MaterialPOJobID;
materialPOLog.TransactionCode = this.m_Argument.TransactionCode;
materialPOLog.TransactionSequence = 1;
materialPOLog.RequestDate = dateTime.DBDate;
materialPOLog.RequestTime = dateTime.DBTime;
materialPOLog.RequestContent = xmlFilePath;
materialPOLog.OrganizationID = 2000;
materialPOLog.SendRecordCount = 1;
transferFacade.AddSAPDataTransferLog(materialPOLog);
#endregion
#region Begin for Calling WebService
try
{
MaterialPOServiceClientProxy clientProxy = new MaterialPOServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
clientProxy.MI_MES_SOURCESTOCK_REQ(materialPOParameter);
clientProxy.Dispose();
clientProxy = null;
}
catch (Exception e)
{
materialPOLog.Result = "Fail";
materialPOLog.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(materialPOLog);
return(new ServiceResult(false, e.Message, materialPOLog.TransactionCode));
}
#endregion
#region UPDATE tblmaterialreceive
try
{
this.DataProvider.BeginTransaction();
foreach (DT_MES_SOURCESTOCK_REQLIST post in materialPOParameter.LIST)
{
materialReceive = (MaterialReceive)iqcFacade.GetMaterialReceive(materialReceive.IQCNo, materialReceive.STLine);
if (materialReceive != null)
{
materialReceive.Flag = FlagStatus.FlagStatus_POST;
materialReceive.TransactionCode = this.m_Argument.TransactionCode;
iqcFacade.UpdateMaterialReceive(materialReceive);
}
}
this.DataProvider.CommitTransaction();
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
return(new ServiceResult(false, ex.Message, this.m_Argument.TransactionCode));
}
#endregion
return(new ServiceResult(true, "", this.m_Argument.TransactionCode));
}
public ServiceResult Run(RunMethod runMethod)
{
/*====Get WebService URL and UserName and Password====*/
SAPWebServiceEntity webServiceEntity = System.Configuration.ConfigurationManager.GetSection("MaterialTransferConfig") as SAPWebServiceEntity;
if (webServiceEntity == null)
{
return(new ServiceResult(false, "没有维护MaterialTransferConfig对应的Service地址", this.m_Argument.TransactionCode));
}
#region Begin for Prepare input Paremente
// Prepare input parameter
DT_MES_MATERIAL_REQ materialParameter = new DT_MES_MATERIAL_REQ();
materialParameter.MaintainDate_B = this.m_Argument.MaintainDate_B.Date.ToString("yyyyMMdd", new System.Globalization.CultureInfo("en-US"));
materialParameter.MaintainDate_E = this.m_Argument.MaintainDate_E.Date.ToString("yyyyMMdd", new System.Globalization.CultureInfo("en-US"));
materialParameter.OrgID = this.m_Argument.OrgID.ToString();
materialParameter.Transaction_code = this.m_Argument.TransactionCode;
#endregion
// Serialize the Input Parameter
string xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_MATERIAL_REQ), materialParameter);
#region For Request Log
DBDateTime requestDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
SAPDataTransferLog log = new SAPDataTransferLog();
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
log.JobID = TransferFacade.MaterialTransferJobID;
log.TransactionCode = this.m_Argument.TransactionCode;
log.TransactionSequence = 1;
log.RequestDate = requestDateTime.DBDate;
log.RequestTime = requestDateTime.DBTime;
log.RequestContent = xmlFilePath;
log.OrganizationID = this.m_Argument.OrgID;
log.SendRecordCount = 1;
transferFacade.AddSAPDataTransferLog(log);
#endregion
#region Begin for Calling WebService
// Call Web Service through MaterialServiceClientProxy
DT_MES_MATERIAL_RESP returnValue;
ReTryLabel:
m_RetriedTimes++;
try
{
MaterialServiceClientProxy clientProxy = new MaterialServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
returnValue = clientProxy.MI_MES_MATERIAL_REQ(materialParameter);
clientProxy.Dispose();
clientProxy = null;
//Serialize the output Parameter
xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Response.xml",
typeof(DT_MES_MATERIAL_RESP), returnValue);
// Update Log
DBDateTime responseDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.ResponseDate = responseDateTime.DBDate;
log.ResponseTime = responseDateTime.DBTime;
log.ResponseContent = xmlFilePath;
transferFacade.UpdateSAPDataTransferLog(log);
}
catch (Exception e)
{
#region Retry or log it
if (e.Message.IndexOf("Server Error", StringComparison.CurrentCultureIgnoreCase) >= 0)
{
if (m_RetriedTimes < InternalVariables.MS_ReTryTimes)
{
System.Threading.Thread.Sleep(InternalVariables.MS_ReTryInterval * 1000);
goto ReTryLabel;
}
else
{
log.Result = "Fail";
log.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, e.Message, log.TransactionCode));
}
}
else
{
if (e is System.Net.WebException)
{
if (((System.Net.WebException)e).Status == WebExceptionStatus.Timeout)
{
if (m_RetriedTimes < InternalVariables.MS_ReTryTimes)
{
System.Threading.Thread.Sleep(InternalVariables.MS_ReTryInterval * 1000);
goto ReTryLabel;
}
else
{
log.Result = "Fail";
log.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, e.Message, log.TransactionCode));
}
}
else
{
log.Result = "Fail";
log.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, e.Message, log.TransactionCode));
}
}
else
{
log.Result = "Fail";
log.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, e.Message, log.TransactionCode));
}
}
#endregion
}
#endregion
// Generate Material Object and Save it
if (string.Compare(returnValue.FLAG, "Y", true) == 0)
{
int materialCount = returnValue.Material_Tab.Length;
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = false;
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection();
this.DataProvider.BeginTransaction();
try
{
ItemFacade itemFacade = new ItemFacade(this.DataProvider);
ModelFacade modelFacade = new ModelFacade(this.DataProvider);
BenQGuru.eMES.Domain.MOModel.Material material;
DT_MES_MATERIAL_TAB_RESP materialObj;
DBDateTime currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
#region Get Parameters
// Get CheckOPCode and LotSize
SystemSettingFacade ssf = new SystemSettingFacade(this.DataProvider);
string finishGoodCheckOPCode = "AWGJC1";
object para = ssf.GetParameter("FINISHEDPRODUCTOPCODE", "ITEMCHECKOP");
if (para != null)
{
finishGoodCheckOPCode = (para as Parameter).ParameterAlias.Trim().ToUpper();
}
string semiGoodCheckOPCode = "ATSH1";
para = ssf.GetParameter("SEMIMANUFACTUREOPCODE", "ITEMCHECKOP");
if (para != null)
{
semiGoodCheckOPCode = (para as Parameter).ParameterAlias.Trim().ToUpper();
}
int finishGoodLotSize = 200;
para = ssf.GetParameter("FINISHEDPRODUCTLOTSIZE", "ITEMLOTSIZE");
if (para != null)
{
finishGoodLotSize = int.Parse((para as Parameter).ParameterAlias.Trim());
}
int semiGoodLotSize = 500;
para = ssf.GetParameter("SEMIMANUFACTURELOTSIZE", "ITEMLOTSIZE");
if (para != null)
{
semiGoodLotSize = int.Parse((para as Parameter).ParameterAlias.Trim());
}
// Get NeedCheckCarton and NeedCheckAccessory from parameter table
string importFGCheckCarton = "1";
para = ssf.GetParameter("FGIMPORTCHKCARTON", "CHECKPACKING");
if (para != null)
{
importFGCheckCarton = (para as Parameter).ParameterAlias.Trim();
}
string exportFGCheckCarton = "1";
para = ssf.GetParameter("FGEXPORTCHKCARTON", "CHECKPACKING");
if (para != null)
{
exportFGCheckCarton = (para as Parameter).ParameterAlias.Trim();
}
string importFGCheckAccessory = "1";
para = ssf.GetParameter("FGIMPORTCHKACCESSORY", "CHECKPACKING");
if (para != null)
{
importFGCheckAccessory = (para as Parameter).ParameterAlias.Trim();
}
string exportFGCheckAccessory = "0";
para = ssf.GetParameter("FGEXPORTCHKACCESSORY", "CHECKPACKING");
if (para != null)
{
exportFGCheckAccessory = (para as Parameter).ParameterAlias.Trim();
}
#endregion
for (int i = 0; i < materialCount; i++)
{
#region Material Object
bool needAddNew = false;
materialObj = returnValue.Material_Tab[i];
object oldMaterial = itemFacade.GetMaterial(InternalVariables.MatchItemCode(materialObj.Itemcode.ToUpper()), int.Parse(materialObj.OrgID.Trim()));
if (oldMaterial == null)
{
material = itemFacade.CreateNewMaterial();
material.MaintainUser = "******";
material.EAttribute1 = "";
material.CheckStatus = "";
material.MaterialParseType = "";
material.MaterialCheckType = "";
material.MaterialModelGroup = "";
if (string.Compare(materialObj.ITEMCONTROL, "A", true) == 0 ||
string.Compare(materialObj.ITEMCONTROL, "B", true) == 0)
{
material.MaterialCheckType = OPBOMDetailCheckType.CHECK_LINKBARCODE;
}
needAddNew = true;
}
else
{
material = oldMaterial as BenQGuru.eMES.Domain.MOModel.Material;
needAddNew = false;
}
#region 属性赋值
/*--------------------- Web Service 节点数据 ---------------------*/
material.MaterialCode = InternalVariables.MatchItemCode(materialObj.Itemcode.ToUpper());
material.OrganizationID = int.Parse(materialObj.OrgID);
material.MaterialName = materialObj.itemname.ToUpper();
material.MaterialDescription = materialObj.itemname.ToUpper();
material.MaterialUOM = materialObj.ITEMUOM;
if (string.Compare(materialObj.ITEMTYPE, "FERT", true) == 0)
{
material.MaterialType = ItemType.ITEMTYPE_FINISHEDPRODUCT;
}
else if (string.Compare(materialObj.ITEMTYPE, "HALB", true) == 0)
{
material.MaterialType = ItemType.ITEMTYPE_SEMIMANUFACTURE;
}
else if (string.Compare(materialObj.ITEMTYPE, "ROH", true) == 0)
{
material.MaterialType = ItemType.ITEMTYPE_RAWMATERIAL;
}
else
{
continue;
}
material.MaterialMachineType = materialObj.ItemMachineType;
material.MaterialVolume = materialObj.Itemvolume;
material.MaterialGroup = materialObj.ItemGroup;
material.MaterialGroupDescription = materialObj.ItemGroupDesc.ToUpper();
material.MaterialModelGroup = "";
if (string.Compare(materialObj.ITEMCONTROL, "A", true) == 0)
{
material.MaterialControlType = BOMItemControlType.ITEM_CONTROL_KEYPARTS;
}
else if (string.Compare(materialObj.ITEMCONTROL, "B", true) == 0)
{
material.MaterialControlType = BOMItemControlType.ITEM_CONTROL_LOT;
}
else
{
material.MaterialControlType = BOMItemControlType.ITEM_CONTROL_NOCONTROL;
}
if (materialObj.itemname.Split('.').Length > 3)
{
material.MaterialModelCode = materialObj.itemname.Split('.')[2];
}
else
{
material.MaterialModelCode = "";
}
if (materialObj.itemname.Contains("中国"))
{
material.MaterialExportImport = "IMPORT";
}
else
{
material.MaterialExportImport = "EXPORT";
}
if (material.MaterialDescription.Length >= 3)
{
if (string.Compare(material.MaterialDescription.Substring(material.MaterialDescription.Length - 3, 3),
"ROH", true) == 0)
{
material.ROHS = "Y";
}
else
{
material.ROHS = "";
}
}
else
{
material.ROHS = "";
}
#endregion
// Save
if (needAddNew)
{
itemFacade.AddMaterial(material);
}
else
{
itemFacade.UpdateMaterial(material);
}
#endregion
#region Finish Good & Semi Finish Good
/*------------ 如果ItemType是半成品或者成品,则同时更新或插入tblitem----------*/
if (material.MaterialType == ItemType.ITEMTYPE_FINISHEDPRODUCT ||
material.MaterialType == ItemType.ITEMTYPE_SEMIMANUFACTURE)
{
needAddNew = false;
BenQGuru.eMES.Domain.MOModel.Item item;
object oldItem = itemFacade.GetItem(material.MaterialCode.ToUpper(), material.OrganizationID);
if (oldItem == null)
{
item = itemFacade.CreateNewItem();
/*-------------- 固定数据 ----------*/
item.ItemVersion = "";
item.MaintainUser = "******";
item.ItemUser = "******";
item.ItemDate = currentDateTime.DBDate;
item.EAttribute1 = "";
item.ItemConfigration = "";
item.ItemCartonQty = 1;
item.ItemBurnInQty = 0;
item.ElectricCurrentMaxValue = 0;
item.ElectricCurrentMinValue = 0;
item.ItemProductCode = "";
if (material.MaterialType == ItemType.ITEMTYPE_FINISHEDPRODUCT)
{
item.CheckItemOP = finishGoodCheckOPCode;
item.LotSize = finishGoodLotSize;
}
else if (material.MaterialType == ItemType.ITEMTYPE_SEMIMANUFACTURE)
{
item.CheckItemOP = semiGoodCheckOPCode;
item.LotSize = semiGoodLotSize;
}
if (material.MaterialType == ItemType.ITEMTYPE_FINISHEDPRODUCT)
{
if (material.MaterialExportImport == "IMPORT")
{
item.NeedCheckCarton = importFGCheckCarton;
item.NeedCheckAccessory = importFGCheckAccessory;
}
else
{
item.NeedCheckCarton = exportFGCheckCarton;
item.NeedCheckAccessory = exportFGCheckAccessory;
}
}
else
{
item.NeedCheckCarton = "0";
item.NeedCheckAccessory = "0";
}
needAddNew = true;
}
else
{
item = oldItem as Item;
needAddNew = false;
}
/*----- Web Service 节点数据 -----*/
item.ItemCode = material.MaterialCode;
item.OrganizationID = material.OrganizationID;
item.ItemName = material.MaterialName.ToUpper();
item.ItemDescription = material.MaterialName.ToUpper();
item.ItemUOM = material.MaterialUOM;
item.ItemType = material.MaterialType;
item.ItemControlType = material.MaterialControlType;
if (needAddNew)
{
itemFacade.AddItem(item);
}
else
{
itemFacade.UpdateItem(item);
}
// ItemSNCheck
if (itemFacade.GetItem2SNCheck(item.ItemCode, ItemCheckType.ItemCheckType_SERIAL) == null)
{
Item2SNCheck item2SNCheck = new Item2SNCheck();
item2SNCheck.ItemCode = item.ItemCode;
item2SNCheck.EAttribute1 = "";
item2SNCheck.MaintainUser = "******";
if (material.MaterialType == ItemType.ITEMTYPE_FINISHEDPRODUCT)
{
item2SNCheck.SNLength = 24;
item2SNCheck.SNPrefix = item.ItemCode;
}
else // ITEMTYPE_SEMIMANUFACTURE
{
item2SNCheck.SNLength = 10;
item2SNCheck.SNPrefix = "";
}
item2SNCheck.SNContentCheck = "Y";
item2SNCheck.Type = "SERIAL";
itemFacade.AddItem2SNCheck(item2SNCheck);
}
/*----------- 物料所属物料别插入tblmodel2item中，取物料料号的第二位为物料别 ---------*/
object oldModel2Item = modelFacade.GetModel2Item(item.ItemCode.Substring(1, 1), item.ItemCode, item.OrganizationID);
if (oldModel2Item == null)
{
Model2Item model2Item = new Model2Item();
model2Item.ModelCode = item.ItemCode.Substring(1, 1);
model2Item.ItemCode = item.ItemCode;
model2Item.OrganizationID = item.OrganizationID;
model2Item.MaintainUser = "******";
modelFacade.AddModel2Item(model2Item);
}
/*---- 在tblmodel2item中Distinct tblmodel2item.modelcode,如果不存在于tblmodel中，则插入tblmodel ----*/
object oldModel = modelFacade.GetModel(item.ItemCode.Substring(1, 1), item.OrganizationID);
if (oldModel == null)
{
Model model = new Model();
model.ModelCode = item.ItemCode.Substring(1, 1);
model.OrganizationID = item.OrganizationID;
model.MaintainUser = "******";
model.ModelDescription = model.ModelCode;
model.DataLinkQty = 0;
model.DimQty = 0;
model.EAttribute1 = "";
model.IsCheckDataLink = "0";
model.IsDim = "0";
model.IsInventory = "1";
model.IsReflow = "0";
modelFacade.AddModel(model);
}
}
#endregion
}
this.DataProvider.CommitTransaction();
log.Result = "OK";
log.ErrorMessage = "";
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
// Log
log.Result = "Fail";
log.ErrorMessage = ex.Message;
}
finally
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection();
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = true;
}
log.ReceivedRecordCount = materialCount;
DBDateTime finishedDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.FinishedDate = finishedDateTime.DBDate;
log.FinishedTime = finishedDateTime.DBTime;
transferFacade.UpdateSAPDataTransferLog(log);
if (log.Result == "OK")
{
return(new ServiceResult(true, "", log.TransactionCode));
}
else
{
return(new ServiceResult(false, log.ErrorMessage, log.TransactionCode));
}
}
else // status!="OK"
{
log.Result = "Fail";
log.ErrorMessage = returnValue.message;
log.ReceivedRecordCount = 0;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, log.ErrorMessage, log.TransactionCode));
}
}
public ServiceResult Run(RunMethod runMethod)
{
/*====Get WebService URL and UserName and Password====*/
SAPWebServiceEntity webServiceEntity = System.Configuration.ConfigurationManager.GetSection("DNTransferConfig") as SAPWebServiceEntity;
if (webServiceEntity == null)
{
return(new ServiceResult(false, "没有维护DNTransfer对应的Service地址", this.m_Argument.TransactionCode));
}
#region Begin for Prepare input Paremente
// Prepare input parameter
DT_MES_DN_REQ dnParameter = new DT_MES_DN_REQ();
dnParameter.TRANS = this.m_Argument.TransactionCode;
if (this.m_Argument.DNCode.Trim().Length == 0)
{
dnParameter.DATE_B = this.m_Argument.MaintainDate_B.Date.ToString("yyyyMMdd", new System.Globalization.CultureInfo("en-US"));
dnParameter.DATE_E = this.m_Argument.MaintainDate_E.Date.ToString("yyyyMMdd", new System.Globalization.CultureInfo("en-US"));
dnParameter.WERKS = this.m_Argument.OrgList;
dnParameter.VBELN = "";
}
else
{
dnParameter.DATE_B = "";
dnParameter.DATE_E = "";
dnParameter.WERKS = null;
dnParameter.VBELN = this.m_Argument.DNCode.Trim().ToUpper();
}
#endregion
// Serialize the Input Parameter
string xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_DN_REQ), dnParameter);
#region For Request Log
DBDateTime requestDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
SAPDataTransferLog log = new SAPDataTransferLog();
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
log.JobID = TransferFacade.DNTransferJobID;
log.TransactionCode = this.m_Argument.TransactionCode;
log.TransactionSequence = 1;
log.RequestDate = requestDateTime.DBDate;
log.RequestTime = requestDateTime.DBTime;
log.RequestContent = xmlFilePath;
log.OrganizationID = 2000;
log.SendRecordCount = 1;
transferFacade.AddSAPDataTransferLog(log);
#endregion
#region Begin for Calling WebService
// Call Web Service through DNServiceClientProxy
try
{
DNServiceClientProxy clientProxy = new DNServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
clientProxy.MI_MES_DN_REQ(dnParameter);
clientProxy.Dispose();
clientProxy = null;
}
catch (Exception e)
{
log.Result = "Fail";
log.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, e.Message, log.TransactionCode));
}
#endregion
return(new ServiceResult(true, "", this.m_Argument.TransactionCode));
}
public void Receive(DNRecive_REQ request)
{
((SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = false;
((SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection();
try
{
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
SAPDataTransferLog log;
DBDateTime currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
string xmlFilePath;
if (request.TransactionCode == null || request.TransactionCode == string.Empty)
{
// New Log
log = transferFacade.CreateNewSAPDataTransferLog();
//log.ErrorMessage
//log.FinishedDate
//log.FinishedTime
log.JobID = TransferFacade.DNTransferJobID;
log.OrganizationID = 2000;
log.ReceivedRecordCount = (request.DNList == null || request.DNList.Count == 0) ? 0 : request.DNList.Count;
log.TransactionCode = TransferFacade.DNTransferJobID + "_"
+ currentDateTime.DBDate.ToString() + "_"
+ currentDateTime.DBTime.ToString()
+ DateTime.Now.Millisecond.ToString();
log.TransactionSequence = 1;
xmlFilePath = SerializeUtil.SerializeFile(log.TransactionCode + "_Response.xml",
typeof(DNRecive_REQ), request);
log.RequestContent = xmlFilePath;
log.RequestDate = currentDateTime.DBDate;
log.RequestTime = currentDateTime.DBTime;
//log.Result
log.SendRecordCount = 0;
transferFacade.AddSAPDataTransferLog(log);
request.TransactionCode = log.TransactionCode;
}
else
{
// Update log
log = transferFacade.GetSAPDataTransferLog(request.TransactionCode, 1) as SAPDataTransferLog;
//log.ErrorMessage
//log.FinishedDate
//log.FinishedTime
log.ReceivedRecordCount = (request.DNList == null || request.DNList.Count == 0) ? 0 : request.DNList.Count;
xmlFilePath = SerializeUtil.SerializeFile(log.TransactionCode + "_Response.xml",
typeof(DNRecive_REQ), request);
log.ResponseContent = xmlFilePath;
log.ResponseDate = currentDateTime.DBDate;
log.ResponseTime = currentDateTime.DBTime;
//log.Result
transferFacade.UpdateSAPDataTransferLog(log);
}
if (string.Compare(request.Flag, "Y", true) == 0)
{
if (request.DNList == null || request.DNList.Count == 0)
{
log.Result = "Fail";
log.ErrorMessage = "DN list is null.";
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
return;
}
else
{
this.DataProvider.BeginTransaction();
try
{
this.DealDN(request.DNList, currentDateTime);
this.DataProvider.CommitTransaction();
log.Result = "OK";
log.ErrorMessage = "";
currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.FinishedDate = currentDateTime.DBDate;
log.FinishedTime = currentDateTime.DBTime;
transferFacade.UpdateSAPDataTransferLog(log);
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
log.Result = "Fail";
log.ErrorMessage = ex.Message;
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
}
}
}
else
{
log.Result = "Fail";
log.ErrorMessage = request.Message;
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
((SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection();
((SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = true;
}
}
public ServiceResult Run(RunMethod runMethod)
{
/*---------- Get WebService URL and UserName and Password -------------*/
SAPWebServiceEntity webServiceEntity = System.Configuration.ConfigurationManager.GetSection("MOConfirmConfig") as SAPWebServiceEntity;
if (webServiceEntity == null)
{
if (System.Configuration.ConfigurationManager.AppSettings["WebServiceUrl"] != null &&
System.Configuration.ConfigurationManager.AppSettings["WebServiceUserName"] != null &&
System.Configuration.ConfigurationManager.AppSettings["WebServicePassword"] != null)
{
webServiceEntity = new SAPWebServiceEntity();
webServiceEntity.Url = System.Configuration.ConfigurationManager.AppSettings["WebServiceUrl"];
webServiceEntity.UserName = System.Configuration.ConfigurationManager.AppSettings["WebServiceUserName"];
webServiceEntity.Password = System.Configuration.ConfigurationManager.AppSettings["WebServicePassword"];
}
else
{
return(new ServiceResult(false, "没有维护MOConfirmConfig对应的Service地址", this.m_Argument.TransactionCode));
}
}
#region Begin for Prepare input Paremeter
// Prepare input parameter
DT_MES_POCONFIRM_REQ moInputParas = new DT_MES_POCONFIRM_REQ();
moInputParas.Trsaction_code = this.m_Argument.TransactionCode;
moInputParas.POLIST = new DT_MES_POCONFIRM_REQPOLIST[this.m_Argument.MOList.Count];
for (int i = 0; i < this.m_Argument.MOList.Count; i++)
{
moInputParas.POLIST[i] = this.m_Argument.MOList[i];
}
#endregion
// Serialize the Input Parameter
string inputXmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_POCONFIRM_REQ), moInputParas);
DBDateTime requestDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
SAPDataTransferLog log;
#region Begin for Calling WebService
// Call Web Service through StandardBOMServiceClientProxy
DT_MES_POCONFIRM_RESP returnValue;
string outputXmlFilePath;
DBDateTime responseDateTime;
try
{
MOConfirmServiceClientProxy clientProxy = new MOConfirmServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
returnValue = clientProxy.MI_MES_POCONFIRM_REQ(moInputParas);
clientProxy.Dispose();
clientProxy = null;
}
catch (Exception e)
{
log = new SAPDataTransferLog();
log.JobID = TransferFacade.MOCompleteTransferJobID;
log.TransactionCode = this.m_Argument.TransactionCode;
log.TransactionSequence = 1;
log.RequestDate = requestDateTime.DBDate;
log.RequestTime = requestDateTime.DBTime;
log.RequestContent = inputXmlFilePath;
log.OrganizationID = this.m_Argument.OrgID;
log.SendRecordCount = this.m_Argument.MOList.Count;
log.ReceivedRecordCount = 0;
log.ResponseDate = 0;
log.ResponseTime = 0;
log.ResponseContent = "";
log.FinishedDate = 0;
log.FinishedTime = 0;
log.Result = "Fail";
log.ErrorMessage = e.Message;
transferFacade.AddSAPDataTransferLog(log);
return(new ServiceResult(false, e.Message, log.TransactionCode));
}
#endregion
//Serialize the output Parameter
outputXmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Response.xml",
typeof(DT_MES_POCONFIRM_RESP), returnValue);
// Update Log
responseDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
Dictionary <string, List <DT_MES_POCONFIRM> > result = this.ParseMOResult(returnValue.PO_lIST);
int sMOCount = result.Count;
List <DT_MES_POCONFIRM> moMessageList;
DBDateTime finishedDateTime;
MOFacade moFacade = new MOFacade(this.DataProvider);
MO2SAPLog mo2saplog;
int counter = 0;
foreach (string moCode in result.Keys)
{
moMessageList = result[moCode];
// Add log for Single MO
log = new SAPDataTransferLog();
log.JobID = TransferFacade.MOCompleteTransferJobID;
log.TransactionCode = this.m_Argument.TransactionCode;
log.TransactionSequence = counter + 1;
log.RequestDate = requestDateTime.DBDate;
log.RequestTime = requestDateTime.DBTime;
log.RequestContent = inputXmlFilePath;
log.OrganizationID = this.m_Argument.OrgID;
log.SendRecordCount = 1;
log.ReceivedRecordCount = moMessageList.Count;
log.ResponseDate = responseDateTime.DBDate;
log.ResponseTime = responseDateTime.DBTime;
log.ResponseContent = outputXmlFilePath;
log.Result = "OK";
log.ErrorMessage = "";
finishedDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.FinishedDate = finishedDateTime.DBDate;
log.FinishedTime = finishedDateTime.DBTime;
transferFacade.AddSAPDataTransferLog(log);
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = false;
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection();
this.DataProvider.BeginTransaction();
try
{
if (moMessageList.Count == 1)
{
DT_MES_POCONFIRM moConfirm = moMessageList[0];
if (string.Compare(moConfirm.FLAG, "Y", true) == 0)
{
// Update MO2SAP.Flag
moFacade.UpdateMO2SAPFlag(moConfirm.MOCode, decimal.Parse(moConfirm.PostSeq));
}
else
{
// Fail
// Insert new MO2SAPLog
mo2saplog = new MO2SAPLog();
mo2saplog.MOCode = moConfirm.MOCode;
mo2saplog.Active = "Y";
mo2saplog.ErrorMessage = moConfirm.message;
mo2saplog.MaintainDate = finishedDateTime.DBDate;
mo2saplog.MaintainTime = finishedDateTime.DBTime;
mo2saplog.MaintainUser = "******";
mo2saplog.OrganizationID = this.m_Argument.OrgID;
mo2saplog.PostSequence = decimal.Parse(moConfirm.PostSeq);
mo2saplog.Sequence = moFacade.GetMaxMO2SAPSequence(mo2saplog.MOCode, mo2saplog.PostSequence);
moFacade.AddMO2SAPLog(mo2saplog);
}
}
else // 返回的是ErrorMessage
{
foreach (DT_MES_POCONFIRM moConfirm in moMessageList)
{
// Insert New MO2SAPLog
mo2saplog = new MO2SAPLog();
mo2saplog.MOCode = moConfirm.MOCode;
mo2saplog.Active = "Y";
mo2saplog.ErrorMessage = moConfirm.message;
mo2saplog.MaintainDate = finishedDateTime.DBDate;
mo2saplog.MaintainTime = finishedDateTime.DBTime;
mo2saplog.MaintainUser = "******";
mo2saplog.OrganizationID = this.m_Argument.OrgID;
mo2saplog.PostSequence = decimal.Parse(moConfirm.PostSeq);
mo2saplog.Sequence = moFacade.GetMaxMO2SAPSequence(mo2saplog.MOCode, mo2saplog.PostSequence);
moFacade.AddMO2SAPLog(mo2saplog);
}
}
this.DataProvider.CommitTransaction();
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
return(new ServiceResult(false, ex.Message, this.m_Argument.TransactionCode));
}
finally
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection();
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = true;
}
counter++;
}
return(new ServiceResult(true, "", this.m_Argument.TransactionCode));
}
public ServiceResult Run(RunMethod runMethod)
{
/*--------- Get WebService URL and UserName and Password ---------*/
SAPWebServiceEntity webServiceEntity = System.Configuration.ConfigurationManager.GetSection("MOHeaderTransferConfig") as SAPWebServiceEntity;
if (webServiceEntity == null)
{
return(new ServiceResult(false, "没有维护MOHeaderTransferConfig对应的Service地址", this.m_Argument.TransactionCode));
}
#region Begin for Prepare input Paremente
// Prepare input parameter
DT_MES_PO_REQ moParameter = new DT_MES_PO_REQ();
moParameter.Trsaction_Code = this.m_Argument.TransactionCode;
if (this.m_Argument.MOCode.Trim().Length == 0)
{
moParameter.MaintainDate_B = this.m_Argument.MaintainDate_B.Date.ToString("yyyyMMdd", new System.Globalization.CultureInfo("en-US"));
moParameter.MaintainDate_E = this.m_Argument.MaintainDate_E.Date.ToString("yyyyMMdd", new System.Globalization.CultureInfo("en-US"));
moParameter.OrgID = this.m_Argument.OrgID.ToString();
moParameter.Mocode = "";
}
else
{
moParameter.MaintainDate_B = "";
moParameter.MaintainDate_E = "";
moParameter.OrgID = "";
moParameter.Mocode = this.m_Argument.MOCode.ToUpper().Trim();
}
#endregion
// Serialize the Input Parameter
string xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_PO_REQ), moParameter);
#region For Request Log
DBDateTime requestDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
SAPDataTransferLog log = new SAPDataTransferLog();
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
log.JobID = TransferFacade.MOHeaderTransferJobID;
log.TransactionCode = this.m_Argument.TransactionCode;
log.TransactionSequence = 1;
log.RequestDate = requestDateTime.DBDate;
log.RequestTime = requestDateTime.DBTime;
log.RequestContent = xmlFilePath;
log.OrganizationID = this.m_Argument.OrgID;
log.SendRecordCount = 1;
transferFacade.AddSAPDataTransferLog(log);
#endregion
#region Begin for Calling WebService
// Call Web Service through MOServiceClientProxy
DT_MES_PO_RESP returnValue;
try
{
MOServiceClientProxy clientProxy = new MOServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
returnValue = clientProxy.MI_MES_PO_REQ(moParameter);
clientProxy.Dispose();
clientProxy = null;
//Serialize the output Parameter
xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Response.xml",
typeof(DT_MES_PO_RESP), returnValue);
// Update Log
DBDateTime responseDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.ResponseDate = responseDateTime.DBDate;
log.ResponseTime = responseDateTime.DBTime;
log.ResponseContent = xmlFilePath;
transferFacade.UpdateSAPDataTransferLog(log);
}
catch (Exception e)
{
log.Result = "Fail";
log.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, e.Message, log.TransactionCode));
}
#endregion
// Generate MO Object and Save it
if (string.Compare(returnValue.FLAG, "Y", true) == 0)
{
int moCount = returnValue.POLIST.Length;
string moList = "";
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = false;
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection();
this.DataProvider.BeginTransaction();
try
{
MOFacade moFacade = new MOFacade(this.DataProvider);
ItemFacade itemFacade = new ItemFacade(this.DataProvider);
MO mo;
DT_MES_PO_RESPPOLIST moObject;
DBDateTime currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
for (int i = 0; i < moCount; i++)
{
moObject = returnValue.POLIST[i];
moList += moObject.MOCODE + "|";
if (moFacade.GetMO(moObject.MOCODE) != null)
{
continue;
}
mo = moFacade.CreateNewMO();
/*--------------------- Web Service 节点数据 ---------------------*/
mo.MOCode = moObject.MOCODE;
mo.MOType = moObject.MoType;
mo.MOPlanQty = decimal.Parse(moObject.MOPlanQty);
mo.MOPlanStartDate = int.Parse(moObject.MOPlanstart);
mo.MOPlanEndDate = int.Parse(moObject.MOPlanEndDate);
mo.ItemCode = InternalVariables.MatchItemCode(moObject.ItemCode);
mo.OrganizationID = int.Parse(moObject.ORGID);
mo.BOMVersion = moObject.MOBOM;
mo.MOOP = moObject.MOOP;
mo.EAttribute2 = moObject.StorNo;
/*-------------- 固定数据 ----------*/
object material = itemFacade.GetMaterial(mo.ItemCode, int.Parse(moObject.ORGID));
if (material == null)
{
mo.MaterialDescription = "";
}
else
{
mo.MaterialDescription = (material as BenQGuru.eMES.Domain.MOModel.Material).MaterialDescription;
}
mo.MOMemo = "";
mo.MODescription = "";
mo.MOInputQty = 0;
mo.MOScrapQty = 0;
mo.MOActualQty = 0;
mo.MOActualStartDate = 0;
mo.MOActualEndDate = 0;
mo.Factory = mo.OrganizationID.ToString();
mo.OrderSequence = 0;
mo.MOUser = "******";
mo.MODownloadDate = currentDateTime.DBDate;
mo.MOStatus = MOManufactureStatus.MOSTATUS_INITIAL;
mo.MOVersion = "1.0";
mo.IsControlInput = "1";
mo.IsBOMPass = "******";
mo.IDMergeRule = 1;
mo.MaintainUser = "******";
mo.MOReleaseDate = 0;
mo.MOReleaseTime = 0;
mo.MOPendingCause = " ";
mo.MOImportDate = currentDateTime.DBDate;
mo.MOImportTime = currentDateTime.DBTime;
mo.CustomerCode = "";
mo.CustomerName = "";
mo.CustomerOrderNO = "";
mo.CustomerItemCode = "";
mo.OrderNO = "";
mo.EAttribute1 = "";
mo.MOOffQty = 0;
mo.IsCompareSoft = 0;
mo.RMABillCode = "";
mo.MOSeq = 0;
mo.MOPCBAVersion = "";
mo.MOBIOSVersion = "";
moFacade.AddMO(mo);
}
// Call MOBOM Logic in one transaction
if (moList.Trim().Length > 0)
{
moList = moList.Substring(0, moList.Length - 1);
int requestCount = this.GetRequestCount(moList);
MOBOMTransfer moBOMTransfer = new MOBOMTransfer(this.DataProvider);
MOBOMTransferArgument moBOMArgument = new MOBOMTransferArgument(this.DataProvider);
ServiceResult sr;
for (int j = 0; j < requestCount; j++)
{
moBOMArgument.GenerateNewTransactionCode(this.DataProvider);
moBOMArgument.MOCodeList = this.GetMOListPerRequest(moList, j);
moBOMTransfer.SetArguments(moBOMArgument);
sr = moBOMTransfer.Run(RunMethod.Auto);
if (sr.Result == false)
{
throw new Exception(sr.Message);
}
}
}
this.DataProvider.CommitTransaction();
log.Result = "OK";
log.ErrorMessage = "";
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
// Log
log.Result = "Fail";
log.ErrorMessage = ex.Message;
}
finally
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection();
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = true;
}
log.ReceivedRecordCount = moCount;
DBDateTime finishedDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.FinishedDate = finishedDateTime.DBDate;
log.FinishedTime = finishedDateTime.DBTime;
transferFacade.UpdateSAPDataTransferLog(log);
if (log.Result == "OK")
{
return(new ServiceResult(true, "", log.TransactionCode));
}
else
{
return(new ServiceResult(false, log.ErrorMessage, log.TransactionCode));
}
}
else // status!="OK"
{
log.Result = "Fail";
log.ErrorMessage = returnValue.Message;
log.ReceivedRecordCount = 0;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, log.ErrorMessage, log.TransactionCode));
}
}
public ServiceResult Run(RunMethod runMethod)
{
/*---------- Get WebService URL and UserName and Password -------------*/
SAPWebServiceEntity webServiceEntity = System.Configuration.ConfigurationManager.GetSection("StandardBOMTransferConfig") as SAPWebServiceEntity;
if (webServiceEntity == null)
{
return(new ServiceResult(false, "没有维护StandardBOMTransferConfig对应的Service地址", this.m_Argument.TransactionCode));
}
#region Begin for Prepare input Paremente
// Prepare input parameter
DT_MES_MATBOM_REQ standardBOMParameter = new DT_MES_MATBOM_REQ();
standardBOMParameter.Trsactioncode = this.m_Argument.TransactionCode.ToString();
standardBOMParameter.OrgID = this.m_Argument.OrgID.ToString();
if (this.m_Argument.MaterialCode.Trim().Length == 0)
{
standardBOMParameter.MaintainDate_B = this.m_Argument.MaintainDate_B.Date.ToString("yyyyMMdd", new System.Globalization.CultureInfo("en-US"));
standardBOMParameter.MaintainDate_E = this.m_Argument.MaintainDate_E.Date.ToString("yyyyMMdd", new System.Globalization.CultureInfo("en-US"));
standardBOMParameter.MaterialCode = "";
}
else
{
standardBOMParameter.MaintainDate_B = "";
standardBOMParameter.MaintainDate_E = "";
standardBOMParameter.MaterialCode = this.m_Argument.MaterialCode.Trim().ToUpper();
}
#endregion
// Serialize the Input Parameter
string xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_MATBOM_REQ), standardBOMParameter);
#region For Request Log
DBDateTime requestDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
SAPDataTransferLog log = new SAPDataTransferLog();
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
log.JobID = TransferFacade.StandardBOMTransferJobID;
log.TransactionCode = this.m_Argument.TransactionCode;
log.TransactionSequence = 1;
log.RequestDate = requestDateTime.DBDate;
log.RequestTime = requestDateTime.DBTime;
log.RequestContent = xmlFilePath;
log.OrganizationID = this.m_Argument.OrgID;
log.SendRecordCount = 1;
transferFacade.AddSAPDataTransferLog(log);
#endregion
#region Begin for Calling WebService
// Call Web Service through StandardBOMServiceClientProxy
DT_MES_MATBOM_RSP returnValue;
try
{
StandardBOMServiceClientProxy clientProxy = new StandardBOMServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
returnValue = clientProxy.MI_MES_MATBOM(standardBOMParameter);
clientProxy.Dispose();
clientProxy = null;
//Serialize the output Parameter
xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Response.xml",
typeof(DT_MES_MATBOM_RSP), returnValue);
// Update Log
DBDateTime responseDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.ResponseDate = responseDateTime.DBDate;
log.ResponseTime = responseDateTime.DBTime;
log.ResponseContent = xmlFilePath;
transferFacade.UpdateSAPDataTransferLog(log);
}
catch (Exception e)
{
log.Result = "Fail";
log.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, e.Message, log.TransactionCode));
}
#endregion
/*--- 获取Flag字段，如果FLAG字段值是DEL的话，删除该条；FLAG是空，则判断是否有该数据，有则更新，否则插入该条 ----*/
if (string.Compare(returnValue.FLAG, "Y", true) == 0)
{
int sBOMCount = returnValue.ITEM.Length;
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = false;
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection();
this.DataProvider.BeginTransaction();
try
{
SBOMFacade sBOMFacade = new SBOMFacade(this.DataProvider);
SBOM sBOM;
DT_MES_MATBOM_RSPITEM sBOMObject;
bool needAddNew = false;
for (int i = 0; i < sBOMCount; i++)
{
sBOMObject = returnValue.ITEM[i];
if (sBOMObject.ItemCode == null || sBOMObject.ItemCode == string.Empty ||
sBOMObject.SBItemCode == null || sBOMObject.SBItemCode == string.Empty ||
sBOMObject.SBOMVer == null || sBOMObject.SBOMVer == string.Empty ||
sBOMObject.SBItemProject == null || sBOMObject.SBItemProject == string.Empty ||
sBOMObject.SBItemSeq == null || sBOMObject.SBItemSeq == string.Empty)
{
continue;
}
object oldSBOM = sBOMFacade.GetSBOM(InternalVariables.MatchItemCode(sBOMObject.ItemCode).ToUpper(),
InternalVariables.MatchItemCode(sBOMObject.SBItemCode).ToUpper(),
sBOMObject.SBOMVer, sBOMObject.SBItemProject, sBOMObject.SBItemSeq, int.Parse(standardBOMParameter.OrgID));
if (string.Compare(sBOMObject.FLAG, "DEL", true) == 0) //如果FLAG字段值是DEL的，执行删除操作
{
if (oldSBOM != null)
{
sBOMFacade.DeleteSBOM(oldSBOM as SBOM);
}
}
else if (string.Compare(sBOMObject.FLAG, "", true) == 0) //如果FLAG字段值是空，执行Insert/Update tblsbom操作
{
if (oldSBOM == null) //如果为空，则Insert tblsbom
{
sBOM = sBOMFacade.CreateSBOM();
sBOM.SBOMItemEffectiveDate = 20080101;
sBOM.SBOMWH = "";
sBOM.Sequence = sBOMFacade.GetSBOMMaxSequence(sBOM.ItemCode, sBOM.SBOMVersion);
sBOM.SBOMItemECN = "";
sBOM.SBOMItemStatus = "0";
sBOM.SBOMItemLocation = "";
sBOM.SBOMItemEffectiveTime = 1;
sBOM.SBOMItemInvalidDate = 29991231;
sBOM.SBOMItemInvalidTime = 1;
sBOM.SBOMItemVersion = "";
sBOM.SBOMItemControlType = "";
sBOM.SBOMParentItemCode = "";
sBOM.ALPGR = "";
sBOM.MaintainUser = "******";
sBOM.EAttribute1 = "";
needAddNew = true;
}
else
{
sBOM = oldSBOM as SBOM;
needAddNew = false;
}
sBOM.ItemCode = InternalVariables.MatchItemCode(sBOMObject.ItemCode); //tblsbom 的 PK
sBOM.SBOMItemCode = InternalVariables.MatchItemCode(sBOMObject.SBItemCode);
sBOM.SBOMSourceItemCode = InternalVariables.MatchItemCode(sBOMObject.SBItemCode);
sBOM.SBOMItemQty = decimal.Parse(sBOMObject.SBItemQTY);
sBOM.OrganizationID = int.Parse(standardBOMParameter.OrgID);
sBOM.SBOMVersion = sBOMObject.SBOMVer;
//sBOM.SBOMItemName = sBOMObject.SBItemDesc;
//sBOM.SBOMItemDescription = sBOMObject.SBItemDesc;
sBOM.SBOMItemName = "";
sBOM.SBOMItemDescription = "";
sBOM.SBOMItemUOM = sBOMObject.SBItemUOM;
//sBOM.ItemDescription = sBOMObject.ItemDesc;
sBOM.ItemDescription = "";
sBOM.SBOMFactory = sBOMObject.SBFactory;
sBOM.SBOMUsage = sBOMObject.SBUsage;
sBOM.SBOMItemProject = sBOMObject.SBItemProject;
sBOM.SBOMItemSequence = sBOMObject.SBItemSeq;
sBOM.Location = sBOMObject.SBItemPotx1;
if (needAddNew)
{
sBOMFacade.AddSBOM(sBOM);
}
else
{
sBOMFacade.UpdateSBOM(sBOM);
}
}
}
this.DataProvider.CommitTransaction();
log.Result = "OK";
log.ErrorMessage = "";
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
// Log
log.Result = "Fail";
log.ErrorMessage = ex.Message;
}
finally
{
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection();
((BenQGuru.eMES.Common.DomainDataProvider.SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = true;
}
log.ReceivedRecordCount = sBOMCount;
DBDateTime finishedDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.FinishedDate = finishedDateTime.DBDate;
log.FinishedTime = finishedDateTime.DBTime;
transferFacade.UpdateSAPDataTransferLog(log);
if (log.Result == "OK")
{
return(new ServiceResult(true, "", log.TransactionCode));
}
else
{
return(new ServiceResult(false, log.ErrorMessage, log.TransactionCode));
}
}
else //FLAG != "Y"
{
log.Result = "Fail";
log.ErrorMessage = returnValue.message;
log.ReceivedRecordCount = 0;
transferFacade.UpdateSAPDataTransferLog(log);
return(new ServiceResult(false, log.ErrorMessage, log.TransactionCode));
}
}
public void Receive(DNCONFIRM_REQ request)
{
((SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = false;
((SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection();
try
{
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
SAPDataTransferLog log;
DBDateTime currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
string xmlFilePath;
if (request.TransactionCode == null || request.TransactionCode == string.Empty)
{
// New Log
log = transferFacade.CreateNewSAPDataTransferLog();
//log.ErrorMessage
//log.FinishedDate
//log.FinishedTime
log.JobID = TransferFacade.InvertoryJobID;
log.OrganizationID = 2000;
log.ReceivedRecordCount = (request.DNConfirmList == null || request.DNConfirmList.Count == 0) ? 0 : request.DNConfirmList.Count;
log.TransactionCode = TransferFacade.DNConfirmJobID + "_"
+ currentDateTime.DBDate.ToString() + "_"
+ currentDateTime.DBTime.ToString()
+ DateTime.Now.Millisecond.ToString();
log.TransactionSequence = 1;
xmlFilePath = SerializeUtil.SerializeFile(log.TransactionCode + "_Response.xml",
typeof(DNCONFIRM_REQ), request);
log.RequestContent = xmlFilePath;
log.RequestDate = currentDateTime.DBDate;
log.RequestTime = currentDateTime.DBTime;
//log.Result
log.SendRecordCount = 0;
transferFacade.AddSAPDataTransferLog(log);
request.TransactionCode = log.TransactionCode;
}
else
{
// Update log
log = transferFacade.GetSAPDataTransferLog(request.TransactionCode, 1) as SAPDataTransferLog;
//log.ErrorMessage
//log.FinishedDate
//log.FinishedTime
log.ReceivedRecordCount = (request.DNConfirmList == null || request.DNConfirmList.Count == 0) ? 0 : request.DNConfirmList.Count;
xmlFilePath = SerializeUtil.SerializeFile(log.TransactionCode + "_Response.xml",
typeof(DNCONFIRM_REQ), request);
log.ResponseContent = xmlFilePath;
log.ResponseDate = currentDateTime.DBDate;
log.ResponseTime = currentDateTime.DBTime;
//log.Result
transferFacade.UpdateSAPDataTransferLog(log);
}
this.DataProvider.BeginTransaction();
try
{
DeliveryFacade deliveryFacade = new DeliveryFacade(this.DataProvider);
DN2SAP dn2sap;
foreach (MES_DNConfirm dnconfirm in request.DNConfirmList)
{
dn2sap = deliveryFacade.CreateNewDN2SAP();
dn2sap.Active = "Y";
dn2sap.DNCode = dnconfirm.DNNo;
dn2sap.ErrorMessage = dnconfirm.Message;
dn2sap.Flag = dnconfirm.Flag;
dn2sap.MaintainDate = currentDateTime.DBDate;
dn2sap.MaintainTime = currentDateTime.DBTime;
dn2sap.MaintainUser = "******";
deliveryFacade.UpdateDN2SAPStatusByDNNo(dn2sap.DNCode.ToUpper());
deliveryFacade.AddDN2SAP(dn2sap);
if (string.Compare(dnconfirm.Flag, "Y", true) == 0) // Post OK
{
// Update tbldn.flag to SAP
deliveryFacade.UpdateDNFlag(dnconfirm.DNNo, FlagStatus.FlagStatus_SAP);
}
}
this.DataProvider.CommitTransaction();
log.Result = "OK";
log.ErrorMessage = "";
currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.FinishedDate = currentDateTime.DBDate;
log.FinishedTime = currentDateTime.DBTime;
transferFacade.UpdateSAPDataTransferLog(log);
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
log.Result = "Fail";
log.ErrorMessage = ex.Message;
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
((SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection();
((SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = true;
}
}
public ServiceResult Run(RunMethod runMethod)
{
/*====Get WebService URL and UserName and Password====*/
SAPWebServiceEntity webServiceEntity = System.Configuration.ConfigurationManager.GetSection("DNConfirmConfig") as SAPWebServiceEntity;
if (webServiceEntity == null)
{
return(new ServiceResult(false, "没有维护DNConfirm对应的Service地址", this.m_Argument.TransactionCode));
}
DeliveryFacade deliveryFacade = new DeliveryFacade(this.DataProvider);
#region Begin for Prepare input Paremeter
DT_MES_DNPOST_REQ inputParameter = new DT_MES_DNPOST_REQ();
if (runMethod == RunMethod.Auto)
{
this.NewTransactionCode();
this.m_Argument.DNList.Clear();
object[] deliveryNoteList = deliveryFacade.QueryDNNotConfirmed();
if (deliveryNoteList != null)
{
foreach (DeliveryNote deliveryNote in deliveryNoteList)
{
DT_MES_DNPOST post = new DT_MES_DNPOST();
post.VBELN = deliveryNote.DNCode;
post.POSNR = deliveryNote.DNLine;
post.MATNR = deliveryNote.ItemCode;
post.G_LFIMG = deliveryNote.RealQuantity.ToString();
post.LGORT = deliveryNote.SAPStorage;
this.m_Argument.DNList.Add(post);
}
}
}
if (this.m_Argument.DNList == null || this.m_Argument.DNList.Count <= 0)
{
return(new ServiceResult(true, "", this.m_Argument.TransactionCode));
}
inputParameter.TRANS = this.m_Argument.TransactionCode;
inputParameter.DNPARAM = this.m_Argument.DNList.ToArray();
#endregion
string xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_DNPOST_REQ), inputParameter);
#region TransferLog
DBDateTime requestDataTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
SAPDataTransferLog transferLog = new SAPDataTransferLog();
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
transferLog.JobID = TransferFacade.DNConfirmJobID;
transferLog.TransactionCode = this.m_Argument.TransactionCode;
transferLog.TransactionSequence = 1;
transferLog.RequestDate = requestDataTime.DBDate;
transferLog.RequestTime = requestDataTime.DBTime;
transferLog.RequestContent = xmlFilePath;
transferLog.OrganizationID = 2000;
transferLog.SendRecordCount = 1;
transferFacade.AddSAPDataTransferLog(transferLog);
#endregion
#region Begin for Calling WebService
try
{
DNConfirmServiceClientProxy clientProxy = new DNConfirmServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
clientProxy.MI_MES_DNPOST_REQ(inputParameter);
clientProxy.Dispose();
clientProxy = null;
}
catch (Exception e)
{
transferLog.Result = "Fail";
transferLog.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(transferLog);
return(new ServiceResult(false, e.Message, transferLog.TransactionCode));
}
#endregion
#region Update tbldn
try
{
this.DataProvider.BeginTransaction();
foreach (DT_MES_DNPOST post in this.m_Argument.DNList)
{
DeliveryNote deliveryNote = (DeliveryNote)deliveryFacade.GetDeliveryNote(post.VBELN, post.POSNR);
if (deliveryNote != null)
{
deliveryNote.Flag = FlagStatus.FlagStatus_POST;
deliveryNote.TransactionCode = this.m_Argument.TransactionCode;
deliveryFacade.UpdateDeliveryNote(deliveryNote);
}
}
this.DataProvider.CommitTransaction();
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
return(new ServiceResult(false, ex.Message, this.m_Argument.TransactionCode));
}
#endregion
return(new ServiceResult(true, "", this.m_Argument.TransactionCode));
}
public void Receive(INVReceive_REQ request)
{
((SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = false;
((SQLDomainDataProvider)DataProvider).PersistBroker.OpenConnection();
try
{
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
SAPDataTransferLog log;
DBDateTime currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
string xmlFilePath;
if (request.TransactionCode == null || request.TransactionCode == string.Empty)
{
// New Log
log = transferFacade.CreateNewSAPDataTransferLog();
//log.ErrorMessage
//log.FinishedDate
//log.FinishedTime
log.JobID = TransferFacade.InvertoryJobID;
log.OrganizationID = 2000;
log.ReceivedRecordCount = (request.INVList == null || request.INVList.Count == 0) ? 0 : request.INVList.Count;
log.TransactionCode = TransferFacade.InvertoryJobID + "_"
+ currentDateTime.DBDate.ToString() + "_"
+ currentDateTime.DBTime.ToString()
+ DateTime.Now.Millisecond.ToString();
log.TransactionSequence = 1;
xmlFilePath = SerializeUtil.SerializeFile(log.TransactionCode + "_Response.xml",
typeof(INVReceive_REQ), request);
log.RequestContent = xmlFilePath;
log.RequestDate = currentDateTime.DBDate;
log.RequestTime = currentDateTime.DBTime;
//log.Result
log.SendRecordCount = 0;
transferFacade.AddSAPDataTransferLog(log);
request.TransactionCode = log.TransactionCode;
}
else
{
// Update log
log = transferFacade.GetSAPDataTransferLog(request.TransactionCode, 1) as SAPDataTransferLog;
//log.ErrorMessage
//log.FinishedDate
//log.FinishedTime
log.ReceivedRecordCount = (request.INVList == null || request.INVList.Count == 0) ? 0 : request.INVList.Count;
xmlFilePath = SerializeUtil.SerializeFile(log.TransactionCode + "_Response.xml",
typeof(INVReceive_REQ), request);
log.ResponseContent = xmlFilePath;
log.ResponseDate = currentDateTime.DBDate;
log.ResponseTime = currentDateTime.DBTime;
//log.Result
transferFacade.UpdateSAPDataTransferLog(log);
}
if (string.Compare(request.Flag, "Y", true) == 0)
{
if (request.INVList == null || request.INVList.Count == 0)
{
log.Result = "Fail";
log.ErrorMessage = "Inventory list is null.";
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
return;
}
else
{
this.DataProvider.BeginTransaction();
try
{
InventoryFacade inventoryFacade = new InventoryFacade(this.DataProvider);
SAPStorageInfo sapStorageInfo;
foreach (MES_INV inv in request.INVList)
{
sapStorageInfo = inventoryFacade.CreateNewSAPStorageInfo();
sapStorageInfo.ItemCode = inv.ItemCode;
sapStorageInfo.OrgID = inv.OrgID;
sapStorageInfo.StorageID = inv.StorageID;
sapStorageInfo.CINSMQty = inv.CINSMQTY;
sapStorageInfo.CLABSQty = inv.CLABSQTY;
sapStorageInfo.CSPEMQty = inv.CSPEMQTY;
sapStorageInfo.CUMLQty = inv.CUMLQTY;
sapStorageInfo.Division = inv.Division;
//sapStorageInfo.ItemDescription = inv.ItemDescription;
sapStorageInfo.ItemDescription = "";
sapStorageInfo.ItemGrade = inv.ItemGrade;
sapStorageInfo.ModelCode = string.Empty;
sapStorageInfo.StorageName = inv.StorageName;
sapStorageInfo.MaintainDate = currentDateTime.DBDate;
sapStorageInfo.MaintainTime = currentDateTime.DBTime;
sapStorageInfo.MaintainUser = "******";
object oldStorageInfo = inventoryFacade.GetSAPStorageInfo(inv.ItemCode.ToUpper(), inv.OrgID, inv.StorageID.ToUpper(), inv.ItemGrade.ToUpper());
if (oldStorageInfo == null)
{
inventoryFacade.AddSAPStorageInfo(sapStorageInfo);
}
else
{
inventoryFacade.DeleteSAPStorageInfo(oldStorageInfo as SAPStorageInfo);
inventoryFacade.AddSAPStorageInfo(sapStorageInfo);
}
}
object[] queryList = inventoryFacade.QuerySAPStorageQuery(string.Empty, request.TransactionCode);
if (queryList != null)
{
foreach (SAPStorageQuery query in queryList)
{
query.Flag = FlagStatus.FlagStatus_SAP;
inventoryFacade.UpdateSAPStorageQuery(query);
}
}
this.DataProvider.CommitTransaction();
log.Result = "OK";
log.ErrorMessage = "";
currentDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
log.FinishedDate = currentDateTime.DBDate;
log.FinishedTime = currentDateTime.DBTime;
transferFacade.UpdateSAPDataTransferLog(log);
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
log.Result = "Fail";
log.ErrorMessage = ex.Message;
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
}
}
}
else
{
log.Result = "Fail";
log.ErrorMessage = request.Message;
log.FinishedDate = 0;
log.FinishedTime = 0;
transferFacade.UpdateSAPDataTransferLog(log);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
((SQLDomainDataProvider)DataProvider).PersistBroker.CloseConnection();
((SQLDomainDataProvider)DataProvider).PersistBroker.AutoCloseConnection = true;
}
}
public ServiceResult Run(RunMethod runMethod)
{
SAPWebServiceEntity webServiceEntity = System.Configuration.ConfigurationManager.GetSection("InventoryTransferConfig") as SAPWebServiceEntity;
if (webServiceEntity == null)
{
return(new ServiceResult(false, "没有维护InvertoryTransferConfig对应的Service地址", this.m_Argument.TransactionCode));
}
InventoryFacade invFacade = new InventoryFacade(this.DataProvider);
#region Begin for Prepare input Paremeter
DT_MES_MATSTARCE_REQ inventoryParameter = new DT_MES_MATSTARCE_REQ();
object[] sapStorageQueryList = null;
if (runMethod == RunMethod.Auto)
{
sapStorageQueryList = invFacade.QuerySAPStorageQueryNotDealed(1);
if (sapStorageQueryList == null)
{
return(new ServiceResult(true, "", this.m_Argument.TransactionCode));
}
SAPStorageQuery query = (SAPStorageQuery)sapStorageQueryList[0];
inventoryParameter.LGORT = query.StorageID.Split(',');
inventoryParameter.MATNR = query.ItemCode;
inventoryParameter.TRANS = this.m_Argument.TransactionCode;
inventoryParameter.WERKS = query.OrganizationID.Split(',');
}
else if (runMethod == RunMethod.Manually)
{
inventoryParameter.LGORT = this.m_Argument.Location;
inventoryParameter.MATNR = this.m_Argument.MaterialNumber;
inventoryParameter.TRANS = this.m_Argument.TransactionCode;
inventoryParameter.WERKS = this.m_Argument.OrgList;
}
invFacade.DeleteSAPStorageInfo(inventoryParameter.WERKS, inventoryParameter.LGORT, inventoryParameter.MATNR);
#endregion
string xmlFilePath = SerializeUtil.SerializeFile(this.m_Argument.TransactionCode + "_Request.xml",
typeof(DT_MES_MATSTARCE_REQ), inventoryParameter);
#region InventoryLog
DBDateTime dateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
SAPDataTransferLog inventoryLog = new SAPDataTransferLog();
TransferFacade transferFacade = new TransferFacade(this.DataProvider);
inventoryLog.JobID = TransferFacade.InvertoryJobID;
inventoryLog.TransactionCode = inventoryParameter.TRANS;
inventoryLog.TransactionSequence = 1;
inventoryLog.RequestDate = dateTime.DBDate;
inventoryLog.RequestTime = dateTime.DBTime;
inventoryLog.RequestContent = xmlFilePath;
inventoryLog.OrganizationID = 2000;
inventoryLog.SendRecordCount = 1;
transferFacade.AddSAPDataTransferLog(inventoryLog);
#endregion
#region Begin for Calling WebService
try
{
//Delete sapstorageInfo
//invFacade.DeleteSAPStorageInfoByItemCode(this.m_Argument.MaterialNumber.ToUpper());
InvertoryServiceClientProxy clientProxy = new InvertoryServiceClientProxy();
clientProxy.RequestEncoding = Encoding.UTF8;
clientProxy.Timeout = InternalVariables.MS_TimeOut * 1000;
clientProxy.Url = webServiceEntity.Url;
clientProxy.PreAuthenticate = true;
System.Uri uri = new Uri(clientProxy.Url);
clientProxy.Credentials = new NetworkCredential(webServiceEntity.UserName, webServiceEntity.Password).GetCredential(uri, "");
clientProxy.MI_MES_MATSTARCE_REQ(inventoryParameter);
clientProxy.Dispose();
clientProxy = null;
}
catch (Exception e)
{
inventoryLog.Result = "Fail";
inventoryLog.ErrorMessage = e.Message;
transferFacade.UpdateSAPDataTransferLog(inventoryLog);
return(new ServiceResult(false, e.Message, inventoryLog.TransactionCode));
}
if (runMethod == RunMethod.Auto && sapStorageQueryList != null)
{
try
{
SAPStorageQuery query = (SAPStorageQuery)sapStorageQueryList[0];
query.Flag = FlagStatus.FlagStatus_POST;
query.TransactionCode = this.m_Argument.TransactionCode;
invFacade.UpdateSAPStorageQuery(query);
}
catch (Exception ex)
{
return(new ServiceResult(false, ex.Message, this.m_Argument.TransactionCode));
}
}
#endregion
return(new ServiceResult(true, "", this.m_Argument.TransactionCode));
}