private void BtExport_Click(object sender, System.EventArgs e)
{
Csy.WebControls.Export _objExport = new Csy.WebControls.Export();
DataTable _dt = new DataTable();
Classi.ClassiAnagrafiche.Buildings _Buildings = new Classi.ClassiAnagrafiche.Buildings();
int bl_id = 0;
if (RicercaModulo1._txthidbl.Value != "")
{
bl_id = int.Parse(RicercaModulo1._txthidbl.Value);
}
DataSet Ds = _Buildings.GetReport(int.Parse(DrTipoRep.SelectedValue), bl_id);
_dt = Ds.Tables[0].Copy();
if (_dt.Rows.Count > 65536)
{
String scriptString = "<script language=JavaScript>alert('I record trovati sono in numero maggiore di 65536 e non possono entrare in un solo foglio excel. Impostare filtri più restrittivi');";
scriptString += "<";
scriptString += "/";
scriptString += "script>";
if (!this.IsClientScriptBlockRegistered("clientScriptexp"))
{
this.RegisterStartupScript("clientScriptexp", scriptString);
}
}
else
{
if (_dt.Rows.Count != 0)
{
_objExport.ExportDetails(_dt, Csy.WebControls.Export.ExportFormat.Excel, "exp.xls");
}
else
{
String scriptString = "<script language=JavaScript>alert('Nessun elemento da esportare');";
scriptString += "<";
scriptString += "/";
scriptString += "script>";
if (!this.IsClientScriptBlockRegistered("clientScriptexp"))
{
this.RegisterStartupScript("clientScriptexp", scriptString);
}
}
}
}
private void Execute(bool reset)
{
///Istanzio la Classe per eseguire la Strore Procedure
Classi.ClassiAnagrafiche.Buildings _Buildings = new Classi.ClassiAnagrafiche.Buildings();
S_Controls.Collections.S_ControlsCollection _SCollection = GetDatistanza();
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 = _SCollection.Count;
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 = _SCollection.Count;
s_p_pagesize.Value = MyDataGrid1.PageSize;
_SCollection.Add(s_p_pagesize);
DataSet Ds = _Buildings.GetDataStanze(_SCollection).Copy();
GridTitle1.Visible = true;
if (reset == true)
{
_SCollection = GetDatistanza();
int _totalRecords = _Buildings.GetDataStanzeCount(_SCollection);
this.GridTitle1.NumeroRecords = _totalRecords.ToString();
}
MyDataGrid1.DataSource = Ds.Tables[0];
this.MyDataGrid1.VirtualItemCount = int.Parse(this.GridTitle1.NumeroRecords);
this.MyDataGrid1.DataBind();
if (int.Parse(this.GridTitle1.NumeroRecords) > 0)
{
setvisiblecontrol(true);
GridTitle1.DescriptionTitle = "";
}
else
{
GridTitle1.DescriptionTitle = "Nessun dato trovato.";
setvisiblecontrol(false);
}
}
private void S_Button1_Click(object sender, System.EventArgs e)
{
//esporta in excel
Csy.WebControls.Export _objExport = new Csy.WebControls.Export();
DataTable _dt = new DataTable();
Classi.ClassiAnagrafiche.Buildings _Buildings = new Classi.ClassiAnagrafiche.Buildings();
S_Controls.Collections.S_ControlsCollection _SCollection = GetDatistanza();
DataSet Ds = _Buildings.GetDataStanzeExcel(_SCollection).Copy();
_dt = Ds.Tables[0].Copy();
if (_dt.Rows.Count > 65536)
{
String scriptString = "<script language=JavaScript>alert('I record trovati sono in numero maggiore di 65536 e non possono entrare in un solo foglio excel. Impostare filtri più restrittivi');";
scriptString += "<";
scriptString += "/";
scriptString += "script>";
if (!this.IsClientScriptBlockRegistered("clientScriptexp"))
{
this.RegisterStartupScript("clientScriptexp", scriptString);
}
}
else
{
if (_dt.Rows.Count != 0)
{
_objExport.ExportDetails(_dt, Csy.WebControls.Export.ExportFormat.Excel, "exp.xls");
}
else
{
String scriptString = "<script language=JavaScript>alert('Nessun elemento da esportare');";
scriptString += "<";
scriptString += "/";
scriptString += "script>";
if (!this.IsClientScriptBlockRegistered("clientScriptexp"))
{
this.RegisterStartupScript("clientScriptexp", scriptString);
}
}
}
}
