public string GetOrangePineReportDataByContainer(int packingListID, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
OrangePiePrintoutDataObject ds = new OrangePiePrintoutDataObject();
try
{
SqlDataAdapter adap = new SqlDataAdapter();
adap.SelectCommand = new SqlCommand("PackingListMng_function_GetOrangePiePrintout", new SqlConnection(DALBase.Helper.GetSQLConnectionString()));
adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
adap.SelectCommand.Parameters.AddWithValue("@PackingListID", packingListID);
adap.TableMappings.Add("Table", "OrangePie_PackingList");
adap.TableMappings.Add("Table1", "OrangePie_Container");
adap.TableMappings.Add("Table2", "OrangePie_Goods");
adap.TableMappings.Add("Table3", "OrangePie_GoodsDescription");
adap.Fill(ds);
string ClientOrderNos = "";
string CustomerOrderNos = "";
foreach (var item in ds.OrangePie_Goods)
{
if (!string.IsNullOrEmpty(item.ProformaInvoiceNo) && !ClientOrderNos.Contains(item.ProformaInvoiceNo))
{
ClientOrderNos += item.ProformaInvoiceNo + ", ";
}
if (!string.IsNullOrEmpty(item.ClientOrderNumber) && !CustomerOrderNos.Contains(item.ClientOrderNumber))
{
CustomerOrderNos += item.ClientOrderNumber + ", ";
}
}
ds.OrangePie_PackingList.FirstOrDefault().ClientOrderNos = ClientOrderNos;
ds.OrangePie_PackingList.FirstOrDefault().CustomerOrderNos = CustomerOrderNos;
return(Library.Helper.CreateReportFileWithEPPlus2(ds, "PackingList_OrangePine_ByContainer"));
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
return(string.Empty);
}
}
public string GetOrangePiePrintout(int packingListID, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
OrangePiePrintoutDataObject ds = new OrangePiePrintoutDataObject();
try
{
SqlDataAdapter adap = new SqlDataAdapter();
adap.SelectCommand = new SqlCommand("PackingListMng_function_GetOrangePiePrintout", new SqlConnection(DALBase.Helper.GetSQLConnectionString()));
adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
adap.SelectCommand.Parameters.AddWithValue("@PackingListID", packingListID);
adap.TableMappings.Add("Table", "OrangePie_PackingList");
adap.TableMappings.Add("Table1", "OrangePie_Container");
adap.TableMappings.Add("Table2", "OrangePie_Goods");
adap.TableMappings.Add("Table3", "OrangePie_GoodsDescription");
adap.Fill(ds);
string ClientOrderNos = "";
string CustomerOrderNos = "";
foreach (var item in ds.OrangePie_Goods)
{
if (!string.IsNullOrEmpty(item.ProformaInvoiceNo) && !ClientOrderNos.Contains(item.ProformaInvoiceNo))
{
ClientOrderNos += item.ProformaInvoiceNo + ", ";
}
if (!string.IsNullOrEmpty(item.ClientOrderNumber) && !CustomerOrderNos.Contains(item.ClientOrderNumber))
{
CustomerOrderNos += item.ClientOrderNumber + ", ";
}
}
ds.OrangePie_PackingList.FirstOrDefault().ClientOrderNos = ClientOrderNos;
ds.OrangePie_PackingList.FirstOrDefault().CustomerOrderNos = CustomerOrderNos;
OrangePiePrintoutDataObject.PackingListRow drPackingList = ds.PackingList.NewPackingListRow();
OrangePiePrintoutDataObject.OrangePie_PackingListRow drOrigin = ds.OrangePie_PackingList.FirstOrDefault();
drPackingList.SupplierNM = drOrigin.IsSupplierNMNull() ? "" : drOrigin.SupplierNM;
drPackingList.Address = drOrigin.IsAddressNull() ? "" : drOrigin.Address;
drPackingList.ConsigneeInfo = drOrigin.IsConsigneeInfoNull() ? "" : drOrigin.ConsigneeInfo;
drPackingList.NotifyParty = drOrigin.IsNotifyPartyNull() ? "" : drOrigin.NotifyParty;
drPackingList.PackingListUD = drOrigin.IsPackingListUDNull() ? "" : drOrigin.PackingListUD;
drPackingList.PackingListDate = drOrigin.IsPackingListDateNull() ? "" : drOrigin.PackingListDate;
drPackingList.ClientOrderNos = drOrigin.IsClientOrderNosNull() ? "" : drOrigin.ClientOrderNos;
drPackingList.CustomerOrderNos = drOrigin.IsCustomerOrderNosNull() ? "" : drOrigin.CustomerOrderNos;
drPackingList.ForwarderNM = drOrigin.IsForwarderNMNull() ? "" : drOrigin.ForwarderNM;
drPackingList.ShipedDate = drOrigin.IsShipedDateNull() ? "" : drOrigin.ShipedDate;
drPackingList.POLName = drOrigin.IsPOLNameNull() ? "" : drOrigin.POLName;
drPackingList.PODName = drOrigin.IsPODNameNull() ? "" : drOrigin.PODName;
drPackingList.Vessel = drOrigin.IsVesselNull() ? "" : drOrigin.Vessel;
drPackingList.BLNo = drOrigin.IsBLNoNull() ? "" : drOrigin.BLNo;
drPackingList.TotalQuantityShipped = drOrigin.IsTotalQuantityShippedNull() ? 0 : drOrigin.TotalQuantityShipped;
drPackingList.TotalPKGs = drOrigin.IsTotalPKGsNull() ? 0 : drOrigin.TotalPKGs;
drPackingList.TotalNettWeight = drOrigin.IsTotalNettWeightNull() ? 0 : drOrigin.TotalNettWeight;
drPackingList.TotalKGs = drOrigin.IsTotalPKGsNull() ? 0 : drOrigin.TotalKGs;
drPackingList.TotalCBMs = drOrigin.IsTotalCBMsNull() ? 0 : drOrigin.TotalCBMs;
drPackingList.FSCCode = drOrigin.IsFSCCodeNull() ? "" : drOrigin.FSCCode;
ds.PackingList.AddPackingListRow(drPackingList);
//parse detail data
OrangePiePrintoutDataObject.PackingListDetailRow drPackingListDetail;
foreach (var container in ds.OrangePie_Container)
{
drPackingListDetail = ds.PackingListDetail.NewPackingListDetailRow();
drPackingListDetail.Description = "1x" + (container.IsContainerTypeNMNull() ? "" : container.ContainerTypeNM) + " CONTAINER / CONT.NO: " + (container.IsContainerNoNull() ? "" : container.ContainerNo) + " / SEAL NO: " + (container.IsSealNoNull() ? "" : container.SealNo);
ds.PackingListDetail.AddPackingListDetailRow(drPackingListDetail);
foreach (var product in ds.OrangePie_Goods.Where(o => o.ContainerNo == container.ContainerNo))
{
drPackingListDetail = ds.PackingListDetail.NewPackingListDetailRow();
drPackingListDetail.ArticleCode = product.IsArticleCodeNull() ? "" : product.ArticleCode;
drPackingListDetail.Description = product.IsDescriptionNull() ? "" : product.Description;
drPackingListDetail.QuantityShipped = product.IsQuantityShippedNull() ? 0 : product.QuantityShipped;
drPackingListDetail.PKGs = product.IsPKGsNull() ? 0 : product.PKGs;
drPackingListDetail.NettWeight = product.IsNettWeightNull() ? 0 : product.NettWeight;
drPackingListDetail.KGs = product.IsKGsNull() ? 0 : product.KGs;
drPackingListDetail.CBMs = product.IsCBMsNull() ? 0 : product.CBMs;
ds.PackingListDetail.AddPackingListDetailRow(drPackingListDetail);
}
}
//generate schema
//DALBase.Helper.DevCreateReportXMLSource(ds, "PackingList");
// generate xml file
string reportFile = DALBase.Helper.CreateReportFiles(ds, "PackingList_OrangePine");
return(reportFile = reportFile + ".xlsm");
//return Library.Helper.CreateReportFileWithEPPlus2(ds, "PackingList_OrangePine");
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
return(string.Empty);
}
}
