protected override void Print()
{
var ds = new Zek.DataModel.DS_CardPointTransfer();
DataSetHelper.AddEmptyRow(ds.T_CardPointTransfer);
var cardID = CardManager.GetCardID(FromCardNumber);
var card = CardManager.GetCard(cardID);
var holder = PersonManager.GetPerson(card[0].PersonID);
ds.T_CardPointTransfer[0].Company = GlobalVariable.MyCompanyName;
ds.T_CardPointTransfer[0].CardNumber = FromCardNumber;
ds.T_CardPointTransfer[0].CardHolder = holder[0].FullName;
ds.T_CardPointTransfer[0].Address = holder[0].Address;
ds.T_CardPointTransfer[0].PersonalNumber = holder[0].PersonalNumber;
ds.T_CardPointTransfer[0].Phone = holder[0].Phone + " " + holder[0].Mobile;
Zek.Report.ReportHelper.Show(MdiParent, Text, Reports.ReportName.CardPointTransfer, ds);
}
private void miExportApex(object sender, ItemClickEventArgs e)
{
var dlg = new SaveFileDialog()
{
Filter = "Xml Files|*.xml|All Files|*.*"
};
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
try
{
Application.DoEvents();
Cursor = Cursors.WaitCursor;
var usdRate = DictionaryManager.GetCurrencyRate("USD", BaseGlobalVariable.ServerDateTime);
//var rate = CurrencyRate != 0 ? CurrencyRate : 1m;
var dsExport = new DS_Neopharmi();
foreach (var row in ds.VW_ProductLocation)
{
if (DataSetHelper.IsDataRowDeleted(row))
{
continue;
}
var newrow = (DS_Neopharmi.T_NeopharmiRow)DataSetHelper.AddEmptyRow(dsExport.T_Neopharmi);
newrow.productsid = row.ProductID.ToString();
newrow.products_n = StringHelper.Trim(GeoConvertHelper.Convert(row.MedicamentName, GeoConvertHelper.UnicodeGeo, GeoConvertHelper.StandardGeo), 100);
newrow.producer_n = StringHelper.Trim(GeoConvertHelper.Convert(row.BrandName, GeoConvertHelper.UnicodeGeo, GeoConvertHelper.StandardGeo), 40);
newrow.country_n = StringHelper.Trim(GeoConvertHelper.Convert(row.CountryName, GeoConvertHelper.UnicodeGeo, GeoConvertHelper.StandardGeo), 20);
newrow.icount = row.Quantity;
newrow.priceg = row.ListPrice * row.ProductCurrencyRate;
newrow.priceu = newrow.priceg / usdRate;
newrow.svg = row.Quantity * newrow.priceg;
newrow.svu = row.Quantity * newrow.priceu;
newrow.discount = row.DiscountPct * 100m;
newrow.vg = newrow.icount * (row.UnitPrice * row.PurchaseCurrencyRate);
newrow.vu = newrow.icount * ((row.UnitPrice * row.PurchaseCurrencyRate) / usdRate);
if (!row.IsValidDateNull())
{
newrow.lifedate = row.ValidDate;
}
}
dsExport.Namespace = " ";
dsExport.DataSetName = "VFPData";
dsExport.T_Neopharmi.TableName = "row";
DataSetHelper.SetColumnMappingType(dsExport);
dsExport.WriteXml(dlg.FileName, XmlWriteMode.WriteSchema);
}
catch (Exception ex)
{
ExceptionHelper.Show(ex);
}
finally
{
Cursor = Cursors.Default;
}
}
