private void Execute()
{
Classi.ManProgrammata.ProcAndSteps _PMP = new TheSite.Classi.ManProgrammata.ProcAndSteps();
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object s_pmp_id = new S_Controls.Collections.S_Object();
s_pmp_id.ParameterName = "p_Id";
s_pmp_id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_pmp_id.Direction = ParameterDirection.Input;
s_pmp_id.Size = 8;
s_pmp_id.Index = 0;
s_pmp_id.Value = txtmatricola.Text;
_SCollection.Add(s_pmp_id);
S_Controls.Collections.S_Object s_eqstd_id = new S_Controls.Collections.S_Object();
s_eqstd_id.ParameterName = "p_idEqst";
s_eqstd_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_eqstd_id.Direction = ParameterDirection.Input;
s_eqstd_id.Size = 8;
s_eqstd_id.Index = 1;
s_eqstd_id.Value = 0;
_SCollection.Add(s_eqstd_id);
S_Controls.Collections.S_Object s_servizio_id = new S_Controls.Collections.S_Object();
s_servizio_id.ParameterName = "p_idServizio";
s_servizio_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_servizio_id.Direction = ParameterDirection.Input;
s_servizio_id.Size = 8;
s_servizio_id.Index = 2;
s_servizio_id.Value = 0;
_SCollection.Add(s_servizio_id);
DataSet _MyDs = _PMP.GetAllPMP(_SCollection).Copy();
if (_MyDs.Tables[0].Rows.Count == 1)
{
DataRow _Dr = _MyDs.Tables[0].Rows[0];
txtdescrizione.Text = _Dr["descrizione"].ToString();
txtmatricola.Text = _Dr["id"].ToString();
txtid.Value = _Dr["idnumerico"].ToString();
}
// Controllo che sia stata assegnata una funzione.
if (DelegateCodicePMP1 != null)
{
DelegateCodicePMP1(Int32.Parse(txtid.Value));
}
}
private void 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 GetDataGrid()
{
Classi.ManProgrammata.ProcAndSteps _ProcAndSteps = new TheSite.Classi.ManProgrammata.ProcAndSteps();
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_ID = new S_Object();
s_ID.ParameterName = "p_ID_pmp";
s_ID.DbType = CustomDBType.Integer;
s_ID.Direction = ParameterDirection.Input;
s_ID.Index = 0;
s_ID.Value = PMP;
s_ID.Size = 50;
_SCollection.Add(s_ID);
DataSet _MyDs = _ProcAndSteps.GetDataDett(_SCollection).Copy();
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
this.DataGridRicerca.DataBind();
this.GridTitle1.NumeroRecords = _MyDs.Tables[0].Rows.Count.ToString();
}
private void Execute()
{
Classi.ManProgrammata.ProcAndSteps _PMP = new TheSite.Classi.ManProgrammata.ProcAndSteps();
S_Controls.Collections.S_ControlsCollection _SCollection = new S_Controls.Collections.S_ControlsCollection();
S_Controls.Collections.S_Object s_pmp_id = new S_Controls.Collections.S_Object();
s_pmp_id.ParameterName = "p_Id";
s_pmp_id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_pmp_id.Direction = ParameterDirection.Input;
s_pmp_id.Size = 8;
s_pmp_id.Index = 0;
s_pmp_id.Value = this.idric;
_SCollection.Add(s_pmp_id);
S_Controls.Collections.S_Object s_eqstd_id = new S_Controls.Collections.S_Object();
s_eqstd_id.ParameterName = "p_idEqst";
s_eqstd_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_eqstd_id.Direction = ParameterDirection.Input;
s_eqstd_id.Size = 8;
s_eqstd_id.Index = 1;
s_eqstd_id.Value = this.idEqStd;
_SCollection.Add(s_eqstd_id);
S_Controls.Collections.S_Object s_servizio_id = new S_Controls.Collections.S_Object();
s_servizio_id.ParameterName = "p_idServizio";
s_servizio_id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_servizio_id.Direction = ParameterDirection.Input;
s_servizio_id.Size = 8;
s_servizio_id.Index = 2;
s_servizio_id.Value = this.idServizio;
_SCollection.Add(s_servizio_id);
DataSet _MyDs = _PMP.GetAllPMP(_SCollection).Copy();
DataGrid1.DataSource = _MyDs;
GridTitle1.NumeroRecords = (_MyDs.Tables[0].Rows.Count) == 0? "0":_MyDs.Tables[0].Rows.Count.ToString();
DataGrid1.DataBind();
}
private void Ricerca(bool reset)
{
Classi.ManProgrammata.ProcAndSteps _ProcAndSteps = new TheSite.Classi.ManProgrammata.ProcAndSteps(Context.User.Identity.Name);
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
int idservizio = 0;
int ideqstd = 0;
int idtr = 0;
if (cmbsServizio.SelectedValue != "")
{
idservizio = Int32.Parse(cmbsServizio.SelectedValue);
}
if (cmdsStdApparecchiatura.SelectedValue != "")
{
ideqstd = Int32.Parse(cmdsStdApparecchiatura.SelectedValue);
}
if (cmbsSpecializzazione.SelectedValue != "")
{
idtr = Int32.Parse(cmbsSpecializzazione.SelectedValue);
}
S_Controls.Collections.S_Object s_Servizio_id = new S_Object();
s_Servizio_id.ParameterName = "p_Servizio_id";
s_Servizio_id.DbType = CustomDBType.Integer;
s_Servizio_id.Direction = ParameterDirection.Input;
s_Servizio_id.Index = 0;
s_Servizio_id.Value = idservizio;
s_Servizio_id.Size = 50;
CollezioneControlli.Add(s_Servizio_id);
S_Controls.Collections.S_Object s_EqStd_id = new S_Object();
s_EqStd_id.ParameterName = "p_EqStd_id";
s_EqStd_id.DbType = CustomDBType.Integer;
s_EqStd_id.Direction = ParameterDirection.Input;
s_EqStd_id.Index = 1;
s_EqStd_id.Value = ideqstd;
s_EqStd_id.Size = 50;
CollezioneControlli.Add(s_EqStd_id);
S_Controls.Collections.S_Object s_TR_id = new S_Object();
s_TR_id.ParameterName = "p_TR_id";
s_TR_id.DbType = CustomDBType.Integer;
s_TR_id.Direction = ParameterDirection.Input;
s_TR_id.Index = 2;
s_TR_id.Value = idtr;
s_TR_id.Size = 50;
CollezioneControlli.Add(s_TR_id);
S_Controls.Collections.S_Object s_PMP_id = new S_Object();
s_PMP_id.ParameterName = "p_PMP_id";
s_PMP_id.DbType = CustomDBType.Integer;
s_PMP_id.Direction = ParameterDirection.Input;
s_PMP_id.Index = 3;
s_PMP_id.Value = this.UserPmp1.CodiceNum.Value;
s_PMP_id.Size = 50;
CollezioneControlli.Add(s_PMP_id);
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);
S_Controls.Collections.S_Object s_UserName = new S_Object();
s_UserName.ParameterName = "p_UserName";
s_UserName.DbType = CustomDBType.VarChar;
s_UserName.Direction = ParameterDirection.Input;
s_UserName.Index = 4;
s_UserName.Value = this.User.Identity.Name;
s_UserName.Size = 50;
CollezioneControlli.Add(s_UserName);
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 = 5;
CollezioneControlli.Add(s_Cursor);
DataSet _MyDs = _ProcAndSteps.GetData(CollezioneControlli).Copy();
if (reset == true)
{
CollezioneControlli.RemoveAt(CollezioneControlli.Count - 4);
CollezioneControlli.RemoveAt(CollezioneControlli.Count - 3);
int _totalRecords = _ProcAndSteps.GetDataCount(CollezioneControlli);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
}
this.DataGridRicerca.DataSource = _MyDs.Tables[0];
this.DataGridRicerca.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
this.DataGridRicerca.DataBind();
}
