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