private System.Data.Common.DbParameter[] ParametriRicerca() =>
new System.Data.Common.DbParameter[]
{
cDB.NewPar("tipo1", Tipo),
cDB.NewPar("tipo2", Tipo),
cDB.NewPar("descrizione", "%" + eDescrizione.Text + "%"),
cDB.NewPar("MacroArea", "%" + eMacroarea.Text + "%"),
cDB.NewPar("bSoldi", bSoldi.Checked ? 1 : 0),
cDB.NewPar("bData", bData.Checked ? 1 : 0),
cDB.NewPar("SoldiDa", GB.ObjectToDouble(eSoldiDa.Text, 0)),
cDB.NewPar("SoldiA", GB.ObjectToDouble(eSoldiA.Text, 0)),
cDB.NewPar("DataDa", GB.StringToDate(eDataDa.Text, new DateTime(1986, 1, 1))),
cDB.NewPar("DataA", GB.StringToDate(eDataA.Text, DateTime.Now.AddYears(20)))
};
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes["onclick"] = ClientScript.GetPostBackClientHyperlink(GridView1, "Select$" + e.Row.RowIndex);
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
using (var db = new cDB(GB.Instance.getCurrentSession(Session).PathDB))
using (var dr = db.EseguiSQLDataReader(cDB.Queries.Movimenti_Saldo))
if (dr.HasRows)
{
var lbl = (Label)e.Row.FindControl("lblTotal");
while (dr.Read())
{
lbl.Text = GB.ObjectToDouble(dr["Saldo"], 0).ToString("c");
}
}
}
}
