public void MetaData_AfterLink() { Meta = MetaData.GetMetaData(this); string filter = "(iddbdepartment = " + QueryCreator.quotedstrvalue(Meta.GetSys("userdb"), true) + ")"; GetData.CacheTable(DS.dbaccess, filter, "login", true); }
public void MetaData_AfterGetFormData() { int flagins = 0; if (chkCanInsertFromParentToChild.Checked) { flagins = flagins + 1; } if (chkCanNavigateFromParentToChild.Checked) { flagins = flagins + 2; } if (chkCustomFilterForNavigation.Checked) { flagins = flagins + 4; } if (chkCustomFilterForInsert.Checked) { flagins = flagins + 8; } if (chkCustomDefaults.Checked) { flagins = flagins + 16; } DataRow Curr = HelpForm.GetLastSelected(DS.customdirectrel); string filtro = "(tabellaorigine=" + QueryCreator.quotedstrvalue(Curr["fromtable"], true) + "tabelladest=" + QueryCreator.quotedstrvalue(Curr["totable"], true) + ")"; // DataRow []DelChilds=DS.tipodocoperiva.Select(filtro,null,DataViewRowState.Deleted); }
private string GetMovimentoFilter() { object codicecreddeb = DS.assetunload.Rows[0]["idreg"]; object eserccorrente = Conn.GetSys("esercizio"); string MyFilter = QHS.CmpEq("nphase", codicefase); if (txtEsercizio.Text.Trim() != "") { MyFilter = QHS.AppAnd(MyFilter, QHS.CmpEq("ayear", eserccorrente)); } //MyFilter += "AND (esercizio=" + QueryCreator.quotedstrvalue(txtEsercizio.Text.Trim(), true) + ")"; if (flagcreddeb) { MyFilter = QHS.AppAnd(MyFilter, QHS.CmpEq("idreg", codicecreddeb)); } if (DS.assetunloadincome.Rows.Count > 0) { foreach (DataRow R in DS.assetunloadincome.Rows) { if (R.RowState == DataRowState.Deleted) { continue; } MyFilter += " AND (idinc <> " + QueryCreator.quotedstrvalue(R["idinc"], true) + ")"; } } return(MyFilter); }
private void gridSpesa_DoubleClick(object sender, System.EventArgs e) { DataTable T; DataRow R; bool res = GetCurrentRow(DS, gridSpesa, out T, out R); if (!res) { return; } if (R == null) { return; } MetaData newSpesa = Meta.Dispatcher.Get("spesa"); newSpesa.Edit(this.ParentForm, "gerarchico", false); string idspesa = R["idexp"].ToString(); DataRow R2 = newSpesa.SelectOne(newSpesa.DefaultListType, "(esercizio='" + Meta.Conn.sys["esercizio"].ToString() + "')AND" + "(idspesa=" + QueryCreator.quotedstrvalue(idspesa, true) + ")", "spesa", null); if (R2 != null) { newSpesa.SelectRow(R2, newSpesa.DefaultListType); } }
private void cmbTipoRitenuta_SelectedIndexChanged(object sender, System.EventArgs e) { //if (!Meta.DrawStateIsDone) return; DS.regionalrate.Clear(); DS.regionalratebracket.Clear(); cmbDataInizioStruttura.Items.Clear(); if (!Meta.IsEmpty) { Meta.FreshForm(); Meta.DoMainCommand("mainsetsearch"); } if (txtGeoRegione.Text != "") { if (cmbTipoRitenuta.SelectedItem.ToString() == "") { return; } DataRow [] CodRiten = TipoRitenutaTable.Select("description=" + QueryCreator.quotedstrvalue(cmbTipoRitenuta.SelectedItem, false)); if (CodRiten.Length != 1) { return; } filterritenuta = "(taxcode=" + QueryCreator.quotedstrvalue(CodRiten[0]["taxcode"], true) + ") AND (idregion=" + QueryCreator.quotedstrvalue(lastidregione, true) + ")"; MetaData.SetDefault(DS.regionalrate, "taxcode", CodRiten[0]["taxcode"]); PopolaComboDataInizioStruttura(filterritenuta); if (!Meta.IsEmpty) { DisableToolbar(); } } }
public void MetaData_AfterRowSelect(DataTable T, DataRow rDepartment) { if (rDepartment["!password"] is DBNull) { string userAmmin = (string)Meta.Conn.GetSys("user"); byte[] alfa = mainConn.sha256UserPassword(); string filtroAmmin = "(login="******") and (iddbdepartment=" + QueryCreator.quotedstrvalue(rDepartment["iddbdepartment"], true) + ")"; object o = Meta.Conn.DO_READ_VALUE("dbaccess", filtroAmmin, "alpha1"); if (o != null) { byte[] alfa1 = QueryCreator.StringToByteArray((string)o); byte[] up = xor(alfa, alfa1); try { rDepartment["!password"] = DataAccess.DecryptString(up); } catch (CryptographicException) { } } } btnPassword.Text = (rDepartment["!password"] is DBNull) ? "Inserisci password" : "Modifica password"; }
private object GetInstallDate(DataRow R, string tipoupdate) { try { string filter = "code=" + QueryCreator.quotedstrvalue(R["code"], false); switch (tipoupdate.ToUpper()) { case "S": return(DS.ondemand.Select(filter)[0]["downloaddate"]); case "C": return(DSclient.update.Select(filter)[0]["downloaddate"]); case "M": DateTime objServer = (DateTime)DS.ondemand.Select(filter)[0]["downloaddate"]; DateTime objClient = (DateTime)DSclient.update.Select(filter)[0]["downloaddate"]; if (objServer.CompareTo(objClient) > 0) { return(objServer); } return(objClient); } } catch { } return(DBNull.Value); }
public bool DatiValidi() { int esercizio; try { esercizio = (int)HelpForm.GetObjectFromString(typeof(int), txtEsercizio.Text.ToString(), "x.y.year"); if ((esercizio < 0)) { MessageBox.Show("L'esercizio non può essere negativo"); txtEsercizio.Focus(); return(false); } //return true; } catch { MessageBox.Show("E' necessario inserire un esercizio"); txtEsercizio.Focus(); return(false); } string filteresercizio = "(ayear=" + QueryCreator.quotedstrvalue(esercizio, true) + ")"; DataTable EsercizioTable = DataAccessLocale.RUN_SELECT("accountingyear", "*", null, filteresercizio, null, true); if (EsercizioTable.Rows.Count == 0) { MessageBox.Show("L'esercizio " + esercizio + " non è stato creato."); txtEsercizio.Focus(); return(false); } txtEsercizio.Focus(); return(true); }
bool CollegaUtenteADipartimento(string login, string iddbdepartment) { DataTable Utenti = Conn.RUN_SELECT("dbaccess", "*", null, QHS.AppAnd(QHS.CmpEq("iddbdepartment", iddbdepartment), QHS.CmpEq("login", login)), null, false); if (Utenti != null && Utenti.Rows.Count > 0) { return(true); //già presente } Conn.SQLRunner("exec sp_grantdbaccess " + QueryCreator.quotedstrvalue(login, false) + ", " + QueryCreator.quotedstrvalue(login, false)); Conn.SQLRunner("exec sp_addrolemember N'db_denydatawriter'," + QHS.quote(login)); Conn.SQLRunner("GRANT SELECT ON [dbo].[dbaccess] TO [" + login + "]"); Conn.SQLRunner("GRANT SELECT ON [" + iddbdepartment + "].[customobject] TO [" + login + "]"); Conn.SQLRunner("GRANT SELECT ON [" + iddbdepartment + "].[columntypes] TO [" + login + "]"); string err; Conn.linkUserToDepartment(login, out err); if (err != null && err != "") { MessageBox.Show("Errore associando l'utente " + login + ":" + err + "\r\n"); return(false); } return(true); }
public void MetaData_AfterFill() { if (!Meta.FirstFillForThisRow) { return; } string esercMov = ""; string numMov = ""; string descrFase = ""; if (Meta.edit_type == "detail") { DataRow R = Meta.SourceRow.GetParentRow("incomeproceedspart"); esercMov = R["ymov"].ToString(); if (R.RowState == DataRowState.Added) { numMov = ""; } else { numMov = R["nmov"].ToString(); } object faseObj = Meta.Conn.DO_READ_VALUE("incomephase", QHS.CmpEq("nphase", Meta.GetSys("maxincomephase")), "description"); if (faseObj != null) { descrFase = faseObj.ToString(); } // DataRow fase = R.GetParentRow("incomephaseincome"); // if (fase!=null) descrFase = fase["description"].ToString(); } if (Meta.edit_type == "variazione") { if (DS.proceedspart.Rows.Count == 0) { return; } DataRow Curr = DS.proceedspart.Rows[0]; string filterMov = "(idinc = " + QueryCreator.quotedstrvalue(Curr["idinc"], true) + ")"; DataTable movTable = DataAccess.RUN_SELECT(Meta.Conn, "income", "ymov,nmov,nphase", null, filterMov, null, null, true); if (movTable == null) { return; } esercMov = movTable.Rows[0]["ymov"].ToString(); numMov = movTable.Rows[0]["nmov"].ToString(); object faseObj = Meta.Conn.DO_READ_VALUE("incomephase", QHS.CmpEq("nphase", movTable.Rows[0]["nphase"]), "description"); if (faseObj != null) { descrFase = faseObj.ToString(); } } txtEsercEntrata.Text = esercMov; txtNumEntrata.Text = numMov; if (descrFase != "") { grpAccertamento.Text = descrFase; } }
void FillTree(string tablename) { ClearTree(); Tree.Nodes.Add(tablename); Tree.Nodes[0].Expand(); DataTable RefTables = Conn.SQLRunner( " SELECT object_name(rkeyid) FROM sysreferences "+ " WHERE fkeyid = object_id(" + QueryCreator.quotedstrvalue(tablename, true) + ")" + " AND object_name(rkeyid) != " + QueryCreator.quotedstrvalue(tablename, true)); foreach (DataRow Rtable in RefTables.Rows) { Tree.Nodes.Add(Rtable[0].ToString()); } foreach (TreeNode N in Tree.Nodes) { string currtable = N.Text; dbstructure DBS = Conn.GetStructure(currtable); foreach (DataRow ColDesc in DBS.columntypes.Rows) { N.Nodes.Add(ColDesc["field"].ToString()); } } }
public override void DescribeColumns(DataTable T, string ListingType) { base.DescribeColumns(T, ListingType); if (ListingType.StartsWith("lista")) { string[] splittedlistingtype = ListingType.Split(".".ToCharArray()); string idsorkind = splittedlistingtype[1]; DataTable TipoClass = Conn.RUN_SELECT("sortingkind", "*", null, "(idsorkind=" + QueryCreator.quotedstrvalue(idsorkind, true) + ")", null, true); if (TipoClass.Rows.Count != 1) { return; } foreach (DataColumn C in T.Columns) { DescribeAColumn(T, C.ColumnName, "", -1); } int nPos = 1; DescribeAColumn(T, "codesorkind", "Tipo", nPos++); DescribeAColumn(T, "sortingkind", "Tipo", nPos++); DescribeAColumn(T, "sortcode", "Codice", nPos++); DescribeAColumn(T, "sorting", "Descrizione", nPos++); DescribeAColumn(T, "idsor", "", nPos++); DescribeAColumn(T, "finpart", "Parte Bil.", nPos++); DescribeAColumn(T, "codefin", "Codice Bil.", nPos++); DescribeAColumn(T, "quota", "Quota", nPos++); HelpForm.SetFormatForColumn(T.Columns["quota"], "p"); } }
// Passo 4. private bool riempiAssetUnload() { string testo = "Buono Scarico Inventario"; aggiornaForm(testo); string listaCampi = "A.idassetunloadkind, A.yassetunload, A.nassetunload, " + "TBC.codeassetunloadkind AS '!codeassetunloadkind', " + "A.idmot, M.codemot AS '!codemot', A.doc, A.docdate, A.ratificationdate, A.transmitted, " + "A.description, A.enactment, A.enactmentdate, A.adate, A.printdate, " + "A.txt, A.rtf, I.codeinventory AS 'I.codeinventory'"; if (esportaAnagrafica) { listaCampi += ", A.idreg"; } // Attenzione per i buoni di scarico non viene considerata la data di ratifica string stringaSQL = "SELECT " + listaCampi + " FROM assetunload A" + " LEFT OUTER JOIN assetunloadmotive M " + " ON M.idmot = A.idmot " + " JOIN assetunloadkind TBC ON A.idassetunloadkind = TBC.idassetunloadkind " + " JOIN inventory I ON I.idinventory = TBC.idinventory " + " WHERE (ISNULL(A.transmitted,'N') = 'N') " + " AND (I.idinventoryagency = " + QueryCreator.quotedstrvalue(enteScelto, true) + ")"; return(scriviInTabella(stringaSQL, "assetunload")); }
// Passo 8. private bool riempiAsset() { string testo = "Bene Inventariabile"; aggiornaForm(testo); string listaCampi = "b.idasset, b.idpiece, b.idassetunloadkind AS '!idassetunloadkind', b.lifestart, " + " b.nassetacquire, b.nassetunload, " + " b.ninventory, b.yassetunload, b.flag, b.flagunload, b.transmitted, k.codeassetunloadkind, " + " b.idinventory AS '!idinventory', i.codeinventory AS '!codeinventory', b.idassetunload "; string stringaSQL = "SELECT " + listaCampi + " FROM assetview b " + " LEFT OUTER JOIN assetunloadkind k " + " ON k.idassetunloadkind = b.idassetunloadkind " + " JOIN inventory i " + " ON i.idinventory = b.idinventory " + " WHERE ((b.transmitted = 'N') OR " + " (ISNULL((SELECT au.transmitted FROM assetunload au " + " WHERE au.idassetunload = b.idassetunload),'N') = 'N' " + " AND b.idassetunload IS NOT NULL) OR " + " ((b.transmitted IS NULL) AND " + " (((b.idassetunload IS NOT NULL) OR ((b.idassetunload IS NULL) AND (b.flagunload = 'N'))) " + " OR ((b.idassetload IS NOT NULL) OR (b.idassetload IS NULL AND b.flagload = 'N'))))) " + " AND i.idinventoryagency = " + QueryCreator.quotedstrvalue(enteScelto, true); return(scriviInTabella(stringaSQL, "asset")); }
private void aggiornaDataGrid() { string filtro = ""; DateTime dataContabile = (DateTime)Meta.GetSys("datacontabile"); if (rbArretrati.Checked) { filtro = ".(start < " + QueryCreator.quotedstrvalue(dataContabile.AddMonths(-1), true) + ")"; } if (rbMese.Checked) { filtro = ".(start between (" + QueryCreator.quotedstrvalue(dataContabile.AddMonths(-1), true) + ") and (" + QueryCreator.quotedstrvalue(dataContabile, true) + "))"; } txtCedoliniSelezionati.Text = null; Meta.DoMainCommand("maindosearch.calcolomultiplo" + filtro); string dataMember = dgCedolini.DataMember; CurrencyManager cm = dgCedolini.BindingContext[DS, dataMember] as CurrencyManager; if (cm == null) { return; } for (int i = 0; i < cm.Count; i++) { dgCedolini.UnSelect(i); } new formatgrids(dgCedolini).AutosizeColumnWidth(); }
private void cmbDataInizioStruttura_SelectedIndexChanged(object sender, System.EventArgs e) { Meta.DoMainCommand("mainsetsearch"); if (!Meta.IsEmpty && DS.HasChanges()) { MetaDataDetail.Focus(); return; } if (cmbDataInizioStruttura.SelectedItem.ToString() == "") { cmbDataInizioStruttura.Items.Clear(); cmbTipoRitenuta.SelectedItem = ""; txtGeoRegione.Text = ""; Meta.FreshForm(); DisableToolbar(); return; } filterdatainiziostruttura = "(validitystart=" + QueryCreator.quotedstrvalue(cmbDataInizioStruttura.SelectedItem, true) + ")"; MetaData.SetDefault(DS.regionalrate, "validitystart", Convert.ToDateTime(cmbDataInizioStruttura.SelectedItem)); DS.regionalratebracket.Clear(); string filter = GetData.MergeFilters(filterritenuta, filterdatainiziostruttura); Meta.DoMainCommand("maindosearch.default." + filter); MetaData.SetDefault(DS.regionalrate, "idregion", lastidregione); PopolaComboScaglione(filter); EnableToolbar(); }
public void MetaData_AfterGetFormData() { if (Meta.EditMode) { return; } DataRow CurrentRow = HelpForm.GetLastSelected(DS.regionalrate); int CurrentScaglione = Convert.ToInt16(cmbScaglione.SelectedValue); string filter = "(ratestart=" + QueryCreator.quotedstrvalue( CurrentRow["ratestart"], false) + ") AND (nbracket = " + QueryCreator.quotedstrvalue( CurrentScaglione, false) + ")"; // verifica se lo scaglione è già stato inserito // sulla datainizioaliquota corrente DataRow [] res = DS.regionalrate.Select(filter); if (res.Length == 0) { CurrentRow["nbracket"] = cmbScaglione.SelectedValue; } else { CurrentRow["nbracket"] = 0; } }
/// <summary> /// Funzione che controlla se il comune o la nazione passata non siano validi con rispettiva visualizzazione /// del bottone "Aggiorna Comune", "Aggiorna Stato Estero" /// Il parametro comune_stato può assumere i seguenti valori: C - Comune; S - Stato /// </summary> /// <param name="codice"></param> /// <param name="comune_stato"></param> private void VisualizzaBottoneComune(int codice, string comune_stato) { bool visible = false; // Controllo sul Comune if (comune_stato == "C") { object val = Meta.Conn.DO_READ_VALUE("geo_cityusable", "idcity=" + QueryCreator.quotedstrvalue(codice, true), "idcity"); if (val == null) { btnAggiornaComune.Text = "Aggiorna Comune"; visible = true; } } // Controllo sulla Nazione if (comune_stato == "S") { object val = Meta.Conn.DO_READ_VALUE("geo_nationusable", "idnation=" + QueryCreator.quotedstrvalue(codice, true), "idnation"); if (val == null) { btnAggiornaComune.Text = "Aggiorna Stato estero"; visible = true; } } btnAggiornaComune.Visible = visible; }
public bool DatiValidi() { try { DateTime TT = (DateTime)HelpForm.GetObjectFromString(typeof(DateTime), txtDataContabile.Text.ToString(), "x.y"); } catch { MessageBox.Show("E' necessario inserire una data valida"); txtDataContabile.Focus(); return(false); } DateTime T = (DateTime)HelpForm.GetObjectFromString(typeof(DateTime), txtDataContabile.Text.ToString(), "x.y"); int esercizio = T.Year; string filteresercizio = "(ayear=" + QueryCreator.quotedstrvalue(esercizio, true) + ")"; DataTable EsercizioTable = DataAccessLocale.RUN_SELECT("accountingyear", "*", null, filteresercizio, null, true); if (EsercizioTable.Rows.Count == 0) { MessageBox.Show("L'esercizio " + esercizio + " non è stato creato."); txtDataContabile.Focus(); return(false); } return(true); }
private void GetParamfromDB() { DataRow MR = Session["ExportRow"] as DataRow; if (MR == null) { return; } TitoloExp.Text = MR["Description"].ToString(); DataAccess Conn = GetVars.GetUserConn(this); if (Conn == null) { return; } string filterpar = "(" + "procedurename=" + QueryCreator.quotedstrvalue(MR["procedurename"], true) + ")"; DataTable Params = Conn.RUN_SELECT("exportfunctionparam", "*", "number asc", filterpar, null, true); if (Params == null) { return; } Params.Columns.Add("__WebControlID", typeof(string)); //Dataset di Sessione Session["Paramdata"] = Params; //Crea la tabella per inserire i parametri dell'utente CreatePrimaryTable(Params.Select(null, "number asc")); //Aggiunge la colonna ParamValue che mi servirà per conservare il valore inserito dall'utente //Params.Columns.Add("ParamValue",GetTypeFromUserFormat(Params["userformat"].ToString())); }
private void btnBilancio_Click(object sender, System.EventArgs e) { string filter; int esercizio = (int)Meta.GetSys("esercizio"); string filterpart = (E_S == "E") ? QHS.BitClear("flag", 0) : QHS.BitSet("flag", 0); string filteridfin = QHS.AppAnd(QHS.CmpEq("ayear", esercizio), filterpart); //filter= filter_upb; filter = currfilter_upb; filter = GetData.MergeFilters(filteridfin, filter); //Aggiunge eventualmente il filtro sul disponibile if (chkFilterAvailable.Checked) { decimal currval = importo; filter = GetData.MergeFilters(filter, QHS.CmpGe("availableprevision", currval)); } string filteroperativo = "(idfin in (SELECT idfin from finusable where ayear = '" + esercizio + "'))"; if (chkListManager.Checked) { if (cmbResponsabile.SelectedIndex > 0) { filter = GetData.MergeFilters(filter, QHS.CmpEq("idman", cmbResponsabile.SelectedValue)); } else { filter = GetData.MergeFilters(filter, QHS.IsNull("idman")); } Meta.FilterLocked = true; filter = GetData.MergeFilters(filter, filteroperativo); Selected = Meta.SelectOne("default", filter, "finview", null); riempiTextBox(Selected); return; } if (chkListTitle.Checked) { FrmAskDescr FR = new FrmAskDescr(0); DialogResult D = FR.ShowDialog(this); if (D != DialogResult.OK) { return; } filter = GetData.MergeFilters(filter, "(title like " + QueryCreator.quotedstrvalue( "%" + FR.txtDescrizione.Text + "%", true)) + ")"; Meta.FilterLocked = true; filter = GetData.MergeFilters(filter, filteroperativo); Selected = Meta.SelectOne("default", filter, "finview", null); riempiTextBox(Selected); return; } chiamaFormBilancio(filter); }
void SetCodice() { MetaData Meta = MetaData.GetMetaData(this); if (Meta.EditMode) { return; } btnCodice.Enabled = (cmbTipo.SelectedIndex > 0); txtCodice.ReadOnly = (cmbTipo.SelectedIndex <= 0); if (cmbTipo.SelectedIndex <= 0) { txtCodice.Text = ""; txtDescrizione.Text = ""; } else { string filter = "(idsorkind=" + QueryCreator.quotedstrvalue(cmbTipo.SelectedValue, false) + ")"; btnCodice.Tag = "manage.sorting.tree." + filter; //label per il form di selezione della voce di classificazione +"."+ filtro DS.sorting.ExtendedProperties[MetaData.ExtraParams] = filter; //AutoManage.txtCodiceClass.tree gboxclass.Tag = "AutoManage.txtCodice.tree." + filter; MetaData.GetMetaData(this).SetAutoMode(gboxclass); } }
/// <summary> /// "Si" se il codice presente nella riga si trova nel DataTable, altrimenti "No" /// </summary> /// <param name="T"></param> /// <param name="ToFind"></param> /// <returns></returns> private string IsInstalled(DataRow R, string tipoupdate) { try { string filter = "code=" + QueryCreator.quotedstrvalue(R["code"], false); switch (tipoupdate.ToUpper()) { case "S": if (DS.ondemand.Select(filter).Length == 1) { return("Si"); } return("No"); case "C": if (DSclient.update.Select(filter).Length == 1) { return("Si"); } return("No"); case "M": if ((DS.ondemand.Select(filter).Length == 1) && (DSclient.update.Select(filter).Length == 1)) { return("Si"); } return("No"); } } catch {} return("No"); }
// void EnableToolbar(bool enable) { // Meta.CanInsert=enable; // Meta.CanInsertCopy=enable; // Meta.FreshToolBar(); // this.SendToBack(); // MetaDataToolBar.BringToFront(); // } private void cmbTipoRitenuta_SelectedIndexChanged(object sender, System.EventArgs e) { if (!Meta.DrawStateIsDone) { return; } DS.taxrate.Clear(); DS.ratebracket.Clear(); // Meta.FreshForm(); cmbDataInizioStruttura.Items.Clear(); if (cmbTipoRitenuta.SelectedIndex <= 0) { return; } //if (cmbTipoRitenuta.SelectedItem.ToString()=="") return; object taxcode = cmbTipoRitenuta.SelectedValue; if (taxcode == null) { return; } filterritenuta = "(taxcode=" + QueryCreator.quotedstrvalue(taxcode, true) + ")"; MetaData.SetDefault(DS.taxrate, "taxcode", taxcode); PopolaComboDataInizioStruttura(filterritenuta); if (!Meta.IsEmpty) { DisableToolbar(); } }
override public DataRow Get_New_Row(DataRow ParentRow, DataTable T) { DataTable Levels = T.DataSet.Tables["flowchartlevel"]; if (Levels == null) { return(null); } int level; string codprefix; string ordinestampaprefix; if (ParentRow != null) { level = Convert.ToInt32(ParentRow["nlevel"]) + 1; codprefix = ParentRow["codeflowchart"].ToString(); ordinestampaprefix = ParentRow["printingorder"].ToString(); } else { level = 1; codprefix = ""; ordinestampaprefix = ""; SetDefault(T, "paridflowchart", GetSys("esercizio").ToString().Substring(2, 2)); } if (level > (Levels.Rows.Count - 1)) { MessageBox.Show("Non è possibile inserire un livello inferiore a quello selezionato"); return(null); } string kind = "A"; //corresponding to "flagreset" DataRow[] levrow = Levels.Select("(nlevel=" + QueryCreator.quotedstrvalue(level, false) + ") AND " + "(ayear=" + QueryCreator.quotedstrvalue(esercizio, false) + ")"); if (levrow.Length != 1) { return(null); } SetDefault(T, "nlevel", level); RowChange.MarkAsAutoincrement(T.Columns["idflowchart"], "paridflowchart", null, 4); if (kind.ToLower() == "a") { SetDefault(T, "codeflowchart", codprefix); SetDefault(T, "printingorder", ordinestampaprefix); } DataRow R = base.Get_New_Row(ParentRow, T); if (kind.ToLower() == "a") { RowChange.ClearAutoIncrement(T.Columns["printingorder"]); } return(R); }
/// <summary> /// Filtro da usarsi per diarie /// </summary> /// <param name="Missione"></param> /// <param name="Tappa"></param> /// <returns></returns> public static string GetQualificaClasseFilter(object idposition, object incomeclass) { string codicequalifica = idposition.ToString(); object classe = incomeclass; return("(idposition=" + QueryCreator.quotedstrvalue(codicequalifica, true) + ")" + " AND (" + QueryCreator.quotedstrvalue(classe, true) + " between minincomeclass and maxincomeclass)"); }
private void Esegui() { string filter_auto = ""; DateTime Datainizio, Datafine; int taxkind = 0; foreach (DataRow R in DS.tax.Rows) { taxkind = CfgFn.GetNoNullInt32(R["taxkind"]); switch (taxkind) { case 1: R["!taxcategory"] = "Fiscale"; break; case 2: R["!taxcategory"] = "Assistenziale"; break; case 3: R["!taxcategory"] = "Previdenziale"; break; case 4: R["!taxcategory"] = "Assicurativa"; break; case 5: R["!taxcategory"] = "Arretrati"; break; case 6: R["!taxcategory"] = "Altro"; break; } } foreach (DataRow R in DS.tax.Rows) { filter_auto = "(taxcode = " + QueryCreator.quotedstrvalue(R["taxcode"], false) + ") AND " + filter_eserc; DataTable Ttaxsetup = meta.Conn.RUN_SELECT("taxsetup", "*", null, filter_auto, null, true); DataRow[] Rauto = Ttaxsetup.Select(filter_auto, null); if (Rauto.Length == 0) { continue; } if (!ControllaConfRitenuta(Rauto[0])) { continue; } Datainizio = new DateTime(1, 1, 1); Datafine = new DateTime(1, 1, 1); CalcolaDateDaPeriodo(Rauto[0], out Datainizio, out Datafine); if (!CallStoredProcedure(R["taxcode"], Datainizio, Datafine)) { continue; } else { MessageBox.Show("Ci sono ritenute da pagare", "Informazioni", MessageBoxButtons.OK, MessageBoxIcon.Information); MetaData Metataxpay = MetaData.GetMetaData(this, "taxpay"); Metataxpay.Edit(meta.LinkedForm.ParentForm, "ritenutedapagare", true); return; } } }
private void btnListino_Click(object sender, EventArgs e) { Meta = Disp.Get("listview"); string filter = QHS.DoPar(QHS.AppOr(QHS.IsNull("validitystop"), QHS.CmpGe("validitystop", Meta.GetSys("datacontabile")))); MetaData Mlistino = Disp.Get("listview"); Mlistino.FilterLocked = true; Mlistino.DS = new DataSet(); int nFilter = 0; //Filtro sulla classificazione merceologica if (chkFilterClass.Checked) { nFilter = 1; } //Filtro sulla descrizione if (chkListDescription.Checked) { nFilter = nFilter + 2; } if (nFilter > 0) { FrmAskDescr FR = new FrmAskDescr(Meta.Dispatcher, nFilter); DialogResult D = FR.ShowDialog(this); if (D != DialogResult.OK) { return; } if (FR.Selected != null) { object idlistclass = FR.Selected["idlistclass"]; filter = GetData.MergeFilters(filter, "(idlistclass = " + QueryCreator.quotedstrvalue(FR.Selected["idlistclass"], true) + ")"); } filter = GetData.MergeFilters(filter, "(description like " + QueryCreator.quotedstrvalue("%" + FR.txtDescrizione.Text + "%", true) + ")"); } DataRow Choosen = Mlistino.SelectOne("default", filter, "listview", null); if (Choosen == null) { return; } riempiOggetti(Choosen); return; }
/// <summary> /// Resituisce True se il codice aggiornamento esiste nel Datatable che /// rappresenta l'indice client o server /// </summary> private bool RowExists(DataTable T, object codice) { if (T == null) { return(false); } string filter = "code=" + QueryCreator.quotedstrvalue(codice, false); return(T.Select(filter).Length > 0); }
string CalcolaCheckBackup2(DataRow R) { string S = "2" + QueryCreator.quotedstrvalue(R["iddb"], true) + QueryCreator.quotedstrvalue(R["serverbackup2"].ToString().ToUpper(), true) + QueryCreator.quotedstrvalue(R["dbname"], true) + QueryCreator.quotedstrvalue(R["swmoreflag"], true) + QueryCreator.quotedstrvalue(R["swmorecode"], true); string Check = CheckFlags.GetCheck(S); return(Check); }