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) { } }