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