public void MetaData_AfterLink() { Meta = MetaData.GetMetaData(this, "registry"); QHC = new CQueryHelper(); QHS = Meta.Conn.GetQueryHelper(); QueryCreator.SetTableForPosting(DS.registrymainview, "registry"); }
public Frm_proceeds_default() { InitializeComponent(); CanGoInsert = true; InChiusura = false; QueryCreator.SetTableForPosting(DS.incomelastview, "incomelast"); QueryCreator.SetTableForPosting(DS.proceeds_bankview, "proceeds_bank"); }
public Frm_cabview_lista_anag() { InitializeComponent(); QueryCreator.SetTableForPosting(DS.cabview, "cab"); QueryCreator.SetColumnNameForPosting(DS.cabview.Columns["city"], ""); QueryCreator.SetColumnNameForPosting(DS.cabview.Columns["country"], ""); HelpForm.SetDenyNull(DS.cabview.Columns["flagusable"], true); }
public Frm_payment_default() { InitializeComponent(); CanGoInsert = true; InChiusura = false; QueryCreator.SetTableForPosting(DS.expenselastview, "expenselast"); QueryCreator.SetTableForPosting(DS.payment_bankview, "payment_bank"); }
public FrmAssetUnload_generauto() { InitializeComponent(); GetData.SetSorting(DS.incomeview, "ymov DESC,nmov DESC"); QueryCreator.SetTableForPosting(DS.assetpieceview, "asset"); TempTable = new DataTable("temptable"); cboTipo.DataSource = DS.assetunloadkindview; cboTipo.DisplayMember = "description"; cboTipo.ValueMember = "idassetunloadkind"; }
public void MetaData_AfterLink() { MetaRegistry = MetaData.GetMetaData(this, "registry"); conn = this.getInstance<IDataAccess>(); metaNoTable = this.getInstance<IMetaData>(); ctrl = this.getInstance<IFormController>(); QHC = new CQueryHelper(); QHS = conn.GetQueryHelper(); rdoCF.Checked = true; QueryCreator.SetTableForPosting(DS.registrymainview, "registry"); GetData.CacheTable(DS.registryclass, QHS.CmpEq("active", "S"), "idregistryclass", true); metaNoTable.searchEnabled = false; }
public Frm_mainivapay_default() { InitializeComponent(); GetData.SetSorting(DS.mainivapay, "ymainivapay DESC"); DataAccess.SetTableForReading(DS.dettliquidazioneivaview_debito, "mainivapaydetailview"); QueryCreator.SetTableForPosting(DS.dettliquidazioneivaview_debito, "mainivapaydetail"); QueryCreator.SetTableForPosting(DS.mainivapaydetailview, "mainivapaydetail"); QueryCreator.SetTableForPosting(DS.mainivapayincomeview, "mainivapayincome"); QueryCreator.SetTableForPosting(DS.mainivapayexpenseview, "mainivapayexpense"); GetData.CacheTable(DS.incomephase); GetData.CacheTable(DS.expensephase); }
public void MetaData_AfterLink() { Meta = MetaData.GetMetaData(this); QHC = new CQueryHelper(); QHS = Meta.Conn.GetQueryHelper(); esercizio = Convert.ToInt32(Meta.GetSys("esercizio")); DataAccess.RUN_SELECT_INTO_TABLE(Meta.Conn, DS.incomephase, null, null, null, true); codicefase = CfgFn.GetNoNullInt32(Meta.GetSys("maxincomephase")); GetData.LockRead(DS.incomeview); GetData.DenyClear(DS.incomeview); GetData.LockRead(DS.proceedspart); FillEntrataView(); QueryCreator.SetTableForPosting(DS.incomeview, "income"); HelpForm.SetAllowMultiSelection(DS.incomeview, true); Meta.CanCancel = false; Meta.CanInsert = false; Meta.CanInsertCopy = false; Meta.CanSave = false; Meta.SearchEnabled = false; }
public void MetaData_AfterLink() { Meta = MetaData.GetMetaData(this); QHC = new CQueryHelper(); QHS = Meta.Conn.GetQueryHelper(); esercizio = Convert.ToInt32(Meta.GetSys("esercizio")); codicefase = Convert.ToInt32(Meta.GetSys("incomefinphase")); GetData.LockRead(DS.incomeview); GetData.DenyClear(DS.incomeview); GetData.LockRead(DS.creditpart); FillEntrataView(); QueryCreator.SetTableForPosting(DS.incomeview, "income"); HelpForm.SetAllowMultiSelection(DS.incomeview, true); Meta.CanCancel = false; Meta.CanInsert = false; Meta.CanInsertCopy = false; Meta.CanSave = false; Meta.SearchEnabled = false; }
bool Do_Delete() { pBar.Visible = true; this.Cursor = Cursors.WaitCursor; foreach (DataTable T in DS.Tables) { if ((T.TableName == "registrymainview") || (T.TableName == "no_table")) { continue; } T.Clear(); } string dataMember = dgAnagrafica.DataMember; CurrencyManager cm = dgAnagrafica.BindingContext[DS, dataMember] as CurrencyManager; if (cm == null) { return(false); } DataView view = cm.List as DataView; if (view == null) { MessageBox.Show(this, "Selezionare almeno una anagrafica"); return(true); } int Nselected = 0; int max = view.Count - 1; for (int i = 0; i <= max; i++) { if (dgAnagrafica.IsSelected(i)) { Nselected++; } } pBar.Maximum = Nselected; pBar.Value = 0; string filter = ""; //int j = 0; for (int i = 0; i <= max; i++) { if (!dgAnagrafica.IsSelected(i)) { continue; } DataSet D = DS.Clone(); QueryCreator.SetTableForPosting(D.Tables["registrymainview"], "registry"); pBar.Increment(1); filter = QHS.CmpEq("idreg", view[i]["idreg"]); foreach (string tname in new string[] { "registrymainview", "registryaddress", "registrycf", "registrylegalstatus", "registrypaymethod", "registrypiva", "registryreference", "registrytaxablestatus" }) { DataAccess.RUN_SELECT_INTO_TABLE(Meta.Conn, D.Tables[tname], null, filter, null, false); foreach (DataRow RD in D.Tables[tname].Rows) { RD.Delete(); } } PostData P = Meta.Get_PostData(); P.InitClass(D, Meta.Conn); if (!P.DO_POST()) { Aggiorna(); pBar.Visible = false; return(false); } } Aggiorna(); this.Cursor = Cursors.Default; pBar.Visible = false; return(true); }