private void CarregarTela(string SortExpression)
{
if (IsPostBack)
{
ExtratoComponenteBLL CredReeBLL = new ExtratoComponenteBLL();
int iRepresentante = 0;
int.TryParse(ddlRepresentante.SelectedValue, out iRepresentante);
//var dadosGrid = CredReeBLL.Listar(int.Parse(txtCodEmpresa.Text), int.Parse(txtCodMatricula.Text), iRepresentante, " ", DateTime.Parse(txtDtIni.Text), DateTime.Parse(txtDtFim.Text));
var dadosGrid = CredReeBLL.Listar(int.Parse(txtCodEmpresa.Text), int.Parse(txtCodMatricula.Text), iRepresentante, "00", short.Parse(ddlSemestre.SelectedValue), int.Parse(ddlNumAno.SelectedValue.ToString()));
DataTable dt1 = dadosGrid;
DataTable tblOrdered = new DataTable();
DataView view = new DataView();
var vsSort = ViewState["SortDirection"];
if (String.IsNullOrEmpty(SortExpression))
{
grdExtratoUtilizacao.DataSource = dt1;
grdExtratoUtilizacao.DataBind();
return;
}
if (dt1.Rows.Count > 0)
{
if (vsSort == null)
{
ViewState["SortDirection"] = System.Web.UI.WebControls.SortDirection.Descending;
}
System.Web.UI.WebControls.SortDirection lastDirection = (System.Web.UI.WebControls.SortDirection)ViewState["SortDirection"];
if (lastDirection != System.Web.UI.WebControls.SortDirection.Ascending)
{
EnumerableRowCollection <DataRow> query = from row in dt1.AsEnumerable()
orderby DateTime.Parse(row.Field <string>(SortExpression)) descending
select row;
tblOrdered = query.AsDataView().ToTable();
ViewState["SortDirection"] = System.Web.UI.WebControls.SortDirection.Ascending;
}
else
{
EnumerableRowCollection <DataRow> query = from row in dt1.AsEnumerable()
orderby DateTime.Parse(row.Field <string>(SortExpression)) ascending
select row;
tblOrdered = query.AsDataView().ToTable();
ViewState["SortDirection"] = System.Web.UI.WebControls.SortDirection.Descending;
}
grdExtratoUtilizacao.DataSource = tblOrdered;
grdExtratoUtilizacao.DataBind();
}
}
}
protected void btnPesquisar_Click(object sender, EventArgs e)
{
if (ValidarCampos())
{
ExtratoComponenteBLL CredReeBLL = new ExtratoComponenteBLL();
int iRepresentante = 0;
int.TryParse(ddlRepresentante.SelectedValue, out iRepresentante);
grdExtratoUtilizacao.DataSource = CredReeBLL.Listar(int.Parse(txtCodEmpresa.Text), int.Parse(txtCodMatricula.Text), iRepresentante, "00", short.Parse(ddlSemestre.SelectedValue), int.Parse(ddlNumAno.SelectedValue.ToString()));
grdExtratoUtilizacao.DataBind();
grdExtratoUtilizacao.Visible = true;
txtEMail.Enabled = true;
btnEmail.Enabled = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
CarregarDropdownSemestre();
string detalhado = Request.QueryString["hidDetalhado"] ?? "false";
string visualizar = Request.QueryString["hidVisualizar"] ?? "false";
string COD_EMPRS = Request.QueryString["nempr"];
string NUM_RGTRO_EMPRG = Request.QueryString["nreg"];
string PARTICIPANTEEMAIL = Request.QueryString["ParticipanteEmail"];
NUM_IDNTF_RPTANT = Util.String2Int32(Request.QueryString["nrepr"]);
//ScriptManager.RegisterStartupScript(UpdatePanel,
// UpdatePanel.GetType(),
// "script",
// "_client_side_script()",
// true);
Page.Form.DefaultButton = btnPesquisar.UniqueID;
if (!IsPostBack)
{
if (!String.IsNullOrEmpty(COD_EMPRS) && !String.IsNullOrEmpty(NUM_RGTRO_EMPRG))
{
//ReportCrystal.Visible = false;
txtCodEmpresa.Text = COD_EMPRS;
txtCodMatricula.Text = NUM_RGTRO_EMPRG;
if (!String.IsNullOrEmpty(PARTICIPANTEEMAIL) && PARTICIPANTEEMAIL != "undefined")
{
txtEMail.Text = PARTICIPANTEEMAIL;
}
ddlNumAno.SelectedValue = DateTime.Now.Year.ToString();
CarregarDropDown();
ExtratoComponenteBLL CredReeBLL = new ExtratoComponenteBLL();
int iRepresentante = 0;
int.TryParse(ddlRepresentante.SelectedValue, out iRepresentante);
grdExtratoUtilizacao.DataSource = CredReeBLL.Listar(int.Parse(txtCodEmpresa.Text), int.Parse(txtCodMatricula.Text), iRepresentante, "00", short.Parse(ddlSemestre.SelectedValue), int.Parse(ddlNumAno.SelectedValue.ToString()));
grdExtratoUtilizacao.DataBind();
grdExtratoUtilizacao.Visible = true;
txtEMail.Enabled = true;
btnEmail.Enabled = true;
//}
}
}
}
