private long CalcolaTot()
{
Classi.AnagrafeImpianti.Apparecchiature _Richiesta = new TheSite.Classi.AnagrafeImpianti.Apparecchiature();
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_Wr_Id = new S_Controls.Collections.S_Object();
s_p_Wr_Id.ParameterName = "p_Wr_Id";
s_p_Wr_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wr_Id.Direction = ParameterDirection.Input;
s_p_Wr_Id.Index = 2;
s_p_Wr_Id.Size = 50;
s_p_Wr_Id.Value = (this.txtsRichiesta.Text == "")?0:Int32.Parse(this.txtsRichiesta.Text);
_SCollection.Add(s_p_Wr_Id);
S_Controls.Collections.S_Object s_p_Addetto = new S_Controls.Collections.S_Object();
s_p_Addetto.ParameterName = "p_Addetto";
s_p_Addetto.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Addetto.Direction = ParameterDirection.Input;
s_p_Addetto.Index = 3;
s_p_Addetto.Size = 50;
s_p_Addetto.Value = this.Addetti1.NomeCompleto;
_SCollection.Add(s_p_Addetto);
S_Controls.Collections.S_Object s_p_DataDa = new S_Controls.Collections.S_Object();
s_p_DataDa.ParameterName = "p_DataDa";
s_p_DataDa.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataDa.Direction = ParameterDirection.Input;
s_p_DataDa.Index = 4;
s_p_DataDa.Size = 10;
s_p_DataDa.Value = (CalendarPicker1.Datazione.Text == "")? "":CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_DataDa);
S_Controls.Collections.S_Object s_p_DataA = new S_Controls.Collections.S_Object();
s_p_DataA.ParameterName = "p_DataA";
s_p_DataA.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataA.Direction = ParameterDirection.Input;
s_p_DataA.Index = 5;
s_p_DataA.Size = 10;
s_p_DataA.Value = (CalendarPicker2.Datazione.Text == "")? "":CalendarPicker2.Datazione.Text;
_SCollection.Add(s_p_DataA);
S_Controls.Collections.S_Object s_p_Wo_Id = new S_Controls.Collections.S_Object();
s_p_Wo_Id.ParameterName = "p_Wo_Id";
s_p_Wo_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wo_Id.Direction = ParameterDirection.Input;
s_p_Wo_Id.Index = 6;
s_p_Wo_Id.Size = 50;
s_p_Wo_Id.Value = (this.txtsOrdine.Text == "")?0:Int32.Parse(this.txtsOrdine.Text);
_SCollection.Add(s_p_Wo_Id);
S_Controls.Collections.S_Object s_p_Status = new S_Controls.Collections.S_Object();
s_p_Status.ParameterName = "p_Status";
s_p_Status.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Status.Direction = ParameterDirection.Input;
s_p_Status.Index = 8;
s_p_Status.Value = (cmbsStatus.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsStatus.SelectedValue);
_SCollection.Add(s_p_Status);
DataSet _MyDsTot = _Richiesta.GetTotRDLEQ(_SCollection, DataGridRicerca.PageSize, DataGridRicerca.CurrentPageIndex).Copy();
DataRow _DR = _MyDsTot.Tables[0].Rows[0];
return(long.Parse(_DR[0].ToString()));
}
private void btnsAggiungi_Click(object sender, System.EventArgs e)
{
this.txtsMotivo.DBDefaultValue = DBNull.Value;
this.txtsMotivo.Text = this.txtsMotivo.Text.Trim();
int i_RowsAffected = 0;
if (RichiedentiSollecito1.s_RichID.Text != "" && txtsMotivo.Text != "")
{
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object s_p_ID_RICHIEDENTE = new S_Controls.Collections.S_Object();
s_p_ID_RICHIEDENTE.ParameterName = "p_ID_RICHIEDENTE";
s_p_ID_RICHIEDENTE.DbType = CustomDBType.Integer;
s_p_ID_RICHIEDENTE.Direction = ParameterDirection.Input;
s_p_ID_RICHIEDENTE.Index = _SCollection.Count;
s_p_ID_RICHIEDENTE.Size = 10;
s_p_ID_RICHIEDENTE.Value = Int32.Parse(RichiedentiSollecito1.s_RichID.Text);
_SCollection.Add(s_p_ID_RICHIEDENTE);
S_Controls.Collections.S_Object s_p_NomeCompleto = new S_Controls.Collections.S_Object();
s_p_NomeCompleto.ParameterName = "p_NomeCompleto";
s_p_NomeCompleto.DbType = CustomDBType.VarChar;
s_p_NomeCompleto.Direction = ParameterDirection.Input;
s_p_NomeCompleto.Index = _SCollection.Count;
s_p_NomeCompleto.Size = 50;
s_p_NomeCompleto.Value = RichiedentiSollecito1.NomeCompleto.ToString();
_SCollection.Add(s_p_NomeCompleto);
S_Controls.Collections.S_Object s_p_CognomeCompleto = new S_Controls.Collections.S_Object();
s_p_CognomeCompleto.ParameterName = "p_CognomeCompleto";
s_p_CognomeCompleto.DbType = CustomDBType.VarChar;
s_p_CognomeCompleto.Direction = ParameterDirection.Input;
s_p_CognomeCompleto.Index = _SCollection.Count;
s_p_CognomeCompleto.Size = 50;
s_p_CognomeCompleto.Value = RichiedentiSollecito1.CognomeCompleto.ToString();
_SCollection.Add(s_p_CognomeCompleto);
S_Controls.Collections.S_Object s_p_phone = new S_Controls.Collections.S_Object();
s_p_phone.ParameterName = "p_phone";
s_p_phone.DbType = CustomDBType.VarChar;
s_p_phone.Direction = ParameterDirection.Input;
s_p_phone.Index = _SCollection.Count;
s_p_phone.Size = 50;
s_p_phone.Value = RichiedentiSollecito1.telefono.ToString();
_SCollection.Add(s_p_phone);
S_Controls.Collections.S_Object s_p_email = new S_Controls.Collections.S_Object();
s_p_email.ParameterName = "p_email";
s_p_email.DbType = CustomDBType.VarChar;
s_p_email.Direction = ParameterDirection.Input;
s_p_email.Index = _SCollection.Count;
s_p_email.Size = 50;
s_p_email.Value = RichiedentiSollecito1.email.ToString();
_SCollection.Add(s_p_email);
S_Controls.Collections.S_Object s_p_stanza = new S_Controls.Collections.S_Object();
s_p_stanza.ParameterName = "p_stanza";
s_p_stanza.DbType = CustomDBType.VarChar;
s_p_stanza.Direction = ParameterDirection.Input;
s_p_stanza.Index = _SCollection.Count;
s_p_stanza.Size = 50;
s_p_stanza.Value = RichiedentiSollecito1.stanza.ToString();
_SCollection.Add(s_p_stanza);
S_Controls.Collections.S_Object s_p_Gruppo = new S_Controls.Collections.S_Object();
s_p_Gruppo.ParameterName = "p_ID_Gruppo";
s_p_Gruppo.DbType = CustomDBType.Integer;
s_p_Gruppo.Direction = ParameterDirection.Input;
s_p_Gruppo.Index = _SCollection.Count;
s_p_Gruppo.Size = 50;
s_p_Gruppo.Value = Convert.ToInt32(RichiedentiSollecito1.IdGruppo);
_SCollection.Add(s_p_Gruppo);
S_Controls.Collections.S_Object s_p_Motivo = new S_Controls.Collections.S_Object();
s_p_Motivo.ParameterName = "p_Motivo";
s_p_Motivo.DbType = CustomDBType.VarChar;
s_p_Motivo.Direction = ParameterDirection.Input;
s_p_Motivo.Index = _SCollection.Count;
s_p_Motivo.Size = 50;
s_p_Motivo.Value = txtsMotivo.Text;
_SCollection.Add(s_p_Motivo);
Classi.ManOrdinaria.ChiariInfo _ChiariInfo = new TheSite.Classi.ManOrdinaria.ChiariInfo();
i_RowsAffected = _ChiariInfo.ExecuteAddChiariInfo(_SCollection, int.Parse(this.idric));
string jscript = "<script language=JavaScript>\n";
jscript += "var oVDiv=parent.document.getElementById('PopupAddChiariInfo').style;\n";
jscript += "oVDiv.display = 'none';";
jscript += "<";
jscript += "/";
jscript += "script>";
if (!this.IsStartupScriptRegistered("clientScriptChiudi"))
{
this.RegisterStartupScript("clientScriptChiudi", jscript);
}
lbloperazione.Text = "Richiesta Chiarimento inserita";
}
else
{
lbloperazione.Text = "Inserire richiedente e richiesta di Chiarimento";
return;
}
//xx
}
/// <summary>
/// Ottiene imposta la visibilità della griglia e dell'ogetto title
/// </summary>
/// <param name="Visibile"> indica true di renderli visibili</param>
private S_Controls.Collections.S_ControlsCollection GetDatiAprrarecchiature()
{
///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 = 0;
s_p_Bl_Id.Value = RicercaModulo1.TxtCodice.Text;
_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 = 1;
s_p_campus.Size = 50;
s_p_campus.Value = RicercaModulo1.TxtRicerca.Text;
///Aggiungo i parametri alla collection
_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 = 2;
s_p_Servizio.Value = (cmbsServizio.SelectedValue == string.Empty) ? 0 : Int32.Parse(cmbsServizio.SelectedValue);
///Aggiungo i parametri alla collection
_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.Integer;
s_p_eqstdid.Direction = ParameterDirection.Input;
s_p_eqstdid.Size = 8;
s_p_eqstdid.Index = 3;
s_p_eqstdid.Value = (cmbsApparecchiatura.SelectedValue == string.Empty) ? 0 : Int32.Parse(cmbsApparecchiatura.SelectedValue);
_SCollection.Add(s_p_eqstdid);
S_Controls.Collections.S_Object s_p_eq_id = new S_Controls.Collections.S_Object();
s_p_eq_id.ParameterName = "p_eq_id";
s_p_eq_id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_eq_id.Direction = ParameterDirection.Input;
// s_p_eq_id.Size =8;
s_p_eq_id.Index = 4;
s_p_eq_id.Size = 50;
s_p_eq_id.Value = CodiceApparecchiature1.CodiceApparecchiatura;
///Aggiungo i parametri alla collection
_SCollection.Add(s_p_eq_id);
S_Controls.Collections.S_Object s_p_DataDa = new S_Controls.Collections.S_Object();
s_p_DataDa.ParameterName = "p_DataDa";
s_p_DataDa.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataDa.Direction = ParameterDirection.Input;
s_p_DataDa.Index = _SCollection.Count;
s_p_DataDa.Size = 10;
s_p_DataDa.Value = (CalendarPicker1.Datazione.Text == "") ? "" : CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_DataDa);
S_Controls.Collections.S_Object s_p_DataA = new S_Controls.Collections.S_Object();
s_p_DataA.ParameterName = "p_DataA";
s_p_DataA.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataA.Direction = ParameterDirection.Input;
s_p_DataA.Index = _SCollection.Count;
s_p_DataA.Size = 10;
s_p_DataA.Value = (CalendarPicker2.Datazione.Text == "") ? "" : CalendarPicker2.Datazione.Text;
_SCollection.Add(s_p_DataA);
//andrea
return(_SCollection);
}
private S_Controls.Collections.S_ControlsCollection GetDatiAprrarecchiature()
{
///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 = 0;
s_p_Bl_Id.Value = RicercaModulo1.TxtCodice.Text;
_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 = 1;
s_p_campus.Size = 50;
s_p_campus.Value = RicercaModulo1.TxtRicerca.Text;
///Aggiungo i parametri alla collection
_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 = 2;
s_p_Servizio.Value = (cmbsServizio.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsServizio.SelectedValue);
///Aggiungo i parametri alla collection
_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.Integer;
s_p_eqstdid.Direction = ParameterDirection.Input;
s_p_eqstdid.Size = 8;
s_p_eqstdid.Index = 3;
s_p_eqstdid.Value = (cmbsApparecchiatura.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsApparecchiatura.SelectedValue);
_SCollection.Add(s_p_eqstdid);
S_Controls.Collections.S_Object s_p_eq_id = new S_Controls.Collections.S_Object();
s_p_eq_id.ParameterName = "p_eq_id";
s_p_eq_id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_eq_id.Direction = ParameterDirection.Input;
// s_p_eq_id.Size =8;
s_p_eq_id.Index = 4;
s_p_eq_id.Size = 50;
s_p_eq_id.Value = CodiceApparecchiature1.CodiceApparecchiatura;
///Aggiungo i parametri alla collection
_SCollection.Add(s_p_eq_id);
S_Controls.Collections.S_Object s_p_dimesso = new S_Controls.Collections.S_Object();
s_p_dimesso.ParameterName = "p_dismesso";
s_p_dimesso.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_dimesso.Direction = ParameterDirection.Input;
s_p_dimesso.Index = 5;
s_p_dimesso.Size = 8;
s_p_dimesso.Value = Classi.DismissioneType.NO;
_SCollection.Add(s_p_dimesso);
S_Controls.Collections.S_Object s_p_idpiano = new S_Controls.Collections.S_Object();
s_p_idpiano.ParameterName = "p_idpiano";
s_p_idpiano.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_idpiano.Direction = ParameterDirection.Input;
s_p_idpiano.Size = 10;
s_p_idpiano.Index = 6;
s_p_idpiano.Value = (cmbsPiano.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsPiano.SelectedValue);
_SCollection.Add(s_p_idpiano);
S_Controls.Collections.S_Object s_p_idstanza = new S_Controls.Collections.S_Object();
s_p_idstanza.ParameterName = "p_idstanza";
s_p_idstanza.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_idstanza.Direction = ParameterDirection.Input;
s_p_idstanza.Size = 10;
s_p_idstanza.Index = 7;
s_p_idstanza.Value = UserStanze1.DescStanza;
_SCollection.Add(s_p_idstanza);
S_Controls.Collections.S_Object s_p_TipoApp = new S_Controls.Collections.S_Object();
s_p_TipoApp.ParameterName = "p_TipoApp";
s_p_TipoApp.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_TipoApp.Direction = ParameterDirection.Input;
s_p_TipoApp.Size = 100;
s_p_TipoApp.Index = 8;
s_p_TipoApp.Value = TxtTipoApp.Text;
_SCollection.Add(s_p_TipoApp);
return(_SCollection);
}
private void BindingEdifici(string BlId, bool reset)
{
if (BlId != "")
{
BlId = "'" + BlId.Replace(",", "','") + "'";
}
// da qui
if (chkEdificio.Checked == true)
{
sql_select += " BL.BL_ID || ' - ' || BL.ADDRESS1 as EDIFICIO";
sql_group += " BL.BL_ID || ' - ' || BL.ADDRESS1";
}
if (chkPiano.Checked == true)
{
if (sql_select != "")
{
sql_select += ",";
}
if (sql_group != "")
{
sql_group += ",";
}
sql_select += " PIANI.DESCRIZIONE as PIANO ";
sql_group += " PIANI.DESCRIZIONE ";
}
if (chkStanze.Checked == true)
{
if (sql_select != "")
{
sql_select += ",";
}
if (sql_group != "")
{
sql_group += ",";
}
sql_select += "RM.RM_ID || '-' || RM.DESCRIZIONE as STANZA ";
sql_group += " RM.RM_ID,RM.DESCRIZIONE ";
}
if (chkCategoria.Checked == true)
{
if (sql_select != "")
{
sql_select += ",";
}
if (sql_group != "")
{
sql_group += ",";
}
sql_select += "RM_CAT.CODICE_CATEGORIA || '-' || RM_CAT.DESCRIZIONE as CATEGORIA ";
sql_group += " RM_CAT.CODICE_CATEGORIA, RM_CAT.DESCRIZIONE ";
}
if (chkDestinazione.Checked == true)
{
if (sql_select != "")
{
sql_select += ",";
}
if (sql_group != "")
{
sql_group += ",";
}
sql_select += " RM_DEST_USO.DESCRIZIONE as DESTINAZIONE ";
sql_group += " RM_DEST_USO.DESCRIZIONE ";
}
if (chkReparto.Checked == true)
{
if (sql_select != "")
{
sql_select += ",";
}
if (sql_group != "")
{
sql_group += ",";
}
sql_select += " RM_REPARTO.DESCRIZIONE as REPARTO ";
sql_group += " RM_REPARTO.DESCRIZIONE ";
}
// a qui
if (BlId != "")
{
if (sql_where != "")
{
sql_where += " AND";
}
sql_where += " UPPER(BL.BL_ID) in (" + BlId.ToUpper() + ") ";
}
if (cmbsPiano.SelectedValue != String.Empty)
{
if (sql_where != "")
{
sql_where += " AND";
}
sql_where += " ID_PIANI =" + cmbsPiano.SelectedValue.ToString();
}
if (UserStanze1.DescStanza.ToString() != "")
{
if (sql_where != "")
{
sql_where += " AND";
}
sql_where += " UPPER(RM.RM_ID ||'-'|| RM.DESCRIZIONE) like '%" + UserStanze1.DescStanza.ToUpper() + "%'";
}
if (cmbsCategoria.SelectedValue != String.Empty)
{
if (sql_where != "")
{
sql_where += " AND";
}
sql_where += " RM_CAT.ID_RM_CAT=" + cmbsCategoria.SelectedValue.ToString();
}
if (s_txtReparto.Text != String.Empty)
{
if (sql_where != "")
{
sql_where += " AND";
}
sql_where += " UPPER(RM_REPARTO.DESCRIZIONE) like '%" + s_txtReparto.Text.ToUpper() + "%'";
}
if (s_txtDestinazione.Text != String.Empty)
{
if (sql_where != "")
{
sql_where += " AND";
}
sql_where += " UPPER(RM_DEST_USO.DESCRIZIONE) like '%" + s_txtDestinazione.Text.ToUpper() + "%'";
}
if (cmbsConfronto.SelectedValue != String.Empty & s_txtMq.Text != String.Empty)
{
if (sql_where != "")
{
sql_where += " AND";
}
//s_txtMq.Text.Replace(",",".");
sql_where += " RM.AREA " + cmbsConfronto.SelectedValue + " " + s_txtMq.Text.Replace(",", ".");
}
if (sql_where != "")
{
sql_where = " WHERE " + sql_where;
}
///select finale da passare alla store procedure
if (sql_select != "")
{
sql_select += ", ";
}
sql = "SELECT " + sql_select + " SUM(RM.AREA) as VALORE_INT FROM BL JOIN FL ON (FL.Id_Bl = BL.Id) " +
"JOIN RM USING (id_piani, id_bl) JOIN PIANI ON (id_piani = PIANI.id) " +
"left JOIN RM_REPARTO ON (RM.ID_RM_REPARTO = RM_REPARTO.ID_RM_REPARTO) " +
"left JOIN RM_DEST_USO ON (RM.ID_RM_DEST_USO = RM_DEST_USO.ID_RM_DEST_USO) " +
" left JOIN RM_CAT ON (RM.ID_RM_CAT = RM_CAT.ID_RM_CAT) " + sql_where;
if (sql_group != "")
{
sql += " GROUP BY " + sql_group;
}
// sqlCount = "SELECT count(distinct RM.RM_ID) FROM BL JOIN FL ON (FL.Id_Bl = BL.Id) " +
// "JOIN RM USING (id_piani, id_bl) JOIN PIANI ON (id_piani = PIANI.id) " +
// "left JOIN RM_REPARTO ON (RM.ID_RM_REPARTO = RM_REPARTO.ID_RM_REPARTO) " +
// "left JOIN RM_DEST_USO ON (RM.ID_RM_DEST_USO = RM_DEST_USO.ID_RM_DEST_USO) " +
// " left JOIN RM_CAT ON (RM.ID_RM_CAT = RM_CAT.ID_RM_CAT) " + sql_where ;
// ///Istanzio un nuovo oggetto Collection per aggiungere i parametri
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
// ///creo i parametri
///edifici
S_Controls.Collections.S_Object s_sql = new S_Controls.Collections.S_Object();
s_sql.ParameterName = "p_sql";
s_sql.DbType = CustomDBType.VarChar;
s_sql.Direction = ParameterDirection.Input;
s_sql.Size = 4000;
s_sql.Index = 0;
s_sql.Value = sql;
_SCollection.Add(s_sql);
// nuovi parametri paginazione
S_Controls.Collections.S_Object s_p_pageindex = new S_Object();
s_p_pageindex.ParameterName = "pageindex";
s_p_pageindex.DbType = CustomDBType.Integer;
s_p_pageindex.Direction = ParameterDirection.Input;
s_p_pageindex.Index = 16;
s_p_pageindex.Value = DtgRicercaSpazi.CurrentPageIndex + 1;
_SCollection.Add(s_p_pageindex);
S_Controls.Collections.S_Object s_p_pagesize = new S_Object();
s_p_pagesize.ParameterName = "pagesize";
s_p_pagesize.DbType = CustomDBType.Integer;
s_p_pagesize.Direction = ParameterDirection.Input;
s_p_pagesize.Index = 17;
s_p_pagesize.Value = DtgRicercaSpazi.PageSize;
_SCollection.Add(s_p_pagesize);
Classi.AnagrafeImpianti.ServiziEdifici _ServiziEdifici = new Classi.AnagrafeImpianti.ServiziEdifici(Context.User.Identity.Name);
DataSet Ds = _ServiziEdifici.GetRicerca(_SCollection);
if (reset)
{
_SCollection.Clear();
///edifici
S_Controls.Collections.S_Object s_sqlCount = new S_Controls.Collections.S_Object();
s_sqlCount.ParameterName = "p_sql";
s_sqlCount.DbType = CustomDBType.VarChar;
s_sqlCount.Direction = ParameterDirection.Input;
s_sqlCount.Size = 4000;
s_sqlCount.Index = 0;
s_sqlCount.Value = sql;
_SCollection.Add(s_sqlCount);
int _totalRecords = _ServiziEdifici.GetRicercaCount(_SCollection);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
}
this.DtgRicercaSpazi.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
if (Ds.Tables[0].Rows.Count == 0)
{
Panel1.Visible = false;
}
// {
// int Pagina = 0;
// if ((Ds.Tables[0].Rows.Count % DtgRicercaSpazi.PageSize) >0)
// {
// Pagina ++;
// }
// if (DtgRicercaSpazi.PageCount != Convert.ToInt16((Ds.Tables[0].Rows.Count / DtgRicercaSpazi.PageSize) + Pagina))
// {
// DtgRicercaSpazi.CurrentPageIndex=0;
// }
// }
// else
// {
// Panel1.Visible=false;
// }
Panel1.Visible = true;
DtgRicercaSpazi.Visible = true;
int conta = 0;
if (chkEdificio.Checked == false)
{
DtgRicercaSpazi.Columns.RemoveAt(0);
conta += 1;
}
if (chkPiano.Checked == false)
{
DtgRicercaSpazi.Columns.RemoveAt(1 - conta);
conta += 1;
}
if (chkStanze.Checked == false)
{
DtgRicercaSpazi.Columns.RemoveAt(2 - conta);
conta += 1;
}
if (chkCategoria.Checked == false)
{
DtgRicercaSpazi.Columns.RemoveAt(3 - conta);
conta += 1;
}
if (chkDestinazione.Checked == false)
{
DtgRicercaSpazi.Columns.RemoveAt(4 - conta);
conta += 1;
}
if (chkReparto.Checked == false)
{
DtgRicercaSpazi.Columns.RemoveAt(5 - conta);
conta += 1;
}
if (chkEdificio.Checked == false && chkPiano.Checked == false && chkStanze.Checked == false && chkCategoria.Checked == false && chkDestinazione.Checked == false && chkReparto.Checked == false)
{
DtgRicercaSpazi.Columns.RemoveAt(6 - conta);
//creo colonna vuota
BoundColumn cl8 = new BoundColumn();
cl8.DataField = "";
cl8.HeaderText = "";
DtgRicercaSpazi.Columns.Add(cl8);
}
CalcolaTotali(Ds.Tables[0]);
this.DtgRicercaSpazi.DataSource = Ds.Tables[0];
DtgRicercaSpazi.DataBind();
GridTitle1.DescriptionTitle = "";
// GridTitle1.NumeroRecords = Ds.Tables[0].Rows.Count.ToString();
}
// private void LoadTipoCP()
// {
// this.cmbs_TipoCP.Items.Clear();
//
// Classi.GestioneCP.CompletamentoCP _CompletamentoCP = new TheSite.Classi.GestioneCP.CompletamentoCP(Context.User.Identity.Name);
//
// DataSet _MyDs = _CompletamentoCP.GetDataTipoCP().Copy();
//
// if (_MyDs.Tables[0].Rows.Count > 0)
// {
// this.cmbs_TipoCP.DataSource = Classi.GestoreDropDownList.ItemBlankDataSource(
// _MyDs.Tables[0], "descrizione","id", "- Selezionare un Tipo Controllo Periodico-", "0");
// this.cmbs_TipoCP.DataTextField = "descrizione";
// this.cmbs_TipoCP.DataValueField = "id";
// this.cmbs_TipoCP.DataBind();
// }
// else
// {
// string s_Messagggio = "- Nessuna Frequenza -";
// this.cmbs_TipoCP.Items.Add(Classi.GestoreDropDownList.ItemMessaggio(s_Messagggio, String.Empty));
// }
// }
private void Ricerca()
{
Classi.GestioneCP.SfogliaRdlOdl SfogliaRdlOdl = new TheSite.Classi.GestioneCP.SfogliaRdlOdl(HttpContext.Current.User.ToString());
// DataSet _MyDs = _GCP.GETWRCP_SF(itemId).Copy();
//Classi.ClassiAnagrafiche.DestUso _DestUso = new TheSite.Classi.ClassiAnagrafiche.DestUso();
this.txtsCodice.DBDefaultValue = "%";
this.txtsDescrizione.DBDefaultValue = "%";
this.txtsCodice.Text = this.txtsCodice.Text.Trim();
this.txtsDescrizione.Text = this.txtsDescrizione.Text.Trim();
int index = 0;
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
S_Object p_id_wr_cp = new S_Object();
p_id_wr_cp.ParameterName = "p_id_wr_cp";
p_id_wr_cp.DbType = CustomDBType.VarChar;
p_id_wr_cp.Direction = ParameterDirection.Input;
p_id_wr_cp.Index = index;
p_id_wr_cp.Size = 100;
p_id_wr_cp.Value = txtsCodice.Text;
_SCollection.Add(p_id_wr_cp);
S_Object p_descrizione = new S_Object();
p_descrizione.ParameterName = "p_descrizione";
p_descrizione.DbType = CustomDBType.VarChar;
p_descrizione.Direction = ParameterDirection.Input;
p_descrizione.Index = index++;
p_descrizione.Size = 250;
p_descrizione.Value = txtsDescrizione.Text;
_SCollection.Add(p_descrizione);
S_Object p_data_inizio = new S_Object();
p_data_inizio.ParameterName = "p_data_inizio";
p_data_inizio.DbType = CustomDBType.VarChar;
p_data_inizio.Direction = ParameterDirection.Input;
p_data_inizio.Index = index++;
p_data_inizio.Size = 255;
p_data_inizio.Value = CalendarPicker1.Datazione.Text;
_SCollection.Add(p_data_inizio);
S_Object p_data_fine = new S_Object();
p_data_fine.ParameterName = "p_data_fine";
p_data_fine.DbType = CustomDBType.VarChar;
p_data_fine.Direction = ParameterDirection.Input;
p_data_fine.Index = index++;
p_data_fine.Size = 255;
p_data_fine.Value = CalendarPicker2.Datazione.Text;
_SCollection.Add(p_data_fine);
S_Object p_completato = new S_Object();
p_completato.ParameterName = "p_completato";
p_completato.DbType = CustomDBType.Integer;
p_completato.Direction = ParameterDirection.Input;
p_completato.Size = 225;
p_completato.Index = index++;
p_completato.Value = ListCompl.SelectedValue;
_SCollection.Add(p_completato);
S_Controls.Collections.S_Object s_CurrentUser = new S_Object();
s_CurrentUser.ParameterName = "p_username";
s_CurrentUser.DbType = CustomDBType.VarChar;
s_CurrentUser.Direction = ParameterDirection.Input;
s_CurrentUser.Index = index++;
s_CurrentUser.Value = System.Web.HttpContext.Current.User.Identity.Name;
_SCollection.Add(s_CurrentUser);
S_Object p_nomeFile = new S_Object();
p_nomeFile.ParameterName = "p_nomeFile";
p_nomeFile.DbType = CustomDBType.VarChar;
p_nomeFile.Direction = ParameterDirection.Input;
p_nomeFile.Index = index++;
p_nomeFile.Size = 250;
p_nomeFile.Value = nomeFile.Text;
_SCollection.Add(p_nomeFile);
S_Controls.Collections.S_Object s_p_ID_BL = new S_Controls.Collections.S_Object();
s_p_ID_BL.ParameterName = "p_ID_BL";
s_p_ID_BL.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_ID_BL.Direction = ParameterDirection.Input;
s_p_ID_BL.Size = 50;
s_p_ID_BL.Index = index++;
s_p_ID_BL.Value = (this.RicercaModulo1._txthidbl.Value == "")?0:Int32.Parse(this.RicercaModulo1._txthidbl.Value);
_SCollection.Add(s_p_ID_BL);
// 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 = index++;
// s_p_BL_ID.Value = (RicercaModulo1.TxtCodice.Text=="")?"0":RicercaModulo1.TxtCodice.Text;
// _SCollection.Add(s_p_BL_ID);
S_Controls.Collections.S_Object s_Cursor = new S_Object();
s_Cursor.ParameterName = "IO_CURSOR";
s_Cursor.DbType = CustomDBType.Cursor;
s_Cursor.Direction = ParameterDirection.Output;
s_Cursor.Index = index++;
_SCollection.Add(s_Cursor);
DataSet _MyDs = SfogliaRdlOdl.GETWRCP_SF_BL(_SCollection).Copy();
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
if (_MyDs.Tables[0].Rows.Count == 0)
{
DataGridRicerca.CurrentPageIndex = 0;
}
else
{
int Pagina = 0;
if ((_MyDs.Tables[0].Rows.Count % DataGridRicerca.PageSize) > 0)
{
Pagina++;
}
if (DataGridRicerca.PageCount != Convert.ToInt16((_MyDs.Tables[0].Rows.Count / DataGridRicerca.PageSize) + Pagina))
{
DataGridRicerca.CurrentPageIndex = 0;
}
}
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}
private void Ricerca(bool reset)
{
Classi.ManCorrettiva.ClManCorrettiva _ClManCorrettiva = new TheSite.Classi.ManCorrettiva.ClManCorrettiva(Context.User.Identity.Name);
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_Wr_Id = new S_Controls.Collections.S_Object();
s_p_Wr_Id.ParameterName = "p_Wr_Id";
s_p_Wr_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wr_Id.Direction = ParameterDirection.Input;
s_p_Wr_Id.Index = 0;
s_p_Wr_Id.Size = 50;
s_p_Wr_Id.Value = (this.txtsRichiesta.Text == "")?0:Int32.Parse(this.txtsRichiesta.Text);
_SCollection.Add(s_p_Wr_Id);
S_Controls.Collections.S_Object s_p_DataDa = new S_Controls.Collections.S_Object();
s_p_DataDa.ParameterName = "p_DataDa";
s_p_DataDa.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataDa.Direction = ParameterDirection.Input;
s_p_DataDa.Index = 1;
s_p_DataDa.Size = 10;
s_p_DataDa.Value = (CalendarPicker1.Datazione.Text == "")? "":CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_DataDa);
S_Controls.Collections.S_Object s_p_DataA = new S_Controls.Collections.S_Object();
s_p_DataA.ParameterName = "p_DataA";
s_p_DataA.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataA.Direction = ParameterDirection.Input;
s_p_DataA.Index = 2;
s_p_DataA.Size = 10;
s_p_DataA.Value = (CalendarPicker2.Datazione.Text == "")? "":CalendarPicker2.Datazione.Text;
_SCollection.Add(s_p_DataA);
S_Controls.Collections.S_Object s_p_Richiedente = new S_Controls.Collections.S_Object();
s_p_Richiedente.ParameterName = "p_Richiedente";
s_p_Richiedente.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Richiedente.Direction = ParameterDirection.Input;
s_p_Richiedente.Index = 3;
s_p_Richiedente.Size = 50;
s_p_Richiedente.Value = this.Richiedenti1.NomeCompleto;
_SCollection.Add(s_p_Richiedente);
S_Controls.Collections.S_Object s_p_Gruppo = new S_Controls.Collections.S_Object();
s_p_Gruppo.ParameterName = "p_Gruppo";
s_p_Gruppo.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Gruppo.Direction = ParameterDirection.Input;
s_p_Gruppo.Index = 4;
s_p_Gruppo.Value = (cmbsGruppo.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsGruppo.SelectedValue);
_SCollection.Add(s_p_Gruppo);
S_Controls.Collections.S_Object s_p_Descrizione = new S_Controls.Collections.S_Object();
s_p_Descrizione.ParameterName = "p_Descrizione";
s_p_Descrizione.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Descrizione.Direction = ParameterDirection.Input;
s_p_Descrizione.Index = 5;
s_p_Descrizione.Size = 255;
s_p_Descrizione.Value = txtsDescrizione.Text;
_SCollection.Add(s_p_Descrizione);
S_Controls.Collections.S_Object s_p_Priority = new S_Controls.Collections.S_Object();
s_p_Priority.ParameterName = "p_Urgenza";
s_p_Priority.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Priority.Direction = ParameterDirection.Input;
s_p_Priority.Index = 6;
s_p_Priority.Value = (cmbsUrgenza.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsUrgenza.SelectedValue);
_SCollection.Add(s_p_Priority);
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 = 7;
s_p_Servizio.Value = (cmbsServizio.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsServizio.SelectedValue);
_SCollection.Add(s_p_Servizio);
S_Controls.Collections.S_Object s_p_Operatore = new S_Controls.Collections.S_Object();
s_p_Operatore.ParameterName = "p_Operatore";
s_p_Operatore.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Operatore.Direction = ParameterDirection.Input;
s_p_Operatore.Index = 8;
s_p_Operatore.Size = 255;
s_p_Operatore.Value = this.txtsOperatore.Text;
_SCollection.Add(s_p_Operatore);
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 = 9;
s_p_Bl_Id.Value = RicercaModulo1.TxtCodice.Text;
_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 = 10;
s_p_campus.Size = 50;
s_p_campus.Value = RicercaModulo1.TxtRicerca.Text;
_SCollection.Add(s_p_campus);
S_Controls.Collections.S_Object s_p_validazione = new S_Controls.Collections.S_Object();
s_p_validazione.ParameterName = "p_validazione";
s_p_validazione.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_validazione.Direction = ParameterDirection.Input;
s_p_validazione.Index = 11;
s_p_validazione.Value = int.Parse(cmbsvalidazione.SelectedValue);
_SCollection.Add(s_p_validazione);
S_Controls.Collections.S_Object s_p_pageindex = new S_Object();
s_p_pageindex.ParameterName = "pageindex";
s_p_pageindex.DbType = CustomDBType.Integer;
s_p_pageindex.Direction = ParameterDirection.Input;
s_p_pageindex.Index = _SCollection.Count + 1;
s_p_pageindex.Value = DataGridRicerca.CurrentPageIndex + 1;
_SCollection.Add(s_p_pageindex);
S_Controls.Collections.S_Object s_p_pagesize = new S_Object();
s_p_pagesize.ParameterName = "pagesize";
s_p_pagesize.DbType = CustomDBType.Integer;
s_p_pagesize.Direction = ParameterDirection.Input;
s_p_pagesize.Index = _SCollection.Count + 1;
s_p_pagesize.Value = DataGridRicerca.PageSize;
_SCollection.Add(s_p_pagesize);
DataSet _MyDs = _ClManCorrettiva.GetData(_SCollection);
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
DataGridRicerca.Visible = true;
Double _totalPages = 1;
if (reset == true)
{
_SCollection.RemoveAt(_SCollection.Count - 1);
_SCollection.RemoveAt(_SCollection.Count - 1);
_SCollection.RemoveAt(_SCollection.Count - 1);
_SCollection.RemoveAt(_SCollection.Count - 1);
int _totalRecords = _ClManCorrettiva.GetDataCount(_SCollection);;
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
if ((_totalRecords % DataGridRicerca.PageSize) == 0)
{
_totalPages = _totalRecords / DataGridRicerca.PageSize;
}
else
{
_totalPages = (_totalRecords / DataGridRicerca.PageSize) + 1;
}
}
else
{
_totalPages = Double.Parse(this.GridTitle1.NumeroRecords);
}
GridTitle1.Visible = true;
this.DataGridRicerca.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
this.DataGridRicerca.DataBind();
}
private void btnsAggiungi_Click(object sender, System.EventArgs e)
{
this.txtsMotivo.DBDefaultValue = DBNull.Value;
this.txtsMotivo.Text = this.txtsMotivo.Text.Trim();
int i_RowsAffected = 0;
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object s_p_ID_RICHIEDENTE = new S_Controls.Collections.S_Object();
s_p_ID_RICHIEDENTE.ParameterName = "p_ID_RICHIEDENTE";
s_p_ID_RICHIEDENTE.DbType = CustomDBType.Integer;
s_p_ID_RICHIEDENTE.Direction = ParameterDirection.Input;
s_p_ID_RICHIEDENTE.Index = _SCollection.Count;
s_p_ID_RICHIEDENTE.Size = 10;
s_p_ID_RICHIEDENTE.Value = Int32.Parse(RichiedentiSollecito1.s_RichID.Text);
_SCollection.Add(s_p_ID_RICHIEDENTE);
S_Controls.Collections.S_Object s_p_NomeCompleto = new S_Controls.Collections.S_Object();
s_p_NomeCompleto.ParameterName = "p_NomeCompleto";
s_p_NomeCompleto.DbType = CustomDBType.VarChar;
s_p_NomeCompleto.Direction = ParameterDirection.Input;
s_p_NomeCompleto.Index = _SCollection.Count;
s_p_NomeCompleto.Size = 50;
s_p_NomeCompleto.Value = RichiedentiSollecito1.NomeCompleto.ToString();
_SCollection.Add(s_p_NomeCompleto);
S_Controls.Collections.S_Object s_p_CognomeCompleto = new S_Controls.Collections.S_Object();
s_p_CognomeCompleto.ParameterName = "p_CognomeCompleto";
s_p_CognomeCompleto.DbType = CustomDBType.VarChar;
s_p_CognomeCompleto.Direction = ParameterDirection.Input;
s_p_CognomeCompleto.Index = _SCollection.Count;
s_p_CognomeCompleto.Size = 50;
s_p_CognomeCompleto.Value = RichiedentiSollecito1.CognomeCompleto.ToString();
_SCollection.Add(s_p_CognomeCompleto);
S_Controls.Collections.S_Object s_p_Gruppo = new S_Controls.Collections.S_Object();
s_p_Gruppo.ParameterName = "p_ID_Gruppo";
s_p_Gruppo.DbType = CustomDBType.Integer;
s_p_Gruppo.Direction = ParameterDirection.Input;
s_p_Gruppo.Index = _SCollection.Count;
s_p_Gruppo.Size = 50;
s_p_Gruppo.Value = Convert.ToInt32(RichiedentiSollecito1.IdGruppo);
_SCollection.Add(s_p_Gruppo);
S_Controls.Collections.S_Object s_p_Motivo = new S_Controls.Collections.S_Object();
s_p_Motivo.ParameterName = "p_Motivo";
s_p_Motivo.DbType = CustomDBType.VarChar;
s_p_Motivo.Direction = ParameterDirection.Input;
s_p_Motivo.Index = _SCollection.Count;
s_p_Motivo.Size = 50;
s_p_Motivo.Value = txtsMotivo.Text;
_SCollection.Add(s_p_Motivo);
Classi.ManOrdinaria.Solleciti _Solleciti = new TheSite.Classi.ManOrdinaria.Solleciti();
i_RowsAffected = _Solleciti.ExecuteAddSollecito(_SCollection, int.Parse(this.idric));
string jscript = "<script language=JavaScript>\n";
jscript += "var oVDiv=parent.document.getElementById('PopupAddSoll').style;\n";
jscript += "oVDiv.display = 'none';";
jscript += "<";
jscript += "/";
jscript += "script>";
if (!this.IsStartupScriptRegistered("clientScriptChiudi"))
{
this.RegisterStartupScript("clientScriptChiudi", jscript);
}
}
private DsGestioneSpazi recuperaDataSet(DsGestioneSpazi ds)
{
try
{
int index = 0;
Classi.AnalisiStatistiche.wrapDb _IODB = new TheSite.Classi.AnalisiStatistiche.wrapDb();
S_Controls.Collections.S_ControlsCollection _Scollection = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object p_Id_Edificio = new S_Controls.Collections.S_Object();
p_Id_Edificio.ParameterName = "p_Id_Edificio";
p_Id_Edificio.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
p_Id_Edificio.Direction = ParameterDirection.Input;
p_Id_Edificio.Size = 300;
p_Id_Edificio.Index = index++;
p_Id_Edificio.Value = stringaEdifici;
_Scollection.Add(p_Id_Edificio);
S_Controls.Collections.S_Object p_Id_Piano = new S_Controls.Collections.S_Object();
p_Id_Piano.ParameterName = "p_Id_Piano";
p_Id_Piano.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
p_Id_Piano.Direction = ParameterDirection.Input;
p_Id_Piano.Index = index++;
if (piano == "")
{
p_Id_Piano.Value = 0;
}
else
{
p_Id_Piano.Value = Convert.ToInt32(piano);
}
_Scollection.Add(p_Id_Piano);
S_Controls.Collections.S_Object p_Id_Stanza = new S_Controls.Collections.S_Object();
p_Id_Stanza.ParameterName = "p_Id_Stanza";
p_Id_Stanza.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
p_Id_Stanza.Direction = ParameterDirection.Input;
p_Id_Stanza.Size = 255;
p_Id_Stanza.Index = index++;
p_Id_Stanza.Value = stanza;
_Scollection.Add(p_Id_Stanza);
S_Controls.Collections.S_Object p_Str_Dest_Uso = new S_Controls.Collections.S_Object();
p_Str_Dest_Uso.ParameterName = "p_Str_Dest_Uso";
p_Str_Dest_Uso.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
p_Str_Dest_Uso.Direction = ParameterDirection.Input;
p_Str_Dest_Uso.Size = 256;
p_Str_Dest_Uso.Index = index++;
p_Str_Dest_Uso.Value = stringaDestinazione;
_Scollection.Add(p_Str_Dest_Uso);
S_Controls.Collections.S_Object p_Str_Reparto = new S_Controls.Collections.S_Object();
p_Str_Reparto.ParameterName = "p_Str_Reparto";
p_Str_Reparto.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
p_Str_Reparto.Direction = ParameterDirection.Input;
p_Str_Reparto.Size = 255;
p_Str_Reparto.Index = index++;
p_Str_Reparto.Value = stringaReparto;
_Scollection.Add(p_Str_Reparto);
S_Controls.Collections.S_Object p_Str_Cat = new S_Controls.Collections.S_Object();
p_Str_Cat.ParameterName = "p_Str_Cat";
p_Str_Cat.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
p_Str_Cat.Direction = ParameterDirection.Input;
p_Str_Cat.Size = 255;
p_Str_Cat.Index = index++;
p_Str_Cat.Value = idCategoria;
_Scollection.Add(p_Str_Cat);
S_Controls.Collections.S_Object p_Operatore_Area = new S_Controls.Collections.S_Object();
p_Operatore_Area.ParameterName = "p_Operatore_Area";
p_Operatore_Area.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
p_Operatore_Area.Direction = ParameterDirection.Input;
p_Operatore_Area.Size = 255;
p_Operatore_Area.Index = index++;
p_Operatore_Area.Value = operatoreMq;
_Scollection.Add(p_Operatore_Area);
S_Controls.Collections.S_Object p_Int_MQ2 = new S_Controls.Collections.S_Object();
p_Int_MQ2.ParameterName = "p_Int_MQ2";
p_Int_MQ2.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
p_Int_MQ2.Direction = ParameterDirection.Input;
p_Int_MQ2.Index = index++;
if (valoreMq == "")
{
p_Int_MQ2.Value = 0;
}
else
{
p_Int_MQ2.Value = Convert.ToInt32(valoreMq);
}
_Scollection.Add(p_Int_MQ2);
S_Controls.Collections.S_Object IO_CURSOR = new S_Controls.Collections.S_Object();
IO_CURSOR.ParameterName = "IO_CURSOR";
IO_CURSOR.DbType = ApplicationDataLayer.DBType.CustomDBType.Cursor;
IO_CURSOR.Direction = ParameterDirection.Output;
IO_CURSOR.Index = index++;
_Scollection.Add(IO_CURSOR);
_IODB.s_storedProcedureName = "PACK_RPT_GESTIONE_SPAZI." + GetNomeStrPrd();
DataSet _MyDataset = _IODB.GetData(_Scollection).Copy();
SchemiXSD.DsGestioneSpazi.parametriRow rigaParametri = (SchemiXSD.DsGestioneSpazi.parametriRow)ds.parametri.NewRow();
rigaParametri.edifici = stringaEdifici.Replace("','", " ");
rigaParametri.piano = stringaPiano;
rigaParametri.stanza = stringaStanza;
rigaParametri.categoria = stringaCategoria;
rigaParametri.destUso = stringaDestinazione;
rigaParametri.reparto = stringaReparto;
rigaParametri.opMq = operatoreMq;
rigaParametri.Mq = valoreMq;
ds.Tables["parametri"].Rows.Add(rigaParametri);
int i = 0;
string xml = "";
for (i = 0; i <= _MyDataset.Tables[0].Rows.Count - 1; i++)
{
if (!Convert.ToBoolean(S_Misure))
{
ds.Tables["tabellina"].ImportRow(_MyDataset.Tables[0].Rows[i]);
}
else
{
ds.Tables["tabellina2"].ImportRow(_MyDataset.Tables[0].Rows[i]);
}
}
if (i == 0)
{
throw new Eccezioni.NoDataForReportFoundException();
}
xml = ds.GetXml();
return(ds);
}
catch (Eccezioni.NoDataForReportFoundException ex)
{
LabelMessaggio.Text = "Nono sono presenti dati per i criteri di ricerca selezionati";
rptEngineOra.Visible = false;
return(null);
}
catch (Exception ex)
{
//Server.Transfer("Error.aspx?msgErr=" + ex.Message);
throw ex;
//return null;
}
}
private void Ricerca()
{
Classi.ManCorrettiva.Avvisi _Avvisi = new Classi.ManCorrettiva.Avvisi();
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object p_progetto = new S_Controls.Collections.S_Object();
p_progetto.ParameterName = "p_progetto";
p_progetto.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
p_progetto.Direction = ParameterDirection.Input;
p_progetto.Index = _SCollection.Count;
p_progetto.Size = 10;
p_progetto.Value = id_progetto;
// if(RicercaModulo1.cmbProgetto.SelectedValue!="")
// p_progetto.Value = Int16.Parse(RicercaModulo1.cmbProgetto.SelectedValue);
// else
// p_progetto.Value =0;
_SCollection.Add(p_progetto);
S_Controls.Collections.S_Object p_Wr_Id = new S_Controls.Collections.S_Object();
p_Wr_Id.ParameterName = "p_Wr_Id";
p_Wr_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
p_Wr_Id.Direction = ParameterDirection.Input;
p_Wr_Id.Index = _SCollection.Count;
p_Wr_Id.Size = 10;
p_Wr_Id.Value = txtsRichiesta.Text.Trim();
_SCollection.Add(p_Wr_Id);
S_Controls.Collections.S_Object p_Codice_SGA = new S_Controls.Collections.S_Object();
p_Codice_SGA.ParameterName = "p_Codice_SGA";
p_Codice_SGA.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
p_Codice_SGA.Direction = ParameterDirection.Input;
p_Codice_SGA.Index = _SCollection.Count;
p_Codice_SGA.Size = 10;
p_Codice_SGA.Value = txtSGA.Text.Trim();
_SCollection.Add(p_Codice_SGA);
S_Controls.Collections.S_Object s_p_Priority = new S_Controls.Collections.S_Object();
s_p_Priority.ParameterName = "p_Priority";
s_p_Priority.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Priority.Direction = ParameterDirection.Input;
s_p_Priority.Index = _SCollection.Count;
s_p_Priority.Value = (cmbsUrgenza.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsUrgenza.SelectedValue);
_SCollection.Add(s_p_Priority);
S_Controls.Collections.S_Object p_Sede = new S_Controls.Collections.S_Object();
p_Sede.ParameterName = "p_Sede";
p_Sede.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
p_Sede.Direction = ParameterDirection.Input;
p_Sede.Index = _SCollection.Count;
p_Sede.Size = 10;
p_Sede.Value = txtsSede.Text.Trim();
_SCollection.Add(p_Sede);
S_Controls.Collections.S_Object p_percSla = new S_Controls.Collections.S_Object();
p_percSla.ParameterName = "p_percSla";
p_percSla.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
p_percSla.Direction = ParameterDirection.Input;
p_Sede.Index = _SCollection.Count;
p_percSla.Value = (cmbsPerc.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsPerc.SelectedValue);
_SCollection.Add(p_percSla);
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;
p_Sede.Index = _SCollection.Count;
s_p_Bl_Id.Value = RicercaModulo1.TxtCodice.Text;
_SCollection.Add(s_p_Bl_Id);
S_Controls.Collections.S_Object p_id_stato = new S_Controls.Collections.S_Object();
p_id_stato.ParameterName = "p_id_stato";
p_id_stato.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
p_id_stato.Direction = ParameterDirection.Input;
p_id_stato.Index = _SCollection.Count;
p_id_stato.Value = (CmbStato.SelectedValue == string.Empty)? 0:Int32.Parse(CmbStato.SelectedValue);
_SCollection.Add(p_id_stato);
DataSet _MyDs = _Avvisi.GetData(_SCollection).Copy();
//DataSet _MyDs = _Avvisi.GetData().Copy();
if (SortColum != string.Empty)
{
DataView dv = _MyDs.Tables[0].DefaultView;
dv.Sort = SortColum;
this.DataGridRicerca.DataSource = dv;
}
else
{
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
}
DataGridRicerca.Visible = true;
GridTitle1.Visible = true;
if (_MyDs.Tables[0].Rows.Count == 0)
{
DataGridRicerca.CurrentPageIndex = 0;
GridTitle1.DescriptionTitle = "Nessun dato trovato.";
hiddenpinga.Value = "0";
linkRefresh.Visible = false;
}
else
{
linkRefresh.Visible = true;
hiddenpinga.Value = "1";
GridTitle1.DescriptionTitle = "";
int Pagina = 0;
if ((_MyDs.Tables[0].Rows.Count % DataGridRicerca.PageSize) > 0)
{
Pagina++;
}
if (DataGridRicerca.PageCount != Convert.ToInt16((_MyDs.Tables[0].Rows.Count / DataGridRicerca.PageSize) + Pagina))
{
DataGridRicerca.CurrentPageIndex = 0;
}
}
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}
/// <summary>
/// Recupera le apparecchiature legate ad un edificio
/// </summary>
/// <param name="itemId">è il ID BL dell'edificio</param>
/// <returns></returns>
public DataSet GetApparecchiature(int itemId, int id_servizio, int id_piano, int id_stanza, int id_stapp, int id_codapp)
{
DataSet _Ds;
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_id = new S_Controls.Collections.S_Object();
s_p_id.ParameterName = "p_id";
s_p_id.DbType = CustomDBType.Integer;
s_p_id.Direction = ParameterDirection.Input;
s_p_id.Index = CollezioneControlli.Count + 1;
s_p_id.Value = itemId;
CollezioneControlli.Add(s_p_id);
S_Controls.Collections.S_Object s_p_id_servizio = new S_Controls.Collections.S_Object();
s_p_id_servizio.ParameterName = "p_id_servizio";
s_p_id_servizio.DbType = CustomDBType.Integer;
s_p_id_servizio.Direction = ParameterDirection.Input;
s_p_id_servizio.Index = CollezioneControlli.Count + 1;
s_p_id_servizio.Value = id_servizio;
CollezioneControlli.Add(s_p_id_servizio);
S_Controls.Collections.S_Object s_p_id_piano = new S_Controls.Collections.S_Object();
s_p_id_piano.ParameterName = "p_id_piano";
s_p_id_piano.DbType = CustomDBType.Integer;
s_p_id_piano.Direction = ParameterDirection.Input;
s_p_id_piano.Index = CollezioneControlli.Count + 1;
s_p_id_piano.Value = id_piano;
CollezioneControlli.Add(s_p_id_piano);
S_Controls.Collections.S_Object s_p_id_stanza = new S_Controls.Collections.S_Object();
s_p_id_stanza.ParameterName = "p_id_stanza";
s_p_id_stanza.DbType = CustomDBType.Integer;
s_p_id_stanza.Direction = ParameterDirection.Input;
s_p_id_stanza.Index = CollezioneControlli.Count + 1;
s_p_id_stanza.Value = id_stanza;
CollezioneControlli.Add(s_p_id_stanza);
S_Controls.Collections.S_Object s_p_id_stapp = new S_Controls.Collections.S_Object();
s_p_id_stapp.ParameterName = "p_id_stappar";
s_p_id_stapp.DbType = CustomDBType.Integer;
s_p_id_stapp.Direction = ParameterDirection.Input;
s_p_id_stapp.Index = CollezioneControlli.Count + 1;
s_p_id_stapp.Value = id_stapp;
CollezioneControlli.Add(s_p_id_stapp);
S_Controls.Collections.S_Object s_p_id_codapp = new S_Controls.Collections.S_Object();
s_p_id_codapp.ParameterName = "p_id_codapp";
s_p_id_codapp.DbType = CustomDBType.Integer;
s_p_id_codapp.Direction = ParameterDirection.Input;
s_p_id_codapp.Index = CollezioneControlli.Count + 1;
s_p_id_codapp.Value = id_codapp;
CollezioneControlli.Add(s_p_id_codapp);
S_Controls.Collections.S_Object s_Cursor = new S_Object();
s_Cursor.ParameterName = "IO_CURSOR";
s_Cursor.DbType = CustomDBType.Cursor;
s_Cursor.Direction = ParameterDirection.Output;
s_Cursor.Index = CollezioneControlli.Count + 1;
CollezioneControlli.Add(s_Cursor);
ApplicationDataLayer.OracleDataLayer _OraDl = new OracleDataLayer(s_ConnStr);
string s_StrSql = "PACK_DATITECNICIAPP.SP_GETAPPARECCHIATURE";
_Ds = _OraDl.GetRows(CollezioneControlli, s_StrSql).Copy();
return(_Ds);
}
private void Execute()
{
S_Controls.Collections.S_ControlsCollection CollezioneControlli = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object s_p_eq_std = new S_Controls.Collections.S_Object();
s_p_eq_std.ParameterName = "p_eq_std";
s_p_eq_std.DbType = CustomDBType.VarChar;
s_p_eq_std.Direction = ParameterDirection.Input;
s_p_eq_std.Index = 0;
s_p_eq_std.Value = this.eq_id;
s_p_eq_std.Size = 50;
CollezioneControlli.Add(s_p_eq_std);
Classi.ClassiDettaglio.SchedaApparecchiatura _SchedaApparecchiatura = new Classi.ClassiDettaglio.SchedaApparecchiatura("");
DataSet Ds = _SchedaApparecchiatura.GetData(CollezioneControlli);
if (Ds.Tables[0].Rows.Count > 0)
{
S_lblcodicecomponente.Text = Ds.Tables[0].Rows[0]["var_eq_eq_id"].ToString();
S_lblstdapparecchiature.Text = Ds.Tables[0].Rows[0]["var_eqstd_description"].ToString();
S_lblcodiceedificio.Text = Ds.Tables[0].Rows[0]["var_eq_bl_id"].ToString();
S_lbledificio.Text = Ds.Tables[0].Rows[0]["var_bl_name"].ToString();
S_lblpiano.Text = Ds.Tables[0].Rows[0]["var_eq_fl_id"].ToString();
try
{
S_lblstanza.Text = Ds.Tables[0].Rows[0]["stanza"].ToString();
S_lblqta.Text = Ds.Tables[0].Rows[0]["quantita"].ToString();
S_LblStato.Text = Ds.Tables[0].Rows[0]["var_eq_condition"].ToString();
}
catch (Exception ex)
{ Response.Write(ex.Message); }
S_lbltecnico.Text = Ds.Tables[0].Rows[0]["var_sottocomponente"].ToString();
S_lblmarca.Text = Ds.Tables[0].Rows[0]["var_vn_id"].ToString();
S_lblmodello.Text = Ds.Tables[0].Rows[0]["var_eq_option1"].ToString();
S_lbltipo.Text = Ds.Tables[0].Rows[0]["var_eq_option2"].ToString();
//nome del file imagine
Imagename += Ds.Tables[0].Rows[0]["var_eq_image_eq_assy"].ToString();
BindAttivita(Ds.Tables[0].Rows[0]["var_eqstd_id"].ToString());
//Dati tecnici
Classi.ClassiDettaglio.DatiTecniciApparecchiatura _DatiTecniciApparecchiatura = new Classi.ClassiDettaglio.DatiTecniciApparecchiatura(Context.User.Identity.Name);
DataSet _DsTemp;
//Da Cambiare
IDEQ = Convert.ToInt32(Ds.Tables[0].Rows[0]["var_eq_id"]);
_DsTemp = _DatiTecniciApparecchiatura.GetSingleDatitecnici(IDEQ);
if (_DsTemp.Tables[0].Rows.Count > 0)
{
//DescrizioniTecniche((string)Ds.Tables[0].Rows[0]["var_eq_comments"]);
DataList1.DataSource = _DsTemp;
DataList1.DataBind();
}
else
{
DataPanelCaratteristiche.TitleText = "Nessuna Caratteristica Tecnica";
}
}
else
{
S_lblcodicecomponente.Text = "";
S_lblstdapparecchiature.Text = "";
S_lblcodiceedificio.Text = "";
S_lbledificio.Text = "";
S_lblpiano.Text = "";
S_lbltecnico.Text = "";
S_lblmarca.Text = "";
S_lblmodello.Text = "";
S_lbltipo.Text = "";
}
}
private S_ControlsCollection CreaCriteri()
{
S_ControlsCollection _SCollection = new 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 = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Bl_Id.Direction = ParameterDirection.Input;
s_p_Bl_Id.Size = 50;
s_p_Bl_Id.Index = 0;
s_p_Bl_Id.Value = RicercaModulo1.TxtCodice.Text;
_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 = 1;
s_p_campus.Size = 50;
s_p_campus.Value = RicercaModulo1.TxtRicerca.Text;
_SCollection.Add(s_p_campus);
S_Controls.Collections.S_Object s_p_Wr_Id = new S_Controls.Collections.S_Object();
s_p_Wr_Id.ParameterName = "p_Wr_Id";
s_p_Wr_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wr_Id.Direction = ParameterDirection.Input;
s_p_Wr_Id.Index = 2;
s_p_Wr_Id.Size = 50;
s_p_Wr_Id.Value = (this.txtsRichiesta.Text == "")?0:Int32.Parse(this.txtsRichiesta.Text);
_SCollection.Add(s_p_Wr_Id);
S_Controls.Collections.S_Object s_p_Addetto = new S_Controls.Collections.S_Object();
s_p_Addetto.ParameterName = "p_Addetto";
s_p_Addetto.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Addetto.Direction = ParameterDirection.Input;
s_p_Addetto.Index = 3;
s_p_Addetto.Size = 50;
s_p_Addetto.Value = this.Addetti1.NomeCompleto;
_SCollection.Add(s_p_Addetto);
S_Controls.Collections.S_Object s_p_DataDa = new S_Controls.Collections.S_Object();
s_p_DataDa.ParameterName = "p_DataDa";
s_p_DataDa.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataDa.Direction = ParameterDirection.Input;
s_p_DataDa.Index = 4;
s_p_DataDa.Size = 10;
s_p_DataDa.Value = (CalendarPicker1.Datazione.Text == "")? "":CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_DataDa);
S_Controls.Collections.S_Object s_p_DataA = new S_Controls.Collections.S_Object();
s_p_DataA.ParameterName = "p_DataA";
s_p_DataA.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataA.Direction = ParameterDirection.Input;
s_p_DataA.Index = 5;
s_p_DataA.Size = 10;
s_p_DataA.Value = (CalendarPicker2.Datazione.Text == "")? "":CalendarPicker2.Datazione.Text;
_SCollection.Add(s_p_DataA);
S_Controls.Collections.S_Object s_p_Wo_Id = new S_Controls.Collections.S_Object();
s_p_Wo_Id.ParameterName = "p_Wo_Id";
s_p_Wo_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wo_Id.Direction = ParameterDirection.Input;
s_p_Wo_Id.Index = 6;
s_p_Wo_Id.Size = 50;
s_p_Wo_Id.Value = (this.txtsOrdine.Text == "")?0:Int32.Parse(this.txtsOrdine.Text);
_SCollection.Add(s_p_Wo_Id);
S_Controls.Collections.S_Object s_p_Servizio = new S_Controls.Collections.S_Object();
s_p_Servizio.ParameterName = "p_ID_Servizio";
s_p_Servizio.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Servizio.Direction = ParameterDirection.Input;
s_p_Servizio.Index = 7;
s_p_Servizio.Value = (cmbsServizio.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsServizio.SelectedValue);
_SCollection.Add(s_p_Servizio);
S_Controls.Collections.S_Object s_p_Status = new S_Controls.Collections.S_Object();
s_p_Status.ParameterName = "p_Status";
s_p_Status.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Status.Direction = ParameterDirection.Input;
s_p_Status.Index = 8;
if (HiddenVisible.Value == "1")
{
s_p_Status.Value = 3;
}
else
{
s_p_Status.Value = (cmbsStatus.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsStatus.SelectedValue);
}
_SCollection.Add(s_p_Status);
S_Controls.Collections.S_Object s_p_Richiedente = new S_Controls.Collections.S_Object();
s_p_Richiedente.ParameterName = "p_Richiedente";
s_p_Richiedente.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Richiedente.Direction = ParameterDirection.Input;
s_p_Richiedente.Index = 9;
s_p_Richiedente.Size = 50;
s_p_Richiedente.Value = this.Richiedenti1.NomeCompleto;
_SCollection.Add(s_p_Richiedente);
S_Controls.Collections.S_Object s_p_Priority = new S_Controls.Collections.S_Object();
s_p_Priority.ParameterName = "p_Priority";
s_p_Priority.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Priority.Direction = ParameterDirection.Input;
s_p_Priority.Index = 10;
s_p_Priority.Value = (cmbsUrgenza.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsUrgenza.SelectedValue);
_SCollection.Add(s_p_Priority);
S_Controls.Collections.S_Object s_p_Descrizione = new S_Controls.Collections.S_Object();
s_p_Descrizione.ParameterName = "p_Descrizione";
s_p_Descrizione.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Descrizione.Direction = ParameterDirection.Input;
s_p_Descrizione.Index = 11;
s_p_Descrizione.Size = 255;
s_p_Descrizione.Value = txtDescrizione.Text;
_SCollection.Add(s_p_Descrizione);
S_Controls.Collections.S_Object s_p_Gruppo = new S_Controls.Collections.S_Object();
s_p_Gruppo.ParameterName = "p_Gruppo";
s_p_Gruppo.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Gruppo.Direction = ParameterDirection.Input;
s_p_Gruppo.Index = 12;
s_p_Gruppo.Value = (cmbsGruppo.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsGruppo.SelectedValue);
_SCollection.Add(s_p_Gruppo);
if (HiddenVisible.Value == "3")
{
S_Controls.Collections.S_Object s_p_RDL_PADRE = new S_Controls.Collections.S_Object();
s_p_RDL_PADRE.ParameterName = "p_RDL_PADRE";
s_p_RDL_PADRE.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_RDL_PADRE.Direction = ParameterDirection.Input;
s_p_RDL_PADRE.Index = 13;
s_p_RDL_PADRE.Size = 50;
s_p_RDL_PADRE.Value = (this.txtRdl.Text == "")?0:Int32.Parse(this.txtRdl.Text);
_SCollection.Add(s_p_RDL_PADRE);
}
return(_SCollection);
}
private void InserisciAssociazioni()
{
DataTable o_Dt = (DataTable)Session["Edifici"];
try
{
foreach (DataRow riga in o_Dt.Rows)
{
bool esegui = false;
string funzione = "";
int valore = 0;
if (riga.RowState == DataRowState.Deleted)
{
funzione = "Delete";
esegui = true;
valore = Convert.ToInt32(riga["id", DataRowVersion.Original].ToString());
}
if (riga.RowState == DataRowState.Added)
{
funzione = "Insert";
esegui = true;
valore = Convert.ToInt32(riga["id", DataRowVersion.Default].ToString());
}
if (esegui)
{
Classi.MailSend _MailSend = new TheSite.Classi.MailSend();
S_Controls.Collections.S_ControlsCollection _SColl = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object s_Ruolo = new S_Controls.Collections.S_Object();
s_Ruolo.ParameterName = "p_email_Id";
s_Ruolo.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Ruolo.Direction = ParameterDirection.Input;
s_Ruolo.Index = 0;
s_Ruolo.Value = itemId;
S_Controls.Collections.S_Object s_Edificio_Id = new S_Controls.Collections.S_Object();
s_Edificio_Id.ParameterName = "p_Edificio_Id";
s_Edificio_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Edificio_Id.Direction = ParameterDirection.Input;
s_Edificio_Id.Index = 1;
s_Edificio_Id.Value = valore;
S_Controls.Collections.S_Object s_Operazione = new S_Object();
s_Operazione.ParameterName = "p_Operazione";
s_Operazione.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_Operazione.Direction = ParameterDirection.Input;
s_Operazione.Index = 2;
s_Operazione.Value = funzione;
S_Controls.Collections.S_Object s_IdOut = new S_Object();
s_IdOut.ParameterName = "p_IdOut";
s_IdOut.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_IdOut.Direction = ParameterDirection.Output;
s_IdOut.Index = 3;
_SColl.Add(s_Ruolo);
_SColl.Add(s_Edificio_Id);
_SColl.Add(s_Operazione);
_SColl.Add(s_IdOut);
_MailSend.UpdateEmailEdifici(_SColl);
}
}
}
catch (Exception ex)
{
string s_Err = ex.Message.ToString().ToUpper();
PanelMess.ShowError(s_Err, true);
}
}
public DataSet GetWordExcel(Classi.TipoManutenzioneType t)
{
Classi.AnagrafeImpianti.Apparecchiature _Richiesta = new TheSite.Classi.AnagrafeImpianti.Apparecchiature();
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_Wr_Id = new S_Controls.Collections.S_Object();
s_p_Wr_Id.ParameterName = "p_Wr_Id";
s_p_Wr_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wr_Id.Direction = ParameterDirection.Input;
s_p_Wr_Id.Index = 2;
s_p_Wr_Id.Size = 50;
s_p_Wr_Id.Value = (this.txtsRichiesta.Text == "")?0:Int32.Parse(this.txtsRichiesta.Text);
_SCollection.Add(s_p_Wr_Id);
S_Controls.Collections.S_Object s_p_Addetto = new S_Controls.Collections.S_Object();
s_p_Addetto.ParameterName = "p_Addetto";
s_p_Addetto.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Addetto.Direction = ParameterDirection.Input;
s_p_Addetto.Index = 3;
s_p_Addetto.Size = 50;
s_p_Addetto.Value = this.Addetti1.NomeCompleto;
_SCollection.Add(s_p_Addetto);
S_Controls.Collections.S_Object s_p_DataDa = new S_Controls.Collections.S_Object();
s_p_DataDa.ParameterName = "p_DataDa";
s_p_DataDa.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataDa.Direction = ParameterDirection.Input;
s_p_DataDa.Index = 4;
s_p_DataDa.Size = 10;
s_p_DataDa.Value = (CalendarPicker1.Datazione.Text == "")? "":CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_DataDa);
S_Controls.Collections.S_Object s_p_DataA = new S_Controls.Collections.S_Object();
s_p_DataA.ParameterName = "p_DataA";
s_p_DataA.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataA.Direction = ParameterDirection.Input;
s_p_DataA.Index = 5;
s_p_DataA.Size = 10;
s_p_DataA.Value = (CalendarPicker2.Datazione.Text == "")? "":CalendarPicker2.Datazione.Text;
_SCollection.Add(s_p_DataA);
S_Controls.Collections.S_Object s_p_Wo_Id = new S_Controls.Collections.S_Object();
s_p_Wo_Id.ParameterName = "p_Wo_Id";
s_p_Wo_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wo_Id.Direction = ParameterDirection.Input;
s_p_Wo_Id.Index = 6;
s_p_Wo_Id.Size = 50;
s_p_Wo_Id.Value = (this.txtsOrdine.Text == "")?0:Int32.Parse(this.txtsOrdine.Text);
_SCollection.Add(s_p_Wo_Id);
S_Controls.Collections.S_Object s_p_Status = new S_Controls.Collections.S_Object();
s_p_Status.ParameterName = "p_Status";
s_p_Status.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Status.Direction = ParameterDirection.Input;
s_p_Status.Index = 8;
s_p_Status.Value = (cmbsStatus.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsStatus.SelectedValue);
_SCollection.Add(s_p_Status);
S_Controls.Collections.S_Object s_p_eq = new S_Controls.Collections.S_Object();
s_p_eq.ParameterName = "p_eq";
s_p_eq.DbType = CustomDBType.Integer;
s_p_eq.Direction = ParameterDirection.Input;
s_p_eq.Index = 9;
s_p_eq.Value = this.eq_id;
s_p_eq.Size = 50;
_SCollection.Add(s_p_eq);
S_Controls.Collections.S_Object s_TipoManutenzione = new S_Controls.Collections.S_Object();
s_TipoManutenzione.ParameterName = "p_TipoManutenzione";
s_TipoManutenzione.DbType = CustomDBType.Integer;
s_TipoManutenzione.Direction = ParameterDirection.Input;
s_TipoManutenzione.Index = 10;
s_TipoManutenzione.Size = 4;
s_TipoManutenzione.Value = t;
_SCollection.Add(s_TipoManutenzione);
return(_Richiesta.GetSfogliaRDLEQ(_SCollection).Copy());
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="Operazione"></param>
/// <param name="cmbFunzioni"></param>
/// <param name="ckbLettura"></param>
/// <param name="ckbInserimento"></param>
/// <param name="ckbModifica"></param>
/// <param name="ckbCancellazione"></param>
/// <returns></returns>
private int ExecuteRuoliFunzioni(int id, Classi.ExecuteType Operazione, S_Controls.S_ComboBox cmbFunzioni,
S_Controls.S_CheckBox ckbLettura, S_Controls.S_CheckBox ckbInserimento,
S_Controls.S_CheckBox ckbModifica, S_Controls.S_CheckBox ckbCancellazione)
{
int i_Result = 0;
Classi.Ruolo _Ruolo = new TheSite.Classi.Ruolo();
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object s_Id = new S_Controls.Collections.S_Object();
s_Id.ParameterName = "p_Funzione_Ruoli_Id";
s_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Id.Direction = ParameterDirection.Input;
s_Id.Index = 0;
s_Id.Value = id;
S_Controls.Collections.S_Object s_FunzioneId = new S_Controls.Collections.S_Object();
s_FunzioneId.ParameterName = "p_Funzione_Id";
s_FunzioneId.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_FunzioneId.Direction = ParameterDirection.Input;
s_FunzioneId.Index = 1;
if (cmbFunzioni != null)
{
s_FunzioneId.Value = cmbFunzioni.SelectedValue;
}
else
{
s_FunzioneId.Value = DBNull.Value;
}
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 = 2;
s_RuoloId.Value = itemId;;
S_Controls.Collections.S_Object s_Lettura = new S_Controls.Collections.S_Object();
s_Lettura.ParameterName = "p_Lettura";
s_Lettura.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Lettura.Direction = ParameterDirection.Input;
s_Lettura.Index = 3;
if (ckbLettura != null)
{
s_Lettura.Value = Convert.ToInt32(ckbLettura.Checked) * (-1);
}
else
{
s_Lettura.Value = DBNull.Value;
}
S_Controls.Collections.S_Object s_Inserimento = new S_Controls.Collections.S_Object();
s_Inserimento.ParameterName = "p_Inserimento";
s_Inserimento.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Inserimento.Direction = ParameterDirection.Input;
s_Inserimento.Index = 4;
if (ckbLettura != null)
{
s_Inserimento.Value = Convert.ToInt32(ckbInserimento.Checked) * (-1);
}
else
{
s_Inserimento.Value = DBNull.Value;
}
S_Controls.Collections.S_Object s_Modifica = new S_Controls.Collections.S_Object();
s_Modifica.ParameterName = "p_Modifica";
s_Modifica.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Modifica.Direction = ParameterDirection.Input;
s_Modifica.Index = 5;
if (ckbLettura != null)
{
s_Modifica.Value = Convert.ToInt32(ckbModifica.Checked) * (-1);
}
else
{
s_Modifica.Value = DBNull.Value;
}
S_Controls.Collections.S_Object s_Cancellazione = new S_Controls.Collections.S_Object();
s_Cancellazione.ParameterName = "p_Cancellazione";
s_Cancellazione.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Cancellazione.Direction = ParameterDirection.Input;
s_Cancellazione.Index = 6;
if (ckbLettura != null)
{
s_Cancellazione.Value = Convert.ToInt32(ckbCancellazione.Checked) * (-1);
}
else
{
s_Cancellazione.Value = DBNull.Value;
}
_SCollection.Add(s_Id);
_SCollection.Add(s_FunzioneId);
_SCollection.Add(s_RuoloId);
_SCollection.Add(s_Lettura);
_SCollection.Add(s_Inserimento);
_SCollection.Add(s_Modifica);
_SCollection.Add(s_Cancellazione);
try
{
i_Result = _Ruolo.UpdateFunzioni(_SCollection, Operazione);
}
catch (Exception ex)
{
string s_Err = ex.Message.ToString().ToUpper();
PanelMess.ShowError(s_Err, true);
i_Result = 0;
}
return(i_Result);
}
private void S_BUTTON1_Click(object sender, System.EventArgs e)
{
//Ricerca();
///Istanzio un nuovo oggetto Collection per aggiungere i parametri
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
//Id_WR
S_Controls.Collections.S_Object s_p_wrid = new S_Controls.Collections.S_Object();
s_p_wrid.ParameterName = "p_wrid";
s_p_wrid.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_wrid.Direction = ParameterDirection.Input;
s_p_wrid.Size = 50;
s_p_wrid.Index = _SCollection.Count;
s_p_wrid.Value = (txtRdl.Text == string.Empty)? 0:Int32.Parse(txtRdl.Text);
_SCollection.Add(s_p_wrid);
//id_materiale
S_Controls.Collections.S_Object s_p_id_materiale = new S_Controls.Collections.S_Object();
s_p_id_materiale.ParameterName = "p_id_materiale";
s_p_id_materiale.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_id_materiale.Direction = ParameterDirection.Input;
s_p_id_materiale.Size = 50;
s_p_id_materiale.Index = _SCollection.Count;
s_p_id_materiale.Value = Convert.ToInt32(cmbsMateriale.SelectedValue.ToString().Split(';')[0]);
_SCollection.Add(s_p_id_materiale);
//data aggiornamento Dal
S_Controls.Collections.S_Object s_p_dataaggiornamentoDal = new S_Controls.Collections.S_Object();
s_p_dataaggiornamentoDal.ParameterName = "p_dataaggiornamentoDal";
s_p_dataaggiornamentoDal.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_dataaggiornamentoDal.Direction = ParameterDirection.Input;
s_p_dataaggiornamentoDal.Size = 50;
s_p_dataaggiornamentoDal.Index = _SCollection.Count;
s_p_dataaggiornamentoDal.Value = CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_dataaggiornamentoDal);
//data aggiornamento Al
S_Controls.Collections.S_Object s_p_dataaggiornamentoAl = new S_Controls.Collections.S_Object();
s_p_dataaggiornamentoAl.ParameterName = "p_dataaggiornamentoAl";
s_p_dataaggiornamentoAl.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_dataaggiornamentoAl.Direction = ParameterDirection.Input;
s_p_dataaggiornamentoAl.Size = 50;
s_p_dataaggiornamentoAl.Index = _SCollection.Count;
s_p_dataaggiornamentoAl.Value = CalendarPicker2.Datazione.Text;
_SCollection.Add(s_p_dataaggiornamentoAl);
//Id stato
S_Controls.Collections.S_Object s_p_stato = new S_Controls.Collections.S_Object();
s_p_stato.ParameterName = "p_stato";
s_p_stato.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_stato.Direction = ParameterDirection.Input;
s_p_stato.Size = 50;
s_p_stato.Index = _SCollection.Count;
s_p_stato.Value = Convert.ToInt32(cmbsStato.SelectedValue);
_SCollection.Add(s_p_stato);
TheSite.Classi.ManCorrettiva.AnalisiCostiMateriali _Materiali = new TheSite.Classi.ManCorrettiva.AnalisiCostiMateriali();
///Eseguo il Binding sulla Griglia.
DataSet Ds = _Materiali.GetData1(_SCollection);
DataTable _dt = Ds.Tables[0];
if (_dt.Rows.Count != 0)
{
Csy.WebControls.Export _objExport = new Csy.WebControls.Export();
_objExport.ExportDetails(_dt, Csy.WebControls.Export.ExportFormat.Excel, "exp.xls");
}
else
{
String scriptString = "<script language=JavaScript>alert('Nessun elemento da esportare');";
scriptString += "<";
scriptString += "/";
scriptString += "script>";
if (!this.IsClientScriptBlockRegistered("clientScriptexp"))
{
this.RegisterStartupScript("clientScriptexp", scriptString);
}
}
}
// Paolo
public S_ControlsCollection creaParam()
{
S_ControlsCollection _SCollection = new 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 = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Bl_Id.Direction = ParameterDirection.Input;
s_p_Bl_Id.Size = 8;
s_p_Bl_Id.Index = 0;
s_p_Bl_Id.Value = RicercaModulo1.TxtCodice.Text;
_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 = 1;
s_p_campus.Size = 50;
s_p_campus.Value = RicercaModulo1.TxtRicerca.Text;
_SCollection.Add(s_p_campus);
S_Controls.Collections.S_Object s_p_piano_id = new S_Controls.Collections.S_Object();
s_p_piano_id.ParameterName = "p_piano_id";
s_p_piano_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_piano_id.Direction = ParameterDirection.Input;
s_p_piano_id.Size = 8;
s_p_piano_id.Index = 2;
s_p_piano_id.Value = (cmbsPiano.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsPiano.SelectedValue);
_SCollection.Add(s_p_piano_id);
S_Controls.Collections.S_Object s_p_nomefile = new S_Controls.Collections.S_Object();
s_p_nomefile.ParameterName = "p_nomefile";
s_p_nomefile.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_nomefile.Direction = ParameterDirection.Input;
s_p_nomefile.Index = 3;
s_p_nomefile.Size = 50;
s_p_nomefile.Value = S_txtnomefile.Text;
_SCollection.Add(s_p_nomefile);
S_Controls.Collections.S_Object s_p_desc_file = new S_Controls.Collections.S_Object();
s_p_desc_file.ParameterName = "p_desc_file";
s_p_desc_file.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_desc_file.Direction = ParameterDirection.Input;
s_p_desc_file.Size = 255;
s_p_desc_file.Index = 4;
s_p_desc_file.Value = S_txtdescrizione.Text;
_SCollection.Add(s_p_desc_file);
S_Controls.Collections.S_Object s_p_categoria = new S_Controls.Collections.S_Object();
s_p_categoria.ParameterName = "p_categoria";
s_p_categoria.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_categoria.Direction = ParameterDirection.Input;
s_p_categoria.Size = 8;
s_p_categoria.Index = 5;
s_p_categoria.Value = (S_CbCategoria.SelectedValue == string.Empty)? 0:Int32.Parse(S_CbCategoria.SelectedValue);
_SCollection.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 = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_tipologia.Direction = ParameterDirection.Input;
s_p_tipologia.Size = 8;
s_p_tipologia.Index = 6;
s_p_tipologia.Value = (S_CbTipologia.SelectedValue == string.Empty)? 0:Int32.Parse(S_CbTipologia.SelectedValue);
_SCollection.Add(s_p_tipologia);
S_Controls.Collections.S_Object s_p_tipo = new S_Controls.Collections.S_Object();
s_p_tipo.ParameterName = "p_tipo";
s_p_tipo.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_tipo.Direction = ParameterDirection.Input;
s_p_tipo.Size = 8;
s_p_tipo.Index = 7;
s_p_tipo.Value = (S_CmbTipologia.SelectedValue == string.Empty)? 0:Int32.Parse(S_CmbTipologia.SelectedValue);
_SCollection.Add(s_p_tipo);
return(_SCollection);
}
private void Ricerca()
{
///Istanzio un nuovo oggetto Collection per aggiungere i parametri
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
//Id_WR
S_Controls.Collections.S_Object s_p_wrid = new S_Controls.Collections.S_Object();
s_p_wrid.ParameterName = "p_wrid";
s_p_wrid.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_wrid.Direction = ParameterDirection.Input;
s_p_wrid.Size = 50;
s_p_wrid.Index = _SCollection.Count;
s_p_wrid.Value = (txtRdl.Text == string.Empty)? 0:Int32.Parse(txtRdl.Text);
_SCollection.Add(s_p_wrid);
//id_materiale
S_Controls.Collections.S_Object s_p_id_materiale = new S_Controls.Collections.S_Object();
s_p_id_materiale.ParameterName = "p_id_materiale";
s_p_id_materiale.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_id_materiale.Direction = ParameterDirection.Input;
s_p_id_materiale.Size = 50;
s_p_id_materiale.Index = _SCollection.Count;
s_p_id_materiale.Value = Convert.ToInt32(cmbsMateriale.SelectedValue.ToString().Split(';')[0]);
_SCollection.Add(s_p_id_materiale);
//data aggiornamento Dal
S_Controls.Collections.S_Object s_p_dataaggiornamentoDal = new S_Controls.Collections.S_Object();
s_p_dataaggiornamentoDal.ParameterName = "p_dataaggiornamentoDal";
s_p_dataaggiornamentoDal.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_dataaggiornamentoDal.Direction = ParameterDirection.Input;
s_p_dataaggiornamentoDal.Size = 50;
s_p_dataaggiornamentoDal.Index = _SCollection.Count;
s_p_dataaggiornamentoDal.Value = CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_dataaggiornamentoDal);
//data aggiornamento Al
S_Controls.Collections.S_Object s_p_dataaggiornamentoAl = new S_Controls.Collections.S_Object();
s_p_dataaggiornamentoAl.ParameterName = "p_dataaggiornamentoAl";
s_p_dataaggiornamentoAl.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_dataaggiornamentoAl.Direction = ParameterDirection.Input;
s_p_dataaggiornamentoAl.Size = 50;
s_p_dataaggiornamentoAl.Index = _SCollection.Count;
s_p_dataaggiornamentoAl.Value = CalendarPicker2.Datazione.Text;
_SCollection.Add(s_p_dataaggiornamentoAl);
//Id stato
S_Controls.Collections.S_Object s_p_stato = new S_Controls.Collections.S_Object();
s_p_stato.ParameterName = "p_stato";
s_p_stato.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_stato.Direction = ParameterDirection.Input;
s_p_stato.Size = 50;
s_p_stato.Index = _SCollection.Count;
s_p_stato.Value = Convert.ToInt32(cmbsStato.SelectedValue);
_SCollection.Add(s_p_stato);
TheSite.Classi.ManCorrettiva.AnalisiCostiMateriali _Materiali = new TheSite.Classi.ManCorrettiva.AnalisiCostiMateriali();
///Eseguo il Binding sulla Griglia.
DataSet Ds = _Materiali.GetData(_SCollection);
if (Ds.Tables[0].Rows.Count >= 0)
{
DataGridRicerca.Visible = true;
lblRecord.Text = "";
DataTable dt = Ds.Tables[0];
string curCat;
string prevCat = string.Empty;
int i = 0;
int QtaIn = 0;
int QtaOut = 0;
while (i <= dt.Rows.Count - 1)
{
curCat = dt.Rows[i]["ID_MATERIALE"].ToString();
if (i == 0)
{
prevCat = dt.Rows[i]["ID_MATERIALE"].ToString();
}
if (curCat != prevCat)
{
prevCat = curCat;
DataRow shRow = dt.NewRow();
shRow["Descrizione"] = "Materiale";
shRow["prezzo_unitario"] = QtaIn;
shRow["totale"] = QtaOut;
shRow["quantita"] = QtaIn + QtaOut;
shRow["id"] = -1;
dt.Rows.InsertAt(shRow, i);
QtaIn = 0;
QtaOut = 0;
i += 1;
}
if (Convert.ToInt32(dt.Rows[i]["quantita"]) > 0)
{
QtaIn += Convert.ToInt32(dt.Rows[i]["quantita"]);
}
else
{
QtaOut += Convert.ToInt32(dt.Rows[i]["quantita"]);
}
i += 1;
}
if (dt.Rows.Count > 0)
{
DataRow shRow = dt.NewRow();
shRow["Descrizione"] = "Materiale";
shRow["prezzo_unitario"] = QtaIn;
shRow["totale"] = QtaOut;
shRow["quantita"] = QtaIn + QtaOut;
shRow["id"] = -1;
dt.Rows.InsertAt(shRow, i);
}
DataGridRicerca.DataSource = dt;
lblRecord.Text = (Ds.Tables[0].Rows.Count) == 0? "0":Ds.Tables[0].Rows.Count.ToString();
DataGridRicerca.DataBind();
}
else
{
lblRecord.Text = "Nessun dato trovato.";
DataGridRicerca.Visible = false;
}
DataGridRicerca.ShowFooter = false;
}
/// <summary>
/// Esegue la queri di ricerca
/// </summary>
private void Execute()
{
S_Controls.Collections.S_ControlsCollection _SCollection = 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 = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Bl_Id.Direction = ParameterDirection.Input;
s_p_Bl_Id.Size = 8;
s_p_Bl_Id.Index = 0;
s_p_Bl_Id.Value = RicercaModulo1.TxtCodice.Text;
_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 = 1;
s_p_campus.Size = 50;
s_p_campus.Value = RicercaModulo1.TxtRicerca.Text;
_SCollection.Add(s_p_campus);
S_Controls.Collections.S_Object s_p_piano_id = new S_Controls.Collections.S_Object();
s_p_piano_id.ParameterName = "p_piano_id";
s_p_piano_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_piano_id.Direction = ParameterDirection.Input;
s_p_piano_id.Size = 8;
s_p_piano_id.Index = 2;
s_p_piano_id.Value = (cmbsPiano.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsPiano.SelectedValue);
_SCollection.Add(s_p_piano_id);
S_Controls.Collections.S_Object s_p_nomefile = new S_Controls.Collections.S_Object();
s_p_nomefile.ParameterName = "p_nomefile";
s_p_nomefile.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_nomefile.Direction = ParameterDirection.Input;
s_p_nomefile.Index = 3;
s_p_nomefile.Size = 50;
s_p_nomefile.Value = S_txtnomefile.Text;
_SCollection.Add(s_p_nomefile);
S_Controls.Collections.S_Object s_p_desc_file = new S_Controls.Collections.S_Object();
s_p_desc_file.ParameterName = "p_desc_file";
s_p_desc_file.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_desc_file.Direction = ParameterDirection.Input;
s_p_desc_file.Size = 255;
s_p_desc_file.Index = 4;
s_p_desc_file.Value = S_txtdescrizione.Text;
_SCollection.Add(s_p_desc_file);
S_Controls.Collections.S_Object s_p_categoria = new S_Controls.Collections.S_Object();
s_p_categoria.ParameterName = "p_categoria";
s_p_categoria.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_categoria.Direction = ParameterDirection.Input;
s_p_categoria.Size = 8;
s_p_categoria.Index = 5;
s_p_categoria.Value = (S_CbCategoria.SelectedValue == string.Empty)? 0:Int32.Parse(S_CbCategoria.SelectedValue);
_SCollection.Add(s_p_categoria);
S_Controls.Collections.S_Object s_p_tipo = new S_Controls.Collections.S_Object();
s_p_tipo.ParameterName = "p_tipo";
s_p_tipo.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_tipo.Direction = ParameterDirection.Input;
s_p_tipo.Size = 8;
s_p_tipo.Index = 6;
s_p_tipo.Value = (S_CmbTipologia.SelectedValue == string.Empty)? 0:Int32.Parse(S_CmbTipologia.SelectedValue);
_SCollection.Add(s_p_tipo);
//********************************************
Classi.AnagrafeImpianti.AnagrafeServizi _AnagrafeServizi = new Classi.AnagrafeImpianti.AnagrafeServizi(Context.User.Identity.Name);
DataSet _MyDs = _AnagrafeServizi.GetData(_SCollection);
GridTitle1.Visible = true;
DataGrid1.DataSource = _MyDs;
if (_MyDs.Tables[0].Rows.Count > 0)
{
int Pagina = 0;
if ((_MyDs.Tables[0].Rows.Count % DataGrid1.PageSize) > 0)
{
Pagina++;
}
if (DataGrid1.PageCount != Convert.ToInt16((_MyDs.Tables[0].Rows.Count / DataGrid1.PageSize) + Pagina))
{
DataGrid1.CurrentPageIndex = 0;
}
}
else
{
DataGrid1.CurrentPageIndex = 0;
GridTitle1.DescriptionTitle = "Nessun dato trovato.";
setvisible(false);
}
DataGrid1.DataBind();
setvisible(true);
GridTitle1.DescriptionTitle = "";
GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}
private void Salva(TreeNode nodopadre, TreeNodeCollection nodi)
{
int bl_id = Int32.Parse(nodopadre.Target);
string bl_descrizione = nodopadre.Text;
EliminaAssociazioni(bl_id);
//nodopadre = BL | nodofiglio=servizio
foreach (TreeNode nodofiglio in nodi)
{
if (nodofiglio.Checked == true)
{
int servizio_id = Int32.Parse(nodofiglio.Target);
string servizio_descrizione = nodofiglio.Text;
Classi.ClassiDettaglio.Edificio _Edificio = new TheSite.Classi.ClassiDettaglio.Edificio(Context.User.Identity.Name);
S_Controls.Collections.S_ControlsCollection _SColl = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object s_Ruolo = new S_Controls.Collections.S_Object();
s_Ruolo.ParameterName = "p_Ruolo_Id";
s_Ruolo.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Ruolo.Direction = ParameterDirection.Input;
s_Ruolo.Index = 0;
s_Ruolo.Value = itemId;
S_Controls.Collections.S_Object s_Edificio_Id = new S_Controls.Collections.S_Object();
s_Edificio_Id.ParameterName = "p_Edificio_Id";
s_Edificio_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Edificio_Id.Direction = ParameterDirection.Input;
s_Edificio_Id.Index = 1;
s_Edificio_Id.Value = bl_id;
S_Controls.Collections.S_Object s_Servizio_Id = new S_Controls.Collections.S_Object();
s_Servizio_Id.ParameterName = "p_Servizio_Id";
s_Servizio_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_Servizio_Id.Direction = ParameterDirection.Input;
s_Servizio_Id.Index = 2;
s_Servizio_Id.Value = servizio_id;
S_Controls.Collections.S_Object s_Operazione = new S_Object();
s_Operazione.ParameterName = "p_Operazione";
s_Operazione.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_Operazione.Direction = ParameterDirection.Input;
s_Operazione.Index = 3;
s_Operazione.Value = "Insert";
S_Controls.Collections.S_Object s_IdOut = new S_Object();
s_IdOut.ParameterName = "p_IdOut";
s_IdOut.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_IdOut.Direction = ParameterDirection.Output;
s_IdOut.Index = 4;
_SColl.Add(s_Ruolo);
_SColl.Add(s_Edificio_Id);
_SColl.Add(s_Servizio_Id);
_SColl.Add(s_Operazione);
_SColl.Add(s_IdOut);
_Edificio.UpdateRuoliEdificiServizi(_SColl);
}
}
}
private void Ricerca()
{
Classi.ClassiAnagrafiche.Addetti _Addetti = new Classi.ClassiAnagrafiche.Addetti();
this.txtscognome.DBDefaultValue = "%";
this.txtsnome.DBDefaultValue = "%";
this.cmbsditta.DBDefaultValue = "0";
S_ControlsCollection _SCollection = new S_ControlsCollection();
//_SCollection.AddItems(this.PanelRicerca.Controls);
S_Controls.Collections.S_Object s_p_cognome = new S_Controls.Collections.S_Object();
s_p_cognome.ParameterName = "p_cognome";
s_p_cognome.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_cognome.Direction = ParameterDirection.Input;
s_p_cognome.Size = 50;
s_p_cognome.Index = 0;
s_p_cognome.Value = txtscognome.Text;
_SCollection.Add(s_p_cognome);
//_SCollection.AddItems(this.PanelRicerca.Controls);
S_Controls.Collections.S_Object s_p_nome = new S_Controls.Collections.S_Object();
s_p_nome.ParameterName = "p_nome";
s_p_nome.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_nome.Direction = ParameterDirection.Input;
s_p_nome.Size = 50;
s_p_nome.Index = _SCollection.Count;
s_p_nome.Value = txtsnome.Text;
_SCollection.Add(s_p_nome);
S_Controls.Collections.S_Object s_p_DataDa = new S_Controls.Collections.S_Object();
s_p_DataDa.ParameterName = "p_dataDA";
s_p_DataDa.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataDa.Direction = ParameterDirection.Input;
s_p_DataDa.Index = _SCollection.Count;
s_p_DataDa.Size = 10;
s_p_DataDa.Value = (CalendarPicker1.Datazione.Text == "")? "":CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_DataDa);
S_Controls.Collections.S_Object s_p_dataA = new S_Controls.Collections.S_Object();
s_p_dataA.ParameterName = "p_dataA";
s_p_dataA.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_dataA.Direction = ParameterDirection.Input;
s_p_dataA.Index = _SCollection.Count;
s_p_dataA.Size = 10;
s_p_dataA.Value = (Calendarpicker2.Datazione.Text == "")? "":Calendarpicker2.Datazione.Text;
_SCollection.Add(s_p_dataA);
S_Controls.Collections.S_Object s_p_ditta = new S_Controls.Collections.S_Object();
s_p_ditta.ParameterName = "p_ditta";
s_p_ditta.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_ditta.Direction = ParameterDirection.Input;
s_p_ditta.Index = _SCollection.Count;
s_p_ditta.Size = 10;
s_p_ditta.Value = Int32.Parse(cmbsditta.SelectedValue);
_SCollection.Add(s_p_ditta);
S_Controls.Collections.S_Object s_p_id_bl = new S_Controls.Collections.S_Object();
s_p_id_bl.ParameterName = "p_id_bl";
s_p_id_bl.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_id_bl.Direction = ParameterDirection.Input;
s_p_id_bl.Index = _SCollection.Count;
s_p_id_bl.Size = 10;
s_p_id_bl.Value = Int32.Parse(cmbsedificio.SelectedValue);
_SCollection.Add(s_p_id_bl);
DataSet _MyDs = _Addetti.GetDataRdlAdd1(_SCollection).Copy();
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
if (_MyDs.Tables[0].Rows.Count == 0)
{
DataGridRicerca.CurrentPageIndex = 0;
}
else
{
int Pagina = 0;
if ((_MyDs.Tables[0].Rows.Count % DataGridRicerca.PageSize) > 0)
{
Pagina++;
}
if (DataGridRicerca.PageCount != Convert.ToInt16((_MyDs.Tables[0].Rows.Count / DataGridRicerca.PageSize) + Pagina))
{
DataGridRicerca.CurrentPageIndex = 0;
}
}
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}
// private void BindStanza()
// {
// this.cmbsStanza.Items.Clear();
//
// TheSite.Classi.ManOrdinaria.Richiesta _Richiesta = new TheSite.Classi.ManOrdinaria.Richiesta();
// int bl_id=(RicercaModulo1.Idbl=="")?0:int.Parse(RicercaModulo1.Idbl);
// int Piano=(cmbsPiano.SelectedValue=="")?0:int.Parse(cmbsPiano.SelectedValue);
// DataSet _MyDs = _Richiesta.GetStanze(bl_id,Piano);
//
// if (_MyDs.Tables[0].Rows.Count > 0)
// {
// this.cmbsStanza.DataSource = Classi.GestoreDropDownList.ItemBlankDataSource(
// _MyDs.Tables[0], "DESCRIZIONE", "ID", "- Selezionare la Stanza -", "");
// this.cmbsStanza.DataTextField = "DESCRIZIONE";
// this.cmbsStanza.DataValueField = "ID";
// this.cmbsStanza.DataBind();
// }
// else
// {
// string s_Messagggio = "- Nessua Stanza -";
// this.cmbsStanza.Items.Add(Classi.GestoreDropDownList.ItemMessaggio(s_Messagggio, String.Empty));
// }
//
// }
#endregion
#region Sezione dedicata al riempimento del DataGrid
private void Execute(bool reset)
{
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 = 1;
if (RicercaModulo1.TxtCodice.Text == string.Empty)
{
s_p_bl_id.Value = DBNull.Value;
}
else
{
s_p_bl_id.Value = RicercaModulo1.TxtCodice.Text;
}
_SCollection.Add(s_p_bl_id);
S_Controls.Collections.S_Object s_p_id_piani = new S_Controls.Collections.S_Object();
s_p_id_piani.ParameterName = "p_piani";
s_p_id_piani.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_id_piani.Direction = ParameterDirection.Input;
s_p_id_piani.Size = 10;
s_p_id_piani.Index = 2;
if (cmbsPiano.SelectedValue == "")
{
s_p_id_piani.Value = -1;
}
else
{
s_p_id_piani.Value = Int32.Parse(cmbsPiano.SelectedValue);
}
_SCollection.Add(s_p_id_piani);
S_Controls.Collections.S_Object s_p_id_room = new S_Controls.Collections.S_Object();
s_p_id_room.ParameterName = "p_rm";
s_p_id_room.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_id_room.Direction = ParameterDirection.Input;
s_p_id_room.Size = 10;
s_p_id_room.Index = 3;
s_p_id_room.Value = UserStanze1.DescStanza;
_SCollection.Add(s_p_id_room);
S_Controls.Collections.S_Object s_p_id_servizio = new S_Controls.Collections.S_Object();
s_p_id_servizio.ParameterName = "p_idservizio";
s_p_id_servizio.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_id_servizio.Direction = ParameterDirection.Input;
s_p_id_servizio.Size = 10;
s_p_id_servizio.Index = 4;
if (cmbsServizio.SelectedValue == "")
{
s_p_id_servizio.Value = -1;
}
else
{
s_p_id_servizio.Value = Int32.Parse(cmbsServizio.SelectedValue);
}
_SCollection.Add(s_p_id_servizio);
S_Controls.Collections.S_Object s_p_id_codappar = new S_Controls.Collections.S_Object();
s_p_id_codappar.ParameterName = "p_idcodappar";
s_p_id_codappar.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_id_codappar.Direction = ParameterDirection.Input;
s_p_id_codappar.Size = 10;
s_p_id_codappar.Index = 5;
if (CodiceApparecchiature1.CodiceHidden.Value == "")
{
s_p_id_codappar.Value = -1;
}
else
{
s_p_id_codappar.Value = Int32.Parse(CodiceApparecchiature1.CodiceHidden.Value);
}
_SCollection.Add(s_p_id_codappar);
///La stored procedure cambia in base alla scelta del Standard Apparecchiatura
//if (cmbsApparecchiatura.SelectedValue==""||cmbsApparecchiatura.SelectedValue==string.Empty)
// Ds=_DataRoom.RicercaDataRoom(_SCollection);
// else
// {
S_Controls.Collections.S_Object s_eqstd = new S_Controls.Collections.S_Object();
s_eqstd.ParameterName = "p_eqstd";
s_eqstd.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_eqstd.Direction = ParameterDirection.Input;
s_eqstd.Size = 255;
s_eqstd.Index = 6;
if (cmbsApparecchiatura.SelectedValue == "")
{
s_eqstd.Value = -1;
}
else
{
s_eqstd.Value = Int32.Parse(cmbsApparecchiatura.SelectedValue);
}
_SCollection.Add(s_eqstd);
S_Controls.Collections.S_Object s_p_pageindex = new S_Object();
s_p_pageindex.ParameterName = "pageindex";
s_p_pageindex.DbType = CustomDBType.Integer;
s_p_pageindex.Direction = ParameterDirection.Input;
s_p_pageindex.Index = _SCollection.Count + 1;
s_p_pageindex.Value = MyDataGrid1.CurrentPageIndex + 1;
_SCollection.Add(s_p_pageindex);
S_Controls.Collections.S_Object s_p_pagesize = new S_Object();
s_p_pagesize.ParameterName = "pagesize";
s_p_pagesize.DbType = CustomDBType.Integer;
s_p_pagesize.Direction = ParameterDirection.Input;
s_p_pagesize.Index = _SCollection.Count + 1;
s_p_pagesize.Value = MyDataGrid1.PageSize;
_SCollection.Add(s_p_pagesize);
Ds = _DataRoom.RicercaDataRoomSTD(_SCollection);
// }
// if (CodiceStdApparecchiatura1.CodiceStd==""||CodiceStdApparecchiatura1.CodiceStd==string.Empty)
// Ds=_DataRoom.RicercaDataRoom(_SCollection);
// else
// {
// S_Controls.Collections.S_Object s_eqstd = new S_Controls.Collections.S_Object();
// s_eqstd.ParameterName = "p_eqstd";
// s_eqstd.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
// s_eqstd.Direction = ParameterDirection.Input;
// s_eqstd.Size=255;
// s_eqstd.Index =4;
// s_eqstd.Value = (CodiceStdApparecchiatura1.CodiceHidden.Value);
// _SCollection.Add(s_eqstd);
// Ds=_DataRoom.RicercaDataRoomSTD(_SCollection);
// }
if (reset == true)
{
_SCollection.RemoveAt(_SCollection.Count - 1);
_SCollection.RemoveAt(_SCollection.Count - 1);
_SCollection.RemoveAt(_SCollection.Count - 1);
int _totalRecords = _DataRoom.RicercaDataRoomSTDCount(_SCollection);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
}
MyDataGrid1.DataSource = Ds;
GridTitle1.Visible = true;
if (int.Parse(GridTitle1.NumeroRecords) > 0)
{
setvisiblecontrol(true);
GridTitle1.DescriptionTitle = "";
}
else
{
GridTitle1.DescriptionTitle = "Nessun dato trovato.";
setvisiblecontrol(false);
}
this.MyDataGrid1.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
this.MyDataGrid1.DataBind();
}
public void Ricarica()
{
int LengthCod = int.Parse(System.Configuration.ConfigurationSettings.AppSettings["edi_cod"]);
if (txtsRDL.Text.Trim().Length != LengthCod && txtsRDL.Text.Trim().Length > 0)
{
return;
}
if (txtsRDL.Text.Trim().Length == 0)
{
ClearCampi();
// Controllo che sia stata assegnata una funzione.
if (DelegateCodiceRDL1 != null)
{
DelegateCodiceRDL1(txtsRDL.Text);
}
if (DelegateIDRDL1 != null)
{
DelegateIDRDL1("");
}
return;
}
// Controllo che sia stata assegnata una funzione.
if (DelegateCodiceRDL1 != null)
{
DelegateCodiceRDL1(txtsRDL.Text);
}
Classi.ManOrdinaria.GestioneRdl _GestioneRdl = new Classi.ManOrdinaria.GestioneRdl(HttpContext.Current.User.Identity.Name);
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
///creo i parametri
///
S_Controls.Collections.S_Object s_wr_id = new S_Controls.Collections.S_Object();
s_wr_id.ParameterName = "p_wr_id";
s_wr_id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_wr_id.Direction = ParameterDirection.Input;
s_wr_id.Size = 50;
s_wr_id.Index = 0;
s_wr_id.Value = txtsRDL.Text;
_SCollection.Add(s_wr_id);
DataSet _MyDs = _GestioneRdl.GetRDL1(_SCollection).Copy();
if (_MyDs.Tables[0].Rows.Count == 1)
{
DataRow _Dr = _MyDs.Tables[0].Rows[0];
if (DelegateIDRDL1 != null)
{
DelegateIDRDL1(_Dr["ID"].ToString());
}
this.hiddenidRDL.Value = _Dr["ID"].ToString();
if (_Dr["descrizione"] != DBNull.Value)
{
CalendarPicker1.Datazione.Text = (string)_Dr["descrizione"];
}
}
else
{
ClearCampi();
}
}
private DsAnalisiStatistiche recuperaDataSet(DsAnalisiStatistiche ds, int tipologiaManutenzione)
{
try
{
Classi.AnalisiStatistiche.wrapDb _IODB = new TheSite.Classi.AnalisiStatistiche.wrapDb();
S_Controls.Collections.S_ControlsCollection _Scollection = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object s_data_init = new S_Controls.Collections.S_Object();
s_data_init.ParameterName = "S_DATA_INIT";
s_data_init.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_data_init.Direction = ParameterDirection.Input;
s_data_init.Size = 10;
s_data_init.Index = _Scollection.Count;
s_data_init.Value = sDataPkInit;
_Scollection.Add(s_data_init);
S_Controls.Collections.S_Object s_data_end = new S_Controls.Collections.S_Object();
s_data_end.ParameterName = "S_DATA_END";
s_data_end.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_data_end.Direction = ParameterDirection.Input;
s_data_end.Size = 10;
s_data_end.Index = _Scollection.Count;
s_data_end.Value = sDataPkEnd;
_Scollection.Add(s_data_end);
S_Controls.Collections.S_Object i_tip = new S_Controls.Collections.S_Object();
i_tip.ParameterName = "S_TIPOLOGIA";
i_tip.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
i_tip.Direction = ParameterDirection.Input;
i_tip.Size = 10;
i_tip.Index = _Scollection.Count;
i_tip.Value = tipologiaManutenzione;
_Scollection.Add(i_tip);
S_Controls.Collections.S_Object p_prog = new S_Controls.Collections.S_Object();
p_prog.ParameterName = "S_PROGETTO";
p_prog.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
p_prog.Direction = ParameterDirection.Input;
p_prog.Index = _Scollection.Count;
string Progetto = "";
if (Request["VarApp"] != null)
{
Progetto = Request["VarApp"];
}
if (Progetto == "")
{
p_prog.Value = 0;
}
else
{
p_prog.Value = int.Parse(Progetto);
}
_Scollection.Add(p_prog);
S_Controls.Collections.S_Object s_CurrentUser = new S_Object();
s_CurrentUser.ParameterName = "S_CurrentUser";
s_CurrentUser.DbType = CustomDBType.VarChar;
s_CurrentUser.Direction = ParameterDirection.Input;
s_CurrentUser.Index = _Scollection.Count;
s_CurrentUser.Value = System.Web.HttpContext.Current.User.Identity.Name;
_Scollection.Add(s_CurrentUser);
S_Controls.Collections.S_Object s_Cursor = new S_Object();
s_Cursor.ParameterName = "IO_CURSOR";
s_Cursor.DbType = CustomDBType.Cursor;
s_Cursor.Direction = ParameterDirection.Output;
s_Cursor.Index = _Scollection.Count + 2;
_Scollection.Add(s_Cursor);
_IODB.s_storedProcedureName = GetNomeStrPrd();
DataSet _MyDataset = _IODB.GetData(_Scollection).Copy();
int i = 0;
for (i = 0; i <= _MyDataset.Tables[0].Rows.Count - 1; i++)
{
ds.Tables[0].ImportRow(_MyDataset.Tables[0].Rows[i]);
}
if (i == 0)
{
throw new Exception("* Non ci sono Rdl nell'intervallo temporale che hai selezionato, cambia intervallo e riprova.");
}
return(ds);
}
catch (Exception ex)
{
Server.Transfer("Error.aspx?msgErr=" + ex.Message);
return(null);
}
}
private void Ricerca(Classi.TipoManutenzioneType t)
{
Classi.AnagrafeImpianti.Apparecchiature _Richiesta = new TheSite.Classi.AnagrafeImpianti.Apparecchiature();
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_Wr_Id = new S_Controls.Collections.S_Object();
s_p_Wr_Id.ParameterName = "p_Wr_Id";
s_p_Wr_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wr_Id.Direction = ParameterDirection.Input;
s_p_Wr_Id.Index = 2;
s_p_Wr_Id.Size = 50;
s_p_Wr_Id.Value = (this.txtsRichiesta.Text == "")?0:Int32.Parse(this.txtsRichiesta.Text);
_SCollection.Add(s_p_Wr_Id);
S_Controls.Collections.S_Object s_p_Addetto = new S_Controls.Collections.S_Object();
s_p_Addetto.ParameterName = "p_Addetto";
s_p_Addetto.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Addetto.Direction = ParameterDirection.Input;
s_p_Addetto.Index = 3;
s_p_Addetto.Size = 50;
s_p_Addetto.Value = this.Addetti1.NomeCompleto;
_SCollection.Add(s_p_Addetto);
S_Controls.Collections.S_Object s_p_DataDa = new S_Controls.Collections.S_Object();
s_p_DataDa.ParameterName = "p_DataDa";
s_p_DataDa.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataDa.Direction = ParameterDirection.Input;
s_p_DataDa.Index = 4;
s_p_DataDa.Size = 10;
s_p_DataDa.Value = (CalendarPicker1.Datazione.Text == "")? "":CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_DataDa);
S_Controls.Collections.S_Object s_p_DataA = new S_Controls.Collections.S_Object();
s_p_DataA.ParameterName = "p_DataA";
s_p_DataA.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataA.Direction = ParameterDirection.Input;
s_p_DataA.Index = 5;
s_p_DataA.Size = 10;
s_p_DataA.Value = (CalendarPicker2.Datazione.Text == "")? "":CalendarPicker2.Datazione.Text;
_SCollection.Add(s_p_DataA);
S_Controls.Collections.S_Object s_p_Wo_Id = new S_Controls.Collections.S_Object();
s_p_Wo_Id.ParameterName = "p_Wo_Id";
s_p_Wo_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wo_Id.Direction = ParameterDirection.Input;
s_p_Wo_Id.Index = 6;
s_p_Wo_Id.Size = 50;
s_p_Wo_Id.Value = (this.txtsOrdine.Text == "")?0:Int32.Parse(this.txtsOrdine.Text);
_SCollection.Add(s_p_Wo_Id);
S_Controls.Collections.S_Object s_p_Status = new S_Controls.Collections.S_Object();
s_p_Status.ParameterName = "p_Status";
s_p_Status.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Status.Direction = ParameterDirection.Input;
s_p_Status.Index = 8;
s_p_Status.Value = (cmbsStatus.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsStatus.SelectedValue);
_SCollection.Add(s_p_Status);
S_Controls.Collections.S_Object s_p_eq = new S_Controls.Collections.S_Object();
s_p_eq.ParameterName = "p_eq";
s_p_eq.DbType = CustomDBType.Integer;
s_p_eq.Direction = ParameterDirection.Input;
s_p_eq.Index = 9;
s_p_eq.Value = this.eq_id;
s_p_eq.Size = 50;
_SCollection.Add(s_p_eq);
S_Controls.Collections.S_Object s_TipoManutenzione = new S_Controls.Collections.S_Object();
s_TipoManutenzione.ParameterName = "p_TipoManutenzione";
s_TipoManutenzione.DbType = CustomDBType.Integer;
s_TipoManutenzione.Direction = ParameterDirection.Input;
s_TipoManutenzione.Index = 10;
s_TipoManutenzione.Size = 4;
s_TipoManutenzione.Value = t;
_SCollection.Add(s_TipoManutenzione);
DataSet _MyDs = _Richiesta.GetSfogliaRDLEQ(_SCollection, DataGridRicerca.PageSize, DataGridRicerca.CurrentPageIndex).Copy();
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
DataGridRicerca.Visible = true;
GridTitle1.Visible = true;
if (_MyDs.Tables[0].Rows.Count == 0)
{
DataGridRicerca.CurrentPageIndex = 0;
GridTitle1.DescriptionTitle = "Nessun dato trovato.";
}
else
{
GridTitle1.DescriptionTitle = "";
int Pagina = 0;
if ((_MyDs.Tables[0].Rows.Count % DataGridRicerca.PageSize) > 0)
{
Pagina++;
}
if (DataGridRicerca.PageCount != Convert.ToInt16((_MyDs.Tables[0].Rows.Count / DataGridRicerca.PageSize) + Pagina))
{
DataGridRicerca.CurrentPageIndex = 0;
}
}
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
//long tot = CalcolaTot();
//ImpostaPagine(tot);
}
private void Ricerca()
{
S_ControlsCollection _SCollection = new S_ControlsCollection();
int indice = _SCollection.Count;
S_Controls.Collections.S_Object s_p_NOME_DOC = new S_Controls.Collections.S_Object();
s_p_NOME_DOC.ParameterName = "p_NOME_DOC";
s_p_NOME_DOC.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_NOME_DOC.Direction = ParameterDirection.Input;
s_p_NOME_DOC.Index = indice;
s_p_NOME_DOC.Size = 50;
s_p_NOME_DOC.Value = this.TxtNomeDoc.Text;
_SCollection.Add(s_p_NOME_DOC);
S_Controls.Collections.S_Object s_p_DATA_INVIO = new S_Controls.Collections.S_Object();
s_p_DATA_INVIO.ParameterName = "p_DATA_INVIO";
s_p_DATA_INVIO.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DATA_INVIO.Direction = ParameterDirection.Input;
s_p_DATA_INVIO.Index = indice;
s_p_DATA_INVIO.Size = 10;
s_p_DATA_INVIO.Value = (CalendarPicker1.Datazione.Text == "")? "":CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_DATA_INVIO);
S_Controls.Collections.S_Object s_p_USERS = new S_Controls.Collections.S_Object();
s_p_USERS.ParameterName = "p_USERS";
s_p_USERS.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_USERS.Direction = ParameterDirection.Input;
s_p_USERS.Index = indice;
s_p_USERS.Size = 50;
s_p_USERS.Value = this.txtUtente.Text;
_SCollection.Add(s_p_USERS);
S_Controls.Collections.S_Object s_p_TIPO_DOC = new S_Controls.Collections.S_Object();
s_p_TIPO_DOC.ParameterName = "p_TIPO_DOC";
s_p_TIPO_DOC.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_TIPO_DOC.Direction = ParameterDirection.Input;
s_p_TIPO_DOC.Index = indice;
if (cmbsTipoDoc.SelectedValue.ToUpper() == "TUTTI")
{
s_p_TIPO_DOC.Value = DBNull.Value;
}
else
{
s_p_TIPO_DOC.Value = cmbsTipoDoc.SelectedValue;
}
_SCollection.Add(s_p_TIPO_DOC);
S_Controls.Collections.S_Object s_p_CODICE = new S_Controls.Collections.S_Object();
s_p_CODICE.ParameterName = "p_CODICE";
s_p_CODICE.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_CODICE.Direction = ParameterDirection.Input;
s_p_CODICE.Index = indice;
s_p_CODICE.Size = 50;
s_p_CODICE.Value = this.TxtCodice.Text;
_SCollection.Add(s_p_CODICE);
S_Controls.Collections.S_Object s_p_ID_WR = new S_Controls.Collections.S_Object();
s_p_ID_WR.ParameterName = "p_ID_WR";
s_p_ID_WR.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_ID_WR.Direction = ParameterDirection.Input;
s_p_ID_WR.Index = indice;
s_p_ID_WR.Size = 50;
int Rdl = 0;
try
{
Rdl = (this.TxtWr_id.Text == "")?0:Int32.Parse(this.TxtWr_id.Text);
}
catch
{
Rdl = 0;
}
s_p_ID_WR.Value = Rdl;
_SCollection.Add(s_p_ID_WR);
S_Controls.Collections.S_Object s_p_ID_BL = new S_Controls.Collections.S_Object();
s_p_ID_BL.ParameterName = "p_ID_BL";
s_p_ID_BL.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_ID_BL.Direction = ParameterDirection.Input;
s_p_ID_BL.Size = 50;
s_p_ID_BL.Index = indice;
s_p_ID_BL.Value = (this.RicercaModulo1._txthidbl.Value == "")?0:Int32.Parse(this.RicercaModulo1._txthidbl.Value);
_SCollection.Add(s_p_ID_BL);
S_Controls.Collections.S_Object p_user = new S_Controls.Collections.S_Object();
p_user.ParameterName = "p_username";
p_user.DbType = CustomDBType.VarChar;
p_user.Direction = ParameterDirection.Input;
p_user.Index = indice;
p_user.Size = 30;
p_user.Value = HttpContext.Current.User.Identity.Name;
_SCollection.Add(p_user);
Double _totalPages = 1;
int _totalRecords = Traccia_doc.GetCount(_SCollection);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
if ((_totalRecords % DataGridRicerca.PageSize) == 0)
{
_totalPages = _totalRecords / DataGridRicerca.PageSize;
}
else
{
_totalPages = (_totalRecords / DataGridRicerca.PageSize) + 1;
}
this.DataGridRicerca.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
if (int.Parse(this.GridTitle1.NumeroRecords) == 0)
{
DataGridRicerca.CurrentPageIndex = 0;
GridTitle1.DescriptionTitle = "Nessun dato trovato.";
}
else
{
GridTitle1.DescriptionTitle = "";
}
S_Controls.Collections.S_Object s_p_pageindex = new S_Object();
s_p_pageindex.ParameterName = "pageindex";
s_p_pageindex.DbType = CustomDBType.Integer;
s_p_pageindex.Direction = ParameterDirection.Input;
s_p_pageindex.Index = indice;
s_p_pageindex.Value = DataGridRicerca.CurrentPageIndex + 1;
_SCollection.Add(s_p_pageindex);
S_Controls.Collections.S_Object s_p_pagesize = new S_Object();
s_p_pagesize.ParameterName = "pagesize";
s_p_pagesize.DbType = CustomDBType.Integer;
s_p_pagesize.Direction = ParameterDirection.Input;
s_p_pagesize.Index = indice;
s_p_pagesize.Value = DataGridRicerca.PageSize;
_SCollection.Add(s_p_pagesize);
DataSet _MyDs = Traccia_doc.GetSfoglia(_SCollection).Copy();
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
this.DataGridRicerca.DataBind();
}
private DataSet GetData()
{
string data_da = CPDataDa.Datazione.Text;
if (data_da == "")
{
data_da = "0";
}
string data_a = CPDataA.Datazione.Text;
if (data_a == "")
{
data_a = "0";
}
Classi.GiudizioCliente.Giudizio _ReportGiudizio = new Classi.GiudizioCliente.Giudizio();
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_Bl_cod = new S_Controls.Collections.S_Object();
s_p_Bl_cod.ParameterName = "p_Bl_id";
s_p_Bl_cod.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Bl_cod.Direction = ParameterDirection.Input;
s_p_Bl_cod.Index = 0;
s_p_Bl_cod.Value = (RicercaModulo1.Idbl == "")?0:int.Parse(RicercaModulo1.Idbl);
CollezioneControlli.Add(s_p_Bl_cod);
S_Controls.Collections.S_Object s_p_datada = new S_Controls.Collections.S_Object();
s_p_datada.ParameterName = "p_data_da";
s_p_datada.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_datada.Direction = ParameterDirection.Input;
s_p_datada.Index = 1;
s_p_datada.Value = data_da;
CollezioneControlli.Add(s_p_datada);
S_Controls.Collections.S_Object s_p_dataa = new S_Controls.Collections.S_Object();
s_p_dataa.ParameterName = "p_data_a";
s_p_dataa.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_dataa.Direction = ParameterDirection.Input;
s_p_dataa.Index = 2;
s_p_dataa.Value = data_a;
CollezioneControlli.Add(s_p_dataa);
S_Controls.Collections.S_Object s_p_id_servizio = new S_Controls.Collections.S_Object();
s_p_id_servizio.ParameterName = "p_id_servizio";
s_p_id_servizio.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_id_servizio.Direction = ParameterDirection.Input;
s_p_id_servizio.Index = 3;
s_p_id_servizio.Value = (this.cmbsServizio.SelectedValue.ToString() == "")?0:Int32.Parse(this.cmbsServizio.SelectedValue.ToString());
CollezioneControlli.Add(s_p_id_servizio);
S_Controls.Collections.S_Object s_p_id_soddisfazione = new S_Controls.Collections.S_Object();
s_p_id_soddisfazione.ParameterName = "p_id_soddisfazione";
s_p_id_soddisfazione.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_id_soddisfazione.Direction = ParameterDirection.Input;
s_p_id_soddisfazione.Index = 4;
s_p_id_soddisfazione.Value = (this.cmbsGiudizio.SelectedValue.ToString() == "")?0:Int32.Parse(this.cmbsGiudizio.SelectedValue.ToString());
CollezioneControlli.Add(s_p_id_soddisfazione);
S_Controls.Collections.S_Object s_p_tipogiudizio = new S_Controls.Collections.S_Object();
s_p_tipogiudizio.ParameterName = "p_tipogiudizio";
s_p_tipogiudizio.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_tipogiudizio.Direction = ParameterDirection.Input;
s_p_tipogiudizio.Index = 5;
s_p_tipogiudizio.Value = cmbsTipoGiudizio.SelectedValue;
CollezioneControlli.Add(s_p_tipogiudizio);
DataSet _MyDs = _ReportGiudizio.ReportGiudizio(CollezioneControlli).Copy();
return(_MyDs);
}
