private void Ricerca(bool reset)
{
//Session.Remove("DataSet");
S_Controls.Collections.S_ControlsCollection CollezioneControlli = new S_Controls.Collections.S_ControlsCollection();
cmbsComune.DBDefaultValue = "0";
cmbsEdificio.DBDefaultValue = "0";
cmbsServizio.DBDefaultValue = "0";
CollezioneControlli = GetData();
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 = DataGridRicerca.CurrentPageIndex + 1;
CollezioneControlli.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 = DataGridRicerca.PageSize;
CollezioneControlli.Add(s_p_pagesize);
Classi.ManProgrammata.Rapportino _Rapportino = new TheSite.Classi.ManProgrammata.Rapportino();
DataSet _MyDs = _Rapportino.GetData(CollezioneControlli).Copy();
if (reset)
{
CollezioneControlli.Clear();
CollezioneControlli = GetData();
int _totalRecords = _Rapportino.getCount(CollezioneControlli);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
}
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
// this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
this.DataGridRicerca.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
this.DataGridRicerca.DataBind();
}
private void Execute(bool reset)
{
///Istanzio un nuovo oggetto Collection per aggiungere i parametri
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
///creo i parametri
_SCollection = getParam();
// 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 = 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 = 17;
s_p_pagesize.Value = MyDataGrid1.PageSize;
_SCollection.Add(s_p_pagesize);
///Istanzio la Classe per eseguire la Strore Procedure
Classi.AnagrafeImpianti.Apparecchiature _Apparecchiature = new Classi.AnagrafeImpianti.Apparecchiature(Context.User.Identity.Name);
///Eseguo il Binding sulla Griglia.
DataSet Ds = _Apparecchiature.RicercaDescStanze(_SCollection);
// GridTitle1.NumeroRecords=(Ds.Tables[0].Rows.Count)==0? "0":Ds.Tables[0].Rows.Count.ToString();
MyDataGrid1.DataSource = Ds;
if (reset)
{
_SCollection.Clear();
_SCollection = getParam();
int _totalRecords = _Apparecchiature.RicercaStanzeDescCount(_SCollection);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
}
this.MyDataGrid1.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
MyDataGrid1.DataBind();
}
/// <summary>
/// Esegue la queri di ricerca
/// </summary>
///
private void Execute(bool reset)
{
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);
//********************************************
_SCollection = creaParam();
// 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 = DataGrid1.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 = DataGrid1.PageSize;
_SCollection.Add(s_p_pagesize);
Classi.AnagrafeImpianti.AnagrafeServizi _AnagrafeServizi = new Classi.AnagrafeImpianti.AnagrafeServizi(Context.User.Identity.Name);
DataSet _MyDs = _AnagrafeServizi.GetData(_SCollection);
//////////
GridTitle1.Visible = true;
if (reset == true)
{
_SCollection.Clear();
_SCollection = creaParam();
int _totalRecords = _AnagrafeServizi.GetDataCount(_SCollection);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
}
DataGrid1.DataSource = _MyDs.Tables[0];
this.DataGrid1.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
this.DataGrid1.DataBind();
if (int.Parse(this.GridTitle1.NumeroRecords) > 0)
{
setvisible(true);
GridTitle1.DescriptionTitle = "";
}
else
{
GridTitle1.DescriptionTitle = "Nessun dato trovato.";
setvisible(false);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
Classi.SiteModule _SiteModule = (Classi.SiteModule)HttpContext.Current.Items["SiteModule"];
FunId = int.Parse(Request["FunId"]);
HelpLink = _SiteModule.HelpLink;
// DIACHIARO PRIMA LE VARIABILI INT
// get da request le variabili stringa RM001, PTE,CP001
// POI LE RICERCO IN DB E LE TRASFORMO IN INT (ID)
// QUINDI VALORIZZO LE VARIABILI USATE QUI: s_bl_id s_piani s_stanza
//------------------------------
// bl_str ="";
// fl_str ="";
// rm_str ="";
//
// if (Request["var_stanza"]== null || Request["var_stanza"]=="" ||Request["var_stanza"]==string.Empty)
// {
// s_stanza=0;
// TitoloPiano = Request["TitoloPiano"].ToString();
// PageTitle1.Title = "Apparecchiature del Piano " + TitoloPiano;
// }
// else
// {}
if (Request["rm"] != null && Request["rm"] != string.Empty && Request["rm"] != "")
{
S_Controls.Collections.S_Object s_p_rm = new S_Controls.Collections.S_Object();
s_p_rm.ParameterName = "p_rm";
s_p_rm.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_rm.Direction = ParameterDirection.Input;
s_p_rm.Size = 20;
s_p_rm.Index = 1;
s_p_rm.Value = Request["rm"].ToString();
_SCollection.Add(s_p_rm);
S_Controls.Collections.S_Object s_p_fl = new S_Controls.Collections.S_Object();
s_p_fl.ParameterName = "p_fl";
s_p_fl.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_fl.Direction = ParameterDirection.Input;
s_p_fl.Size = 20;
s_p_fl.Index = 2;
s_p_fl.Value = Request["fl"].ToString();
_SCollection.Add(s_p_fl);
S_Controls.Collections.S_Object s_p_bl = new S_Controls.Collections.S_Object();
s_p_bl.ParameterName = "p_bl";
s_p_bl.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_bl.Direction = ParameterDirection.Input;
s_p_bl.Size = 20;
s_p_bl.Index = 3;
s_p_bl.Value = Request["bl"].ToString();;
_SCollection.Add(s_p_bl);
DataSet Ds1 = _DataRoom.DatiTestata_STR(_SCollection);
DataRow _Dr1 = Ds1.Tables[0].Rows[0];
if (_Dr1["id_rm"] != DBNull.Value)
{
s_stanza = (int)int.Parse(_Dr1["id_rm"].ToString());
}
if (_Dr1["id_piani"] != DBNull.Value)
{
s_piani = (int)int.Parse(_Dr1["id_piani"].ToString());
}
if (_Dr1["id_bl"] != DBNull.Value)
{
s_bl_id = (int)int.Parse(_Dr1["id_bl"].ToString());
}
}
if (s_piani == 0)
{
s_piani = (int)int.Parse(Request["var_piani"]);
}
if (s_bl_id == 0)
{
s_bl_id = (int)int.Parse(Request["var_bl_id"]);
}
if ((Request["var_stanza"] == null || Request["var_stanza"] == "" || Request["var_stanza"] == string.Empty) &&
(Request["rm"] == null || Request["rm"] == "" || Request["rm"] == string.Empty)
)
{
s_stanza = 0;
//TitoloPiano = //Request["fl"].ToString();
//Request["TitoloPiano"].ToString();
PageTitle1.Title = "Apparecchiature del Piano "; //+ TitoloPiano;
}
else
{
if (s_stanza == 0)
{
s_stanza = (int)int.Parse(Request["var_stanza"]);
}
//TitoloStanza = Request["TitoloStanza"].ToString();
PageTitle1.Title = "Apparecchiature della Stanza "; //+ TitoloStanza;
_SCollection.Clear();
S_Controls.Collections.S_Object s_p_stanza = new S_Controls.Collections.S_Object();
s_p_stanza.ParameterName = "p_stanza";
s_p_stanza.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_stanza.Direction = ParameterDirection.Input;
s_p_stanza.Size = 20;
s_p_stanza.Index = 1;
s_p_stanza.Value = s_stanza;
_SCollection.Add(s_p_stanza);
DataSet Ds = _DataRoom.DatiTestata(_SCollection);
if (Ds.Tables[0].Rows.Count == 1)
{
DataRow _Dr = Ds.Tables[0].Rows[0];
if (_Dr["altezza"] != DBNull.Value)
{
this.lblAltezza.Text = _Dr["altezza"].ToString();
}
if (_Dr["area"] != DBNull.Value)
{
this.lblArea.Text = _Dr["area"].ToString();
}
if (_Dr["categoria"] != DBNull.Value)
{
this.lblCategoria.Text = _Dr["categoria"].ToString();
}
if (_Dr["Descstanza"] != DBNull.Value)
{
this.lblDescstanza.Text = _Dr["Descstanza"].ToString();
}
if (_Dr["Destuso"] != DBNull.Value)
{
this.lblDestuso.Text = _Dr["Destuso"].ToString();
}
if (_Dr["Edificio"] != DBNull.Value)
{
this.lblEdificio.Text = _Dr["Edificio"].ToString();
}
if (_Dr["Nrstanza"] != DBNull.Value)
{
this.lblNrstanza.Text = _Dr["Nrstanza"].ToString();
}
if (_Dr["pareti"] != DBNull.Value)
{
this.lblPareti.Text = _Dr["pareti"].ToString();
}
if (_Dr["pavimento"] != DBNull.Value)
{
this.lblPavimento.Text = _Dr["pavimento"].ToString();
}
if (_Dr["Piano"] != DBNull.Value)
{
this.lblPiano.Text = _Dr["Piano"].ToString();
}
if (_Dr["soffitto"] != DBNull.Value)
{
this.lblSoffitto.Text = _Dr["soffitto"].ToString();
}
}
_SCollection.Clear();
}
if (!IsPostBack)
{
Execute();
GridTitle1.Visible = true;
if (Context.Handler is TheSite.AnagrafeImpianti.DataRoom)
{
_fp = (TheSite.AnagrafeImpianti.DataRoom)Context.Handler;
this.ViewState.Add("mioContenitore", _fp._Contenitore);
}
}
GridTitle1.hplsNuovo.Visible = false;
///DataRoom.aspx?id_edificio_cad=201&id_piano_cad=1&FromWebCad=true
if (Request.QueryString["FromWebCad"] != null || Request.QueryString["FromWebCad"].ToString() != String.Empty)
{
if (Request.QueryString["WebCadIndietro"] != null)
{
//BntIndietro.Visible=true;
}
PageTitle1.VisibleLogut = false;
}
else
{
PageTitle1.VisibleLogut = true;
}
}
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(5 - 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();
}
