public string ToXml() { XmlSerializer xmls = new XmlSerializer(typeof(User)); StringWriter writer = new StringWriter(); xmls.Serialize(writer, this); writer.Close(); return writer.ToString(); }
// ------------------------------------------ // STATIC // ------------------------------------------ #region Static // Serialization ---------------------------- /// <summary> /// Saves the xml string of this instance. /// </summary> /// <param name="object1">The object1 to save.</param> /// <param name="log">The saving log to consider.</param> /// <returns>The Xml string of this instance.</returns> public static string ToXml(this Object object1, IBdoLog log = null) { if (object1 == null) { return(string.Empty); } string st = string.Empty; StringWriter streamWriter = null; try { // if the object is a data item then we update the storage info if (object1 is DataItem dataItem) { dataItem?.UpdateStorageInfo(log); } XmlSerializer xmlSerializer = new XmlSerializer(object1.GetType()); streamWriter = new StringWriter(); xmlSerializer.Serialize(streamWriter, object1); st = streamWriter.ToString(); } catch (Exception ex) { log?.AddException(ex); } finally { streamWriter?.Close(); } return(st); }
public void Page_466() { try { strwtr = new StringWriter(); for (int i = 0; i < 10; i++) { strwtr.WriteLine("Meaning i equals: " + i); } strrdr = new StringReader(strwtr.ToString()); string str = strrdr.ReadLine(); while (str != null) { str = strrdr.ReadLine(); Console.WriteLine(str); } } catch (IOException e) { Console.WriteLine("Error I/O " + e.Message); } finally { strrdr?.Close(); strwtr?.Close(); } }
public static string DataTableToJSON(DataTable dt, string dtName) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); using (JsonWriter jw = new JsonTextWriter(sw)) { JsonSerializer ser = new JsonSerializer(); jw.WriteStartObject(); jw.WritePropertyName(dtName); jw.WriteStartArray(); foreach (DataRow dr in dt.Rows) { jw.WriteStartObject(); foreach (DataColumn dc in dt.Columns) { jw.WritePropertyName(dc.ColumnName); ser.Serialize(jw, dr[dc].ToString()); } jw.WriteEndObject(); } jw.WriteEndArray(); jw.WriteEndObject(); sw.Close(); jw.Close(); } return sb.ToString(); }
/// <summary> /// 将对象序列化成Xml字符串。 /// </summary> /// <typeparam name="T">对象的类型。</typeparam> /// <param name="sourceObject">被序列化的对象。</param> /// <param name="prefix">The prefix associated with an XML namespace.</param> /// <param name="ns">An XML namespace.</param> /// <returns></returns> public static string SerializeObjectToXmlString <T>(T sourceObject, string prefix = "", string ns = "") { string xmlString = null; StringWriter stringWriter = null; XmlWriter xmlWriter = null; try { stringWriter = new StringWriter(); var xmlNamespaces = new XmlSerializerNamespaces(); xmlNamespaces.Add(prefix, ns); var settings = new XmlWriterSettings { Indent = true, IndentChars = "\t" }; xmlWriter = XmlWriter.Create(stringWriter, settings); var serializer = new XmlSerializer(typeof(T)); serializer.Serialize(xmlWriter, sourceObject, xmlNamespaces); xmlString = xmlWriter.ToString(); } finally { xmlWriter?.Close(); xmlWriter?.Dispose(); stringWriter?.Close(); stringWriter?.Dispose(); } return(xmlString); }
private void CreateTemplateResult(Message messageResult, string methodResult) { string updateBlockControlId = this.Context.Request.Header["X-BlockRenderingId"]; if (!string.IsNullOrEmpty(updateBlockControlId)) { this._DomainControl.RenderService(messageResult, updateBlockControlId.Split('>')); } else { this._DomainControl.RenderService(messageResult, null); } if (this.Context.Response.Header.Status.Code == 200 && this._DomainControl.ServiceResult.HasErrors) { this.Context.Response.Header.Status.Code = 218; } StringBuilder sB = new StringBuilder(); sB.Append(this._DomainControl.ServiceResult.Content); sB.Append(methodResult); string result = sB.ToString(); const string sysRenderDurationMark = "<!--_sys_PAGERENDERDURATION-->"; int idxRenderDurationMark = result.IndexOf(sysRenderDurationMark, StringComparison.InvariantCulture); if (idxRenderDurationMark > -1) { TimeSpan endRequestTimeSpan = DateTime.Now.Subtract(this._BeginRequestTime); result = result.Remove(idxRenderDurationMark, sysRenderDurationMark.Length); result = result.Insert(idxRenderDurationMark, endRequestTimeSpan.TotalMilliseconds.ToString(CultureInfo.InvariantCulture)); } if (!this._DomainControl.IsWorkingAsStandAlone && string.IsNullOrEmpty(updateBlockControlId)) { StringWriter writer = null; try { writer = new StringWriter(); this.CreateHtmlTag(ref writer, result); writer.Flush(); result = writer.ToString(); } finally { writer?.Close(); } } this.WriteOutput(this._DomainControl.ServiceMimeType, result, this._SupportCompression); }
public void SavePref() { var mySeriData = new XmlSerializer(typeof(PlayerPrefsSerializer)); StringWriter Writer = new StringWriter(); mySeriData.Serialize(Writer, this); string tmp = Writer.ToString(); PlayerPrefs.SetString(key, tmp); Writer.Close(); }
// Use this for initialization public static string serialization(object o) { string text=""; TextWriter writer; XmlSerializer serialWrite = new XmlSerializer (o.GetType()); writer = new StringWriter(); serialWrite.Serialize (writer, o); text=writer.ToString(); writer.Close (); return text; }
public string ToXml() { StringWriter xmlStream = null; System.Xml.XmlTextWriter xmlWriter = null; try { xmlStream = new StringWriter(); xmlWriter = new System.Xml.XmlTextWriter(xmlStream); // Start Document Element xmlWriter.WriteStartElement("ServiceParameters"); if (this.PublicKey != null) { xmlWriter.WriteStartElement("Item"); xmlWriter.WriteAttributeString("key", "PublicKey"); xmlWriter.WriteString(this.PublicKey); xmlWriter.WriteEndElement(); } Enumerator enumerator = this.GetEnumerator(); try { while (enumerator.MoveNext()) { xmlWriter.WriteStartElement("Item"); xmlWriter.WriteAttributeString("key", enumerator.Current.Key); xmlWriter.WriteCData(enumerator.Current.Value); xmlWriter.WriteEndElement(); } } finally { enumerator.Dispose(); } // End Document Element xmlWriter.WriteEndElement(); xmlWriter.Flush(); return(xmlStream.ToString()); } catch (Exception) { return(string.Empty); } finally { xmlWriter?.Close(); xmlStream?.Close(); } }
protected void btnExport_Click(object sender, EventArgs e) { string style = @"<style> .text { mso-number-format:\@; } </script> "; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); this.GridView2.RenderControl(htw); sw.Close(); Response.AddHeader("Content-Disposition", "attachment; filename=test.xls"); Response.ContentType = "application/ms-excel"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.Write(style); Response.Write(sw); Response.End(); }
//this must be called before saving to disk private void MakeLatestXml() { if (_itemDataModel == null) { return; } StringWriter stringWriter = null; XmlWriter xmlWriter = null; string stageDesc = "(3)"; try { xmlMainType = _itemDataModel.GetType().AssemblyQualifiedName; //xmlItemDataModel = ""; _serializationError = ""; stringWriter = new StringWriter(); stageDesc = "(2)"; xmlWriter = XmlWriter.Create(stringWriter); stageDesc = "(1)"; XmlSerializer ser = new XmlSerializer(_itemDataModel.GetType());//, allsertypes); ser.Serialize(xmlWriter, _itemDataModel); _serializationError = stringWriter.ToString(); xmlWriter.Flush(); xmlItemDataModel = _serializationError; _serializationError = "XML OK"; } catch (Exception ex) { _serializationError = stageDesc + ex.Message; if (ex.InnerException != null) { _serializationError += " Inner: " + ex.InnerException.Message; } } finally { if (xmlWriter != null) { xmlWriter.Close(); } else { stringWriter?.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { string m = "<?xml version=\"1.0\"?>"; m += "<address>"; m += "<addressline1>" + "Veerannapet" + "</addressline1>"; m += "<addressline2>" + "Veerannapet2" + "</addressline2>"; m += "<city>" + "Mahabubnagar" + "</city>"; m += "<postcode>" + "509001" + "</postcode>"; m += "</address>"; string result1 = m.Replace("<?xml version=\"1.0\"?>", ""); XmlDocument docs = new XmlDocument(); docs.LoadXml(result1); string json = Newtonsoft.Json.JsonConvert.SerializeXmlNode(docs); XmlDocument doc = (XmlDocument)JsonConvert.DeserializeXmlNode(json, "Report"); XslCompiledTransform xsl = new XslCompiledTransform(); StringWriter result = new StringWriter(); xsl.Load(Server.MapPath("Focus.xslt")); XmlTextWriter tx = new XmlTextWriter(result); XmlDeclaration xmldecl; xmldecl = doc.CreateXmlDeclaration("1.0", null, null); XmlElement root = doc.DocumentElement; doc.InsertBefore(xmldecl, root); //string strs = doc.InnerXml.ToString(); doc.WriteTo(tx); xsl.Transform(doc, null, tx); result.Close(); result.Flush(); string str = result.ToString(); // ... And the result you'll send back will be usable in a report: Response.ContentType = "text/xml"; Response.Write(str.ToString()); Response.Flush(); Response.Close(); }
protected void Page_Load(object sender, EventArgs e) { string searchWords = Request.QueryString["SearchWords"]; string indexNames = Request.QueryString["IndexNames"]; //Response.Write(searchWords); string hostname = ConfigurationManager.AppSettings["HostName"]; int port = int.Parse(ConfigurationManager.AppSettings["PortNum"]); TcpClient client; NetworkStream ns; BinaryFormatter formater; DateTime now = DateTime.Now; try { client = new TcpClient(hostname, port); ns = client.GetStream(); formater = new BinaryFormatter(); SearchInfo sinfo = new SearchInfo(); QueryInfo info = new QueryInfo(); info.IndexNames = ""; info.SearchWords = searchWords; info.IndexNames = indexNames; sinfo.Query = info; sinfo.PageSize = 10; formater.Serialize(ns, sinfo); SearchResult sr = (SearchResult)formater.Deserialize(ns); //WriteLog(Server.MapPath(".") + "searchutils.log", searchWords, indexNames, sr.Records.Count, sr); XmlSerializer xmlSerializer = new XmlSerializer(typeof(SearchResult)); StringBuilder builder = new StringBuilder(); StringWriter writer = new StringWriter(builder); xmlSerializer.Serialize(writer, sr); XmlDocument doc = new XmlDocument(); doc.LoadXml(builder.ToString()); writer.Close(); ns.Close(); Response.Write(doc.DocumentElement.OuterXml); //FileStream fs = new FileStream(@"result.xml", FileMode.Truncate); //xmlSerializer.Serialize(writer, fs); //fs.Close(); } catch (Exception se) { Response.Write(se.StackTrace.ToString()); return; } }
private void ParseResponse(string response) { XmlDocument doc = null; XslTransform myXslTransform = null; StringWriter sw = null; try { doc = new XmlDocument(); ; myXslTransform = new XslTransform(); sw = new StringWriter(); doc.LoadXml(response); myXslTransform.Load("C:\\Users\\simona.EDUSOFT2\\Documents\\Visual Studio 2013\\WebSites\\WebSite1\\transform.xsl"); myXslTransform.Transform(doc, null, sw); string result = sw.ToString().Replace("xmlns:asp=\"remove\"", "").Replace("<", "<").Replace(">", ">"); Control control = Page.FindControl("MyTable"); if (control != null) { Page.Controls.Remove(control); } Control ctrl = Page.ParseControl(result); Page.Controls.Add(ctrl); MyPanel.Visible = false; } catch { //parsing or loading error displayErrorMessage(errorParsingOrLoading); } finally { sw.Close(); } }
private void CreateServiceResult(Message messageResult) { this._DomainControl.RenderService(messageResult, null); StringWriter writer = null; try { writer = new StringWriter(); writer.Write("<?xml version=\"1.0\" encoding=\"utf-8\" ?>"); writer.Write(this._DomainControl.ServiceResult.Content); writer.Flush(); } finally { writer?.Close(); } this.WriteOutput(this._DomainControl.ServiceMimeType, writer.ToString(), this._SupportCompression); }
/// <summary> ///操作DataGrid DataTable導出到Excel.繁體OS,無亂碼問題. /// </summary> /// <param name="dg">DataTable</param> /// <param name="ckID">CheckBox项的ID值 cbMail</param> /// <param name="strFileName">含.xls後綴</param> public static void DownloadAsExcel(DataGrid dg, DataSet ds, string ckID, string strFileName) { DataTable dt = GetSelectedTable(dg, ckID, ds); if (dt == null) { dt = new DataTable(); } try { StringWriter sw = new StringWriter(); string colstr = ""; foreach (DataColumn col in dt.Columns) { colstr += col.ColumnName + "\t"; } sw.WriteLine(colstr); foreach (DataRow row in dt.Rows) { colstr = ""; foreach (DataColumn col in dt.Columns) { colstr += row[col.ColumnName].ToString() + "\t"; } sw.WriteLine(colstr); } sw.Close(); System.Web.HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + strFileName + ""); System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel"; System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default; System.Web.HttpContext.Current.Response.Write(sw); System.Web.HttpContext.Current.Response.End(); } catch (Exception ex) { } }
protected void printbutton_Click(object sender, EventArgs e) { // Create a Document object Document document = new Document(); string contents = string.Empty; //string contents = File.ReadAllText(Server.MapPath("~/pdftest.html")); //string css = File.ReadAllText(Server.MapPath("~/Content/Site.css")); MemoryStream ms = new MemoryStream(); using (StringWriter sw = new StringWriter()) { Server.Execute("pdf.aspx", sw); contents = sw.ToString(); sw.Close(); } //ICSSResolver resolver = XMLWorkerHelper.GetInstance().GetDefaultCssResolver(true); //string css = Server.MapPath("~/Content/Site.css"); //resolver.AddCssFile(css, true); }
/// <summary> /// SERIALIZACION DE OBJETO /// </summary> /// <returns></returns> public string Serialize(Object Objeto) { //=============================================================== // DECLARACION DE VARIABLES //=============================================================== StringBuilder Sb = new StringBuilder(); StringWriter Sw = new StringWriter(Sb); JsonWriter Writer = new JsonTextWriter(Sw); JsonSerializer Serializer = new JsonSerializer(); try { //=========================================================== // SERIALIZAR //=========================================================== Serializer.Serialize(Writer, Objeto); String JsonResult = Sb.ToString(); //=========================================================== // RETORNO //=========================================================== return(JsonResult); } catch { throw; } finally { Sb.Clear(); Sw.Close(); Writer.Close(); Serializer = null; } }
/// <summary> /// 序列化数据为Json数据格式. /// </summary> /// <param name="value">被序列化的对象</param> /// <param name="clearLastZero">是否清除小数位后的0</param> /// <returns></returns> public static dynamic ObjectToJson(object value, bool clearLastZero) { Type type = value.GetType(); JsonSerializer json = new JsonSerializer(); //json.NullValueHandling = NullValueHandling.Ignore; json.ObjectCreationHandling = ObjectCreationHandling.Replace; json.MissingMemberHandling = MissingMemberHandling.Ignore; json.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; json.Converters.Add(new StringEnumConverter()); IsoDateTimeConverter timeFormate = new IsoDateTimeConverter(); timeFormate.DateTimeFormat = "yyyy-MM-dd"; json.Converters.Add(timeFormate); json.Formatting = Formatting.Indented; json.NullValueHandling = NullValueHandling.Ignore; if (clearLastZero) { json.Converters.Add(new MinifiedNumArrayConverter()); } StringWriter sw = new StringWriter(); JsonTextWriter writer = new JsonTextWriter(sw); writer.Formatting = Formatting.None; writer.QuoteChar = '"'; writer.QuoteName = false; json.Serialize(writer, value); string output = sw.ToString(); writer.Close(); sw.Close(); // return JObject.Parse(output); return(output); }
public static string TransformXml(string xml, string xsl) { //create an object to perform the XSLT transformation XslCompiledTransform xct = new XslCompiledTransform(); //create an object to recieve the results of the transformation StringWriter outStream = null; XmlDocument xmlDoc = new XmlDocument(); XmlDocument xslDoc = new XmlDocument(); xmlDoc.LoadXml(xml); xslDoc.Load(xsl); try { outStream = new StringWriter(); // load the xslt xct.Load(xsl); // transform the xml document and pass the results to the Stream object xct.Transform(xmlDoc, null, outStream); // send the result back to the calling function return(outStream.ToString()); } finally { if (outStream != null) { //close the stream outStream.Close(); outStream.Dispose(); } } }
/// <summary> /// Serializes the specified obj. /// </summary> /// <param name="obj">The obj.</param> /// <returns></returns> public static string SerializeXml(object obj, Encoding encoding) { if (obj == null) { return(null); } if (handlers.ContainsKey(obj.GetType())) { return(handlers[obj.GetType()].Key(obj)); } else { if (encoding == Encoding.Default) { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); XmlSerializer serializer = new XmlSerializer(obj.GetType()); serializer.Serialize(sw, obj); sw.Close(); return(sb.ToString()); } else { MemoryStream ms = new MemoryStream(); XmlTextWriter xw = new XmlTextWriter(ms, encoding); xw.Formatting = System.Xml.Formatting.Indented; xw.WriteStartDocument(); XmlSerializer serializer = new XmlSerializer(obj.GetType()); serializer.Serialize(xw, obj); xw.Close(); var serializedObject = ms.ToArray(); ms.Close(); return(encoding.GetString(serializedObject)); } } }
/// <summary> /// Converts datasets into xml, stores xml into dicts, serializes dicts into binary and saves this to given location. /// </summary> /// <param path="save location"></param> public void exportTables(String path) { BinaryFormatter b = new BinaryFormatter(); Stream s = File.OpenWrite(path); Dictionary <string, string> xmlStringDict = new Dictionary <string, string>(); StringWriter sw = new StringWriter(); this.ancestories.WriteXml(sw); xmlStringDict.Add("ancestories", sw.ToString()); sw = new StringWriter(); this.traitsDict.WriteXml(sw); xmlStringDict.Add("traitsDict", sw.ToString()); sw = new StringWriter(); this.equipment.WriteXml(sw); xmlStringDict.Add("equipment", sw.ToString()); sw = new StringWriter(); this.experiences.WriteXml(sw); xmlStringDict.Add("experiences", sw.ToString()); sw = new StringWriter(); this.types.WriteXml(sw); xmlStringDict.Add("types", sw.ToString()); sw = new StringWriter(); this.sizes.WriteXml(sw); xmlStringDict.Add("sizes", sw.ToString()); sw = new StringWriter(); b.Serialize(s, xmlStringDict); sw.Close(); s.Close(); }
private void reformatXmlButton_Click(object sender, EventArgs e) { XmlWriter xmlWriter = null; StringWriter stringWriter = null; try { XmlDocument xmlDocument = new XmlDocument(); xmlDocument.LoadXml(textBox.Text); stringWriter = new StringWriter(); XmlWriterSettings settings = new XmlWriterSettings(); settings.Indent = true; settings.IndentChars = "\t"; settings.OmitXmlDeclaration = true; xmlWriter = XmlTextWriter.Create(stringWriter, settings); xmlDocument.Save(xmlWriter); textBox.Text = stringWriter.ToString(); } catch (Exception exception) { MessageBox.Show(exception.Message, "DILE - XML Reformatting Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { if (xmlWriter != null) { xmlWriter.Close(); } if (stringWriter != null) { stringWriter.Close(); } } }
public static string GetToursXML(List <Tour> sqlTours) { if (sqlTours.Count > 0) { using (StringWriter sw = new StringWriter()) { using (XmlTextWriter xmlWriter = new XmlTextWriter(sw)) { xmlWriter.Formatting = Formatting.Indented; xmlWriter.WriteProcessingInstruction("xml", "version=\"1.0\" encoding=\"UTF-8\""); xmlWriter.WriteStartElement("Folder"); foreach (Tour tr in sqlTours) { xmlWriter.WriteStartElement("Tour"); xmlWriter.WriteAttributeString("Title", tr.TourTitle); xmlWriter.WriteAttributeString("ID", tr.TourGuid.ToString()); xmlWriter.WriteAttributeString("Description", tr.TourDescription); xmlWriter.WriteAttributeString("Classification", "Other"); xmlWriter.WriteAttributeString("AuthorEmail", tr.AuthorEmailAddress); xmlWriter.WriteAttributeString("Author", tr.AuthorName); xmlWriter.WriteAttributeString("AuthorUrl", tr.AuthorURL); xmlWriter.WriteAttributeString("AverageRating", tr.AverageRating.ToString()); xmlWriter.WriteAttributeString("LengthInSecs", tr.LengthInSecs.ToString()); xmlWriter.WriteAttributeString("OrganizationUrl", tr.OrganizationURL); xmlWriter.WriteAttributeString("OrganizationName", tr.OrganizationName); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); xmlWriter.Close(); } sw.Close(); return(sw.ToString()); } } return(""); }
public void TypeReferenceExpressionTest() { StringBuilder sb = new StringBuilder(); using (StringWriter sw = new StringWriter(sb)) { CodeThisReferenceExpression thisRef = new CodeThisReferenceExpression(); CodeFieldReferenceExpression parentField = new CodeFieldReferenceExpression(); parentField.TargetObject = thisRef; parentField.FieldName = "Parent"; CodeBinaryOperatorExpression expression = new CodeBinaryOperatorExpression( parentField, CodeBinaryOperatorType.IdentityInequality, new CodePrimitiveExpression(null)); Assert.AreEqual("(Not (Me.Parent) Is Nothing)", Generate(expression, sw), "#1"); sw.Close(); } sb = new StringBuilder(); using (StringWriter sw = new StringWriter(sb)) { CodeThisReferenceExpression thisRef = new CodeThisReferenceExpression(); CodeFieldReferenceExpression parentField = new CodeFieldReferenceExpression(); parentField.TargetObject = thisRef; parentField.FieldName = "Parent"; CodeBinaryOperatorExpression expression = new CodeBinaryOperatorExpression( new CodePrimitiveExpression(null), CodeBinaryOperatorType.IdentityInequality, parentField); Assert.AreEqual("(Not (Me.Parent) Is Nothing)", Generate(expression, sw), "#2"); sw.Close(); } }
public static void ExcelXMLRpt(DataSet dsBook, string filename, string[] sheetname, string[] titles, string[][] colsNames, string[][] colsFormat) { StringWriter sw = new StringWriter(); sw.WriteLine("<?xml version=\"1.0\"?>"); sw.WriteLine("<?mso-application progid=\"Excel.Sheet\"?>"); sw.WriteLine("<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\""); sw.WriteLine(" xmlns:o=\"urn:schemas-microsoft-com:office:office\""); sw.WriteLine(" xmlns:x=\"urn:schemas-microsoft-com:office:excel\""); sw.WriteLine(" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\""); sw.WriteLine(" xmlns:html=\"http://www.w3.org/TR/REC-html40/\">"); sw.Write(xlDocProp().ToString()); sw.WriteLine(" <ExcelWorkbook xmlns=\"urn:schemas-microsoft-com:office:excel\">"); sw.WriteLine(" <WindowHeight>8955</WindowHeight>"); sw.WriteLine(" <WindowWidth>11355</WindowWidth>"); sw.WriteLine(" <WindowTopX>480</WindowTopX>"); sw.WriteLine(" <WindowTopY>15</WindowTopY>"); sw.WriteLine(" <ProtectStructure>False</ProtectStructure>"); sw.WriteLine(" <ProtectWindows>False</ProtectWindows>"); sw.WriteLine(" </ExcelWorkbook>"); sw.Write(xlStyles().ToString()); sw.Write(AddWorksheets(sheetname, titles, colsNames, colsFormat, dsBook)); sw.WriteLine("</Workbook>"); sw.Close(); HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Charset = ""; HttpContext.Current.Response.ClearContent(); HttpContext.Current.Response.ClearHeaders(); HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=" + filename + ".xls"); HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"; HttpContext.Current.Response.Write(sw.ToString()); HttpContext.Current.Response.End(); }
public void End() { TextWriter ftw = _sg.GetTextWriter(); // the final text writer location ftw.Write(@"{\rtf1\ansi"); // start of the rtf file // information group PutInformationGroup(ftw); // page metrics PutPageMetrics(ftw); // do the font table PutFontTable(ftw); // do the color table PutColorTable(ftw); // write out the body of the rtf file ftw.Write(tw.ToString()); tw.Close(); tw = null; ftw.WriteLine(@"}"); // end of the rtf file if (_g != null) { _g.Dispose(); _g = null; } if (_bm != null) { _bm.Dispose(); _bm = null; } return; }
/// <summary> /// The decode. /// </summary> /// <param name="encoded"> /// The encoded. /// </param> /// <returns> /// The decode. /// </returns> /// <exception cref="ArgumentNullException"> /// </exception> public static string Decode(string encoded) { if (encoded == null) { throw new ArgumentNullException(); } string line; var sw = new StringWriter(); var sr = new StringReader(encoded); try { while ((line = sr.ReadLine()) != null) { if (line.EndsWith("=")) { sw.Write(HexDecoder(line.Substring(0, line.Length - 1))); } else { sw.WriteLine(HexDecoder(line)); } sw.Flush(); } return(sw.ToString()); } finally { sw.Close(); sr.Close(); sw = null; sr = null; } }
public static void SaveTableConfiguration(Table xpTable, string keyName) { try { XPTableConfiguration tableConfig = new XPTableConfiguration(); foreach (Column col in xpTable.ColumnModel.Columns) { XPTableColumn column = new XPTableColumn(); column.Width = col.Width; column.Visible = col.Visible; tableConfig.TableColumns.Add(column); } if (xpTable.SortingColumn >= 0) { tableConfig.SortColumn = xpTable.SortingColumn; tableConfig.SortOrder = (int)xpTable.ColumnModel.Columns[tableConfig.SortColumn].SortOrder; } XmlSerializer bf = new XmlSerializer(typeof(XPTableConfiguration)); StringWriter stream = new StringWriter(); bf.Serialize(stream, tableConfig); stream.Close(); string xml = stream.ToString(); using (RegistryKey regKey = Registry.CurrentUser.CreateSubKey(Settings.HitbaseRegistryKey)) { regKey.SetValue(keyName, xml); } } catch (Exception e) { MessageBox.Show(e.ToString(), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void SendPosition() { List <PlayerData> playerDataList = new List <PlayerData>(); foreach (ClientPeer peer in MyGameServer.Instance.clientPeers) { if (string.IsNullOrEmpty(peer.username) == false) { PlayerData playerData = new PlayerData(); playerData.Username = peer.username; playerData.Pos = new Vector3Data() { x = peer.x, y = peer.y, z = peer.z }; playerDataList.Add(playerData); } } StringWriter sw = new StringWriter(); XmlSerializer serializer = new XmlSerializer(typeof(List <PlayerData>)); serializer.Serialize(sw, playerDataList); sw.Close(); string playerDataListString = sw.ToString(); // MyGameServer.log.Info(playerDataListString); Dictionary <byte, object> data = new Dictionary <byte, object>(); data.Add((byte)ParameterCode.PlayerDataList, playerDataListString); foreach (ClientPeer peer in MyGameServer.Instance.clientPeers) { if (string.IsNullOrEmpty(peer.username) == false) { EventData ed = new EventData((byte)EventCode.SyncPos); ed.Parameters = data; peer.SendEvent(ed, new SendParameters()); } } }
public void ExportHistoricosToExcel(ICollection <PortalChamadosHistorico> model) { System.Text.Encoding encoding = System.Text.Encoding.Unicode; StringWriter sw = new StringWriter(); string linha = string.Empty; linha = "NR.HISTÓRICO;DATA INCLUSÃO;DATA PREVISTA;DATA ADIADA;DE STATUS;PARA STATUS;DESCRIÇÃO"; sw.WriteLine(linha); foreach (var item in model) { linha = string.Empty; linha += item.ChamadoHistID + ";"; linha += item.DtIncl.ToShortDateString() + ";"; linha += item.PortalChamados.ChamadoDtPrevista.ToShortDateString() + ";"; if (item.DtAdiar != null) { linha += item.DtAdiar + ";"; } else { linha += ";"; } linha += item.DeStatus + ";"; linha += item.ParaStatus + ";"; linha += item.Descricao; sw.WriteLine(linha); } sw.Close(); Response.ClearContent(); Response.ContentEncoding = encoding; Response.AddHeader("content-disposition", "attachment; filename=Historico_" + model.First().PortalChamados.ChamadoTitulo + "_" + System.Web.HttpContext.Current.Session["NomeUsuario"].ToString() + ".csv"); Response.ContentType = "application/excel"; Response.Write(sw); Response.End(); }
public string Serialize(Reporter reporter) { string str = ""; StringWriter sw = null; XmlWriter xw = null; XmlSerializerNamespaces ns = null; try { XmlWriterSettings settings = new XmlWriterSettings() { Encoding = Encoding.UTF8, Indent = true, OmitXmlDeclaration = true }; ns = new XmlSerializerNamespaces(); ns.Add(string.Empty, string.Empty); sw = new StringWriter(); xw = XmlWriter.Create(sw, settings); xmlSerializer.Serialize(xw, this, ns); str = sw.ToString(); } catch (Exception ex) { throw ex; } finally { xw?.Close(); xw?.Dispose(); sw?.Close(); sw?.Dispose(); } return(str); }
public static string ConvertToXml(object toSerialize, Type objectType) { // create a string wrtiter to hold the xml string // the a xml writer with the proper settings. // use that writer to serialize the document. // use an namespace to create a fully qualified odcument. StringWriter aWriter = new StringWriter(); XmlWriterSettings settings = new XmlWriterSettings(); settings.OmitXmlDeclaration = true; settings.ConformanceLevel = ConformanceLevel.Document; // Fragment fails settings.Indent = false; settings.Encoding = System.Text.Encoding.UTF8; XmlWriter xWriter = XmlWriter.Create(aWriter, settings); new XmlSerializerNamespaces(); XmlSerializerNamespaces myNamespaces = new XmlSerializerNamespaces(); myNamespaces.Add("wtr", "http://www.cuahsi.org/waterML/1_1/"); myNamespaces.Add("xsd", "http://www.w3.org/2001/XMLSchema"); myNamespaces.Add("xsi", "http://www.w3.org/2001/XMLSchema-instance"); myNamespaces.Add("gml", "http://www.opengis.net/gml"); myNamespaces.Add("xlink", "http://www.w3.org/1999/xlink"); myNamespaces.Add("xml", "http://www.w3.org/XML/1998/namespace"); XmlSerializer aSerializer = new XmlSerializer(objectType); //aSerialize(xWriter, toSerialize); aSerializer.Serialize(xWriter, toSerialize, myNamespaces); string xml = aWriter.ToString(); aWriter.Flush(); aWriter.Close(); return(xml); }
public void TestConsoleLogging() { lock (ConsoleMutex.mutex) { var writer = new StringWriter(); try { Console.SetOut(writer); SetUpLogger(10000, 500, 10); log4netLog.Info("hello"); writer.Flush(); var consoleText = writer.GetStringBuilder().ToString(); Assert.True(!string.IsNullOrWhiteSpace(consoleText)); } finally { var standardOutput = new StreamWriter(Console.OpenStandardOutput()); standardOutput.AutoFlush = true; Console.SetOut(standardOutput); writer.Close(); } } }
/// <summary> /// This method serializes a T object to a xml string representation. /// </summary> /// <param name="settings">The T object to serialize</param> /// <param name="omitNamespace">if set to <c>true</c> the namespace declaration withing the root node will be omitted.</param> /// <param name="omitXmlDeclaration">if set to <c>true</c> the xml declaration at the beginning of the string will be omitted.</param> /// <returns> /// The xml representation of the specified object, string.Empty if an error occurred. /// </returns> public static string ConvertToXml(T settings, bool omitNamespace, bool omitXmlDeclaration) { string xml = string.Empty; if (settings != null) { try { XmlSerializer serializer = new XmlSerializer(typeof(T)); using (StringWriter writer = new StringWriter(CultureInfo.InvariantCulture)) { if (omitNamespace) { XmlSerializerNamespaces ns = new XmlSerializerNamespaces(); ns.Add("", ""); serializer.Serialize((TextWriter)writer, settings, ns); } else { serializer.Serialize((TextWriter)writer, settings); } xml = writer.ToString(); writer.Close(); } if (omitXmlDeclaration) { xml = xml.Remove(0, xml.IndexOf('\n')).Trim(); } } catch { xml = string.Empty; } } return(xml); }
[Ignore] // TODO remove with instrumentation public void LogHandlingError() { if (!EventLog.SourceExists(EventLogSource)) { return; } Exception ex = new Exception(exceptionMessage); ExceptionUtility.FormatExceptionHandlingExceptionMessage(policy, null, null, ex); StringBuilder message = new StringBuilder(); StringWriter writer = null; try { writer = new StringWriter(message); TextExceptionFormatter formatter = new TextExceptionFormatter(writer, ex); formatter.Format(); } finally { if (writer != null) { writer.Close(); } } using (EventLog log = new EventLog(EventLogName)) { EventLogEntry entry = log.Entries[log.Entries.Count - 1]; Assert.AreEqual(EventLogEntryType.Error, entry.EntryType); Assert.AreEqual(EventLogSource, entry.Source); } }
/// <summary> /// Save gets the xml respresentation /// for the given object instance /// </summary> /// <param name="obj"> /// Object instance /// </param> /// <returns> /// XAML string representing object instance /// </returns> /// <remarks> /// This API requires unmanaged code permission /// </remarks> public static string Save(object obj) { // Validate input arguments if (obj == null) { throw new ArgumentNullException("obj"); } // Create TextWriter StringBuilder sb = new StringBuilder(); TextWriter writer = new StringWriter(sb, TypeConverterHelper.InvariantEnglishUS); try { Save(obj, writer); } finally { // Close writer writer.Close(); } return(sb.ToString()); }
/// <summary> /// Returns an XML version of the reflected PDU /// </summary> /// <param name="pdu">PDU to reflect into XML</param> /// <returns>StringBuilder</returns> public StringBuilder XmlDecodePdu(object pdu) { var sb = new StringBuilder(); using (var stringWriter = new StringWriter(CultureInfo.InvariantCulture)) { try { xmlSerializedData = new XmlSerializer(pdu.GetType()); xmlSerializedData.Serialize(stringWriter, pdu); } catch { throw; } finally { sb.Append(stringWriter.ToString()); stringWriter.Close(); } } return(sb); }
public static string ExportProjectWithTheirTasks(TeisterMaskContext context) { var serializer = new XmlSerializer(typeof(ExportProjectsWithTasksDTO[]), new XmlRootAttribute("Projects")); var projects = context.Projects .ToArray() .Where(p => p.Tasks.Any()) .Select(p => new ExportProjectsWithTasksDTO { TasksCount = p.Tasks.Count, Name = p.Name, HasEndDate = p.DueDate.HasValue ? "Yes" : "No", Tasks = p.Tasks.Select(t => new ExportTasksForProjectsDTO { Name = t.Name, Label = t.LabelType.ToString() }) .OrderBy(t => t.Name) .ToArray() }) .OrderByDescending(p => p.TasksCount) .ThenBy(p => p.Name) .ToArray(); var namespaces = new XmlSerializerNamespaces(); namespaces.Add("", ""); var writer = new StringWriter(); serializer.Serialize(writer, projects, namespaces); writer.Close(); return(writer.ToString()); }
public override string CreateJson(int jsonStartRow, int jsonendRow) { if (!IsValid()) { throw new Exception("For Two Column Group, You need to have exactly two columns"); } var data = new List <DataModel>(); for (int row = jsonStartRow; row <= jsonendRow && row <= end.Row; row++) { Count++; data.Add(new DataModel { Col1 = GetCellStringValue(row, 1), Col2 = GetCellStringValue(row, 2), }); } var dictionary = data.GroupBy(d => d.Col1).ToDictionary(d => d.Key, d => d.Select(v => v.Col2)); var arrayDictionary = dictionary.Select(d => new Dictionary <string, object> { [fieldNames[1]] = d.Key, [fieldNames[2]] = d.Value }).ToList(); StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); var jsonWriter = new JsonTextWriter(sw) { //Use indentation for readability. Formatting = Formatting.Indented }; jsonWriter.WriteRaw(JsonConvert.SerializeObject(arrayDictionary)); jsonWriter.Close(); sw.Close(); return(sb.ToString()); }
protected void imgSearchIcon_Click(object sender, ImageClickEventArgs e) { string helpCultureName = _cultureCookie != null ? _cultureCookie.Value : string.Empty; string rootUrl = HelpSiteMapProvider.GetProviderRootUrlByCultureName(helpCultureName); string contentIndexName = "HelpContentIndex:" + rootUrl; ContentIndex myContentIndex = null; ContentSearchResult mySearchResult = null; XmlDocument doc = new XmlDocument(); XslCompiledTransform xslt = new XslCompiledTransform(); XsltArgumentList xsltArgs = new XsltArgumentList(); StringWriter xsltResult = null; string exprPageTitle = @"(?si)(?:(?<=<meta\s*name\s*=\s*(?:""|')menuText(?:""|')\s*content\s*=\s*(?:""|'))(?<contentAttribute>.*?[^(?:"")]*)(?=(?:"")[^>]*>)|(?<=<meta\s*content\s*=\s*(?:""|'))(?<contentAttribute>.*?[^(?:"")]*)(?=(?:"")\s*name\s*=\s*(?:""|')menuText(?:""|')\s*[^>]*>))"; if (txtSearch.Text.Length > 0) { try { myContentIndex = Application[contentIndexName] as ContentIndex; if (myContentIndex == null) { myContentIndex = new ContentIndex(Page.MapPath(rootUrl), exprPageTitle); Application[contentIndexName] = myContentIndex; } mySearchResult = myContentIndex.Search(txtSearch.Text); doc.LoadXml(mySearchResult.ToXml()); xslt.Load(Server.MapPath("css/searchResult.xsl")); xsltArgs.AddParam("hrefPrefix", string.Empty, Request.Url.GetLeftPart(System.UriPartial.Path) + "?page=Help&content="); xsltArgs.AddParam("relativeURL", string.Empty, rootUrl); xsltArgs.AddParam("mappedURL", string.Empty, Page.MapPath(rootUrl)); xsltResult = new StringWriter(); xslt.Transform(doc, xsltArgs, xsltResult); litMainContent.Text = xsltResult.ToString(); } catch (XmlException xmlEx) { if (xmlEx.Message.ToLowerInvariant().Contains("root")) { //Missing root element. litMainContent.Text = String.Format(GetLocalResourceObject("NoContentFound").ToString(), txtSearch.Text); } else { litMainContent.Text = String.Format(GetLocalResourceObject("UnableToSearch").ToString(), xmlEx.Message); } } catch (Exception ex) { litMainContent.Text = String.Format(GetLocalResourceObject("UnableToSearch").ToString(), ex.Message); } finally { if (xsltResult != null) xsltResult.Close(); } } }
public static string ConvertToXml(object toSerialize, Type objectType) { // create a string wrtiter to hold the xml string // the a xml writer with the proper settings. // use that writer to serialize the document. // use an namespace to create a fully qualified odcument. StringWriter aWriter = new StringWriter(); XmlWriterSettings settings = new XmlWriterSettings(); settings.OmitXmlDeclaration = true; settings.ConformanceLevel = ConformanceLevel.Document; // Fragment fails settings.Indent = false; settings.Encoding = System.Text.Encoding.UTF8; XmlWriter xWriter = XmlWriter.Create(aWriter, settings); new XmlSerializerNamespaces(); XmlSerializerNamespaces myNamespaces = new XmlSerializerNamespaces(); myNamespaces.Add("wtr", "http://www.cuahsi.org/waterML/1_1/"); myNamespaces.Add("xsd", "http://www.w3.org/2001/XMLSchema"); myNamespaces.Add("xsi", "http://www.w3.org/2001/XMLSchema-instance"); myNamespaces.Add("gml", "http://www.opengis.net/gml"); myNamespaces.Add("xlink", "http://www.w3.org/1999/xlink"); myNamespaces.Add("xml", "http://www.w3.org/XML/1998/namespace"); XmlSerializer aSerializer = new XmlSerializer(objectType); //aSerialize(xWriter, toSerialize); aSerializer.Serialize(xWriter, toSerialize, myNamespaces); string xml = aWriter.ToString(); aWriter.Flush(); aWriter.Close(); return xml; }
/// <summary> /// Retrieve an array of entires and write them to an output stream /// </summary> public HttpStatusCode Query(bool count, string query, TextWriter output) { HttpStatusCode status = _constructorStatus; FileStream resourceStream = null; try { string[] filter = null, select = null; if (status == HttpStatusCode.OK) { status = ParseQuery(query, out filter, out select); } if (status == HttpStatusCode.OK) { resourceStream = new FileStream(_restdFile, FileMode.Open, FileAccess.Read, FileShare.ReadWrite); if (resourceStream == null) { status = HttpStatusCode.InternalServerError; } } char[] entryBuffer = null; if (status == HttpStatusCode.OK) { resourceStream.Seek(64 + _byteOrderMarkSize, SeekOrigin.Begin); StreamReader resourceReader = new StreamReader(resourceStream); if (count && (filter == null || filter.Length == 0)) { FileInfo resourceInfo = new FileInfo(_restdFile); long entityCount = (resourceInfo.Length - 64) / _blockSize; output.Write(entityCount); } else { entryBuffer = new char[_blockSize]; if (!count) { output.Write(@"{ ""d"": ["); } int index = 0, total = 0; int bytesRead = resourceReader.Read(entryBuffer, 0, _blockSize); while (bytesRead == _blockSize) { if (entryBuffer[0] == '{') { if (filter == null || filter.Length == 0) { if (total > 0) { output.Write(','); } output.Write(EntryPrefixFormat, _serviceUri, _resourcePath, index); WriteEntryProperties(entryBuffer, select, output); output.Write('}'); total++; } else { StringBuilder entryBuilder = new StringBuilder(); StringWriter entryWriter = new StringWriter(entryBuilder); entryWriter.Write(EntryPrefixFormat, _serviceUri, _resourcePath, index); WriteEntryProperties(entryBuffer, select, entryWriter); entryWriter.Write('}'); entryWriter.Close(); string entry = entryBuilder.ToString(); entryBuilder = new StringBuilder(); entryWriter = new StringWriter(entryBuilder); entryWriter.Write(EntryPrefixFormat, _serviceUri, _resourcePath, index); WriteEntryProperties(entryBuffer, null, entryWriter); entryWriter.Write('}'); entryWriter.Close(); string fullEntry = entryBuilder.ToString(); bool inFilter = true; for (int i = 0; i < filter.Length; i++) { if (!IsInFilter(fullEntry, filter[i])) { inFilter = false; break; } } if (inFilter) { if (!count) { if (total > 0) { output.Write(","); } output.Write(entry); } total++; } } } index++; bytesRead = resourceReader.Read(entryBuffer, 0, _blockSize); } if (count) { output.Write(total); } else { output.Write("] }"); } } } } catch (Exception) { status = HttpStatusCode.InternalServerError; } finally { if (resourceStream != null) { resourceStream.Close(); } } return status; }
private static string GenerateCode(string expression) { var source = new StringBuilder(); var sw = new StringWriter(source); var options = new CodeGeneratorOptions(); var myNamespace = new CodeNamespace("ExpressionEvaluator"); myNamespace.Imports.Add(new CodeNamespaceImport("System")); var classDeclaration = new CodeTypeDeclaration { IsClass = true, Name = "Calculator", Attributes = MemberAttributes.Public }; var myMethod = new CodeMemberMethod { Name = "Calculate", ReturnType = new CodeTypeReference(typeof(double)), Attributes = MemberAttributes.Public }; myMethod.Statements.Add(new CodeMethodReturnStatement(new CodeSnippetExpression(expression))); classDeclaration.Members.Add(myMethod); myNamespace.Types.Add(classDeclaration); provider.GenerateCodeFromNamespace(myNamespace, sw, options); sw.Flush(); sw.Close(); return source.ToString(); }
// Function : Export_with_XSLT_Windows // Arguments : dsExport, sHeaders, sFileds, FormatType, FileName // Purpose : Exports dataset into CSV / Excel format private void Export_with_XSLT_Windows(DataSet dsExport, string[] sHeaders, string[] sFileds, ExportFormat FormatType, string FileName) { try { // XSLT to use for transforming this dataset. MemoryStream stream = new MemoryStream( ); XmlTextWriter writer = new XmlTextWriter(stream, Encoding.UTF8); CreateStylesheet(writer, sHeaders, sFileds, FormatType); writer.Flush( ); stream.Seek( 0, SeekOrigin.Begin); XmlDocument xsl = new XmlDocument(); xsl.Load(stream); //XslTransform xslTran = new XslTransform(); //xslTran.Load(new XmlTextReader(stream), null, null); //System.IO.StringWriter sw = new System.IO.StringWriter(); //xslTran.Transform(xmlDoc, null, sw, null); XmlDataDocument xmlDoc = new XmlDataDocument(dsExport); StringWriter sw = new StringWriter(); XmlTextWriter xtw = new XmlTextWriter(sw); XslCompiledTransform t = new XslCompiledTransform(); t.Load((IXPathNavigable)xsl, null, null); t.Transform((IXPathNavigable)xmlDoc, xtw); //Writeout the Content File.WriteAllText(FileName, sw.ToString()); sw.Close(); xtw.Close(); writer.Close(); stream.Close(); sw.Dispose(); stream.Dispose(); } catch(Exception Ex) { throw Ex; } }
protected string GetXmlRecord(XmlSerializer xmlSerializer ,SearchRecord record) { StringBuilder builder = new StringBuilder(); StringWriter writer = new StringWriter(builder); xmlSerializer.Serialize(writer, record); XmlDocument doc = new XmlDocument(); doc.LoadXml(builder.ToString()); writer.Close(); return doc.DocumentElement.OuterXml; }
/// <summary> /// Returns a <see cref="System.String"/> that represents the current <see cref="IniFile"/>. /// </summary> /// <returns>A <see cref="System.String"/> that represents the current <see cref="IniFile"/>.</returns> public override string ToString() { string res; StringWriter writer = new StringWriter(); writer.NewLine = "\n"; Save(writer); res = writer.ToString(); writer.Close(); return res; }
/// <summary> /// Return an array of entires as a string /// </summary> public string Query(string query) { StringBuilder entryBuilder = new StringBuilder(); StringWriter entryWriter = null; try { entryWriter = new StringWriter(entryBuilder); if (Query(query, entryWriter) == HttpStatusCode.OK) { return entryBuilder.ToString(); } else { return "[]"; } } catch (Exception) { return "[]"; } finally { entryWriter.Close(); } }
private string GetEntryString(int index, char[] entryBuffer) { StringBuilder entryBuilder = new StringBuilder(); StringWriter entryWriter = new StringWriter(entryBuilder); entryWriter.Write(EntryPrefixFormat, _resourceName, index); WriteEntryProperties(entryBuffer, entryWriter); entryWriter.Write('}'); entryWriter.Close(); return entryBuilder.ToString(); }
protected void btnExport_Click(object sender, EventArgs e) { try { StringWriter swCSV = new StringWriter(); QueryDS.Export_VendorDataTable tbVendorView = new MasterDataBLL().GetVendorViewByExport(this.getSearchCondition()); StringBuilder sbText = new StringBuilder(); sbText = AppendCSVFields(sbText, "VNSTAT"); sbText = AppendCSVFields(sbText, "VMID"); sbText = AppendCSVFields(sbText, "VENDOR"); sbText = AppendCSVFields(sbText, "VNDNAM"); sbText = AppendCSVFields(sbText, "VNDAD1"); sbText = AppendCSVFields(sbText, "VNDAD2"); sbText = AppendCSVFields(sbText, "VCITY"); sbText = AppendCSVFields(sbText, "VSTATE"); sbText = AppendCSVFields(sbText, "VPOST"); sbText = AppendCSVFields(sbText, "VTERMS"); sbText = AppendCSVFields(sbText, "VTYPE"); sbText = AppendCSVFields(sbText, "VPAYTO"); sbText = AppendCSVFields(sbText, "VDTLPD "); sbText = AppendCSVFields(sbText, "VDAYCL"); sbText = AppendCSVFields(sbText, "VGL"); sbText = AppendCSVFields(sbText, "V1099"); sbText = AppendCSVFields(sbText, "V1099C "); sbText = AppendCSVFields(sbText, "VPHONE"); sbText = AppendCSVFields(sbText, "VCMPNY"); sbText = AppendCSVFields(sbText, "VCURR"); sbText = AppendCSVFields(sbText, "VPAYTY"); sbText = AppendCSVFields(sbText, "V1TIME"); sbText = AppendCSVFields(sbText, "VCORPV"); sbText = AppendCSVFields(sbText, "VHOLD"); sbText = AppendCSVFields(sbText, "VHOLDT"); sbText = AppendCSVFields(sbText, "VPYTYR"); sbText = AppendCSVFields(sbText, "VDSCAV"); sbText = AppendCSVFields(sbText, "VDSCTK"); sbText = AppendCSVFields(sbText, "VDPURS"); sbText = AppendCSVFields(sbText, "VNNEXT"); sbText = AppendCSVFields(sbText, "VNGEN"); sbText = AppendCSVFields(sbText, "VNALPH "); sbText = AppendCSVFields(sbText, "VNUNAL"); sbText = AppendCSVFields(sbText, "VCON"); sbText = AppendCSVFields(sbText, "VCOUN"); sbText = AppendCSVFields(sbText, "V1099S"); sbText = AppendCSVFields(sbText, "VPAD1"); sbText = AppendCSVFields(sbText, "VPAD2"); sbText = AppendCSVFields(sbText, "VPCTY"); sbText = AppendCSVFields(sbText, "VPSTE"); sbText = AppendCSVFields(sbText, "VPPST"); sbText = AppendCSVFields(sbText, "VPCON"); sbText = AppendCSVFields(sbText, "VPCOU"); sbText = AppendCSVFields(sbText, "VMFRM"); sbText = AppendCSVFields(sbText, "VMMAT"); sbText = AppendCSVFields(sbText, "VTAX"); sbText = AppendCSVFields(sbText, "VPPHN"); sbText = AppendCSVFields(sbText, "VMFSCD"); sbText = AppendCSVFields(sbText, "VMIDNM"); sbText = AppendCSVFields(sbText, "VTAXCD"); sbText = AppendCSVFields(sbText, "VMXNBR"); sbText = AppendCSVFields(sbText, "VMXCRT"); sbText = AppendCSVFields(sbText, "VMXDTE"); sbText = AppendCSVFields(sbText, "VMXMAX"); sbText = AppendCSVFields(sbText, "VFOB"); sbText = AppendCSVFields(sbText, "VMCLAS"); sbText = AppendCSVFields(sbText, "VMRATE"); sbText = AppendCSVFields(sbText, "VMDCPX"); sbText = AppendCSVFields(sbText, "VMSRCC"); sbText = AppendCSVFields(sbText, "VMSRNO"); sbText = AppendCSVFields(sbText, "VMPREQ"); sbText = AppendCSVFields(sbText, "VXMID"); sbText = AppendCSVFields(sbText, "VXNUMB"); sbText = AppendCSVFields(sbText, "VXCUR"); sbText = AppendCSVFields(sbText, "VXBKCD"); sbText = AppendCSVFields(sbText, "VXTYP"); sbText = AppendCSVFields(sbText, "VXBNKN"); sbText = AppendCSVFields(sbText, "VXACT"); sbText = AppendCSVFields(sbText, "VXB2BA"); sbText = AppendCSVFields(sbText, "VXCCB"); sbText = AppendCSVFields(sbText, "VXCCBB"); //ȥ��β���Ķ��� sbText.Remove(sbText.Length - 1, 1); //дdatatable��һ�� swCSV.WriteLine(sbText.ToString()); //����datatable�������� foreach (DataRow drTemp in tbVendorView.Rows) { sbText = new StringBuilder(); sbText = AppendCSVFields(sbText, drTemp["VNSTAT"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMID"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VENDOR"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VNDNAM"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VNDAD1"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VNDAD2"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VCITY"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VSTATE"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPOST"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VTERMS"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VTYPE"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPAYTO"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VDTLPD"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VDAYCL"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VGL"].ToString()); sbText = AppendCSVFields(sbText, drTemp["V1099"].ToString()); sbText = AppendCSVFields(sbText, drTemp["V1099C"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPHONE"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VCMPNY"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VCURR"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPAYTY"].ToString()); sbText = AppendCSVFields(sbText, drTemp["V1TIME"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VCORPV"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VHOLD"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VHOLDT"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPYTYR"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VDSCAV"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VDSCTK"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VDPURS"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VNNEXT"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VNGEN"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VNALPH"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VNUNAL"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VCON"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VCOUN"].ToString()); sbText = AppendCSVFields(sbText, drTemp["V1099S"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPAD1"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPAD2"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPCTY"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPSTE"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPPST"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPCON"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPCOU"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMFRM"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMMAT"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VTAX"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VPPHN"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMFSCD"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMIDNM"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VTAXCD"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMXNBR"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMXCRT"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMXDTE"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMXMAX"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VFOB"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMCLAS"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMRATE"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMDCPX"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMSRCC"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMSRNO"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMPREQ"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VMID"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VXNUMB"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VXCUR"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VXBKCD"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VXTYP"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VXBNKN"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VXACT"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VXB2BA"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VXCCB"].ToString()); sbText = AppendCSVFields(sbText, drTemp["VXCCBB"].ToString()); //ȥ��β���Ķ��� sbText.Remove(sbText.Length - 1, 1); //дdatatable��һ�� swCSV.WriteLine(sbText.ToString()); } //�����ļ� DownloadFile(Response, swCSV.GetStringBuilder(), "Vendor_Export_" + DateTime.Now.ToString("yyyyMMdd") + ".csv"); swCSV.Close(); Response.End(); } catch (Exception ex) { throw ex; } }
private static String ParseResponse(string response) { XmlDocument doc = null; XslCompiledTransform myXslTransform = null; TextWriter sw = null; string result; try { doc = new XmlDocument(); ; myXslTransform = new XslCompiledTransform(); sw = new StringWriter(); doc.LoadXml(response); myXslTransform.Load(new XmlTextReader(new StringReader(Resources.Resource.xml2json))); JavaScriptSerializer serializer = new JavaScriptSerializer(); myXslTransform.Transform(doc, null, sw); result = sw.ToString(); } catch { result = System.Web.Configuration.WebConfigurationManager.AppSettings["errorParsingOrLoading"]; logger.Error(result); } finally { sw.Close(); } return result; }
private void PerformFlush() { // *** If local cache was not modified, exit *** if (!m_CacheModified) return; m_CacheModified = false; // *** Copy content of original iniString to temporary string, replace modified values *** StringWriter sw = new StringWriter(); try { Dictionary<string, string> CurrentSection = null; Dictionary<string, string> CurrentSection2 = null; StringReader sr = null; try { // *** Open the original file *** sr = new StringReader(m_iniString); // *** Read the file original content, replace changes with local cache values *** string s; string SectionName; string Key = null; string Value = null; bool Unmodified; bool Reading = true; bool Deleted = false; string Key2 = null; string Value2 = null; StringBuilder sb_temp; while (Reading) { s = sr.ReadLine(); Reading = (s != null); // *** Check for end of iniString *** if (Reading) { Unmodified = true; s = s.Trim(); SectionName = ParseSectionName(s); } else { Unmodified = false; SectionName = null; } // *** Check for section names *** if ((SectionName != null) || (!Reading)) { if (CurrentSection != null) { // *** Write all remaining modified values before leaving a section **** if (CurrentSection.Count > 0) { // *** Optional: All blank lines before new values and sections are removed **** sb_temp = sw.GetStringBuilder(); while ((sb_temp[sb_temp.Length - 1] == '\n') || (sb_temp[sb_temp.Length - 1] == '\r')) { sb_temp.Length = sb_temp.Length - 1; } sw.WriteLine(); foreach (string fkey in CurrentSection.Keys) { if (CurrentSection.TryGetValue(fkey, out Value)) { sw.Write(fkey); sw.Write('='); sw.WriteLine(Value); } } sw.WriteLine(); CurrentSection.Clear(); } } if (Reading) { // *** Check if current section is in local modified cache *** if (!m_Modified.TryGetValue(SectionName, out CurrentSection)) { CurrentSection = null; } } } else if (CurrentSection != null) { // *** Check for key+value pair *** if (ParseKeyValuePair(s, ref Key, ref Value)) { if (CurrentSection.TryGetValue(Key, out Value)) { // *** Write modified value to temporary file *** Unmodified = false; CurrentSection.Remove(Key); sw.Write(Key); sw.Write('='); sw.WriteLine(Value); } } } // ** Check if the section/key in current line has been deleted *** if (Unmodified) { if (SectionName != null) { if (!m_Sections.ContainsKey(SectionName)) { Deleted = true; CurrentSection2 = null; } else { Deleted = false; m_Sections.TryGetValue(SectionName, out CurrentSection2); } } else if (CurrentSection2 != null) { if (ParseKeyValuePair(s, ref Key2, ref Value2)) { if (!CurrentSection2.ContainsKey(Key2)) Deleted = true; else Deleted = false; } } } // *** Write unmodified lines from the original iniString *** if (Unmodified) { if (isComment(s)) sw.WriteLine(s); else if (!Deleted) sw.WriteLine(s); } } // *** Close string reader *** sr.Close(); sr = null; } finally { // *** Cleanup: close string reader *** if (sr != null) sr.Close(); sr = null; } // *** Cycle on all remaining modified values *** foreach (KeyValuePair<string, Dictionary<string, string>> SectionPair in m_Modified) { CurrentSection = SectionPair.Value; if (CurrentSection.Count > 0) { sw.WriteLine(); // *** Write the section name *** sw.Write('['); sw.Write(SectionPair.Key); sw.WriteLine(']'); // *** Cycle on all key+value pairs in the section *** foreach (KeyValuePair<string, string> ValuePair in CurrentSection) { // *** Write the key+value pair *** sw.Write(ValuePair.Key); sw.Write('='); sw.WriteLine(ValuePair.Value); } CurrentSection.Clear(); } } m_Modified.Clear(); // *** Get result to iniString *** m_iniString = sw.ToString(); sw.Close(); sw = null; // ** Write iniString to file *** if (m_FileName != null) { File.WriteAllText(m_FileName, m_iniString); } } finally { // *** Cleanup: close string writer *** if (sw != null) sw.Close(); sw = null; } }
protected void Page_Load(object sender, EventArgs e) { try { // Define the Company Name, User Name and Password here string ck = ConfigurationSettings.AppSettings["ck"].ToString();// Enter Company name here string username = ConfigurationSettings.AppSettings["username"].ToString(); // Enter User Name here string pwd = ConfigurationSettings.AppSettings["pwd"].ToString(); // Enter Password here string un = ck + "\\" + username; string strFileName = ""; string strFolderPath = ""; string Report_Url = ConfigurationSettings.AppSettings["ReportUrl"].ToString(); // Define the Web Service URLs that you would use string getallreports_url = Report_Url + ck + "/services/ReportService1.svc/GetAllReports"; string generatereport_url = Report_Url + ck + "/services/ReportService1.svc/GenerateReport"; string report_uri = string.Empty; string dt2 = DateTime.Now.ToString("yyyyMMdd-HHmmss.ff").Replace("/", "").Replace("-", "").Replace(" ", "").Replace(":", ""); strFileName = "Report_" + "_" + dt2 + ".xml"; Cache["Filename"] = strFileName; strFolderPath = Server.MapPath(".") + "\\Temp\\" + strFileName; string json = @" { 'glossary': { 'title': 'example glossary', 'GlossDiv': { 'title': 'S', 'GlossList': { 'GlossEntry': { 'ID': 'SGML', 'ItemNumber': 2, 'SortAs': 'SGML', 'GlossTerm': 'Standard Generalized Markup Language', 'Acronym': 'SGML', 'Abbrev': 'ISO 8879:1986', 'GlossSee': 'markup' } } } } } "; //string payload = (string)getallreports_response["d"]["payload"]; // Now get xml from Factual's JSON response: XmlDocument doc = (XmlDocument)JsonConvert.DeserializeXmlNode(json, "root"); // Convert the json-based XML according to what Newtonsoft will do, // to ADO-shaped XML, very generically : XslCompiledTransform xsl = new XslCompiledTransform(); StringWriter result = new StringWriter(); xsl.Load(Server.MapPath("Focus.xslt")); // I should be caching this, it will always be the same xsl.Transform(doc, null, result); File.WriteAllText(strFolderPath, result.ToString()); result.Close(); result.Flush(); // ... And the result you'll send back will be usable in a report: Response.ContentType = "application/xml"; Response.Write(result.ToString()); //Response.Flush(); Response.AppendHeader("Content-Disposition", "attachment; filename=Report.xml"); Response.TransmitFile(Server.MapPath(".") + "\\Temp\\" + strFileName); Response.End(); } catch (Exception exp) { Response.Write(exp.Message.ToString()); } }
// Function : Export_with_XSLT_Web // Arguments : dsExport, sHeaders, sFileds, FormatType, FileName // Purpose : Exports dataset into CSV / Excel format private void Export_with_XSLT_Web(DataSet dsExport, string[] sHeaders, string[] sFileds, ExportFormat FormatType, string FileName) { try { // Appending Headers response.Clear(); response.Buffer= true; if(FormatType == ExportFormat.CSV) { response.ContentType = "text/csv"; response.AppendHeader("content-disposition", "attachment; filename=" + FileName); } else { response.ContentType = "application/vnd.ms-excel"; response.AppendHeader("content-disposition", "attachment; filename=" + FileName); } // XSLT to use for transforming this dataset. MemoryStream stream = new MemoryStream( ); XmlTextWriter writer = new XmlTextWriter(stream, Encoding.Default); CreateStylesheet(writer, sHeaders, sFileds, FormatType); writer.Flush( ); stream.Seek( 0, SeekOrigin.Begin); XmlDocument xsl = new XmlDocument(); xsl.Load(stream); //XslTransform xslTran = new XslTransform(); //xslTran.Load(new XmlTextReader(stream), null, null); //System.IO.StringWriter sw = new System.IO.StringWriter(); //xslTran.Transform(xmlDoc, null, sw, null); XmlDataDocument xmlDoc = new XmlDataDocument(dsExport); StringWriter sw = new StringWriter(); XmlTextWriter xtw = new XmlTextWriter(sw); XslCompiledTransform t = new XslCompiledTransform(); t.Load((IXPathNavigable)xsl, null, null); t.Transform((IXPathNavigable)xmlDoc, xtw); //Writeout the Content response.Write(sw.ToString()); sw.Close(); xtw.Close(); writer.Close(); stream.Close(); response.End(); sw.Dispose(); stream.Dispose(); } catch(ThreadAbortException Ex) { string ErrMsg = Ex.Message; } catch(Exception Ex) { throw Ex; } }
/// <summary> /// Exports dataset into excel format /// </summary> /// <param name="dsExport">The DataSet want to export</param> /// <param name="sHeaders">The headers of DataTable</param> /// <param name="sFields">The data fields of DataTable</param> /// <param name="fileName">The filename of excel</param> private void ExportWithXSLT(DataSet dsExport, string[] sHeaders, string[] sFields, string fileName) { try { //Appending Headers response.Clear(); response.Buffer = true; response.ContentType = "application/vnd.ms-excel"; response.ContentEncoding = System.Text.Encoding.Default; //response.AppendHeader("content-disposition", "attachment; filename="+"测试.xls"); response.AppendHeader("content-disposition", "attachment; filename=" +fileName+".xls"); //XSLT to use for transforming this dataset MemoryStream stream = new MemoryStream(); XmlTextWriter writer = new XmlTextWriter(stream, Encoding.Unicode); CreateStylesheet(writer, sHeaders, sFields); //Create the Stylesheet writer.Flush(); stream.Seek(0, SeekOrigin.Begin); XmlDocument xmlDoc = new XmlDataDocument(dsExport); XslTransform xslTran = new XslTransform(); xslTran.Load(new XmlTextReader(stream), null, null); System.IO.StringWriter sw = new StringWriter(); xslTran.Transform(xmlDoc, null, sw, null); //Write out the content response.Write(sw.ToString()); sw.Close(); writer.Close(); stream.Close(); response.End(); } catch (ThreadAbortException ex) { string ErrMsg = ex.Message; } catch (Exception ex) { throw ex; } }
protected void lnkexportResources_Click(object sender, EventArgs e) { StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); foreach (DataListItem li in UserList.Items) { GridView grd = (GridView)li.FindControl("ListUserTimeEntries"); ObjectDataSource ds = li.FindControl("TimeEntryData") as ObjectDataSource; grd.DataSource = ds; Label userlabel = (Label)li.FindControl("UserNameLabel"); Label DurationLabel = (Label)li.FindControl("TotalDurationLabel"); sw.Write("--------------------------------------------------------"); sw.WriteLine("\n"); sw.WriteLine("\n"); sw.NewLine = ("\n"); sw.NewLine = ("\n"); sw.Write("<table class='timeentry-edit' cellspacing='0' cellpadding='2' rules='all' border='0' style='border-width:0px;border-style:None;width:100%;border-collapse:collapse;'><tr class='grid-header' align='left'><th scope='col'>UserName</th><th scope='col'>Total Duration Worked</th> </tr><tr class='row1' style='border-style:None;'><td style='background-Color:#FFFFFF;'>" + userlabel.Text + "</td><td style='background-Color:#FFFFFF;'>" + DurationLabel.Text + "</td></tr></table>"); if (grd.Rows.Count >= 1) { Response.ClearContent(); Response.Buffer = true; Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "ResourcesTimeSheet.xls")); Response.ContentType = "application/ms-excel"; grd.AllowPaging = false; grd.RenderBeginTag(htw); int j = 1; //This loop is used to apply stlye to cells based on particular row foreach (GridViewRow gvrow in grd.Rows) { for (int k = 0; k < gvrow.Cells.Count; k++) { gvrow.Cells[k].Style.Add("background-Color", "#FFFFFF"); } } //grd.RenderControl(htw); //style to format numbers to string string style = @"<style> .textmode { mso-number-format:\@; } </style>"; grd.FooterRow.RenderControl(htw); grd.RenderEndTag(htw); grd.HeaderRow.Style.Add("background-color", "#FFFFFF"); grd.RenderControl(htw); } else { grd.DataSource = null; } } sw.NewLine = ("\n"); sw.NewLine = ("\n"); sw.Close(); Response.Write(sw.ToString()); Response.End(); }
/// <summary> /// Decodes a Quoted-Printable string of any size into /// it's original text. /// </summary> /// <param name="encoded"> /// The encoded string to decode. /// </param> /// <returns>The decoded string.</returns> /// <exception cref="ArgumentNullException"> /// A string is passed in as a null reference. /// </exception> /// <remarks> /// Decodes a quoted-printable encoded string into a string /// of unencoded text of any size. /// </remarks> public static string Decode(string encoded) { if (encoded == null) { throw (new ArgumentNullException()); } string line; StringWriter sw = new StringWriter(); StringReader sr = new StringReader(encoded); try { line = sr.ReadLine(); while (line != null) { if (line.EndsWith("=")) { sw.Write(HexDecoder(line.Substring(0, line.Length - 1))); } else { sw.WriteLine(HexDecoder(line)); } sw.Flush(); line = sr.ReadLine(); } return sw.ToString(); } finally { sw.Close(); sr.Close(); sw = null; sr = null; } }
protected void SaveIbConfigSetting(object sender, EventArgs e) { if (Session["OriginalIbConfig"] != null) { TextWriter writer = null; try { string xmlSettingText = XMLResult.Value; string ibItemXmlSettingText = IbItemXMLResult.Value; string ibItemStyleXmlSettingText = IbItemStyleXMLResult.Value; IbConfig originalConfig = Session["OriginalIbConfig"] as IbConfig; UpdateIbItemInfo(originalConfig, ibItemXmlSettingText); UpdateIbItemStyleInfo(originalConfig, ibItemStyleXmlSettingText); IbConfig newConfig = IbConfig.ParseXml(originalConfig, new StringReader(xmlSettingText)); newConfig.Order(); writer = new StringWriter(); newConfig.CreateSqlScript(writer); writer.Flush(); long scriptId = -1; if (TheAdminServer.IBShopManager.SaveScript(writer.ToString(), out scriptId)) { LabelOpMsg.Text = StringDef.OperationSucceed; FSEye.Security.LogSystem.TheInstance.WriteGMOperationLog(CurrentUser.Id, (int)GMUtil.GMOperation.CreateIBShopScript, scriptId.ToString(), -1, string.Format(StringDef.GMMessageIBShopScript, CurrentUser.RealName, StringDef.Create, scriptId.ToString()), (int)GMUtil.GMOpTargetType.System); } else { LabelOpMsg.Text = StringDef.OperationFail; return; } } catch (Exception ex) { LabelOpMsg.Text = ex.Message; } finally { if (writer != null) { writer.Close(); } } } }
//private DataTable add_column(DataSet ds, string add_col) //{ // DataSet ds_x = new DataSet(); // DataTable dtNew = new DataTable(); // ds_x = ds; // dtNew=ds_x.Tables[0]; // dtNew.Columns.Add(add_col, typeof(string)); // return dtNew; //} //private DataTable rotation(DataSet ds, string row_name, string column_name) // { // DataView dv = ds.Tables[0].DefaultView; // DataTable EQPTable, STEPIDTable; // //?瘞璊grade distinct璅? // EQPTable = ds.Tables[0].DefaultView.ToTable(true, row_name); // STEPIDTable = ds.Tables[0].DefaultView.ToTable(true, column_name, "seq"); // DataView EQPGV = EQPTable.DefaultView; // DataView STEPIDGV = STEPIDTable.DefaultView; // EQPGV.Sort = row_name; // STEPIDGV.Sort = "seq"; // DataTable dtNew = new DataTable(); // //瘞憓 DataTable // dtNew.Columns.Add(txtCalendar1.Text.Replace("/", ""), typeof(string));//蝚砌豢? // dtNew.Columns.Add("Qty", typeof(string));//蝚砌箸? // //瑽怠喳豢?span style="color:#FFA34F">column鋆靚曄? // /*for (int i = 0; i < dateTable.Rows.Count; i++) // { // dtNew.Columns.Add(dateTable.Rows[i][column_name].ToString(), typeof(string)); // }*/ // //string[] arr_date ={ }; // //for (int K = 0; K < 12; K++) // //{ // // arr_date[K] = DateTime.Now.Year.ToString() ; // ////} // //瘞憓撊隞甈雿鞈? // for (int i = 0; i <= STEPIDGV.Count - 1; i++) // { // dtNew.Columns.Add(STEPIDGV[i][column_name].ToString(), typeof(string)); // } // int colnum = 0; // //鳿亙泗ade瘙鋆隢閰函閬ow璅? // for (int i = 0; i < EQPGV.Count; i++) // { // //瘞憓 ROW 撠 dtNew // DataRow drNew = dtNew.NewRow(); // drNew[txtCalendar1.Text.Replace("/", "")] = EQPGV[i][row_name].ToString(); // drNew[1] = "Rework"; // colnum = 0; // foreach (DataRow dr in STEPIDTable.Rows) // { // //甇貏亦歲ow?蝺芣吶lumn靚暹曄? // dv.RowFilter = column_name + "='" + dr[0].ToString() + "' and " + row_name + "='" + EQPGV[i][row_name].ToString() + "' "; // if (dv.Count > 0) // { // //drNew[colnum + 2] = (Convert.ToDouble(dv[0]["STEPID"])).ToString("#,##0"); // // drNew[colnum + 2] = dv[0]["STEPID"].ToString(); // // drNew[colnum + 3] = dv[0]["EQPID"].ToString(); // drNew[colnum + 2] = dv[0]["REWORK"].ToString(); // // drNew[colnum + 5] = dv[0]["TOTAL"].ToString(); // } // else // drNew[colnum + 2] = "0"; // colnum++; // } // dtNew.Rows.Add(drNew); // drNew = dtNew.NewRow(); // drNew[txtCalendar1.Text.Replace("/", "")] = EQPGV[i][row_name].ToString(); // drNew[1] = "Total"; // colnum = 0; // foreach (DataRow dr in STEPIDTable.Rows) // { // //甇貏亦歲ow?蝺芣吶lumn靚暹曄? // dv.RowFilter = column_name + "='" + dr[0].ToString() + "' and " + row_name + "='" + EQPGV[i][row_name].ToString() + "' "; // if (dv.Count > 0) // { // //drNew[colnum + 2] = (Convert.ToDouble(dv[0]["STEPID"])).ToString("#,##0"); // // drNew[colnum + 2] = dv[0]["STEPID"].ToString(); // // drNew[colnum + 3] = dv[0]["EQPID"].ToString(); // drNew[colnum + 2] = dv[0]["Total"].ToString(); // // drNew[colnum + 5] = dv[0]["TOTAL"].ToString(); // } // else // drNew[colnum + 2] = "0"; // colnum++; // } // dtNew.Rows.Add(drNew); // } // return dtNew; // } protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { string strTaskID = string.Empty; if (e.Row.RowType == DataControlRowType.DataRow) { //ImageButton btnDel = new ImageButton(); //btnDel = (ImageButton)e.Row.FindControl("btnDel"); //btnDel.Attributes["onclick"] = "javascript:return confirm('確認刪除否? 【Stock_id】:" + ((DataRowView)e.Row.DataItem)["stock_id"] + " 【End Time】:" + ((DataRowView)e.Row.DataItem)["date1"] + "【SN】:" + ((DataRowView)e.Row.DataItem)["SN"] + "');"; //string conn = System.Configuration.ConfigurationSettings.AppSettings["DBCONN_Meeting"]; //string strSql_Pro; //string snn1; ////GridViewRow row = GridView2.Rows[e.RowIndex]; //DataSet ds = new DataSet(); //strSql_Pro = "select distinct(t.prod_name) from tlms_tmp t "; //strSql_Pro += "where t.tool_id='" + ((DataRowView)e.Row.DataItem)["TOOL_ID"] + "'"; //ds = func.get_dataSet_access(strSql_Pro, conn); //((DataList)e.Row.FindControl("DataList1")).DataSource = ds.Tables[0]; //((DataList)e.Row.FindControl("DataList1")).DataBind(); //strTaskID = ((DataRowView)e.Row.DataItem)["task_id"].ToString(); // dv.RowFilter = "task_id=" + strTaskID; //dv.Sort = "is_owner desc"; //task member datalist //((DataList)e.Row.FindControl("dlTaskMember")).DataSource = dv; //((DataList)e.Row.FindControl("dlTaskMember")).DataBind(); //image link to task content //string sMessage = String.Format("return(OpenTask('{0}'));", strTaskID); //((ImageButton)e.Row.FindControl("btnEdit")).OnClientClick = sMessage;//"if (OpenTask('" + sMessage + "')==false) {return false;}"; //Int32 percent_value = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "percent1")); Int32 countX = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "count1")); Double priceX = Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "price")); // Int32 priceX_top = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "avg_hot_price")); // Int32 priceX_cur = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "Current_price")); Double current_price = Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Current_price")); //Int32 pricexx = Convert.ToInt32(price1); // if (percent_value >0) //e.Row.Cells[0].BackColor = Color.Yellow; // e.Row.Cells[6].Style.Add("background-color", "#FFFF80"); if (countX >= 3) e.Row.Cells[2].Style.Add("background-color", "#95CAFF"); if (countX == 2) e.Row.Cells[2].Style.Add("background-color", "#FFFFB3"); if (current_price < priceX) e.Row.Cells[11].Style.Add("background-color", "#A2FFA2"); //if (Flag_satus == "Cancel") // e.Row.Cells[6].Style.Add("background-color", "#FF9DFF"); if (e.Row.RowIndex != -1) { int RN = e.Row.RowIndex + 1; e.Row.Cells[0].Text = RN.ToString(); } sql_temp2 = " select format(t.date1,'yyyy/MM/dd') as date1 ,t.stock_name,t.stock_id,t.price1,t.percent1&'%' as percent1,t.volume1,t.hot_price, round(t.volume1*t.percent1/100,0) as kpi, switch(turtle is null,0, turtle is not null ,turtle) as turtle from strong_up_history t " + " where t.stock_id='" + ((DataRowView)e.Row.DataItem)["stock_id"].ToString() + "' " + " and t.date1>=#" + txtCalendar1.Text + "# and t.date1<=#" + txtCalendar2.Text + "# " + " order by t.date1 desc "; ds_temp2 = func.get_dataSet_access(sql_temp2,conn); GridView2.DataSource = ds_temp2.Tables[0]; GridView2.DataBind(); if (ds_temp2.Tables[0].Rows.Count == 0) { System.Web.UI.WebControls.Image btnShowDetail = new System.Web.UI.WebControls.Image(); btnShowDetail = (System.Web.UI.WebControls.Image)e.Row.FindControl("btnShowDetail"); btnShowDetail.Visible = false; } else { #region GridViewRow r = new GridViewRow(-1, -1, DataControlRowType.DataRow, DataControlRowState.Normal); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); r.Cells.Add(new TableCell()); r.Cells.Add(new TableCell()); r.Cells[1].ColumnSpan = GridView2.Columns.Count - 1; GridView2.Visible = true; GridView2.RenderControl(hw); GridView2.Visible = false; r.Cells[1].Text = sw.ToString(); sw.Close(); r.ID = "Detail_" + e.Row.RowIndex.ToString(); r.HorizontalAlign = HorizontalAlign.Left; e.Row.Parent.Controls.Add(r); System.Web.UI.WebControls.Image btnShowDetail = new System.Web.UI.WebControls.Image(); btnShowDetail = (System.Web.UI.WebControls.Image)e.Row.FindControl("btnShowDetail"); //btnShowDetail.Attributes.Add("onclick", "showHideAnswer('GridView1_" + r.ID + "','" + e.Row.ClientID.ToString() + "_" + btnShowDetail.ID + "');"); btnShowDetail.Attributes.Add("onclick", "showHideAnswer('ctl00_ContentPlaceHolder1_GridView1_" + r.ID + "','" + e.Row.ClientID.ToString() + "_" + btnShowDetail.ID + "');"); //btnShowDetail.Attributes.Add("onclick", "showHideAnswer('" + this.ClientID.ToString() + "_GridView1_" + r.ID + "','" + e.Row.ClientID.ToString() + "_" + btnShowDetail.ID + "');"); if (lblAIExpand.Text == "Y") { r.Style["display"] = "block"; btnShowDetail.ImageUrl = "~/images/close13.gif"; } else { r.Style["display"] = "none"; btnShowDetail.ImageUrl = "~/images/open13.gif"; } #endregion } } }
protected void lnk_Xml_Report_Click(object sender, EventArgs e) { DateTime CutOffDate = DateTime.Now.AddDays(-1); string rootFolderPath = Server.MapPath(".") + "\\Temp\\"; System.IO.DirectoryInfo di = new System.IO.DirectoryInfo(rootFolderPath); System.IO.FileInfo[] fi = di.GetFiles(); for (int i = 0; i < fi.Length; i++) { if (fi[i].LastWriteTime < CutOffDate) { System.IO.File.Delete(fi[i].FullName); } } string ck = ConfigurationSettings.AppSettings["ck"].ToString();// Enter Company name here string username = ConfigurationSettings.AppSettings["username"].ToString(); // Enter User Name here string pwd = ConfigurationSettings.AppSettings["pwd"].ToString(); // Enter Password here string un = ck + "\\" + username; string strFileName = ""; string strFolderPath = ""; string Report_Url = ConfigurationSettings.AppSettings["ReportUrl"].ToString(); // Define the Web Service URLs that you would use string getallreports_url = Report_Url + ck + "/services/ReportService1.svc/GetAllReports"; string generatereport_url = Report_Url + ck + "/services/ReportService1.svc/GenerateReport"; string Report_name = ddlSubCategory.SelectedItem.Text; string report_uri = string.Empty; string dt2 = DateTime.Now.ToString("yyyyMMdd-HHmmss.ff").Replace("/", "").Replace("-", "").Replace(" ", "").Replace(":", ""); strFileName = Report_name + "_" + dt2 + ".xml"; Cache["Filename"] = strFileName; strFolderPath = Server.MapPath(".") + "\\Temp\\" + strFileName; string jsonText = null; string data_getallreports = string.Empty; var jsondata_getallreports = Newtonsoft.Json.JsonConvert.SerializeObject(data_getallreports); byte[] byteArray_getallreports = Encoding.UTF8.GetBytes(jsondata_getallreports); // Make the HTTP request using the function "callservice" var getallreports_response = callservice(un, pwd, getallreports_url, jsondata_getallreports, byteArray_getallreports); jsonText = getallreports_response.ToString(); //Function to get the Report URI of the Report that you want to pull up foreach (var item in getallreports_response["d"]) { if ((string)item["displayText"] == Report_name) { report_uri = (string)item["uri"]; } } if (report_uri == string.Empty) { Console.WriteLine("No report exists in the Replicon Instance with the report name " + Report_name); Console.ReadKey(); return; } // Create the JSON Object to pass with the HTTP request for GenerateReport dynamic data_generatereport = new ExpandoObject(); data_generatereport.reportUri = report_uri; data_generatereport.filterValues = new string[0]; //data_generatereport.outputFormatUri = "urn:replicon:report-output-format-option:msxml"; /* // The JSON Object to be passed along with the HTTP Header can be also created in the following way // The JSON Object creation with DYNAMIC keyword can be used when the JSON Object will increase in size dynamically (e.g. using arrays) string data_generatereport = "{\"reportUri\":null,\"filterValues\":[],\"outputFormatUri\":null}"; var jObject_GetData = Newtonsoft.Json.Linq.JObject.Parse(data_generatereport); data_generatereport["reportUri"] = report_uri; data_generatereport["outputFormatUri"] = "urn:replicon:report-output-format-option:msxml"; */ // Convert the Object created above to JSON and calculate the Content length var jsondata_generatereport = Newtonsoft.Json.JsonConvert.SerializeObject(data_generatereport); byte[] byteArray_generatereport = Encoding.UTF8.GetBytes(jsondata_generatereport); // Make the HTTP request using the function "callservice" var generatereport_response = callservice(un, pwd, generatereport_url, jsondata_generatereport, byteArray_generatereport); string payload = (string)generatereport_response["d"]["payload"]; XmlDocument docs = new XmlDocument(); docs.LoadXml(payload); string json = Newtonsoft.Json.JsonConvert.SerializeXmlNode(docs); DwnReport.Visible = true; //string payload = (string)getallreports_response["d"]["payload"]; //File.WriteAllText(strFolderPath, jsonText); // Now get xml from Factual's JSON response: XmlDocument doc = (XmlDocument)JsonConvert.DeserializeXmlNode(payload, "Report"); // Convert the json-based XML according to what Newtonsoft will do, // to ADO-shaped XML, very generically : XslCompiledTransform xsl = new XslCompiledTransform(); StringWriter result = new StringWriter(); xsl.Load(Server.MapPath("Focus.xslt")); XmlTextWriter tx = new XmlTextWriter(result); XmlDeclaration xmldecl; xmldecl = doc.CreateXmlDeclaration("1.0", null, null); XmlElement root = doc.DocumentElement; doc.InsertBefore(xmldecl, root); doc.WriteTo(tx); xsl.Transform(doc, null, tx); File.WriteAllText(strFolderPath, result.ToString()); result.Close(); result.Flush(); // ... And the result you'll send back will be usable in a report: Response.ContentType = "text/xml"; Response.Charset = "UTF-8"; Response.ContentEncoding = Encoding.UTF8; //Response.Write(result.ToString()); Response.AppendHeader("Content-Disposition", "attachment; filename=" + strFileName); Response.TransmitFile(Server.MapPath(".") + "\\Temp\\" + strFileName); Response.Flush(); Response.Close(); //strFolderPath = Server.MapPath(".") + "\\Temp\\" + strFileName; }