public static string Money2Arabic(decimal amount, int dollarDirham)
{
var dollarType = dollarDirham == 1 ? new CurrencyInfo(CurrencyInfo.Currencies.Dollar) : new CurrencyInfo(CurrencyInfo.Currencies.UAE);
var toWord = new ToWord(amount, dollarType);
return(toWord.ConvertToArabic());
}
private void PurchRec_Load(object sender, EventArgs e)
{
CopInf = ReportObj.LisSelectCompanyInfo();
reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("CompanyInfo", CopInf));
Logo = CopInf.Rows[0][8].ToString();
SupplierTabl = ReportObj.SupplierData(Supplier_Mobile);
reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("Supplier", SupplierTabl));
PurchTable = ReportObj.SellectPurch(purchID);
reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("PurchTable", PurchTable));
Total = 0;
Reming = 0;
Paiud = 0;
Total = decimal.Parse(PurchTable.Rows[0][4].ToString());
Paiud = decimal.Parse(PurchTable.Rows[0][2].ToString());
Reming = decimal.Parse(PurchTable.Rows[0][3].ToString());
//
PurchDetail = ReportObj.PurchDeatiles(purchID);
reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("PurchDetails", PurchDetail));
try
{
currencies.Add(new CurrencyInfo(CurrencyInfo.Currencies.Syria));
TotalWord = new ToWord(Total, currencies[Convert.ToInt32(0)]);
if (Reming < 0)
{
ReminWord = new ToWord(Reming * -1, currencies[Convert.ToInt32(0)]);
}
else
{
ReminWord = new ToWord(Reming, currencies[Convert.ToInt32(0)]);
}
PaiudWord = new ToWord(Paiud, currencies[Convert.ToInt32(0)]);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
reportViewer1.LocalReport.DisplayName = "فاتورة شراء رقم " + purchID;
reportViewer1.LocalReport.ReportEmbeddedResource = "ITI_Project.Reports.Purch.PurchReceipt.rdlc";
ReportParameter p = new ReportParameter("Total", TotalWord.ConvertToArabic());
ReportParameter p2 = new ReportParameter("Remin", ReminWord.ConvertToArabic());
ReportParameter p3 = new ReportParameter("Paid", PaiudWord.ConvertToArabic());
reportViewer1.LocalReport.EnableExternalImages = true;
ReportParameter P4 = new ReportParameter("Logo", Logo);
this.reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p, p2, p3, P4 });
this.reportViewer1.RefreshReport();
reportViewer1.Refresh();
}
//生成word表格
public void ToWord(CourseBuild model, string mm, string pe)
{
int key = 3;
dal.GetControl(model); //传值
dt = dal.dtShow(key); //得到记录;
dt.Rows[0][10] = mm;
dt.Rows[0][11] = pe;
ToWord toword = new ToWord();
toword.CourseTable1(dt, "申请表", "申请表");
}
private void معاينةToolStripMenuItem_Click(object sender, EventArgs e)
{
ToWord word = new ToWord(Convert.ToDecimal(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[8].Value.Equals(DBNull.Value) ? "0" : dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[8].Value), new CurrencyInfo(CurrencyInfo.Currencies.Kilo));
ReportParameterCollection reportParameter = new ReportParameterCollection();
reportParameter.Add(new ReportParameter("toArabic", word.ConvertToArabic()));
reportParameter.Add(new ReportParameter("User", Properties.Settings.Default.username));
Report report = new Report(Convert.ToInt16(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[0].Value)), reportParameter);
report.Show();
Hide();
}
private void amountTextEdit_EditValueChanged(object sender, EventArgs e)
{
if (amountTextEdit.Text != "")
{
ToWord toWord = new ToWord(Convert.ToDecimal(amountTextEdit.Text), new CurrencyInfo());
txt_amount_ar_word.Text = toWord.ConvertToArabic();
txt_amount_En_word.Text = toWord.ConvertToEnglish();
}
else
{
txt_amount_ar_word.Text = "";
txt_amount_En_word.Text = "";
}
}
private void BuildReport_Click(object sender, EventArgs e)
{
try
{
ToWord.Convert(report); // создаём word
label.ForeColor = Color.Green;
label.Text = "Успешно создано и помещено в Документы :)";
}
catch
{
label.ForeColor = Color.Red;
label.Text = "Произошла ошибка. Возможные прчиины:\n-Не найден файл template.docx\n-Нужно разрешить редактирвоанеи в файле template.docx";
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
Save();
ToWord word = new ToWord(Convert.ToDecimal(finalWieght()), new CurrencyInfo(CurrencyInfo.Currencies.Kilo));
ReportParameterCollection reportParameter = new ReportParameterCollection();
reportParameter.Add(new ReportParameter("toArabic", word.ConvertToArabic()));
reportParameter.Add(new ReportParameter("User", Properties.Settings.Default.username));
Report report = new Report(Convert.ToInt32(lblCode.Text), reportParameter);
report.Show();
Hide();
}
private void print(DataGridView dataGridView1)
{
ToWord word = new ToWord(Convert.ToDecimal(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[8].Value.Equals(DBNull.Value) ? "0" : dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[8].Value), new CurrencyInfo(CurrencyInfo.Currencies.Kilo));
ReportParameterCollection reportParameter = new ReportParameterCollection();
reportParameter.Add(new ReportParameter("toArabic", word.ConvertToArabic()));
reportParameter.Add(new ReportParameter("User", Properties.Settings.Default.username));
LocalReport localReport = new LocalReport();
localReport.ReportPath = Application.StartupPath + "\\Report1.rdlc";
Data_Access data_Access = new Data_Access(Convert.ToInt16(Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[0].Value)));
ReportDataSource rds = new ReportDataSource("Wieghts", data_Access.getReportData());
localReport.DataSources.Clear();
localReport.DataSources.Add(rds);
localReport.SetParameters(reportParameter);
localReport.PrintToPrinter();
}
private void btnPrint_Click(object sender, EventArgs e)
{
ToWord word = new ToWord(Convert.ToDecimal(finalWieght()), new CurrencyInfo(CurrencyInfo.Currencies.Kilo));
ReportParameterCollection reportParameter = new ReportParameterCollection();
reportParameter.Add(new ReportParameter("toArabic", word.ConvertToArabic()));
reportParameter.Add(new ReportParameter("User", Properties.Settings.Default.username));
LocalReport localReport = new LocalReport();
localReport.ReportPath = Application.StartupPath + "\\Report1.rdlc";
Data_Access data_Access = new Data_Access(Convert.ToInt32(lblCode.Text));
ReportDataSource rds = new ReportDataSource("Wieghts", data_Access.getReportData());
localReport.DataSources.Clear();
localReport.DataSources.Add(rds);
localReport.SetParameters(reportParameter);
localReport.PrintToPrinter();
}
private void CustomEntry_TextChanged(object sender, TextChangedEventArgs e)
{
if (e.NewTextValue != "")
{
ToWord toWord2 = new ToWord(Convert.ToDecimal(e.NewTextValue), new CurrencyInfo(Currencies.SaudiArabia));
switch (Helpers.Settings.LastUserGravity)
{
case "Arabic":
NumbertoTextlbl.Text = toWord2.ConvertToArabic();
break;
case "English":
NumbertoTextlbl.Text = toWord2.ConvertToEnglish();
break;
}
}
else
{
NumbertoTextlbl.Text = AppResources.ZeroText;
}
}
private void PrintMethod()
{
Mouse.OverrideCursor = Cursors.Wait;
DS ds = new DS();
ds.Sale.Rows.Clear();
int i = 0;
foreach (var item in _saleCategories)
{
ds.Sale.Rows.Add();
ds.Sale[i]["ID"] = ID;
ds.Sale[i]["Date"] = _selectedSale.Date;
ds.Sale[i]["Client"] = _selectedSale.Client.Name;
ds.Sale[i]["Serial"] = i + 1;
ds.Sale[i]["Category"] = item.Category + " " + item.Company;
ds.Sale[i]["Qty"] = item.Qty;
ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.PriceAfterDiscount), 2);
ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.PriceTotalAfterDiscount), 2);
ds.Sale[i]["BillPrice"] = _selectedSale.PriceAfterDiscount;
ds.Sale[i]["OldDebt"] = Math.Abs(Convert.ToDecimal(_selectedSale.OldDebt));
ds.Sale[i]["TransportCost"] = _selectedSale.TransportCost;
ds.Sale[i]["BillTotal"] = Math.Abs(Convert.ToDecimal(_selectedSale.PriceTotal));
ds.Sale[i]["Paid"] = _selectedSale.Paid;
ds.Sale[i]["NewDebt"] = Math.Abs(Convert.ToDecimal(_selectedSale.NewDebt));
if (_selectedSale.NewDebt > 0)
{
ds.Sale[i]["Type"] = "له";
}
else if (_selectedSale.NewDebt < 0)
{
ds.Sale[i]["Type"] = "عليه";
}
ds.Sale[i]["Salesperson"] = _selectedSale.Salesperson.Name;
ds.Sale[i]["PrintingMan"] = _selectedSale.PrintingMan;
if (_selectedSale.OldDebt > 0)
{
ds.Sale[i]["Type2"] = "له";
}
else if (_selectedSale.OldDebt < 0)
{
ds.Sale[i]["Type2"] = "عليه";
}
ds.Sale[i]["Address"] = _selectedSale.Client.Address;
try
{
ToWord toWord = new ToWord(Math.Abs(Convert.ToDecimal(_selectedSale.NewDebt)), currencies[0]);
ds.Sale[i]["NewDebtAR"] = toWord.ConvertToArabic();
}
catch
{
ds.Sale[i]["NewDebtAR"] = string.Empty;
}
i++;
}
ReportWindow rpt = new ReportWindow();
SaleReport saleRPT = new SaleReport();
saleRPT.SetDataSource(ds.Tables["Sale"]);
rpt.crv.ViewerCore.ReportSource = saleRPT;
Mouse.OverrideCursor = null;
_currentWindow.Hide();
rpt.ShowDialog();
_currentWindow.ShowDialog();
//var dialog = new PrintDialog();
//dialog.PrintVisual(_currentWindow, "ss");
//bool? print = dialog.ShowDialog();
//if (print.HasValue && print.Value)
//{
// string startupPath = Environment.CurrentDirectory;
// printorderRPT.Load(startupPath + @"\..\..\PrintingOrderPaperRpt.rpt");
// printorderRPT.SetDataSource(ds.Tables["PrintOrder"]);
// printorderRPT.Subreports[0].SetDataSource(ds.Tables["PrintOrderRaws"]);
// printorderRPT.PrintOptions.PrinterName = dialog.PrintQueue.Name;
// try
// {
// printorderRPT.PrintToPrinter(1, true, 0, 0);
// }
// catch { }
//}
}
private void ExecuteSave()
{
Mouse.OverrideCursor = Cursors.Wait;
DateTime _dt = DateTime.Now;
_newSale.RegistrationDate = _dt;
_saleServ.AddSale(_newSale);
int _saleID = _saleServ.GetLastSaleID();
foreach (var item in _saleCategories)
{
SaleCategory _saleCategory = new SaleCategory
{
CategoryID = item.CategoryID,
Cost = item.Cost,
PriceAfterDiscount = item.PriceAfterDiscount,
PriceTotalAfterDiscount = item.PriceTotalAfterDiscount,
CostTotal = item.CostTotal,
Price = item.Price,
PriceTotal = item.PriceTotal,
Discount = item.Discount,
DiscountValue = item.DiscountValue,
DiscountValueTotal = item.DiscountValueTotal,
SaleID = _saleID,
Qty = item.Qty
};
_saleCategoryServ.AddSaleCategory(_saleCategory);
Category cat = _categoryServ.GetCategory(item.CategoryID);
cat.Qty = cat.Qty - item.Qty;
_categoryServ.UpdateCategory(cat);
}
ClientAccount _account = new ClientAccount
{
ClientID = _newSale.ClientID,
Date = _newSale.Date,
RegistrationDate = _dt,
Statement = "فاتورة مبيعات رقم " + _saleID,
Credit = _newSale.Paid,
Debit = _newSale.PriceAfterDiscount + _newSale.TransportCost
};
_clientAccountServ.AddAccount(_account);
if (_newSale.Paid > 0)
{
Safe _safe = new Safe
{
Date = _newSale.Date,
RegistrationDate = _dt,
Statement = "فاتورة مبيعات رقم " + _saleID + " للعميل: " + _selectedClient.Name,
Amount = _newSale.Paid,
Source = 4
};
_safeServ.AddSafe(_safe);
}
DS ds = new DS();
ds.Sale.Rows.Clear();
int i = 0;
foreach (var item in _saleCategories)
{
ds.Sale.Rows.Add();
ds.Sale[i]["ID"] = _saleID;
ds.Sale[i]["Date"] = _newSale.Date;
ds.Sale[i]["Client"] = _selectedClient.Name;
ds.Sale[i]["Serial"] = i + 1;
ds.Sale[i]["Category"] = item.Category + " " + item.Company;
ds.Sale[i]["Qty"] = item.Qty;
ds.Sale[i]["Price"] = Math.Round(Convert.ToDecimal(item.PriceAfterDiscount), 2);
ds.Sale[i]["TotalPrice"] = Math.Round(Convert.ToDecimal(item.PriceTotalAfterDiscount), 2);
ds.Sale[i]["BillPrice"] = Math.Round(Convert.ToDecimal(_newSale.PriceAfterDiscount), 2);;
ds.Sale[i]["OldDebt"] = Math.Abs(Convert.ToDecimal(_newSale.OldDebt));
ds.Sale[i]["TransportCost"] = _newSale.TransportCost;
ds.Sale[i]["BillTotal"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.PriceTotal), 2));
ds.Sale[i]["Paid"] = _newSale.Paid;
ds.Sale[i]["NewDebt"] = Math.Abs(Math.Round(Convert.ToDecimal(_newSale.NewDebt), 2));
if (_newSale.NewDebt > 0)
{
ds.Sale[i]["Type"] = "له";
}
else if (_newSale.NewDebt < 0)
{
ds.Sale[i]["Type"] = "عليه";
}
ds.Sale[i]["Salesperson"] = _selectedSalesperson.Name;
ds.Sale[i]["PrintingMan"] = _newSale.PrintingMan;
if (_newSale.OldDebt > 0)
{
ds.Sale[i]["Type2"] = "له";
}
else if (_newSale.OldDebt < 0)
{
ds.Sale[i]["Type2"] = "عليه";
}
ds.Sale[i]["Address"] = _selectedClient.Address;
try
{
ToWord toWord = new ToWord(Math.Abs(Convert.ToDecimal(_newSale.NewDebt)), currencies[0]);
ds.Sale[i]["NewDebtAR"] = toWord.ConvertToArabic();
}
catch
{
ds.Sale[i]["NewDebtAR"] = string.Empty;
}
i++;
}
ReportWindow rpt = new ReportWindow();
SaleReport saleRPT = new SaleReport();
saleRPT.SetDataSource(ds.Tables["Sale"]);
rpt.crv.ViewerCore.ReportSource = saleRPT;
Mouse.OverrideCursor = null;
_currentWindow.Hide();
rpt.ShowDialog();
NewSale = new Sale();
NewSaleCategory = new SaleCategoryVM();
SaleCategories = new ObservableCollection <SaleCategoryVM>();
NewSale.Date = DateTime.Now;
OldPrices = new ObservableCollection <SaleCategory>();
_currentWindow.ShowDialog();
}
private void AmountDesc_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
ToWord toWord = new ToWord(Convert.ToDecimal(Amount.Value), new CurrencyInfo());
AmountAr.Text = toWord.ConvertToArabic();
}
