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"); } } } }