protected void DataBind(int pagina)
{
CDataService dados = new CDataService("controleAtas");
string sql = "";
if (nome == "")
{
sql = "SELECT id, nome, email, admin FROM Usuarios Order by 2";
}
else
{
sql = "SELECT id, nome, email, admin FROM Usuarios WHERE nome like'" + nome + "%' Order by 2";
}
GridView1.DataSource = dados.SelectSqlData(sql);
GridView1.PageIndex = pagina;
GridView1.DataBind();
dados.CloseDataSource();
}
protected void DataBind(int pagina)
{
CDataService dados = new CDataService("controleAtas");
string sql = "";
if (dtFim.Text == "" || dtInicio.Text == "")
{
sql = " SELECT DISTINCT r.id, convert(varchar(10),datahora,103) as data, assunto, local " +
" FROM Reunioes r, Participantes p " +
" WHERE r.id = p.idReuniao " +
" AND r.dataHora BETWEEN (GETDATE() - 30) AND GETDATE() " +
" AND r.excluida = 0 ";
if (Session["admin"].ToString().Equals("False"))
{
sql += "AND p.idUsuario = " + Session["id"].ToString();
}
sql += " Order by 2";
}
else
{
sql = " SELECT DISTINCT r.id, convert(varchar(10),datahora,103) as data, assunto, local " +
" FROM Reunioes r, Participantes p " +
" WHERE r.id = p.idReuniao " +
" AND r.dataHora BETWEEN " + Util.SQLString(dtInicio.SqlData) +
" AND " + Util.SQLString(dtFim.SqlData) +
" AND r.excluida = 0 ";
if (Session["admin"].ToString().Equals("False"))
{
sql += "AND p.idUsuario = " + Session["id"].ToString();
}
sql += " Order by 2";
}
GridView1.DataSource = dados.SelectSqlData(sql);
GridView1.PageIndex = pagina;
GridView1.DataBind();
dados.CloseDataSource();
}
