FIX: Download Excel file, automatically download aspx with Thunderbolt
If(request.querystring["ID"] !=NULL&&!string. IsNullOrEmpty (request.querystring["ID"]. ToString ())) {if(request.querystring["OID"] !=NULL&&!string. IsNullOrEmpty (request.querystring["OID"]. ToString ())) {ID= request.querystring["ID"]. ToString (); OID= request.querystring["OID"]. ToString (); stringSqlwhere =string. Format ("pproductnumber= ' {0} ' and ordersnumber= ' {1} '", ID, OID); List<SonOrders> li=_sonordersmanager.getorderslists (Sqlwhere); if(Li. Count >0&&li!=NULL) {MemoryStream ms=NewMemoryStream (); Iworkbook Workbook=NewHssfworkbook (); Isheet sheet=workbook. Createsheet (); Icellstyle Style1=workbook. Createcellstyle (); IFont Font=workbook. CreateFont (); Font. Fontheightinpoints= One; Style1. SetFont (font); Sheet. Defaultrowheight= -* -; for(inti =0; I <9; i++) { if(i = =0) sheet. Setcolumnwidth (i, -* the); Elsesheet. Setcolumnwidth (i, at* the); Sheet. Setdefaultcolumnstyle (i, style1); } IRow row1= Sheet. CreateRow (0); Icell Cell= Row1. Createcell (0); Cell. Setcellvalue (OID+"_ Status Detail"); Icellstyle Style2=workbook. Createcellstyle (); Style2. Alignment=HorizontalAlignment.Center; IFont Font2=workbook. CreateFont (); Font2. Fontheight= -* -; Style2. SetFont (Font2); Cell. CellStyle=Style2; Sheet. Addmergedregion (NewCellrangeaddress (0,0,0,7)); IRow HeaderRow= Sheet. CreateRow (1); Headerrow.createcell (0). Setcellvalue ("Product number"); Headerrow.createcell (1). Setcellvalue ("Time of order"); Headerrow.createcell (2). Setcellvalue ("Prototype Acceptance Time"); Headerrow.createcell (3). Setcellvalue ("first item acceptance time"); Headerrow.createcell (4). Setcellvalue ("Assembly Acceptance Time"); Headerrow.createcell (5). Setcellvalue ("factory out of stock time"); Headerrow.createcell (6). Setcellvalue ("On- site storage time"); Headerrow.createcell (7). Setcellvalue ("pick-In time"); Headerrow.createcell (8). Setcellvalue ("Open Box Acceptance time"); Headerrow.createcell (9). Setcellvalue ("Installation Completion Time"); Headerrow.createcell (Ten). Setcellvalue ("Installation Acceptance Time"); intj =2; foreach(Sonorders soinchli) {IRow dataRow= Sheet. CreateRow (j + +); Datarow.createcell (0). Setcellvalue (So. Sproductnumber); Datarow.createcell (1). Setcellvalue (Gettimes ("Time of order", so. Sproductnumber). ToString ()); Datarow.createcell (2). Setcellvalue (Gettimes ("Prototype Acceptance Time", so. Sproductnumber). ToString ()); Datarow.createcell (3). Setcellvalue (Gettimes ("first item acceptance time", so. Sproductnumber). ToString ()); Datarow.createcell (4). Setcellvalue (Gettimes ("Assembly Acceptance Time", so. Sproductnumber). ToString ()); Datarow.createcell (5). Setcellvalue (Gettimes ("factory out of stock time", so. Sproductnumber). ToString ()); Datarow.createcell (6). Setcellvalue (Gettimes ("On- site storage time", so. Sproductnumber). ToString ()); Datarow.createcell (7). Setcellvalue (Gettimes ("pick-In time", so. Sproductnumber). ToString ()); Datarow.createcell (8). Setcellvalue (Gettimes ("Open Box Acceptance time", so. Sproductnumber). ToString ()); Datarow.createcell (9). Setcellvalue (Gettimes ("Installation Completion Time", so. Sproductnumber). ToString ()); Datarow.createcell (Ten). Setcellvalue (Gettimes ("Installation Acceptance Time", so. Sproductnumber). ToString ()); } workbook. Write (MS); Ms. Flush (); Ms. Position=0; Try { string[] files = directory.getfiles (System.AppDomain.CurrentDomain.BaseDirectory +"excels/"); foreach(stringFileinchfiles) {File.delete (File); } } Catch(Exception Exx) {Response.Write (Exx. Message.tostring ()); } string pname = "state verbose _" + DateTime.Now.ToString ("YYYYMMDDHHMMSS") + ". xls"; Npoihelper.savetofile (MS, System.AppDomain.CurrentDomain.BaseDirectory + "excels/" + pname); Response.Redirect ("~/excels/" + PName, false); Response.Clear (); //Response.Clear (); //response.clearheaders (); //Response.Buffer = false; //Response.ContentType = "Application/octet-stream"; //if (Request.Browser.Browser = = "Firefox")//System.Web.HttpContext.Current.Response.AppendHeader ("Content-disposition", "attachment;filename=" + oid + "_ Status verbose. xls "); //Else//System.Web.HttpContext.Current.Response.AppendHeader ("Content-disposition", "attachment;filename=" + Httputility.urlencode (oid + "_ State verbose. xls", System.Text.Encoding.UTF8)); //System.Web.HttpContext.Current.Response.AppendHeader ("Content-length", Ms. Length.tostring ()); //System.Web.HttpContext.Current.Response.BinaryWrite (Ms. GetBuffer ()); //System.Web.HttpContext.Current.Response.Flush (); //System.Web.HttpContext.Current.Response.End (); } }
FIX: Download Excel file, automatically download aspx with Thunderbolt