public RecordTreasury() { InitializeComponent(); this.BackgroundImageLayout = ImageLayout.Stretch; this.Icon = Properties.Resources.merp1_ExR_icon; Varibles.setConnection(); cmd = Varibles.getCommand(); te = new TreasuryEntry(); fillTreasuryEntryTypes(); }
private void collectPaper(int paperID, int SuppID, double amount) { try { TreasuryEntry treasury = new TreasuryEntry(); updatePaper(paperID, 1); Double supplBlnc = getSuppBalance(SuppID); treasury.addToTreasury(0, amount, DateTime.Now, "دفع ورقة دفع", " مدفوعات", 2, SuppID, 0, supplBlnc); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void addSupplierPayables() { double suppBalance = getSuppBalance(suppID); TreasuryEntry tresuereEntry = new TreasuryEntry(); tresuereEntry.addToTreasury(0, paymentAmount, paymentDate, notes, " مدفوعات مورد : " + suppName, TreasuryEntry.TE_OUT, suppID, 0, suppBalance); /* * string query = "INSERT INTO `merp`.`treasuryentries` (`TE_IN`, `TE_DATE`, `TE_OPTITLE`, `TE_CMMTS`, `TE_SPLR_ID`, `TE_OPTYPE_ID`, `TE_BLNCE`) " + * " VALUES ('" + paymentAmount + "', '" + paymentDate + "'," + * " 'مدفوعات عميل : " + suppName + "', '" + notes + "', '" + suppID + "', '1', '" + suppBalance + "')"; * cmd.CommandText = query; * cmd.ExecuteNonQuery(); */ }
public ShowRecPapers() { InitializeComponent(); this.Icon = Properties.Resources.merp1_ExR_icon; this.BackgroundImageLayout = ImageLayout.Stretch; states = new List <ComboboxItem>(); cmb_state.DisplayMember = "Text"; cmb_state.ValueMember = "Value"; states.Add(new ComboboxItem("تحت التحصيل", 0)); states.Add(new ComboboxItem("محصل", 1)); states.Add(new ComboboxItem("مرفوض", 2)); cmb_state.DataSource = states; treasury = new TreasuryEntry(); calcTotal(); }
private void addClientPayables() { double clientBalance = getClientBalance(clientID); TreasuryEntry tresuereEntry = new TreasuryEntry(); tresuereEntry.addToTreasury(paymentAmount, 0, paymentDate, notes, " مدفوعات عميل : " + clientName, TreasuryEntry.TE_IN, 0, clientID, clientBalance); /* * Varibles.setConnection(); * cmd = Varibles.getCommand(); * * string query = "INSERT INTO `merp`.`treasuryentries` (`TE_IN`, `TE_DATE`, `TE_OPTITLE`, `TE_CMMTS`, `TE_CLNT_ID`, `TE_OPTYPE_ID`, `TE_BLNCE`) " + * " VALUES ('" + paymentAmount + "', '" + paymentDate + "'," + * " 'مدفوعات عميل : " + clientName + "', '" + notes + "', '" + clientID + "', '1', '" + clientBalance + "')"; * cmd.CommandText = query; * cmd.ExecuteNonQuery(); * * Varibles.closeConnection(); */ }