Hi Mohit,
Thanks for you reply. I would like to get your pointed out to my code. Please let me know, If you need more Info. Please.
*It takes 20 sec when it running from “Step6-1” to “Step6-2” in middle.
Visual Studio 2019 C#
private bool SetDataTable_TurnAround(string PrinterName, string Template)
{
bool bRet = false;
try
{
var Report = new PageReport(new System.IO.FileInfo(Template));
var Document = new PageDocument(Report);
Document.LocateDataSource += OnLocateDataSource_TurnAround;
Document.Printer.PrinterName = PrinterName;
Document.Print(false, false, false);
bRet = true;
Logger.Logging.Trace("Step6-2");
Logger.Logging.Trace("Step7");
}
catch (Exception e)
{
Logger.Logging.Error(e.Message);
bRet = false;
}
return bRet;
}
void OnLocateDataSource_TurnAround(object sender, LocateDataSourceEventArgs args)
{
args.Data = LoadData_PageReport_TurnAround();
Logger.Logging.Trace("Step6-1");
}
DataTable LoadData_PageReport_TurnAround()
{
Logger.Logging.Trace("Step4");
try
{
using (AzureData PrintingData = new AzureData(Globals.LineGroupId, Globals.PrintId))
{
Logger.Logging.Trace("Step5");
using (SqlDataReader AzureReader = PrintingData.SetReader())
{
TurnAround.Columns.Add("ShipmentAdviceNumber", typeof(int));
TurnAround.Columns.Add("ShipmentAdviceItemNumber", typeof(float));
TurnAround.Columns.Add("AcctNumber", typeof(int));
TurnAround.Columns.Add("OrderNumber", typeof(int));
TurnAround.Columns.Add("BillToAcctName", typeof(string));
TurnAround.Columns.Add("AcctName", typeof(string));
TurnAround.Columns.Add("AcctField2", typeof(string));
TurnAround.Columns.Add("AcctField1", typeof(string));
TurnAround.Columns.Add("QuoteDate", typeof(string));
TurnAround.Columns.Add("PurchaserName", typeof(string));
TurnAround.Columns.Add("PONumber", typeof(string));
TurnAround.Columns.Add("HandlingInstructions", typeof(string));
TurnAround.Columns.Add("Description", typeof(string));
TurnAround.Columns.Add("UPCCd", typeof(string));
TurnAround.Columns.Add("ItemQty", typeof(string));
TurnAround.Columns.Add("PriceUnit", typeof(string));
TurnAround.Columns.Add("PriceTtl", typeof(string));
TurnAround.Columns.Add("RetailPriceUnit", typeof(string));
TurnAround.Columns.Add("RetailPriceTtl", typeof(string));
TurnAround.Columns.Add("PriceTtlSum", typeof(string));
TurnAround.Columns.Add("RetailPriceTtlSum", typeof(string));
TurnAround.Columns.Add("ItemQtySum", typeof(string));
TurnAround.Columns.Add("CarrierService1", typeof(string));
while (AzureReader.Read())
{
DisplayItemQty TargetItemQty = new DisplayItemQty(AzureReader["CstzNumber"].ToString().Trim() );
TargetItemQty.ItemQty = AzureReader["ItemQty"].ToString().Trim();
string ItemQty = TargetItemQty.ConvertValue();
DisplayPriceUnit TargetUnit = new DisplayPriceUnit( AzureReader["DropShipFlag"].ToString().Trim() );
TargetUnit.Price = AzureReader["PriceUnit"].ToString().Trim();
string PriceUnit = TargetUnit.ConvertValue();
TargetUnit.Price = AzureReader["PriceTtl"].ToString().Trim();
string PriceTtl = TargetUnit.ConvertValue();
TargetUnit.Price = (AzureReader["TotalPriceType"].ToString().Trim() == "grand") ? AzureReader["PriceGrandTotal"].ToString().Trim() : AzureReader["PriceSubTotal"].ToString().Trim();
string PriceTtlSum = TargetUnit.ConvertValue();
DisplayPriceRetail TargetRetail = new DisplayPriceRetail( AzureReader["DropShipFlag"].ToString().Trim()
, AzureReader["IsOpenPrice"].ToString().Trim()
);
TargetRetail.Price = AzureReader["RetailPriceUnit"].ToString().Trim();
string RetailPriceUnit = TargetRetail.ConvertValueBlank();
TargetRetail.Price = AzureReader["RetailPriceTtl"].ToString().Trim();
string RetailPriceTtl = TargetRetail.ConvertValueString();
TargetRetail.Price = (AzureReader["TotalPriceType"].ToString().Trim() == "grand") ? AzureReader["RetailPriceGrandTotal"].ToString().Trim() : "99999999";
string RetailPriceTtlSum = TargetRetail.ConvertValueString();
string ItemQtySum = (AzureReader["TotalPriceType"].ToString().Trim() == "grand") ? AzureReader["ItemQtyGrandTotal"].ToString().Trim() : AzureReader["ItemQtySubTotal"].ToString().Trim();
string Description = AzureReader["Product"].ToString().Trim() + " : " + AzureReader["Description"].ToString().Trim() + " " + AzureReader["TagName"].ToString().Trim();
string CarrierService1 = (AzureReader["CarrierService1"].ToString().Trim() == "COD") ? "代引き" : "";
TurnAround.Rows.Add(AzureReader["ShipmentAdviceNumber"].ToString().Trim()
, AzureReader["ShipmentAdviceItemNumber"].ToString().Trim() // <- DB:float, DataTable:float
, AzureReader["AcctNumber"].ToString().Trim()
, AzureReader["OrderNumber"].ToString().Trim()
, AzureReader["BillToAcctName"].ToString().Trim()
, AzureReader["AcctName"].ToString().Trim()
, AzureReader["AcctField2"].ToString().Trim()
, AzureReader["AcctField1"].ToString().Trim()
, AzureReader["QuoteDate"].ToString().Trim()
, AzureReader["PurchaserName"].ToString().Trim()
, AzureReader["PONumber"].ToString().Trim()
, AzureReader["HandlingInstructions"].ToString().Trim()
, Description
, AzureReader["UPCCd"].ToString().Trim()
, ItemQty
, PriceUnit
, PriceTtl
, RetailPriceUnit
, RetailPriceTtl
, PriceTtlSum
, RetailPriceTtlSum
, ItemQtySum
, CarrierService1
);
}
}
}
}
catch (Exception e)
{
Logger.Logging.Error(e.Message);
}
return TurnAround;
}