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);
DataSet _MyDs = _Addetti.GetData(_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()
{
Classi.ClassiAnagrafiche.Addetti _Addetti = new Classi.ClassiAnagrafiche.Addetti();
this.txtsadd.DBDefaultValue = "%";
this.txtsditta.DBDefaultValue = "%";
this.cmbsGiorno.DBDefaultValue = "0";
S_ControlsCollection _SCollection = new S_ControlsCollection();
_SCollection.AddItems(this.PanelRicerca.Controls);
DataSet _MyDs = _Addetti.GetDataAddRep(_SCollection).Copy();
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}
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();
}
