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;
}
