public void fofo()
{
try
{
//--------
List <string> ListSt1 = new List <string>();
List <string> ListSt2 = new List <string>();
List <string> ListSt3 = new List <string>();
var accc = new Assest.OrcDataAcess();
DataTable DT = new DataTable();
accc.Show_(DT);
try
{
foreach (DataRow DR in DT.Rows)
{
ListSt1.Add(DR.Field <string>("NAME"));
ListSt2.Add(DR.Field <string>("BARCODE"));
ListSt3.Add(DR.Field <string>("PRICE"));
}
}
catch (Exception ex) { DXMessageBox.Show(ex.Message, "خطأ", MessageBoxButton.OK, MessageBoxImage.Error); }
}
catch (Exception ex) { }
}
public string SumPrice()
{
var list = new List <string>();
DataTable data = new DataTable();
var irc = new Assest.OrcDataAcess();
irc.Show_(data);
Int64 Sumpricee = 0;
foreach (DataRow r in data.Rows)
{
Sumpricee += r.Field <Int64>("PRICE");
}
return(Sumpricee.ToString("N0") + " ر.س");
}
public Printer()
{
InitializeComponent();
try {
var Fdelete = new Assest.OrcDataAcess();
var bind = new System.Windows.Forms.BindingSource();
var datatablea = new DataTable();
Fdelete.Show_(datatablea);
var listat = new List <string>();
foreach (DataRow r in datatablea.Rows)
{
listat.Add(r.Field <string>("PRICE"));
}
for (int i = 0; i < listat.Count; i++)
{
Fdelete._Delete(int.Parse(listat[i]));
}
Barcode.Focus();
}catch (Exception ex) { }
}
public void PPP()
{
try
{
int Update = 0;
DataTable H10 = new DataTable();
DataTable H11 = new DataTable();
var FA = new Assest.OrcDataAcess();
FA.Show(H11);
FA.Show_(H10);
JSum = H10.Compute("Sum(PRICE)", "");
//listStrings5.Clear();
foreach (DataRow DR in H10.Rows)
{
listStrings5.Add(DR.Field <string>("BARCODE"));
}
bool eleno = false;
for (int i = 0; i < listStrings.Count; i++)
{
if (listStrings[i] == listStrings[i] || listStrings[i] == listStrings[i] + "\n")
{
eleno = true;
}
}
if (eleno == true)
{
for (int j = 0; j < 1; j++)
{
if (Quan_li < 1)
{
DXMessageBox.Show(string.Format("لم يتم العثور على اي نتائج", Name.Text), "خطأ", MessageBoxButton.OK, MessageBoxImage.Error);
GID.Add(int.Parse(id_li));
Exists = 0;
}
else
{
if (Exists == 1)
{
Add();
var oracleClassAdd = new Assest.OrcDataAcess();
oracleClassAdd._Add(Name.Text, price.Text, Barcode.Text);
A_qua = j;
Update = Quan_li - 1;//تنقيص من الكمية الموجودة بالمخزن
FA.Updating_QUa(Update.ToString(), id_li);
foreach (string s in Price_Report)
{
price_p += int.Parse(s);
}
var mainwindow = new MainWindow();
mainwindow.button7_Copy1d_Click(null, null);
}
else
{
}
}
//FA.Updating_QUa(Update.ToString(), liststring4[j]);
}
}
}
catch (Exception ex) { }
}
