private void GetDataGrid()
{
Classi.ManProgrammata.Planner _Planner = new TheSite.Classi.ManProgrammata.Planner();
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_EQ_ID = new S_Object();
s_EQ_ID.ParameterName = "p_EQ_ID";
s_EQ_ID.DbType = CustomDBType.VarChar;
s_EQ_ID.Direction = ParameterDirection.Input;
s_EQ_ID.Index = 0;
s_EQ_ID.Value = txtEQ.Text;
s_EQ_ID.Size = 50;
_SCollection.Add(s_EQ_ID);
S_Controls.Collections.S_Object s_Anno = new S_Object();
s_Anno.ParameterName = "p_Anno";
s_Anno.DbType = CustomDBType.Integer;
s_Anno.Direction = ParameterDirection.Input;
s_Anno.Index = 1;
s_Anno.Value = txtAnno.Text;
s_Anno.Size = 4;
_SCollection.Add(s_Anno);
_MyDs = _Planner.GetPassiPianoDett(_SCollection).Copy();
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}
private void lkbInfo_Click(object sender, System.EventArgs e)
{
Classi.ManProgrammata.Planner _Planner = new TheSite.Classi.ManProgrammata.Planner();
this.pnlShowInfo.Visible = true;
rptFrequenze.DataSource = _Planner.GetFrequenze();
rptFrequenze.DataBind();
}
private void GetDataGrid()
{
Classi.ManProgrammata.Planner _Planner = new TheSite.Classi.ManProgrammata.Planner();
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_ID_BL = new S_Object();
s_ID_BL.ParameterName = "p_id_Bl";
s_ID_BL.DbType = CustomDBType.Integer;
s_ID_BL.Direction = ParameterDirection.Input;
s_ID_BL.Index = 0;
s_ID_BL.Value = txtID_BL.Text;
s_ID_BL.Size = 50;
_SCollection.Add(s_ID_BL);
S_Controls.Collections.S_Object s_Anno = new S_Object();
s_Anno.ParameterName = "p_Anno";
s_Anno.DbType = CustomDBType.Integer;
s_Anno.Direction = ParameterDirection.Input;
s_Anno.Index = 1;
s_Anno.Value = txtAnno.Text;
s_Anno.Size = 4;
_SCollection.Add(s_Anno);
S_Controls.Collections.S_Object s_Servizio = new S_Object();
s_Servizio.ParameterName = "p_ID_Servizio";
s_Servizio.DbType = CustomDBType.Integer;
s_Servizio.Direction = ParameterDirection.Input;
s_Servizio.Index = 2;
s_Servizio.Value = txtServizio.Text;
s_Servizio.Size = 50;
_SCollection.Add(s_Servizio);
DataSet _MyDs = _Planner.GetDataDett(_SCollection).Copy();
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}
private void GetDataGrid()
{
Classi.ManProgrammata.Planner _Planner = new TheSite.Classi.ManProgrammata.Planner();
Classi.ManProgrammata.ProcAndSteps _ProcAndSteps = new TheSite.Classi.ManProgrammata.ProcAndSteps();
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_EQ_ID = new S_Object();
s_EQ_ID.ParameterName = "p_EQ_ID";
s_EQ_ID.DbType = CustomDBType.VarChar;
s_EQ_ID.Direction = ParameterDirection.Input;
s_EQ_ID.Index = 0;
s_EQ_ID.Value = txtEQ.Text;
s_EQ_ID.Size = 50;
_SCollection.Add(s_EQ_ID);
S_Controls.Collections.S_Object s_Anno = new S_Object();
s_Anno.ParameterName = "p_Anno";
s_Anno.DbType = CustomDBType.Integer;
s_Anno.Direction = ParameterDirection.Input;
s_Anno.Index = 1;
s_Anno.Value = txtAnno.Text;
s_Anno.Size = 4;
_SCollection.Add(s_Anno);
_MyDs = _Planner.GetPassiPianoDett(_SCollection).Copy();
if (this.e_Page != "ottimizza")
{
_MyDs.Tables.Add(_ProcAndSteps.GetIstruzioni().Tables["ISTRUZIONI"].Copy());
DataGridRicerca.Columns[6].Visible = false;
}
else
{
DataGridRicerca.Columns[4].Visible = false;
}
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}
private void Ricerca(bool reset)
{
Classi.ManProgrammata.Planner _Planner = new TheSite.Classi.ManProgrammata.Planner(Context.User.Identity.Name);
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 = 2;
s_p_campus.Size = 50;
s_p_campus.Value = RicercaModulo1.TxtRicerca.Text;
_SCollection.Add(s_p_campus);
S_Controls.Collections.S_Object s_p_anno = new S_Controls.Collections.S_Object();
s_p_anno.ParameterName = "p_Anno";
s_p_anno.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_anno.Direction = ParameterDirection.Input;
s_p_anno.Index = 3;
s_p_anno.Size = 4;
s_p_anno.Value = cmbsAnno.SelectedItem.ToString();
_SCollection.Add(s_p_anno);
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 = 3;
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_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;
_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 = DataGridRicerca.PageSize;
_SCollection.Add(s_p_pagesize);
DataSet _MyDs = _Planner.GetData(_SCollection).Copy();
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 = _Planner.GetDataCount(_SCollection);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
}
DataGridRicerca.Visible = true;
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
this.DataGridRicerca.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
this.DataGridRicerca.DataBind();
}
