/// <summary> /// Recupera le informazioni relative al documento /// </summary> private void Execute() { S_Controls.Collections.S_ControlsCollection CollezioneControlli = new S_Controls.Collections.S_ControlsCollection(); S_Controls.Collections.S_Object s_p_filname = new S_Controls.Collections.S_Object(); s_p_filname.ParameterName = "p_filname"; s_p_filname.DbType = CustomDBType.VarChar; s_p_filname.Direction = ParameterDirection.Input; s_p_filname.Index = 0; s_p_filname.Value = this.filname; s_p_filname.Size = 50; CollezioneControlli.Add(s_p_filname); Classi.AnagrafeImpianti.DocDWF _DocDWF = new Classi.AnagrafeImpianti.DocDWF(); DataSet Ds = _DocDWF.GetData(CollezioneControlli); Repeater1.DataSource = Ds; Repeater1.DataBind(); if (Ds.Tables[0].Rows.Count > 0) { GetFile(Ds.Tables[0].Rows[0]["var_percorso_root"].ToString(), Ds.Tables[0].Rows[0]["var_percorso_child"].ToString()); } }
/// <summary> /// Aggiorna i ruoli associati all'utente. /// </summary> /// <param name="UpdateDataTable"></param> private void UpdateRuoli(DataTable UpdateDataTable) { foreach (DataRow dr in UpdateDataTable.Rows) { if (dr["Operazione"] != DBNull.Value) { Classi.Utente _Utente = new TheSite.Classi.Utente(); try { S_Controls.Collections.S_ControlsCollection _SColl = new S_Controls.Collections.S_ControlsCollection(); S_Controls.Collections.S_Object s_UtenteId = new S_Controls.Collections.S_Object(); s_UtenteId.ParameterName = "p_Utente_Id"; s_UtenteId.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; s_UtenteId.Direction = ParameterDirection.Input; s_UtenteId.Index = 0; s_UtenteId.Value = Convert.ToInt32(dr["IdUtente"].ToString()); S_Controls.Collections.S_Object s_RuoloId = new S_Controls.Collections.S_Object(); s_RuoloId.ParameterName = "p_Ruolo_Id"; s_RuoloId.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; s_RuoloId.Direction = ParameterDirection.Input; s_RuoloId.Index = 1; s_RuoloId.Value = Convert.ToInt32(dr["Id"].ToString()); _SColl.Add(s_UtenteId); _SColl.Add(s_RuoloId); Classi.ExecuteType Operazione; if (dr["Operazione"].ToString() == "I") { Operazione = Classi.ExecuteType.Insert; } else { Operazione = Classi.ExecuteType.Delete; } _Utente.UpdateRuoli(_SColl, Operazione); } catch { string s_Err = "Errore: aggiornamento non riuscito"; PanelMess.ShowError(s_Err, true); } } } }
private void Execute() { Classi.ManProgrammata.ProcAndSteps _PMP = new TheSite.Classi.ManProgrammata.ProcAndSteps(); S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection(); S_Controls.Collections.S_Object s_pmp_id = new S_Controls.Collections.S_Object(); s_pmp_id.ParameterName = "p_Id"; s_pmp_id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_pmp_id.Direction = ParameterDirection.Input; s_pmp_id.Size = 8; s_pmp_id.Index = 0; s_pmp_id.Value = txtmatricola.Text; _SCollection.Add(s_pmp_id); S_Controls.Collections.S_Object s_eqstd_id = new S_Controls.Collections.S_Object(); s_eqstd_id.ParameterName = "p_idEqst"; s_eqstd_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; s_eqstd_id.Direction = ParameterDirection.Input; s_eqstd_id.Size = 8; s_eqstd_id.Index = 1; s_eqstd_id.Value = 0; _SCollection.Add(s_eqstd_id); S_Controls.Collections.S_Object s_servizio_id = new S_Controls.Collections.S_Object(); s_servizio_id.ParameterName = "p_idServizio"; s_servizio_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; s_servizio_id.Direction = ParameterDirection.Input; s_servizio_id.Size = 8; s_servizio_id.Index = 2; s_servizio_id.Value = 0; _SCollection.Add(s_servizio_id); DataSet _MyDs = _PMP.GetAllPMP(_SCollection).Copy(); if (_MyDs.Tables[0].Rows.Count == 1) { DataRow _Dr = _MyDs.Tables[0].Rows[0]; txtdescrizione.Text = _Dr["descrizione"].ToString(); txtmatricola.Text = _Dr["id"].ToString(); txtid.Value = _Dr["idnumerico"].ToString(); } // Controllo che sia stata assegnata una funzione. if (DelegateCodicePMP1 != null) { DelegateCodicePMP1(Int32.Parse(txtid.Value)); } }
private void Execute() { S_Controls.Collections.S_ControlsCollection CollezioneControlli = new S_Controls.Collections.S_ControlsCollection(); S_Controls.Collections.S_Object s_p_bl_id = new S_Controls.Collections.S_Object(); s_p_bl_id.ParameterName = "p_bl_id"; s_p_bl_id.DbType = CustomDBType.Integer; s_p_bl_id.Direction = ParameterDirection.Input; s_p_bl_id.Index = 0; s_p_bl_id.Value = this.bl_id; CollezioneControlli.Add(s_p_bl_id); S_Controls.Collections.S_Object s_p_doc_id_servizio = new S_Controls.Collections.S_Object(); s_p_doc_id_servizio.ParameterName = "p_doc_id_servizio"; s_p_doc_id_servizio.DbType = CustomDBType.Integer; s_p_doc_id_servizio.Direction = ParameterDirection.Input; s_p_doc_id_servizio.Index = 1; s_p_doc_id_servizio.Value = this.doc_id_servizio; CollezioneControlli.Add(s_p_doc_id_servizio); S_Controls.Collections.S_Object s_p_categoria = new S_Controls.Collections.S_Object(); s_p_categoria.ParameterName = "p_categoria"; s_p_categoria.DbType = CustomDBType.VarChar; s_p_categoria.Direction = ParameterDirection.Input; s_p_categoria.Index = 2; s_p_categoria.Value = this.categoria; s_p_categoria.Size = 50; CollezioneControlli.Add(s_p_categoria); S_Controls.Collections.S_Object s_p_tipologia = new S_Controls.Collections.S_Object(); s_p_tipologia.ParameterName = "p_tipologia"; s_p_tipologia.DbType = CustomDBType.Integer; s_p_tipologia.Direction = ParameterDirection.Input; s_p_tipologia.Index = 3; s_p_tipologia.Value = this.idtip; CollezioneControlli.Add(s_p_tipologia); Classi.AnagrafeImpianti.DocDWF _DocDWF = new Classi.AnagrafeImpianti.DocDWF(); DataSet Ds = _DocDWF.GetDocImage(CollezioneControlli); DataListImage.DataSource = Ds; DataListImage.DataBind(); }
private void Ricerca() { S_Controls.Collections.S_ControlsCollection CollezioneControlli = new S_Controls.Collections.S_ControlsCollection(); S_Controls.Collections.S_Object s_p_mese = new S_Controls.Collections.S_Object(); s_p_mese.ParameterName = "p_mese"; s_p_mese.DbType = CustomDBType.VarChar; s_p_mese.Size = 2; s_p_mese.Direction = ParameterDirection.Input; s_p_mese.Index = CollezioneControlli.Count; s_p_mese.Value = DrMese.SelectedValue; CollezioneControlli.Add(s_p_mese); S_Controls.Collections.S_Object s_p_anno = new S_Controls.Collections.S_Object(); s_p_anno.ParameterName = "p_anno"; s_p_anno.DbType = CustomDBType.VarChar; s_p_anno.Size = 4; s_p_anno.Direction = ParameterDirection.Input; s_p_anno.Index = CollezioneControlli.Count; s_p_anno.Value = DropAnno.SelectedValue; CollezioneControlli.Add(s_p_anno); S_Controls.Collections.S_Object s_p_idbl = new S_Controls.Collections.S_Object(); s_p_idbl.ParameterName = "p_idbl"; s_p_idbl.DbType = CustomDBType.VarChar; s_p_idbl.Size = 4; s_p_idbl.Direction = ParameterDirection.Input; s_p_idbl.Index = CollezioneControlli.Count; s_p_idbl.Value = RicercaModulo1.BlId; CollezioneControlli.Add(s_p_idbl); Classi.SoddCliente.Soddisfato _Kpi = new TheSite.Classi.SoddCliente.Soddisfato(); DataSet Ds = _Kpi.GetPianiMensili(CollezioneControlli); Repeater1.DataSource = Ds; Repeater1.DataBind(); }
private void Execute() { Classi.ManProgrammata.ProcAndSteps _PMP = new TheSite.Classi.ManProgrammata.ProcAndSteps(); S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection(); S_Controls.Collections.S_Object s_pmp_id = new S_Controls.Collections.S_Object(); s_pmp_id.ParameterName = "p_Id"; s_pmp_id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_pmp_id.Direction = ParameterDirection.Input; s_pmp_id.Size = 8; s_pmp_id.Index = 0; s_pmp_id.Value = this.idric; _SCollection.Add(s_pmp_id); S_Controls.Collections.S_Object s_eqstd_id = new S_Controls.Collections.S_Object(); s_eqstd_id.ParameterName = "p_idEqst"; s_eqstd_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; s_eqstd_id.Direction = ParameterDirection.Input; s_eqstd_id.Size = 8; s_eqstd_id.Index = 1; s_eqstd_id.Value = this.idEqStd; _SCollection.Add(s_eqstd_id); S_Controls.Collections.S_Object s_servizio_id = new S_Controls.Collections.S_Object(); s_servizio_id.ParameterName = "p_idServizio"; s_servizio_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; s_servizio_id.Direction = ParameterDirection.Input; s_servizio_id.Size = 8; s_servizio_id.Index = 2; s_servizio_id.Value = this.idServizio; _SCollection.Add(s_servizio_id); DataSet _MyDs = _PMP.GetAllPMP(_SCollection).Copy(); DataGrid1.DataSource = _MyDs; GridTitle1.NumeroRecords = (_MyDs.Tables[0].Rows.Count) == 0? "0":_MyDs.Tables[0].Rows.Count.ToString(); DataGrid1.DataBind(); }
private void Execute() { ///Istanzio un nuovo oggetto Collection per aggiungere i parametri S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection(); ///creo i parametri S_Controls.Collections.S_Object s_p_Bl_Id = new S_Controls.Collections.S_Object(); s_p_Bl_Id.ParameterName = "p_Bl_Id"; s_p_Bl_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_p_Bl_Id.Direction = ParameterDirection.Input; s_p_Bl_Id.Size = 50; s_p_Bl_Id.Index = _SCollection.Count; if (this.blid == null || this.blid == string.Empty) { s_p_Bl_Id.Value = DBNull.Value; } else { s_p_Bl_Id.Value = this.blid; } _SCollection.Add(s_p_Bl_Id); S_Controls.Collections.S_Object s_p_campus = new S_Controls.Collections.S_Object(); s_p_campus.ParameterName = "p_campus"; s_p_campus.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_p_campus.Direction = ParameterDirection.Input; s_p_campus.Index = _SCollection.Count; s_p_campus.Size = 50; if (this.campus == null || this.campus == string.Empty) { s_p_campus.Value = DBNull.Value; } else { s_p_campus.Value = this.campus; } _SCollection.Add(s_p_campus); S_Controls.Collections.S_Object s_p_Servizio = new S_Controls.Collections.S_Object(); s_p_Servizio.ParameterName = "p_Servizio"; s_p_Servizio.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer; s_p_Servizio.Direction = ParameterDirection.Input; s_p_Servizio.Index = _SCollection.Count; // ///Non filtro piu per servizio. // s_p_Servizio.Value = (this.servizioid ==string.Empty)? -1:Int32.Parse(this.servizioid); s_p_Servizio.Value = -1; _SCollection.Add(s_p_Servizio); S_Controls.Collections.S_Object s_p_eqstdid = new S_Controls.Collections.S_Object(); s_p_eqstdid.ParameterName = "p_eqstdid"; s_p_eqstdid.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_p_eqstdid.Direction = ParameterDirection.Input; s_p_eqstdid.Size = 8; s_p_eqstdid.Index = _SCollection.Count; if (this.codStd == null || this.codStd == string.Empty) { s_p_eqstdid.Value = DBNull.Value; } else { s_p_eqstdid.Value = this.codStd; } _SCollection.Add(s_p_eqstdid); ///Istanzio la Classe per eseguire la Strore Procedure Classi.AnagrafeImpianti.Apparecchiature _Apparecchiature = new TheSite.Classi.AnagrafeImpianti.Apparecchiature(Context.User.Identity.Name); DataSet Ds = _Apparecchiature.RicercaStd(_SCollection); GridTitle1.NumeroRecords = (Ds.Tables[0].Rows.Count) == 0? "0":Ds.Tables[0].Rows.Count.ToString(); MyDataGrid1.DataSource = Ds; MyDataGrid1.DataBind(); }
public void Ricarica() { int LengthCod = int.Parse(System.Configuration.ConfigurationSettings.AppSettings["edi_cod"]); //if (txtsCodEdificio.Text.Trim().Length<LengthCod && txtsCodEdificio.Text.Trim().Length>0) return; if (txtsCodEdificio.Text.Trim().Length == 0) { ClearCampi(); // Controllo che sia stata assegnata una funzione. if (DelegateCodiceEdificio1 != null && txtsCodEdificio.Text != "") { DelegateCodiceServizio1(); DelegateCodiceEdificio1(txtsCodEdificio.Text); } if (DelegateIDBLEdificio1 != null) { DelegateIDBLEdificio1(""); } return; } // Controllo che sia stata assegnata una funzione. if (DelegateCodiceEdificio1 != null) { DelegateCodiceEdificio1(txtsCodEdificio.Text); } Classi.ClassiDettaglio.Edificio _MyEdificio = new WebCad.Classi.ClassiDettaglio.Edificio(Context.User.Identity.Name); S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection(); ///creo i parametri /// S_Controls.Collections.S_Object s_bl_id = new S_Controls.Collections.S_Object(); s_bl_id.ParameterName = "p_Bl_Id"; s_bl_id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_bl_id.Direction = ParameterDirection.Input; s_bl_id.Size = 8; s_bl_id.Index = 0; s_bl_id.Value = txtsCodEdificio.Text; _SCollection.Add(s_bl_id); S_Controls.Collections.S_Object s_Campus = new S_Controls.Collections.S_Object(); s_Campus.ParameterName = "p_Campus"; s_Campus.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar; s_Campus.Direction = ParameterDirection.Input; s_Campus.Size = 50; s_Campus.Index = 2; s_Campus.Value = ""; _SCollection.Add(s_Campus); DataSet _MyDs = _MyEdificio.GetData(_SCollection).Copy(); if (_MyDs.Tables[0].Rows.Count == 1) { DataRow _Dr = _MyDs.Tables[0].Rows[0]; if (DelegateIDBLEdificio1 != null) { DelegateIDBLEdificio1(_Dr["ID"].ToString()); } this.hiddenidbl.Value = _Dr["ID"].ToString(); this._Edificio.BlId = (string)_Dr["BL_ID"]; this.lblBlId.Text = this._Edificio.BlId; if (_Dr["DENOMINAZIONE"] != DBNull.Value) { this._Edificio.Name = (string)_Dr["DENOMINAZIONE"]; this.lblDenominazione.Text = this._Edificio.Name; } if (_Dr["INDIRIZZO"] != DBNull.Value) { this._Edificio.Address1 = (string)_Dr["INDIRIZZO"]; this.lblIndirizzo.Text = this._Edificio.Address1; } if (_Dr["CAMPUS"] != DBNull.Value) { this._Edificio.Campus = (string)_Dr["CAMPUS"]; this.txtRicerca.Text = this._Edificio.Campus; } if (_Dr["COMUNE"] != DBNull.Value) { this._Edificio.City_Id = (string)_Dr["COMUNE"]; this.lblComune.Text = this._Edificio.City_Id; } if (_Dr["REFERENTE"] != DBNull.Value) { this._Edificio.Contact_Name = (string)_Dr["REFERENTE"]; this.lblDitta.Text = this._Edificio.Contact_Name; } if (_Dr["TELEFONO_REFERENTE"] != DBNull.Value) { this._Edificio.Contact_Phone = (string)_Dr["TELEFONO_REFERENTE"]; this.lblTelefono.Text = this._Edificio.Contact_Phone; } if (_Dr["CENTRODICOSTO"] != DBNull.Value) { this._Edificio.Centro_Costo = (string)_Dr["CENTRODICOSTO"]; this.lblCdC.Text = this._Edificio.Centro_Costo; } if (_Dr["EMAIL"] != DBNull.Value) { this._Edificio.Option2 = (string)_Dr["EMAIL"]; this.lblEmail.Value = this._Edificio.Option2; } } else { ClearCampi(); } }