public void MetaData_AfterGetFormData() { if (Meta.EditMode) { return; } DataRow CurrentRow = HelpForm.GetLastSelected(DS.regionalrateforcity); 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.regionalrateforcity.Select(filter); if (res.Length == 0) { CurrentRow["nbracket"] = cmbScaglione.SelectedValue; } else { CurrentRow["nbracket"] = 0; } }
private void btnSituazione_Click(object sender, System.EventArgs e) { int esercizio; string codicefondops; DataAccess Conn = Meta.Conn; try { DataRow MyRow = HelpForm.GetLastSelected(DS.pettycash); codicefondops = MyRow["idpettycash"].ToString(); } catch { return; } esercizio = Convert.ToInt16(Meta.GetSys("esercizio")); DataSet Out = Conn.CallSP("show_pettycash", new Object[3] { Meta.GetSys("datacontabile"), esercizio, codicefondops } ); if (Out == null) { return; } Out.Tables[0].TableName = "Situazione fondo economale"; frmSituazioneViewer View = new frmSituazioneViewer(Out); View.Show(); }
public void MetaData_AfterFill() { if (!Meta.CanInsert) { Meta.CanInsert = true; Meta.FreshToolBar(); } //abilita/disabilita i controlli bool ModoInsert = Meta.InsertMode; cmbLivello.Enabled = false; if (ModoInsert) { DataRow R = HelpForm.GetLastSelected(DS.flowchart); if (R == null) { return; } txtCodice.ReadOnly = false; txtOrdineStampa.ReadOnly = false; if (Operativo(R)) { EnableControls(true); } else { EnableControls(false); } } Meta.MarkTableAsNotEntityChild(DS.flowchartuser); Meta.MarkTableAsNotEntityChild(DS.flowchartusersorting); }
private void btnControlli_Click(object sender, System.EventArgs e) { if (Meta.IsEmpty) { return; } DataRow Curr = HelpForm.GetLastSelected(DS.auditcheck); if (Curr == null) { return; } if (!Meta.GetFormData(true)) { return; } frmSqlEditor F = new frmSqlEditor(Conn, Curr["sqlcmd"].ToString(), Curr["tablename"].ToString()); if (F.ShowDialog() == DialogResult.OK) { Curr["sqlcmd"] = F.SQLstatement; txtSql.Text = F.SQLstatement; } //RecalcCheck(); }
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); }
void RicalcolaEnforcementID(object sender, System.EventArgs e) { if (Meta == null) { return; } if (!Meta.DrawStateIsDone) { return; } if (!Meta.InsertMode) { return; } Meta.GetFormData(true); DataRow Curr = HelpForm.GetLastSelected(DS.auditcheck); if (Curr == null) { return; } if (Curr.RowState != DataRowState.Added) { MessageBox.Show("ERRORE!"); return; } int maxexistent = MetaData.MaxFromColumn(DS.auditcheck, "idcheck"); Curr["idcheck"] = maxexistent + 1; }
public void MetaData_AfterFill() { if (!Meta.CanInsert) { Meta.CanInsert = true; Meta.FreshToolBar(); } bool ModoInsert = Meta.InsertMode; grpParte.Enabled = false; cmbLivello.Enabled = false; if (ModoInsert) { DataRow R = HelpForm.GetLastSelected(DS.placcount); txtCodice.ReadOnly = false; txtOrdineStampa.ReadOnly = false; if (R == null) { return; } } if (!Meta.IsEmpty && Meta.EditMode) { txtCodice.ReadOnly = true; txtOrdineStampa.ReadOnly = true; } }
public void MetaData_AfterFill() { if (!Meta.CanInsert) { Meta.CanInsert = true; Meta.FreshToolBar(); } //abilita/disabilita i controlli bool ModoInsert = Meta.InsertMode; cmbLivello.Enabled = false; if (ModoInsert) { DataRow R = HelpForm.GetLastSelected(DS.location); if (R == null) { return; } string livello = R["nlevel"].ToString(); txtCodice.ReadOnly = TipoNumerico(livello); if (Operativo(R)) { txtResponsabile.ReadOnly = false; } else { txtResponsabile.ReadOnly = true; } } }
public void MetaData_AfterGetFormData() { CQueryHelper QHC = new CQueryHelper(); DataRow CurrentRow = HelpForm.GetLastSelected(DS.report); if (Meta.InsertMode) { if (CurrentRow["modulename"].ToString().ToLower() != cmbModuli.SelectedItem.ToString().ToLower()) { CurrentRow["modulename"] = cmbModuli.SelectedItem; } } if (CurrentRow["groupname"].ToString().ToLower() != cmbGroupName.SelectedItem.ToString().ToLower()) { CurrentRow["groupname"] = cmbGroupName.SelectedItem; } if (Meta.InsertMode) { string filtro = QHC.CmpNe("reportname", CurrentRow["reportname"]); foreach (DataRow r in DS.reportparameter.Select(filtro)) { r["reportname"] = CurrentRow["reportname"]; //r.AcceptChanges(); } } }
public void MetaData_AfterFill() { DataRow lastRow = HelpForm.GetLastSelected(DS.sortinglevel); int flag = CfgFn.GetNoNullInt32(lastRow["flag"]); txtLungCodice.Text = (flag >> 8).ToString(); }
public void MetaData_AfterFill() { DataRow lsr = HelpForm.GetLastSelected(DS.cabview); //Meta.myHelpForm.LastSelectedRow; object idcomune = lsr["idcity"]; VisualizzaBottoneComune(idcomune); // abilita disabilita il combo Moduli //cmbBanca.Enabled = ! Meta.InsertMode; object idbank = lsr["idbank"]; /* Al fine di utilizzare il TextBanca per la ricerca: * è stato cambiato il tag al text "...?cabview.bank", * previo aggiunta campo bank alla vista. E'stato implementato il metodo MySetComboBoxValue() * alla stregua del metodo della libreria, perchè si verificava un errore sul cast da * 'System.String' a 'System.Data.DataRowView. * Si verificava un altro problema:se scrivo %sicilia% e poi effettua Ricerca lui fa una ricerca su * cabview col like'%sicilia%' quindi mi fa vedere nel grid tutte le filiali la cui banca è * like %sicilia%, quindi se scorro l'elenco delle filiali del grid nel combo/text della banca * vedrò : BANCO DI SICILIA SPA, CREDITO SICILIANO S.P.A., * questa cosa è errata perchè io mi aspetto di vedere nel grid SOLO le filiali di * BANCO DI SICILIA SPA, se nel combo/text leggo BANCO DI SICILIA SPA. * Invece,nel Grid vedo le fliali di entrambe poi, dopo aver selezionato la filiale il combo / tex mi * dice la banca. * Avedno riscontrato la presenta di tanti problemi si è deciso di rendere il text Banca ReadOnly. */ //IndexChangePilotato = true; //MySetComboBoxValue(cmbBanca, idbank); //IndexChangePilotato = false; }
void FreshLogo() { //Meta = MetaData.GetMetaData(this); //pictureBox1.Image=(byte[])(DS.logo[0]["logo"]); DataRow Curr = HelpForm.GetLastSelected(DS.logo); if (Curr == null) { return; } try { if (Curr["logo"] != DBNull.Value) { MemoryStream MS = new MemoryStream((byte[])Curr["logo"]); Image IM = new Bitmap(MS, false); pbox.Image = IM; } else { pbox.Image = null; } } catch { pbox.Image = null; } }
public void getPorzioneClassificata(out long sommaNum, out long sommaDen) { sommaDen = 1; sommaNum = 1; DataRow R = HelpForm.GetLastSelected(DS.tipoclassmovimenti_dest); object codiceTipoClassChild = R["idsorkind"]; string filtro = QHC.CmpEq("!sortingkindchild", codiceTipoClassChild); foreach (DataRow r in DS.sortingtranslation.Select(filtro)) { if ((r["numerator"] != DBNull.Value) && (r["denominator"] != DBNull.Value)) { long numeratore = (int)r["numerator"]; long denominatore = (int)r["denominator"]; sommaNum = sommaNum * denominatore - sommaDen * numeratore; sommaDen *= denominatore; long mcd = massimoComuneDivisore(sommaNum, sommaDen); if (mcd == 0) { return; } sommaNum /= mcd; sommaDen /= mcd; } } if (sommaDen < 0) { sommaNum = -sommaNum; sommaDen = -sommaDen; } }
public void MetaData_AfterFill() { DataRow Curr = HelpForm.GetLastSelected(DS.customdirectrel); if (Curr == null) { return; } int flagval = (int)DS.customdirectrel.Rows[0]["flag"]; if ((flagval & 1) == 1) { chkCanInsertFromParentToChild.Checked = true; } if ((flagval & 2) == 2) { chkCanNavigateFromParentToChild.Checked = true; } if ((flagval & 4) == 4) { chkCustomFilterForNavigation.Checked = true; } if ((flagval & 8) == 8) { chkCustomFilterForInsert.Checked = true; } if ((flagval & 16) == 16) { chkCustomDefaults.Checked = true; } }
public void MetaData_AfterFill() { DataRow CurrSorKind = HelpForm.GetLastSelected(DS.tipoclassmovimenti_dest); if (CurrSorKind != null) { string f = QHC.CmpEq("!sortingkindchild", CurrSorKind["idsorkind"]); DS.sortingtranslation.ExtendedProperties["CustomParentRelation"] = f; } bool ModoInsert = Meta.InsertMode; txtCodice.ReadOnly = true; cmbLivello.Enabled = false; DataRow R = HelpForm.GetLastSelected(DS.sorting); if (R == null) { return; } object livello = R["nlevel"]; if (ModoInsert) { txtCodice.ReadOnly = TipoNumerico(livello); } }
private void btnCopyAll_Click(object sender, EventArgs e) { MetaData Meta = MetaData.GetMetaData(this); if (Meta.IsEmpty) { return; } Meta.SaveFormData(); if (DS.HasChanges()) { return; } DataRow R = HelpForm.GetLastSelected(DS.ivaregisterkind); if (MessageBox.Show("Copiare tutte le informazioni del tipo registro di codice " + R["codeivaregisterkind"].ToString() + " su tutti i dipartimenti?", "Attenzione", MessageBoxButtons.YesNo) != DialogResult.Yes) { return; } Meta.Conn.CallSP("copyrow_ivaregisterkind", new object[1] { R["idivaregisterkind"] }); }
public void MetaData_AfterGetFormData() { if (Meta.EditMode) { return; } DataRow CurrentRow = HelpForm.GetLastSelected(DS.taxrate); // 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.taxrate.Select(filter); // if (res.Length==0){ try { CurrentRow["nbracket"] = cmbScaglione.SelectedValue; } catch { CurrentRow["nbracket"] = 0; } // } // else{ // CurrentRow["nbracket"]=0; // } }
public void MetaData_AfterGetFormData() { DataRow lastRow = HelpForm.GetLastSelected(DS.sortinglevel); int codelen = CfgFn.GetNoNullInt32(HelpForm.GetObjectFromString(typeof(int), txtLungCodice.Text, "x.y")); int flag = CfgFn.GetNoNullInt32(lastRow["flag"]); lastRow["flag"] = flag & 0xff | (codelen << 8); }
public void MetaData_BeforeFill() { DataRow R = HelpForm.GetLastSelected(DS.checkup); if (R != null) { R["listerrors"] = QueryCreator.GetPrintable(R["listerrors"].ToString()); R["checkerrors"] = QueryCreator.GetPrintable(R["checkerrors"].ToString()); R["corrige"] = QueryCreator.GetPrintable(R["corrige"].ToString()); } }
public void MetaData_AfterFill() { AbilitaDisabilitaControlliCombo(); AbilitaDisabilitaRadioBtnAltro(); CheckControlliCustom(); //riempie i combo senza tag DataRow R = HelpForm.GetLastSelected(DS.reportparameter); cmbTipo.SelectedValue = R["systype"]; }
public void MetaData_BeforeRowSelect(DataTable T, DataRow R) { if (T.TableName == "tipoclassmovimenti_dest") { DataRow CurrSorKind = HelpForm.GetLastSelected(DS.tipoclassmovimenti_dest); if (CurrSorKind != null) { string f = QHC.CmpEq("!sortingkindchild", CurrSorKind["idsorkind"]); DS.sortingtranslation.ExtendedProperties["CustomParentRelation"] = f; } } }
void SalvaAllegato(string certification) { // Legge il file indicato dall'utente e lo scrive nel DB in 'durccertification' o in 'selfcertification' if (Meta.IsEmpty) { return; } if (!Meta.GetFormData(true)) { return; } DialogResult dialogResult = opendlg.ShowDialog(this); if (dialogResult == DialogResult.Cancel) { return; } DataRow Curr = HelpForm.GetLastSelected(DS.registrydurc); if (Curr == null) { return; } FileStream FS = new FileStream(opendlg.FileName, FileMode.Open, FileAccess.Read); string estensione = Path.GetExtension(FS.Name); if (FS == null) { return; } int n = (int)FS.Length; if (n == 0) { return; } int namelen = LengthForFileName(opendlg.FileName); try { byte[] ByteArray = new byte[n + namelen]; FS.Read(ByteArray, namelen, n); if (FS.Length == 0) { Curr[certification] = DBNull.Value; } FS.Close(); SetBytesForFileName(opendlg.FileName, ByteArray); Curr[certification] = ByteArray; } catch { } AbilitaDisabilitaAllegati(); }
private void btnPassword_Click(object sender, System.EventArgs e) { DataRow rDep = HelpForm.GetLastSelected(DS.dbdepartment); string idDbDepartment = (string)rDep["iddbdepartment"]; FrmPassword frmPassword = new FrmPassword(mainConn, idDbDepartment); DialogResult dr = frmPassword.ShowDialog(this); if (dr == DialogResult.OK) { DataRow rDepartment = HelpForm.GetLastSelected(DS.dbdepartment); rDepartment["!password"] = frmPassword.txtPassword.Text; } }
public void MetaData_AfterGetFormData() { string filtro1 = ""; foreach (object LVIO in listViewLog.Items) { ListViewItem LVI = (ListViewItem)LVIO; DataRow P2Row = (DataRow)LVI.Tag; DataRow P1Row = HelpForm.GetLastSelected(DS.journaltablesetup); if (P1Row == null) { return; } filtro1 = "(tablename=" + QueryCreator.quotedstrvalue(P1Row["tablename"].ToString(), false) + ")" + " AND (opkind=" + QueryCreator.quotedstrvalue(P1Row["opkind"].ToString(), false) + ")" + " AND (dbfield=" + QueryCreator.quotedstrvalue(P2Row["field"].ToString(), false) + ")"; DataRow [] CurrChilds = DS.journalfieldsetup.Select(filtro1, null, DataViewRowState.CurrentRows); DataRow [] DelChilds = DS.journalfieldsetup.Select(filtro1, null, DataViewRowState.Deleted); if ((LVI.Checked) && (CurrChilds.Length == 0)) { DataRow newMid; if (DelChilds.Length > 0) { DelChilds[0].RejectChanges(); newMid = DelChilds[0]; } else { newMid = DS.journalfieldsetup.NewRow(); } newMid["tablename"] = P1Row["tablename"]; newMid["opkind"] = P1Row["opkind"]; newMid["dbfield"] = P2Row["field"]; if (DelChilds.Length == 0) { DS.journalfieldsetup.Rows.Add(newMid); } } if ((!LVI.Checked) && (CurrChilds.Length > 0)) { CurrChilds[0].Delete(); } } }
void SalvaLogo() { if (Meta.IsEmpty) { return; } if (!Meta.GetFormData(true)) { return; } DialogResult dialogResult = opendlg.ShowDialog(this); if (dialogResult == DialogResult.Cancel) { return; } DataRow Curr = HelpForm.GetLastSelected(DS.logo); if (Curr == null) { return; } //txtNomeFile.Text = openFileDialog1.FileName; FileStream FS = new FileStream(opendlg.FileName, FileMode.Open, FileAccess.Read); if (FS == null) { return; } int n = (int)FS.Length; if (n == 0) { return; } try { byte[] ByteArray = new byte[n]; FS.Read(ByteArray, 0, n); if (FS.Length == 0) { Curr["logo"] = DBNull.Value; } FS.Close(); Curr["logo"] = ByteArray; } catch {} FreshLogo(); // pictureBox1.Image = Image.FromFile(openFileDialog1.FileName); }
public void MetaData_BeforePost() { ExBusinessRule = null; DataRow Curr = HelpForm.GetLastSelected(DS.audit); if (Curr == null) { return; } string filter = "(idaudit=" + QueryCreator.quotedstrvalue( Curr["idaudit"], true) + ")"; ExBusinessRule = Meta.Conn.SQLRunner("SELECT DISTINCT tablename,opkind FROM auditcheck WHERE " + filter); }
// private string getNuovoAlfa1(string passwordDipart) { // byte[] alfa = mainConn.sha256UserPassword(); // byte[] g1 = DataAccess.CryptString(passwordDipart.PadRight(31)); // byte[] alfa1 = xor(alfa, g1); // return QueryCreator.ByteArrayToString(alfa1); // } public void MetaData_BeforePost() { DataRow rDepartment = HelpForm.GetLastSelected(DS.dbdepartment); if (rDepartment == null) { return; } string passwordDipart = rDepartment["!password"] as string; textBox1.Text = passwordDipart; string userAmmin = (string)Meta.Conn.GetSys("user"); MetaData metaDBAccess = MetaData.GetMetaData(this, "dbaccess"); MetaData metaDBUser = MetaData.GetMetaData(this, "dbuser"); UTF8Encoding encoding = new UTF8Encoding(); string filtroUtente = "(login="******")"; DataTable tUtenti = DataAccess.RUN_SELECT(mainConn, "dbuser", null, null, filtroUtente, null, null, true); DataRow[] rUtenti = tUtenti.Select(filtroUtente); if (rUtenti.Length == 0) { MetaData.SetDefault(DS.dbuser, "login", userAmmin); metaDBUser.Get_New_Row(null, DS.dbuser); } string filtroAccesso = filtroUtente + " and (iddbdepartment=" + QueryCreator.quotedstrvalue(rDepartment["iddbdepartment"], true) + ")"; DataAccess.RUN_SELECT_INTO_TABLE(mainConn, DS.dbaccess, null, filtroAccesso, null, true); MetaData.SetDefault(DS.dbaccess, "login", userAmmin); string iddbdepartment = (string)rDepartment["iddbdepartment"]; string errore; byte[] g1 = mainConn.getDepartmentPassword(iddbdepartment, out errore); if (g1 == null) { metaDBAccess.Get_New_Row(rDepartment, DS.dbaccess); g1 = Easy_DataAccess.CryptString(passwordDipart.PadRight(31)); } DataRow[] righeAccesso = rDepartment.GetChildRows("dbdepartmentdbaccess"); foreach (DataRow rAccess in righeAccesso) { byte[] alfa = mainConn.sha256UserPassword(); byte[] alfa1 = xor(alfa, g1); rAccess["alpha1"] = QueryCreator.ByteArrayToString(alfa1); } }
public void MetaData_AfterFill() { if (Meta.FirstFillForThisRow) { btnAccertamento.Enabled = true; } DataRow CurrSorKind = HelpForm.GetLastSelected(DS.sortingkind); if (CurrSorKind != null) { string f = QHC.CmpEq("!idsorkind", CurrSorKind["idsorkind"]); DS.admpay_incomesorted.ExtendedProperties["CustomParentRelation"] = f; } }
public void MetaData_AfterClear() { txtCodice.ReadOnly = false; if (HelpForm.GetLastSelected(DS.listclass) == null) { Meta.CanInsert = false; } else { Meta.CanInsert = true; } btnInsDettagli.Visible = false; rdbServizi.Checked = false; rdbBeni.Checked = false; AbilitaBeniServizi(); }
private void btnControlli_Click(object sender, System.EventArgs e) { DataRow CurrBusiness = HelpForm.GetLastSelected(DS.audit); if (CurrBusiness == null) { return; } MetaData MetaRule = MetaData.GetMetaData(this, "auditcheck"); MetaRule.StartFilter = "(idaudit=" + QueryCreator.quotedstrvalue(CurrBusiness["idaudit"], true) + ")"; MetaRule.ExtraParameter = CurrBusiness["idaudit"]; MetaRule.Edit(this.ParentForm, "child", false); MetaRule.DoMainCommand("maindosearch.default"); }