private void initGrid(DateTime start, DateTime end, string var_cliente)
{
this.Session[this._nameSessionData] = Documents_Trans.get_Docn_TransAdonis(start, end, var_cliente).Tables[0];
this.gvDocTrans.DataSource = (DataTable)this.Session[this._nameSessionData];
this.gvDocTrans.DataBind();
//this.Session[this._nameSessionData] = (object)Documents_Trans.get_Docn_TransAdonis(start, end,var_cliente);
//this.gvDocTrans.DataSourceID = this.odsConsult.ID;
//this.gvDocTrans.DataBind();
//MergeRows(gvDocTrans, 2);
}
protected void ibExportDoc_Click(object sender, ImageClickEventArgs e)
{
DataTable dt = null;
try
{
DateTime fechaini = Convert.ToDateTime(txtDateStart.Text);
DateTime fechafin = Convert.ToDateTime(txtDateEnd.Text);
dt = Documents_Trans.get_Docn_TransAdonis(fechaini, fechafin, "-1", "2").Tables[0];
if (dt.Rows.Count > 0)
{
DateTime _fecStart = Convert.ToDateTime((txtDateStart.Text.Equals(string.Empty)) ? "01/01/1900" : txtDateStart.Text);
DateTime _fecEnd = Convert.ToDateTime((txtDateEnd.Text.Equals(string.Empty)) ? "01/01/1900" : txtDateEnd.Text);
DataSet _interf = Adonis.Get_Comercial_Interface(_fecStart, _fecEnd);
DataTable dtinter = _interf.Tables[0];
DataRow[] foundRows = dtinter.Select("", "");
System.Text.StringBuilder str = new System.Text.StringBuilder();
for (int i = 0; i <= foundRows.GetUpperBound(0); i++)
{
str.Append(foundRows[i][0].ToString() + "\r\n");
}
Response.Clear();
Response.Buffer = true;
Response.ContentType = "text/plain";
Response.AddHeader("Content-Disposition", "attachment;filename=InterComerAdonis.txt");
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.Default;
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
Response.Write(str.ToString());
Response.End();
}
else
{
msnMessage.LoadMessage("No hay datos para exportar", UserControl.ucMessage.MessageType.Error);
}
}
catch (Exception exc)
{
msnMessage.LoadMessage(exc.Message, UserControl.ucMessage.MessageType.Error);
dt = null;
}
}