private void Execute()
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
Classi.AnagrafeImpianti.Certificati _Certificati = new Classi.AnagrafeImpianti.Certificati(Context.User.Identity.Name);
S_Controls.Collections.S_Object s_P_fascicolo = new S_Controls.Collections.S_Object();
s_P_fascicolo.ParameterName = "P_fascicolo";
s_P_fascicolo.DbType = CustomDBType.VarChar;
s_P_fascicolo.Direction = ParameterDirection.Input;
s_P_fascicolo.Index = 0;
s_P_fascicolo.Size = 250;
s_P_fascicolo.Value = this.idric;
CollezioneControlli.Add(s_P_fascicolo);
DataSet Ds = _Certificati.GetDataFascicoli(CollezioneControlli);
DataGrid1.DataSource = Ds;
GridTitle1.NumeroRecords = (Ds.Tables[0].Rows.Count) == 0? "0":Ds.Tables[0].Rows.Count.ToString();
DataGrid1.DataBind();
}
private void Execute(bool reset)
{
S_ControlsCollection CollezioneControlli = new S_ControlsCollection();
Classi.AnagrafeImpianti.Certificati _Certificati = new Classi.AnagrafeImpianti.Certificati(Context.User.Identity.Name);
SetDefaultValueControl(DataPanel1);
if (S_CbTipo.SelectedValue != "6")
{
Matricole1.Matricola.Text = "";
CalendarPicker1.Datazione.Text = "";
S_CbAnno.SelectedIndex = 0;
}
if (S_CbTipo.SelectedValue != "8")
{
Fascicolo1.TxtFascicolo.Text = "";
CalendarPicker2.Datazione.Text = "";
//S_Checkcollaudo.Checked=false;
}
//if (S_CbTipo.SelectedValue=="8")//VVF
if (S_CbTipo.SelectedValue == "6") //ISPELS
{
tablevvf.Style.Add("display", "none");
tablevvf.Style.Add("visibility", "hidden");
tableispesel.Style.Add("display", "block");
tableispesel.Style.Add("visibility", "visible");
DataGrid1.Columns[5].Visible = true;
DataGrid1.Columns[6].Visible = false;
DataGrid1.Columns[7].Visible = false;
DataGrid1.Columns[8].Visible = false;
DataGrid1.Columns[9].Visible = true;
DataGrid1.Columns[10].Visible = true;
DataGrid1.Columns[11].Visible = true;
}
if (S_CbTipo.SelectedValue == "8") //VVF
{
if (chscollaudo.Visible == false)
{
S_Checkcollaudo.Value = DBNull.Value;
}
else
{
if (chscollaudo.Checked == true)
{
S_Checkcollaudo.Value = 1;
}
else
{
S_Checkcollaudo.Value = 0;
}
}
tableispesel.Style.Add("display", "none");
tableispesel.Style.Add("visibility", "hidden");
tablevvf.Style.Add("display", "block");
tablevvf.Style.Add("visibility", "visible");
DataGrid1.Columns[5].Visible = true;
DataGrid1.Columns[6].Visible = true;
DataGrid1.Columns[7].Visible = true;
DataGrid1.Columns[8].Visible = true;
DataGrid1.Columns[9].Visible = false;
DataGrid1.Columns[10].Visible = false;
DataGrid1.Columns[11].Visible = false;
}
if (S_CbTipo.SelectedValue != "8" && S_CbTipo.SelectedValue != "6") //L46/90
{
tablevvf.Style.Add("display", "none");
tablevvf.Style.Add("visibility", "hidden");
tableispesel.Style.Add("display", "none");
tableispesel.Style.Add("visibility", "hidden");
DataGrid1.Columns[5].Visible = true;
DataGrid1.Columns[6].Visible = false;
DataGrid1.Columns[7].Visible = false;
DataGrid1.Columns[8].Visible = false;
DataGrid1.Columns[9].Visible = false;
DataGrid1.Columns[10].Visible = false;
DataGrid1.Columns[11].Visible = false;
}
CollezioneControlli.AddItems(DataPanel1.Controls);
CollezioneControlli.Add(S_Checkcollaudo);
// 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;
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 = DataGrid1.PageSize;
CollezioneControlli.Add(s_p_pagesize);
DataSet _MyDs = _Certificati.GetData(CollezioneControlli);
if (reset)
{
// elimino i due parametri per la paginazione
CollezioneControlli.RemoveAt(CollezioneControlli.Count - 3);
CollezioneControlli.RemoveAt(CollezioneControlli.Count - 3);
int _totalRecords = _Certificati.GetDataCount(CollezioneControlli);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
}
this.DataGrid1.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
DataGrid1.DataSource = _MyDs.Tables[0];
DataGrid1.DataBind();
if (int.Parse(this.GridTitle1.NumeroRecords) > 0)
{
setvisible(true);
GridTitle1.Visible = true;
GridTitle1.DescriptionTitle = "";
}
else
{
GridTitle1.Visible = true;
GridTitle1.DescriptionTitle = "Nessun dato trovato.";
setvisible(false);
}
chscollaudo.Visible = true;
}
