public string CreateSpecs(out int specCount)
{
var files = FindSpecFiles().ToArray();
specCount = files.Length;
if (specCount < 1)
return string.Empty;
var compile = new CodeCompileUnit();
var globalns = new CodeNamespace();
globalns.Imports.Add(new CodeNamespaceImport("NUnit.Framework"));
globalns.Imports.Add(new CodeNamespaceImport(config.MyNamespace));
compile.Namespaces.Add(globalns);
var specNamespace = new CodeNamespace(config.TargetNamespace + ".ChutzpahSpecs");
compile.Namespaces.Add(specNamespace);
foreach (var fileInfo in files)
{
AddSpec(specNamespace, fileInfo);
}
//specNamespace.Types.AddRange(files.Select(CreateSpec).ToArray());
var provider = CreateProvider();
var options = new CodeGeneratorOptions { BracingStyle = "C", BlankLinesBetweenMembers = false };
var stringBuilder = new StringBuilder();
using (var writer = new StringWriter(stringBuilder))
{
provider.GenerateCodeFromCompileUnit(compile, writer, options);
writer.Flush();
writer.Close();
}
var result = stringBuilder.ToString();
return result;
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
{
ASSERTREQ vrParameter = new ASSERTREQ();
UNIASSERT[] vrResult;
if (m_Request.Assert.AssertGet(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
{
System.IO.StringWriter swCSV = new System.IO.StringWriter();
swCSV.WriteLine("资产编号,资产名称,规格型号,单价,采购日期,所属实验室,所属部门");
for (int i = 0; i < vrResult.Length; i++)
{
System.Text.StringBuilder sbText = new System.Text.StringBuilder();
sbText = AppendCSVFields(sbText, vrResult[i].szAssertSN.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].szDevName.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].szModel.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].dwUnitPrice.ToString());
sbText = AppendCSVFields(sbText, GetDateStr(vrResult[i].dwPurchaseDate));
sbText = AppendCSVFields(sbText, vrResult[i].szRoomName.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].szDeptName.ToString());
//去掉尾部的逗号
sbText.Remove(sbText.Length - 1, 1);
//写datatable的一行
swCSV.WriteLine(sbText.ToString());
}
DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv");
swCSV.Close();
Response.End();
}
}
}
}
private static string ConvertToText(string HTML)
{
string text = string.Empty;
XmlDocument xmlDoc = new XmlDocument();
XmlDocument xsl = new XmlDocument();
xmlDoc.LoadXml(@"\HTMLPage1.htm");
xsl.CreateEntityReference("nbsp");
xsl.Load(System.Web.HttpContext.Current.Server.MapPath("/Convert_Email.xslt"));
//creating xsltD:\Niranjan\Ordermanagement_14.0\Ordermanagement_01\Convert_Email.xslt
XslTransform xslt = new XslTransform();
xslt.Load(xsl, null, null);
//creating stringwriter
StringWriter writer = new System.IO.StringWriter();
//Transform the xml.
xslt.Transform(xmlDoc, null, writer, null);
//return string
text = writer.ToString();
string Exact = text.ToString();
writer.Close();
return(text);
}
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 ();
}
}
protected void Gettxt()
{
Model.Feedback feedback = new Model.Feedback();
BLL.FeedbackManager feedbackManager = new BLL.FeedbackManager();
DataSet ds = feedbackManager.GetTXTList();
Response.Clear();
Response.Buffer = false;
Response.Charset = "utf - 8";
DateTime dt = System.DateTime.Now;
string str = dt.ToString("yyyyMMddhhmmss");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + str + ".txt");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-txt";
Response.Write("<meta http-equiv=Content-Type;content=/text/html;charset=utf-8/>");
System.IO.StringWriter sw = new System.IO.StringWriter();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
sw.WriteLine(ds.Tables[0].Rows[i][j].ToString().Trim() + "\t");
}
sw.WriteLine("\r \n");
}
HttpContext.Current.Response.Write(sw.ToString());
sw.Close();
HttpContext.Current.Response.End();
}
public string ConvertToText(string html)
{
XmlDocument xmlDoc = new XmlDocument();
XmlDocument xsl = new XmlDocument();
xmlDoc.LoadXml(html.ToString());
xsl.CreateEntityReference("nbsp");
xsl.Load(System.Web.HttpContext.Current.Server.MapPath("~/Markdown.xslt"));
//creating xslt
var xslt = new XslCompiledTransform();
xslt.Load(xsl, null, null);
//creating stringwriter
StringWriter writer = new System.IO.StringWriter();
//Transform the xml.
// xslt.Transform(xmlDoc, null, writer, null);
//return string
var text = writer.ToString();
writer.Close();
return(text);
}
private void UsingStringReaderAndStringWriter()
{
Console.WriteLine("String Reader and String Writer example");
Console.WriteLine("Some APIs expects TestWriter and TextReader but they can't work with string or StringBuilder. StringWriter and StringReader adapts to the interface of StringBuilder.");
StringWriter stringWriter = new StringWriter();
using (XmlWriter writer = XmlWriter.Create(stringWriter))
{
writer.WriteStartElement("book");
writer.WriteElementString("price", "19.95");
writer.WriteEndElement();
writer.Flush();
}
string xml = stringWriter.ToString();
Console.WriteLine("String created using StringWriter and XMLWriter is :");
Console.WriteLine(xml);
StringReader stringReader = new StringReader(xml);
using (XmlReader reader = XmlReader.Create(stringReader))
{
reader.ReadToFollowing("price");
decimal price = decimal.Parse(reader.ReadInnerXml(),new CultureInfo("en-US"));
Console.WriteLine("Price read using String Reader and XMLReader is :" + price);
}
stringWriter.Close();
stringReader.Close();
}
[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);
}
}
public override string ToString()
{
string doc;
using (var sw = new StringWriter()) {
using (var writer = new XmlTextWriter(sw)) {
writer.Formatting = Formatting.Indented;
//writer.WriteStartDocument();
writer.WriteProcessingInstruction("xml", "version=\"1.0\" encoding=\"utf-8\"");
writer.WriteStartElement("D", "multistatus", "DAV:");
for (int i = 0; i < _nameSpaceList.Count; i++) {
string tag = string.Format("ns{0}", i);
writer.WriteAttributeString("xmlns", tag, null, _nameSpaceList[i]);
}
foreach (var oneResponse in _ar) {
oneResponse.Xml(writer);
}
writer.WriteEndElement();
//writer.WriteEndDocument();
writer.Flush();
writer.Close();
doc = sw.ToString();
writer.Flush();
writer.Close();
}
sw.Flush();
sw.Close();
}
return doc;
}
/// <summary>
/// 基于接口/基类实现的子类型写入
/// </summary>
/// <typeparam name="TBase">接口/基类类型</typeparam>
/// <param name="children">子类型实例列表</param>
/// <param name="writer">序列化写入器</param>
public static void WriteXmlEx <TBase>(this List <TBase> children, XmlWriter writer)
{
XmlSerializerNamespaces xn = new XmlSerializerNamespaces();
xn.Add("", "");
string rawChildStr = null;
foreach (TBase item in children)
{
Type t = item.GetType();
StringBuilder cb = new StringBuilder();
using (StringWriter sw = new System.IO.StringWriter(cb))
{
XmlSerializer xs = new XmlSerializer(t);
xs.Serialize(sw, item, xn);
sw.Close();
}
rawChildStr = cb.ToString();
XmlDocument rawDoc = new XmlDocument();
rawDoc.LoadXml(rawChildStr);
XmlAttribute attr = rawDoc.CreateAttribute("type");
attr.Value = t.GetNoVersionTypeName();
rawDoc.DocumentElement.Attributes.Append(attr);
writer.WriteRaw(rawDoc.DocumentElement.OuterXml);
}
}
public void RunMockAssemblyTests()
{
TestResult result = NUnit.TestUtilities.TestBuilder.RunTestFixture(typeof(MockTestFixture));
Assert.NotNull(result);
StringBuilder sb = new StringBuilder();
StringWriter writer = new StringWriter(sb);
new NUnit2XmlOutputWriter(DateTime.Now).WriteResultFile(result, writer);
writer.Close();
#if DEBUG
StreamWriter sw = new StreamWriter("MockAssemblyResult.xml");
sw.WriteLine(sb.ToString());
sw.Close();
#endif
doc = new XmlDocument();
doc.LoadXml(sb.ToString());
topNode = doc.SelectSingleNode("/test-results");
if (topNode != null)
{
envNode = topNode.SelectSingleNode("environment");
cultureNode = topNode.SelectSingleNode("culture-info");
suiteNode = topNode.SelectSingleNode("test-suite");
}
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
Debug.Assert(Request.IsAuthenticated);
var user = User.Identity.Name;
using (var ctx = new OffwindEntities())
{
var dCase = ctx.DCases.FirstOrDefault(c => c.Owner == user && c.Name == StandardCases.WindWave);
if (dCase == null)
{
// Init basic properties
dCase = new DCase();
dCase.Id = Guid.NewGuid();
dCase.Name = StandardCases.WindWave;
dCase.Owner = user;
dCase.Created = DateTime.UtcNow;
// Init model
var model = CreateProjectModel();
var serializer = new XmlSerializer(typeof(WindWaveInput));
using (var writer = new StringWriter())
{
serializer.Serialize(writer, model);
dCase.Model = writer.ToString();
writer.Close();
}
ctx.DCases.AddObject(dCase);
ctx.SaveChanges();
}
}
base.Initialize(requestContext);
}
private void createContent(String varName, Object objectToPass, StringReader reader, String outputFileName)
{
Dictionary<String, Object> map = new Dictionary<String, Object>();
map.Add(varName, objectToPass);
String outputContent = null;
StringTemplateGroup group = new StringTemplateGroup(reader);
var contentTemplate = group.GetInstanceOf("Content");
contentTemplate.Attributes = map;
outputContent = contentTemplate.ToString();
//StringBuilder sb = new StringBuilder(outputContent);
StringWriter writer = new StringWriter(new StringBuilder(outputContent));
writer.Flush();
StreamWriter fileWriter = null;
try
{
fileWriter = new StreamWriter(outputFileName + "/report.html.data");
fileWriter.Write(writer.ToString());
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
writer.Close();
fileWriter.Close();
}
public ResAcc<string> GenerarSelloDigital(string sArchivoKey, string sContrasenia, string sCadenaOriginal)
{
var Res = new ResAcc<string>(true);
try
{
byte[] encryptedPrivateKeyInfoData = File.ReadAllBytes(sArchivoKey);
AsymmetricKeyParameter parameter = PrivateKeyFactory.DecryptKey(sContrasenia.ToCharArray(), encryptedPrivateKeyInfoData);
MemoryStream stream = new MemoryStream();
new StreamWriter(stream);
StringWriter writer = new StringWriter();
new PemWriter(writer).WriteObject(parameter);
writer.Close();
ISigner signer = SignerUtilities.GetSigner("SHA1WithRSA");
byte[] bytes = Encoding.UTF8.GetBytes(sCadenaOriginal);
signer.Init(true, parameter);
signer.BlockUpdate(bytes, 0, bytes.Length);
Res.Respuesta = Convert.ToBase64String(signer.GenerateSignature()).ToString();
} catch (Exception e) {
Res.Exito = false;
Res.Mensaje = "Error al generar el sello digital\n\n";
Res.Mensaje += (e.InnerException == null ? e.Message : e.InnerException.Message);
}
return Res;
}
public void Execute(object parameter)
{
var collection = parameter as ObservableCollection<IDataItem>;
if (collection != null)
{
var data = (ObservableCollection<IDataItem>) parameter;
using (var stringWriter = new StringWriter())
{
using (var writer = XmlWriter.Create(stringWriter, new XmlWriterSettings {Indent = true}))
{
writer.WriteStartDocument();
writer.WriteStartElement("data");
foreach (var dataItem in data)
{
writer.WriteStartElement("item");
writer.WriteString(dataItem.Value);
writer.WriteEndElement();
}
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Flush();
}
stringWriter.Close();
var client = new SaveXmlServiceClient();
client.SaveXmlCompleted += (sender, args) => HtmlPage.Window.Invoke("DisplayAlertMessage", string.Format("{0}\r\n{1}", args.Error != null ? args.Error.Message : "", args.Cancelled ? "Cancel" : "OK"));
client.SaveXmlAsync(stringWriter.ToString());
}
}
}
private static void DisplayHelp(OptionSet opts)
{
StringBuilder sb = new StringBuilder();
Assembly thisApp = Assembly.GetExecutingAssembly();
Stream helpStream = thisApp.GetManifestResourceStream("Validator.Help.txt");
try
{
StreamReader reader = new StreamReader(helpStream);
string data = reader.ReadToEnd();
reader.Close();
sb.Append(data);
}
finally
{
helpStream.Close();
}
StringWriter writer = new StringWriter(sb);
opts.WriteOptionDescriptions (writer);
MessageBox.Show(sb.ToString());
writer.Close();
}
// 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);
XmlDataDocument xmlDoc = new XmlDataDocument(dsExport);
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);
//Writeout the Content
StreamWriter strwriter = new StreamWriter(FileName);
strwriter.WriteLine(sw.ToString());
strwriter.Close();
sw.Close();
writer.Close();
stream.Close();
}
catch (Exception Ex)
{
throw Ex;
}
}
/// <summary>
/// 创建CSV格式的Excel
/// </summary>
/// <param name="dt">数据</param>
/// <param name="fileName">生成的Excel文件名</param>
/// <param name="titleColumns">Excel标题名称组</param>
/// <param name="columnNames">数据字段名称组</param>
/// <param name="columnTypes">数据类型名称组</param>
public static void CreateCSVExcel(DataTable dt, string fileName, string titleColumns, string columnNames, string columnTypes)
{
string[] titleColumnCollection = titleColumns.Split(',');
string[] columnNameCollection = columnNames.Split(',');
string[] columnTypeCollection = columnTypes.Split(',');
if (!
((columnNameCollection.Length == columnTypeCollection.Length)
&& (columnNameCollection.Length == titleColumnCollection.Length))
)
throw new Exception("Excel设置的数据参数有误");
HttpResponse resp;
resp = HttpContext.Current.Response;
resp.Buffer = true;
resp.ContentType = "application/vnd.ms-excel";
resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
resp.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));
StringWriter sw = new StringWriter();
sw.WriteLine(titleColumns);
foreach (DataRow eachRow in dt.Rows)
{
sw.WriteLine(GetEachRowExcelData(eachRow, columnNameCollection, columnTypeCollection));
}
sw.Close();
resp.Write(sw);
resp.End();
}
protected void btnExport_Click(Object sender, EventArgs e)
{
Response.ContentEncoding = Encoding.UTF8;
Response.ContentType = "application/ms-excel";
Response.Charset = "utf-8";
Response.AppendHeader("Content-Disposition",
"attachment;filename=" + HttpUtility.UrlEncode("指标历史数据.xls",
System.Text.Encoding.UTF8).ToString());
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
int RecordCount = 0;
DateTime StartDate = Convert.ToDateTime(txtStartDate.Text);
DateTime EndDate = Convert.ToDateTime(txtEndDate.Text);
String ECID = Request.Params["ECID"];
using (ECHistoryDataAccess DataAccess = new ECHistoryDataAccess()) {
ECDataRepeater.DataSource = DataAccess.GetECHourData(ECID, StartDate, EndDate,
1, 20000, out RecordCount);
ECDataRepeater.DataBind();
ECDataRepeater.RenderControl(htw);
Response.Write(sw.ToString());
Response.Flush();
Response.End();
sw.Close();
sw.Dispose();
}
DataBind();
}
public static string ToJson(object value)
{
Newtonsoft.Json.JsonSerializer json = new Newtonsoft.Json.JsonSerializer()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore,
ObjectCreationHandling = Newtonsoft.Json.ObjectCreationHandling.Auto,
NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore
};
StringWriter sw = new StringWriter();
Newtonsoft.Json.JsonTextWriter writer = new JsonTextWriter(sw);
writer.Formatting = Formatting.None;
//writer.QuoteChar = '"';
json.Serialize(writer, value);
string output = sw.ToString();
writer.Close();
sw.Close();
return output;
//JavaScriptSerializer jss = new JavaScriptSerializer();
//return jss.Serialize(value);
}
public void Save()
{
#if !AGGREGATE_ITEMS
using (StreamWriter writer = new StreamWriter(ItemCache.SavedFilePath, false, Encoding.UTF8))
{
XmlSerializer serializer = new XmlSerializer(typeof(ItemList));
serializer.Serialize(writer, new ItemList(AllItems));
writer.Close();
}
LocationFactory.Save(Path.Combine("Data", "ItemSource.xml"));
ItemFilter.Save(Path.Combine("Data", "ItemFilter.xml"));
#else
//this is handy for debugging
foreach (Item item in AllItems)
{
try
{
System.Xml.Serialization.XmlSerializer serializer = new System.Xml.Serialization.XmlSerializer(typeof(Item));
StringBuilder sb = new StringBuilder();
System.IO.StringWriter writer = new System.IO.StringWriter(sb);
serializer.Serialize(writer, item);
writer.Close();
System.IO.File.WriteAllText(Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "ItemCache-" + item.Name + ".xml"), sb.ToString());
}
catch (System.Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Message);
}
}
#endif
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
Debug.Assert(Request.IsAuthenticated);
var user = User.Identity.Name;
var dCase = _ctx.DCases.FirstOrDefault(c => c.Owner == user && c.Name == StandardCases.MesoWind);
if (dCase == null)
{
dCase = new DCase
{
Id = Guid.NewGuid(),
Name = StandardCases.MesoWind,
Owner = user,
Created = DateTime.UtcNow
};
// Model contains points from both databases by default
var model = new VMesoWind();
ItemsCount(model);
var serializer = new XmlSerializer(typeof (VMesoWind));
using (var writer = new StringWriter())
{
serializer.Serialize(writer, model);
dCase.Model = writer.ToString();
writer.Close();
}
_ctx.DCases.AddObject(dCase);
_ctx.SaveChanges();
}
base.Initialize(requestContext);
}
public override void ExecuteResult(ControllerContext context)
{
JsonSerializer json = new JsonSerializer();
json.NullValueHandling = NullValueHandling.Ignore;
json.ObjectCreationHandling = ObjectCreationHandling.Replace;
json.MissingMemberHandling = MissingMemberHandling.Ignore;
json.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
String output = String.Empty;
StringWriter sw = new StringWriter();
JsonTextWriter writer = new JsonTextWriter(sw);
writer.Formatting = Formatting.Indented;
writer.QuoteChar = '"';
json.Serialize(writer, this.Data);
output = sw.ToString();
writer.Close();
sw.Close();
context.HttpContext.Response.ContentType = "application/json";
context.HttpContext.Response.Write(output);
}
/// <summary>
/// 使用XSL转义XML生成HTML字符串
/// </summary>
/// <param name="xml">xml参数</param>
/// <param name="xsl">xsl参数</param>
/// <param name="isXmlUri">使用URI作为xml参数</param>
/// <param name="isXslUri">使用URI作为xsl参数</param>
/// <returns></returns>
public static string XslTransferXml(string xml, string xsl, bool isXmlUri, bool isXslUri)
{
StringBuilder sbRet = new StringBuilder();
XslCompiledTransform xslDoc = new XslCompiledTransform();
System.Xml.XmlDocument xmlDoc = new System.Xml.XmlDocument();
if (isXslUri)
{
xslDoc.Load(xsl);
}
else
{
xmlDoc.LoadXml(xsl);
xslDoc.Load(xmlDoc);
}
if (isXmlUri)
{
xmlDoc.Load(xml);
}
else
{
xmlDoc.LoadXml(xml);
}
using (System.IO.StringWriter sw = new System.IO.StringWriter(sbRet))
{
xslDoc.Transform(xmlDoc, null, sw);
sw.Close();
}
return(sbRet.ToString());
}
public ServerTMS()
{
XmlWriterSettings settings = new XmlWriterSettings();
settings.OmitXmlDeclaration = true;
settings.Encoding = Encoding.UTF8;
settings.Indent = true;
StringWriter strWriter = new StringWriter();
XmlWriter writer = XmlWriter.Create(strWriter, settings);
writer.WriteStartDocument();
writer.WriteStartElement("data");
writer.WriteStartElement("coordinateSystem");
writer.WriteElementString("name", "Mercator");
writer.WriteElementString("datum", "World Geodetic 1984 (WGS84) Auto");
writer.WriteElementString("system", "Mercator");
writer.WriteElementString("unit", "Meter");
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Flush();
writer.Close();
m_CoordinateSystem = strWriter.ToString();
strWriter.Close();
m_DefaultImageType = ".png";
m_ReverseY = false;
m_ScaleHi = 21;
m_ScaleLo = 0;
m_TileSizeX = 256;
m_TileSizeY = 256;
m_Name = "TMS Tile Coordinates";
m_DefaultURL = "http://";
ScaleNames = "0.675m,1.25m,2.5m,5m,10m,20 m,40 m,80 m,160 m,320 m,640 m,1.2km,2.5km,5km,10km,20km,40km,80km,160km,320km,640km,1280km";
}
public static string Serialize(UserProfileData profile)
{
StringWriter sw = new StringWriter();
XmlTextWriter xtw = new XmlTextWriter(sw);
xtw.Formatting = Formatting.Indented;
xtw.WriteStartDocument();
xtw.WriteStartElement("user_profile");
xtw.WriteAttributeString("major_version", MAJOR_VERSION.ToString());
xtw.WriteAttributeString("minor_version", MINOR_VERSION.ToString());
xtw.WriteElementString("name", profile.Name);
xtw.WriteElementString("id", profile.ID.ToString());
xtw.WriteElementString("about", profile.AboutText);
// Not sure if we're storing this yet, need to take a look
// xtw.WriteElementString("Url", profile.Url);
// or, indeed, interests
xtw.WriteEndElement();
xtw.Close();
sw.Close();
return sw.ToString();
}
public void SerializeTest()
{
XmlSerializer serializer = new XmlSerializer(typeof(EmailBroadcast));
Order order = new EmailBroadcast()
{
DisplayName = "jt",
EmailSubject = "test email message",
SendTimeUTC = DateTime.UtcNow,
TextBody = TextBody.FromText("This is a test email")
};
StringBuilder sb = new StringBuilder();
TextWriter writer = new StringWriter(sb);
serializer.Serialize(writer, order);
writer.Close();
Assert.IsNotNull(sb);
Assert.IsTrue(!string.IsNullOrEmpty(sb.ToString()));
TextReader tr = new StringReader(sb.ToString());
object obj = serializer.Deserialize(tr);
var deserializedMessage = obj as EmailBroadcast;
Assert.IsTrue(deserializedMessage.DisplayName == "jt");
Assert.IsTrue(deserializedMessage.EmailSubject == "test email message");
var xml = deserializedMessage.ToXml();
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
ViewBag.ProcessingHost = WebConfigurationManager.AppSettings["ProcessingHost"];
base.OnActionExecuting(filterContext);
Debug.Assert(Request.IsAuthenticated);
var user = User.Identity.Name;
var dCase = ctx.DCases.FirstOrDefault(c => c.Owner == user && c.Name == StandardCases.CfdCase);
if (dCase == null)
{
// Init basic properties
dCase = new DCase();
dCase.Id = Guid.NewGuid();
dCase.Name = StandardCases.CfdCase;
dCase.Owner = user;
dCase.Created = DateTime.UtcNow;
// Init model
var model = SolverData.GetDefaultModel();
var serializer = new XmlSerializer(typeof (SolverData));
using (var writer = new StringWriter())
{
serializer.Serialize(writer, model);
dCase.Model = writer.ToString();
writer.Close();
}
ctx.DCases.AddObject(dCase);
ctx.SaveChanges();
}
}
public void ApplyTransaction(IList<Triple> preconditions, IList<Triple> deletePatterns, IList<Triple> inserts,
string updateGraphUri )
{
var deleteData = new StringWriter();
var dw = new BrightstarTripleSinkAdapter(new NQuadsWriter(deleteData, updateGraphUri));
foreach (Triple triple in deletePatterns)
{
dw.Triple(triple);
}
deleteData.Close();
var addData = new StringWriter();
var aw = new BrightstarTripleSinkAdapter(new NQuadsWriter(addData, updateGraphUri));
foreach (Triple triple in inserts)
{
aw.Triple(triple);
}
addData.Close();
var preconditionsData = new StringWriter();
var pw = new BrightstarTripleSinkAdapter(new NQuadsWriter(preconditionsData, updateGraphUri));
foreach (var triple in preconditions)
{
pw.Triple(triple);
}
preconditionsData.Close();
PostTransaction(preconditionsData.ToString(), deleteData.ToString(), addData.ToString(), updateGraphUri);
}
/// <summary>
/// OFXファイル書き出し
/// </summary>
/// <param name="accounts">アカウントリスト</param>
public override void WriteFile(List<Account> accounts)
{
Ofx ofx = new Ofx();
// OFX 要素を生成する
ofx.genOfx(accounts);
StreamWriter w = new StreamWriter(this.ofxFilePath, false); //, Encoding.UTF8);
w.NewLine = "\n";
// SGMLヘッダ出力
w.WriteLine("OFXHEADER:100");
w.WriteLine("DATA:OFXSGML");
w.WriteLine("VERSION:102");
w.WriteLine("SECURITY:NONE");
w.WriteLine("ENCODING:UTF-8");
w.WriteLine("CHARSET:CSUNICODE");
w.WriteLine("COMPRESSION:NONE");
w.WriteLine("OLDFILEUID:NONE");
w.WriteLine("NEWFILEUID:NONE");
w.WriteLine("");
// OFX 要素出力
StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
XmlTextWriter xw = new XmlTextWriter(sw);
xw.Formatting = Formatting.Indented;
ofx.doc.WriteTo(xw);
w.Write(sb);
xw.Close();
sw.Close();
w.Close();
}
public static void WriteErrorToHtml(string HtmlName, string TestID, string TestStep, string ErrorStack, string ScreenshotFile, string errorSummary)
{
System.IO.FileStream fs = new FileStream(HtmlName, FileMode.Create);
StringWriter stringWriter = new StringWriter();
using (StreamWriter w = new StreamWriter(fs, Encoding.UTF8))
{
w.WriteLine("<html>");
w.Write("<h1>");
w.Write("TestName:"+TestID);
w.WriteLine("</h1>");
w.Write("<h2>");
w.Write("Step Number:"+TestStep);
w.WriteLine("</h2>");
w.WriteLine("<body>");
w.WriteLine("<img src='" + ScreenshotFile + "' style='padding:1px;border:thin solid black;' width=600 height=600 alt='" + ScreenshotFile + "' />");
w.WriteLine("</body>");
w.WriteLine("<br/>");
w.WriteLine("Error: "+errorSummary);
w.WriteLine("<br/>");
w.WriteLine("Error stack trace:");
w.WriteLine("<br/>");
w.WriteLine(ErrorStack);
w.WriteLine("</body>");
w.WriteLine("</html>");
}
stringWriter.Close();
fs.Close();
return;
}
public void ConvertDialogScriptToRealScript(Dialog dialog, Game game, CompileMessages errors)
{
string thisLine;
_currentlyInsideCodeArea = false;
_hadFirstEntryPoint = false;
_game = game;
_currentDialog = dialog;
_existingEntryPoints.Clear();
_currentLineNumber = 0;
StringReader sr = new StringReader(dialog.Script);
StringWriter sw = new StringWriter();
sw.Write(string.Format("function _run_dialog{0}(int entryPoint) {1} ", dialog.ID, "{"));
while ((thisLine = sr.ReadLine()) != null)
{
_currentLineNumber++;
try
{
ConvertDialogScriptLine(thisLine, sw, errors);
}
catch (CompileMessage ex)
{
errors.Add(ex);
}
}
if (_currentlyInsideCodeArea)
{
sw.WriteLine("}");
}
sw.WriteLine("return RUN_DIALOG_RETURN; }"); // end the function
dialog.CachedConvertedScript = sw.ToString();
sw.Close();
sr.Close();
}
/// <summary>
/// Formats an exception message so that it can be sent to the event log later, by someone else.
/// </summary>
/// <param name="policyName">The policy that is running.</param>
/// <param name="offendingException">The exception that occured in the chain.</param>
/// <param name="chainException">The exception when the chain failed.</param>
/// <param name="originalException">The original exception.</param>
public static string FormatExceptionHandlingExceptionMessage(string policyName, Exception offendingException, Exception chainException, Exception originalException)
{
if(policyName == null) throw new ArgumentNullException("policyName");
StringBuilder message = new StringBuilder();
StringWriter writer = null;
string result = null;
try
{
writer = new StringWriter(message, CultureInfo.CurrentCulture);
if (policyName.Length > 0)
{
writer.WriteLine(string.Format(CultureInfo.CurrentCulture, Resources.PolicyName, policyName));
}
FormatHandlingException(writer, Resources.OffendingException, offendingException);
FormatHandlingException(writer, Resources.OriginalException, originalException);
FormatHandlingException(writer, Resources.ChainException, chainException);
}
finally
{
if (writer != null)
{
result = writer.ToString();
writer.Close();
}
}
return result;
}
public override string CreateContent (Project project, Dictionary<string, string> tags, string language)
{
if (language == null || language == "")
throw new InvalidOperationException ("Language not defined in CodeDom based template.");
var binding = GetLanguageBinding (language);
CodeDomProvider provider = null;
if (binding != null)
provider = binding.GetCodeDomProvider ();
if (provider == null)
throw new InvalidOperationException ("The language '" + language + "' does not have support for CodeDom.");
var xcd = new XmlCodeDomReader ();
var cu = xcd.ReadCompileUnit (domContent);
foreach (CodeNamespace cns in cu.Namespaces)
cns.Name = StripImplicitNamespace (project, tags, cns.Name);
CodeGeneratorOptions options = new CodeGeneratorOptions ();
options.IndentString = "\t";
options.BracingStyle = "C";
StringWriter sw = new StringWriter ();
provider.GenerateCodeFromCompileUnit (cu, sw, options);
sw.Close ();
return StripHeaderAndBlankLines (sw.ToString (), provider);
}
protected void exportFile_ServerClick(object sender, EventArgs e)
{
string group = group_id.Value;
if (string.IsNullOrEmpty(group))
{
return;
}
GROUPMEMDETAIL[] detail = GetGroupDetail(ToUInt(group));
if (detail != null)
{
System.IO.StringWriter swCSV = new System.IO.StringWriter();
swCSV.WriteLine("姓名,学号,班级,学院");
for (int i = 0; i < detail.Length; i++)
{
GROUPMEMDETAIL mb = detail[i];
System.Text.StringBuilder sbText = new System.Text.StringBuilder();
sbText = AppendCSVFields(sbText, mb.szTrueName);
sbText = AppendCSVFields(sbText, mb.szPID);
sbText = AppendCSVFields(sbText, mb.szClassName);
sbText = AppendCSVFields(sbText, mb.szDeptName);
//去掉尾部的逗号
sbText.Remove(sbText.Length - 1, 1);
//写datatable的一行
swCSV.WriteLine(sbText.ToString());
}
DownloadFile(Response, swCSV.GetStringBuilder(), "成员名单.csv");
swCSV.Close();
Response.End();
}
}
/// <summary>
/// 导出SmartGridView的数据源的数据
/// </summary>
/// <param name="ds">数据源</param>
/// <param name="headers">导出的表头数组</param>
/// <param name="fields">导出的字段数组</param>
/// <param name="exportFormat">导出文件的格式</param>
/// <param name="fileName">输出文件名</param>
/// <param name="encoding">编码</param>
private static void Export(DataSet ds, string[] headers, string[] fields, ExportFormat exportFormat, string fileName, Encoding encoding)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.ContentType = String.Format("text/{0}", exportFormat.ToString().ToLower());
HttpContext.Current.Response.AddHeader("content-disposition", String.Format("attachment;filename={0}.{1}", fileName, exportFormat.ToString().ToLower()));
HttpContext.Current.Response.ContentEncoding = encoding;
MemoryStream stream = new MemoryStream();
XmlTextWriter writer = new XmlTextWriter(stream, encoding);
CreateStylesheet(writer, headers, fields, exportFormat);
writer.Flush();
stream.Seek(0, SeekOrigin.Begin);
XmlDataDocument xmlDoc = new XmlDataDocument(ds);
XslCompiledTransform xslTran = new XslCompiledTransform();
xslTran.Load(new XmlTextReader(stream));
System.IO.StringWriter sw = new System.IO.StringWriter();
xslTran.Transform(xmlDoc, null, sw);
HttpContext.Current.Response.Write(sw.ToString());
sw.Close();
writer.Close();
stream.Close();
HttpContext.Current.Response.End();
}
public void StorageUsed()
{
var observer = new StorageObserver("mva2015logs");
var random = new Random();
var writer = new StringWriter();
writer.WriteLine("StoreTime;Storage;Bytes");
var minute = 0;
while (true)
{
var size = random.Next(10000, 50000);
writer.WriteLine("{0};{1};{2}", DateTime.Now.ToUniversalTime(), _name, size);
var delay = random.Next(1000, 2000);
System.Threading.Thread.Sleep(delay);
minute += delay;
if (minute > 60000) {
writer.Close();
observer.OnNext(new CsvEvent {
Data = DateTime.UtcNow
,
Csv = writer.ToString()
});
writer = new StringWriter();
writer.WriteLine("StoreTime;Storage;Bytes");
minute = 0;
}
}
}
public void DefaultExpressionTest ()
{
using (StringWriter sw = new StringWriter ()) {
Generate(new CodeExpression (), sw);
sw.Close ();
}
}
public void Init()
{
_server = new TmsServer();
//TileSizeX = 256;
//TileSizeY = 256;
// save coordinate system in xml format
XmlWriterSettings settings = new XmlWriterSettings
{
OmitXmlDeclaration = true,
Encoding = Encoding.UTF8,
Indent = true
};
StringWriter strWriter = new StringWriter();
XmlWriter writer = XmlWriter.Create(strWriter, settings);
writer.WriteStartDocument();
writer.WriteStartElement("data");
writer.WriteStartElement("coordinateSystem");
writer.WriteElementString("name", "Mercator");
writer.WriteElementString("datum", "World Geodetic 1984 (WGS84) Auto");
writer.WriteElementString("system", "Mercator");
writer.WriteElementString("unit", "Meter");
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Flush();
writer.Close();
_coordinateSystem = strWriter.ToString();
strWriter.Close();
}
/// <summary> Returns the OAI-PMH metadata in dublin core (OAI-flavored) for this item </summary>
/// <param name="Item_To_Save"> Package with all the metadata to save </param>
/// <param name="Options"> Dictionary of any options which this metadata reader/writer may utilize </param>
/// <param name="Error_Message">[OUTPUT] Explanation of the error, if an error occurs during write </param>
/// <returns> Metadata for a OAI-PMH record of a particular metadata format/type </returns>
public override string Create_OAI_PMH_Metadata( SobekCM_Item Item_To_Save, Dictionary<string, object> Options, out string Error_Message)
{
// Set default error outpt message
Error_Message = String.Empty;
StringBuilder results = new StringBuilder();
StringWriter writer = new StringWriter(results);
writer.WriteLine("<oai_dc:dc xmlns:oai_dc=\"http://www.openarchives.org/OAI/2.0/oai_dc/\" ");
writer.WriteLine("xmlns:dc=\"http://purl.org/dc/elements/1.1/\" ");
writer.WriteLine("xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" ");
writer.WriteLine("xsi:schemaLocation=\"http://www.openarchives.org/OAI/2.0/oai_dc/ ");
writer.WriteLine("http://www.openarchives.org/OAI/2.0/oai_dc.xsd\">");
// Add the dublin core
DC_METS_dmdSec_ReaderWriter.Write_Simple_Dublin_Core(writer, Item_To_Save.Bib_Info);
// Add the URL as the identifier
if (Item_To_Save.Bib_Info.Location.PURL.Length > 0)
{
writer.WriteLine("<dc:identifier>" + Item_To_Save.Bib_Info.Location.PURL + "</dc:identifier>");
}
else if (Item_To_Save.Web.Service_URL.Length > 0)
{
writer.WriteLine("<dc:identifier>" + Item_To_Save.Web.Service_URL + "</dc:identifier>");
}
// Finish this OAI
writer.WriteLine("</oai_dc:dc>");
string resultsString = results.ToString();
writer.Close();
return resultsString;
}
//--------------------------------------------------------------
/// <overloads>
/// Produces a 'dump' of the given record, including attribute names etc.
/// </overloads>
/// --
/// <summary>
/// Gets a <see cref="T:System.String"/> containing a 'dump' of the given record, including attribute names etc.
/// </summary>
/// -
/// <param name="record">A <see cref="T:InTheHand.Net.Bluetooth.ServiceRecord"/> to be dumped.</param>
/// <param name="attributeIdEnumDefiningTypes">
/// An optional array of <see cref="T:System.Type"/> specifing a set of Ids
/// for the attributes contained in this record. See the
/// <see cref="M:InTheHand.Net.Bluetooth.ServiceRecordUtilities.Dump(System.IO.TextWriter,InTheHand.Net.Bluetooth.ServiceRecord,System.Type[])"/>
/// overload for more information.
/// </param>
/// -
/// <returns>A <see cref="T:System.String"/> containing the 'dump' text.</returns>
/// -
/// <seealso cref="M:InTheHand.Net.Bluetooth.ServiceRecordUtilities.Dump(System.IO.TextWriter,InTheHand.Net.Bluetooth.ServiceRecord,System.Type[])"/>
public static string Dump(ServiceRecord record, params Type[] attributeIdEnumDefiningTypes)
{
using (System.IO.StringWriter writer = new System.IO.StringWriter(
System.Globalization.CultureInfo.InvariantCulture)) {
Dump(writer, record, attributeIdEnumDefiningTypes);
writer.Close(); // close here, and to be sure to be sure also with using()
string result = writer.ToString();
return(result);
}
}
//send a message to all other connected players
public void SendOthers(CustomEventMessage evnt, string channel = DefaultNetworkOutChannel)
{
System.IO.StringWriter strStream = new System.IO.StringWriter();
xmlSerializer.Serialize(strStream, evnt);
strStream.Flush();
strStream.Close();
string toSend = strStream.GetStringBuilder().ToString();
networkView.RPC("NetMessage", RPCMode.Others, toSend, channel);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
{
REPORTREQ vrParameter = new REPORTREQ();
USERSTAT[] vrResult;
vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]);
vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]);
string szKey = Request["orderkey"];
if (szKey == null)
{
vrParameter.szReqExtInfo.szOrderKey = "dwUseTime";
vrParameter.szReqExtInfo.szOrderMode = "desc";
}
else
{
vrParameter.szReqExtInfo.szOrderKey = szKey;
vrParameter.szReqExtInfo.szOrderMode = "desc";
}
if (m_Request.Report.GetUserStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
{
System.IO.StringWriter swCSV = new System.IO.StringWriter();
swCSV.WriteLine("学工号,姓名,班级,学院,使用次数,使用总时间");
for (int i = 0; i < vrResult.Length; i++)
{
System.Text.StringBuilder sbText = new System.Text.StringBuilder();
string szClassName = "";
sbText = AppendCSVFields(sbText, vrResult[i].szPID.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].szTrueName.ToString());
UNIACCOUNT accinfo;
if (GetAccByAccno(vrResult[i].dwAccNo.ToString(), out accinfo))
{
szClassName = accinfo.szClassName.ToString();
}
sbText = AppendCSVFields(sbText, szClassName.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].szDeptName.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].dwUseTimes.ToString());
uint uUseTime = (uint)vrResult[i].dwUseTime;
sbText = AppendCSVFields(sbText, uUseTime / 60 + "小时" + uUseTime % 60 + "分钟");
//去掉尾部的逗号
sbText.Remove(sbText.Length - 1, 1);
//写datatable的一行
swCSV.WriteLine(sbText.ToString());
}
DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv");
swCSV.Close();
Response.End();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
REQUESTCODE uResponse = REQUESTCODE.EXECUTE_FAIL;
ATTENDRECREQ vrParameter = new ATTENDRECREQ();
GetHTTPObj(out vrParameter);
if (vrParameter.dwStartDate == 0)
{
vrParameter.dwStartDate = null;
}
if (vrParameter.dwEndDate == 0)
{
vrParameter.dwEndDate = null;
}
// if(vrParameter.dwStartDate=)
uint uAttend = Parse(Request["attendid"]);
if (uAttend != 0)
{
vrParameter.dwAttendID = uAttend;
}
ATTENDREC[] vrResult;
uResponse = m_Request.Attendance.GetAttendRec(vrParameter, out vrResult);
if (uResponse == REQUESTCODE.EXECUTE_SUCCESS && vrResult != null && vrResult.Length > 0)
{
System.IO.StringWriter swCSV = new System.IO.StringWriter();
swCSV.WriteLine("学工号,姓名,考勤规则,出勤日期,考勤房间,进入时间,退出时间,最近一次进入时间,停留时间(分钟),刷卡次数,状态");
for (int i = 0; i < vrResult.Length; i++)
{
System.Text.StringBuilder sbText = new System.Text.StringBuilder();
sbText = AppendCSVFields(sbText, vrResult[i].szPID);
sbText = AppendCSVFields(sbText, vrResult[i].szTrueName);
sbText = AppendCSVFields(sbText, vrResult[i].szAttendName.ToString());
sbText = AppendCSVFields(sbText, GetDateStr(vrResult[i].dwAttendDate));
sbText = AppendCSVFields(sbText, (vrResult[i].szRoomName));
sbText = AppendCSVFields(sbText, Get1970Date(vrResult[i].dwInTime));
sbText = AppendCSVFields(sbText, Get1970Date(vrResult[i].dwOutTime));
sbText = AppendCSVFields(sbText, Get1970Date(vrResult[i].dwLatestInTime));
sbText = AppendCSVFields(sbText, (vrResult[i].dwStayMin).ToString());
sbText = AppendCSVFields(sbText, (vrResult[i].dwCardTimes).ToString());
sbText = AppendCSVFields(sbText, GetJustName(vrResult[i].dwAttendStat, "attendstatus"));
sbText.Remove(sbText.Length - 1, 1);
//写datatable的一行
swCSV.WriteLine(sbText.ToString());
}
DownloadFile(Response, swCSV.GetStringBuilder(), "attendrec.csv");
swCSV.Close();
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
TEACHINGRESVREQ vrParameter = new TEACHINGRESVREQ();
TEACHINGRESV[] vrResult;
vrParameter.dwBeginDate = Parse(DateTime.Now.ToString("yyyyMMdd"));
vrParameter.dwEndDate = Parse(DateTime.Now.ToString("yyyyMMdd"));
uint uTeachid = Parse(Request["dwTeacherID"]);
if (uTeachid != 0)
{
vrParameter.dwTeacherID = uTeachid;
}
uint dwCourseID = Parse(Request["dwCourseID"]);
if (uTeachid != 0)
{
vrParameter.dwCourseID = dwCourseID;
}
System.IO.StringWriter swCSV = new System.IO.StringWriter();
swCSV.WriteLine("课程名,教师,房间,班级,应到人数,目前人数,上课时间");
if (m_Request.Reserve.GetTeachingResv(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
{
for (int i = 0; i < vrResult.Length; i++)
{
System.Text.StringBuilder sbText = new System.Text.StringBuilder();
sbText = AppendCSVFields(sbText, vrResult[i].szCourseName);
sbText = AppendCSVFields(sbText, vrResult[i].szTeacherName);
RESVDEV[] resvDev = vrResult[i].ResvDev;
string szRoomName = "";
for (int k = 0; resvDev != null && k < resvDev.Length; k++)
{
szRoomName += resvDev[k].szRoomName + ",";
}
sbText = AppendCSVFields(sbText, szRoomName);
sbText = AppendCSVFields(sbText, vrResult[i].szGroupName);
sbText = AppendCSVFields(sbText, vrResult[i].dwGroupUsers.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].dwCurUsers.ToString());
sbText = AppendCSVFields(sbText, GetTeachingTime((uint)vrResult[i].dwTeachingTime));
//去掉尾部的逗号
sbText.Remove(sbText.Length - 1, 1);
//写datatable的一行
swCSV.WriteLine(sbText.ToString());
}
DownloadFile(Response, swCSV.GetStringBuilder(), "teachplan.csv");
swCSV.Close();
Response.End();
}
}
}
public static void ValueWriteToFile()
{
string filename = "needfiles_xxx";
XmlWriterSettings xmlWriterSettings = new XmlWriterSettings();
xmlWriterSettings.CheckCharacters = false;
xmlWriterSettings.ConformanceLevel = ConformanceLevel.Auto;
xmlWriterSettings.OmitXmlDeclaration = false;
System.IO.StringWriter stringWriter = new System.IO.StringWriter();
XmlWriter xmlWriter = XmlWriter.Create(stringWriter, xmlWriterSettings);
xmlWriter.WriteStartDocument(true);
xmlWriter.WriteStartElement("Limit");
xmlWriter.WriteStartElement("DisLimit");
xmlWriter.WriteElementString("OnOff", "aaaaaaaa");
xmlWriter.WriteElementString("Radius", "bbbbbbbbbb");
xmlWriter.WriteEndElement();
int num = 0;
System.Collections.ArrayList myAreaLimitList = new System.Collections.ArrayList();
foreach (string areaLimitClass in myAreaLimitList) // We are not actually writing ANY limits in this case... feel free to define the class and fix it.
{
xmlWriter.WriteStartElement("AreaLimit");
xmlWriter.WriteAttributeString("id", "ccccccc");
xmlWriter.WriteElementString("OnOff", "ddddddddddd");
xmlWriter.WriteElementString("Long", "eeeeeeeeeee");
xmlWriter.WriteElementString("Lati", "ffffffffffff");
xmlWriter.WriteElementString("Radius", "ggggggggggg");
xmlWriter.WriteEndElement();
num++;
}
xmlWriter.WriteEndElement();
xmlWriter.WriteEndDocument();
xmlWriter.Flush();
xmlWriter.Close();
string xml = stringWriter.ToString();
stringWriter.Close();
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.LoadXml(xml);
System.Security.Cryptography.RijndaelManaged rijndaelManaged = new System.Security.Cryptography.RijndaelManaged();
byte[] bytes = System.Text.Encoding.Unicode.GetBytes(args[0]);
rijndaelManaged.Key = bytes;
xmlDocument.PreserveWhitespace = true;
Encrypt(xmlDocument, "Limit", rijndaelManaged);
if (rijndaelManaged != null)
{
rijndaelManaged.Clear();
}
xmlDocument.Save(filename);
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
this.textBox1.Text = "";
sw.Close();
sw = null;
sw = new System.IO.StringWriter();
System.Console.SetOut(sw);
srcIndex = 0;
dstIndex = 0;
}
// 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);
}
//response.BinaryWrite(Encoding.Unicode.GetPreamble());
// 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);
XmlDataDocument xmlDoc = new XmlDataDocument(dsExport);
//dsExport.WriteXml("Data.xml");
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);
//xslTran.Transform(System.Web.HttpContext.Current.Server.MapPath("Data.xml"), null, sw, null);
//Writeout 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;
}
}
public string Serialize()
{
var ser = new XmlSerializer(typeof(AccessRequest));
var sb = new StringBuilder();
using (var writer = new System.IO.StringWriter(sb))
{
ser.Serialize(writer, this);
writer.Close();
}
return(sb.ToString());
}
/// <summary>
/// 生成TXT文件
/// </summary>
/// <param name="txt"></param>
/// <param name="Address"></param>
public static void OutPutTXT(string txt, string Address)
{
FileStream fs = new FileStream(Address, FileMode.Create, FileAccess.Write);
System.IO.StringWriter sw = new System.IO.StringWriter();
sw.Write(txt);
sw.Close();
StreamWriter sw1 = new StreamWriter(fs, System.Text.Encoding.GetEncoding(("utf-8")));
sw1.Write(sw);
sw1.Flush();
sw1.Close();
}
/// <summary>
/// 生成不带明细的TXT文件
/// </summary>
public static void OutPutTXT(DataTable dt, string Address)
{
FileStream fs = new FileStream(Address, FileMode.Create, FileAccess.Write);
System.IO.StringWriter sw = new System.IO.StringWriter();
int iColCount = dt.Columns.Count;
for (int i = 0; i < iColCount; i++)
{
sw.Write("\"" + dt.Columns[i] + "\"");
if (i < iColCount - 1)
{
sw.Write(",");
}
}
sw.Write(sw.NewLine);
foreach (DataRow dr in dt.Rows)
{
string aa = "";
for (int i = 0; i < iColCount; i++)
{
if (!Convert.IsDBNull(dr[i]))
{
//sw.Write("\"" + dr[i].ToString() + "\"");
//aa += "\"" + dr[i].ToString() + "\"";
aa += dr[i].ToString();
}
else
{
//sw.Write("\"\"");
//aa += "\"\"";
aa += "";
}
if (i < iColCount - 1)
{
//sw.Write(",");
aa += ",";
}
}
//sw.Write(sw.NewLine);
sw.WriteLine(aa);
}
sw.Close();
StreamWriter sw1 = new StreamWriter(fs, System.Text.Encoding.GetEncoding(("utf-8")));
sw1.Write(sw);
sw1.Flush();
sw1.Close();
//CommonMethod.OpenFile(Address);
}
// Exports dataset into CSV / Excel format
private void ExportXSLT(DataSet dsExport, string[] sHeaders, string[] sFileds, ExportFormat FormatType, string FileName)
{
try
{
// Appending Headers
objHttpResponse.Clear();
objHttpResponse.Buffer = true;
if (FormatType == ExportFormat.CSV)
{
objHttpResponse.ContentType = "text/csv";
objHttpResponse.AppendHeader("content-disposition", "attachment; filename=" + FileName);
}
else
{
objHttpResponse.ContentType = "application/vnd.ms-excel";
objHttpResponse.AppendHeader("content-disposition", "attachment; filename=" + FileName);
}
// 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);
XmlDataDocument xmlDoc = new XmlDataDocument(dsExport);
//dsExport.WriteXml("Data.xml");
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);
//Writeout the Content
objHttpResponse.Write(sw.ToString());
sw.Close();
writer.Close();
stream.Close();
objHttpResponse.End();
}
catch (ThreadAbortException Ex)
{
string ErrMsg = Ex.Message;
}
catch (Exception Ex)
{
ErrorLog.WriteErrorLog("DB2Excel-ExportDetails", Ex);
}
}
/// <summary>
/// dumps public properties and fields of an object as an xml string
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static string DumpObjectProperties(Object o)
{
try
{
System.Type t = o.GetType();
System.Xml.Serialization.XmlSerializer xs = new System.Xml.Serialization.XmlSerializer(t);
System.IO.StringWriter sw = new System.IO.StringWriter();
xs.Serialize(sw, o);
sw.Close();
return(sw.ToString());
}
catch { }
return(string.Empty);
}
void createHtmlFromXsl()
{
string resultDoc = projSettings.DestinationPath + projSettings.DocHtmlFileName;
if (projSettings.StyleName == "OrteliusXml")
{
resultDoc = projSettings.DestinationPath + "/orteliusXml.xml";
}
string xmlDoc = projSettings.DestinationPath + projSettings.DocXmlFileName;
string xslDoc = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "/styles/" + projSettings.StyleName + ".xsl";
try
{
Processor processor = new Processor();
System.IO.StreamReader reader = new System.IO.StreamReader(xmlDoc, System.Text.Encoding.UTF8);
System.IO.TextWriter stringWriter = new System.IO.StringWriter();
stringWriter.Write(reader.ReadToEnd());
stringWriter.Close();
reader.Close();
System.IO.TextReader stringReader = new System.IO.StringReader(stringWriter.ToString());
System.Xml.XmlTextReader reader2 = new System.Xml.XmlTextReader(stringReader);
reader2.XmlResolver = null;
// Load the source document
XdmNode input = processor.NewDocumentBuilder().Build(reader2);
// Create a transformer for the stylesheet.
XsltTransformer transformer = processor.NewXsltCompiler().Compile(new System.Uri(xslDoc)).Load();
transformer.InputXmlResolver = null;
// Set the root node of the source document to be the initial context node
transformer.InitialContextNode = input;
// Create a serializer
Serializer serializer = new Serializer();
serializer.SetOutputFile(resultDoc);
// Transform the source XML to System.out.
transformer.Run(serializer);
}
catch (Exception e)
{
//MessageBox.Show(e.ToString());
systemSvar += "Error in xslt rendering:\r\n" + e.ToString();
}
}
public string DecodePrivateKey(string filename, string passw)
{
byte[] dataKey = System.IO.File.ReadAllBytes(filename);
AsymmetricKeyParameter asp = PrivateKeyFactory.DecryptKey(passw.ToCharArray(), dataKey);
System.IO.MemoryStream ms = new System.IO.MemoryStream();
System.IO.TextWriter writer = new System.IO.StreamWriter(ms);
System.IO.StringWriter stWrite = new System.IO.StringWriter();
PemWriter pmw = new PemWriter(stWrite);
pmw.WriteObject(asp);
stWrite.Close();
return(stWrite.ToString());
}
private static void PerformFileWrite
(string FileName, MemoryStream stream,
XmlTextWriter writer, System.IO.StringWriter sw)
{
//Writeout the Content
StreamWriter strwriter = new StreamWriter(FileName);
strwriter.WriteLine(sw.ToString());
strwriter.Close();
sw.Close();
writer.Close();
stream.Close();
}
public static string ToXmlString(T obj)
{
var serializer = new XmlSerializer(typeof(T));
var writer = new System.IO.StringWriter();
try {
serializer.Serialize(writer, obj);
} finally {
writer.Flush();
writer.Close();
}
return(writer.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
{
RESVKINDSTATREQ vrParameter = new RESVKINDSTATREQ();
uint uKind = Parse(Request["Kind"]);
CODINGTABLE[] vtCode = null;
if (uKind == 1)
{
vtCode = getCodeTableByType((uint)CODINGTABLE.DWCODETYPE.CODE_RESVKIND);
vrParameter.dwPurpose = (uint)UNIRESERVE.DWPURPOSE.USEFOR_PERSONNAL + (uint)UNIRESERVE.DWPURPOSE.USEFOR_STUDYROOM;
}
else if (uKind == 2)
{
vtCode = getCodeTableByType((uint)CODINGTABLE.DWCODETYPE.CODE_ACTIVITYKIND);
vrParameter.dwPurpose = (uint)UNIRESERVE.DWPURPOSE.USEFOR_ACTIVITY;
}
vrParameter.szReqExtInfo.dwNeedLines = 1000000;
vrParameter.szReqExtInfo.dwStartLine = 0;
RESVKINDSTAT[] vrResult;
vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]);
vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]);
if (m_Request.Report.GetResvKindStat(vrParameter, out vrResult) == REQUESTCODE.EXECUTE_SUCCESS)
{
System.IO.StringWriter swCSV = new System.IO.StringWriter();
swCSV.WriteLine("类型,预约次数,预约总时间");
for (int i = 0; i < vrResult.Length; i++)
{
System.Text.StringBuilder sbText = new System.Text.StringBuilder();
sbText = AppendCSVFields(sbText, GetCode(vtCode, (uint)vrResult[i].dwKind));
sbText = AppendCSVFields(sbText, vrResult[i].dwResvTimes.ToString());
sbText = AppendCSVFields(sbText, vrResult[i].dwResvMinutes.ToString());
//去掉尾部的逗号
sbText.Remove(sbText.Length - 1, 1);
//写datatable的一行
swCSV.WriteLine(sbText.ToString());
}
DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv");
swCSV.Close();
Response.End();
}
}
}
}
/// <summary>
/// Html To XMl 返回格式化好的XML文件
/// </summary>
/// <param name="html">传入要格式化的HTML文件</param>
/// <returns>返回格式化好的XML文件</returns>
public static string HTMLConvert(string html)
{
if (string.IsNullOrEmpty(html.Trim()))
{
return(string.Empty);
}
//solve ]]>
//处理节点
html = System.Text.RegularExpressions.Regex.Replace(html, @"<!\s{0,}\[\s{0,}CDATA\s{0,}\[\s{0,}|\s{0,}\]\s{0,}\]\s{0,}>", "");
using (Sgml.SgmlReader reader = new Sgml.SgmlReader())
{
reader.DocType = "HTML";
reader.InputStream = new System.IO.StringReader(html);
using (System.IO.StringWriter stringWriter = new System.IO.StringWriter())
{
//实例化对象
using (System.Xml.XmlTextWriter writer = new System.Xml.XmlTextWriter(stringWriter))
{
reader.WhitespaceHandling = System.Xml.WhitespaceHandling.None;
writer.Formatting = System.Xml.Formatting.Indented;
System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
doc.Load(reader);
if (doc.DocumentElement == null)
{
return("Html to XML Error this programe can not Convert");
}
else
{
doc.DocumentElement.WriteContentTo(writer);
}
writer.Close();
string xhtml = stringWriter.ToString();
reader.InputStream.Close();
reader.InputStream.Dispose();
if (xhtml == null)
{
xhtml = stringWriter.ToString();
stringWriter.Close();
}
return(xhtml);
}
}
}
}
protected void PrintAssign(uint uDevCount, uint uPrice, string szDevName)
{
System.IO.StringWriter swCSV = new System.IO.StringWriter();
swCSV.WriteLine("<table width=\"100%\" border=\"1px\" cellpadding=\"2\" cellspacing=\"0\"><tr style=\"height:35px;\"><td colspan=\"4\" style=\"text-align:center;height:45px;font-size:23px;\">资产入库表</td></tr><tr style=\"height:35px;\"><td style=\"width:180px;\">本次录入资产数量：</td><td colspan=\"3\" style='text-align:left'>");
swCSV.WriteLine(uDevCount);
swCSV.WriteLine("</td></tr><tr style=\"height:35px;\"><td>本次录入总价格：</td><td colspan=\"3\" style='text-align:left'>");
swCSV.WriteLine(uPrice);
swCSV.WriteLine("(元)</td></tr><tr style=\"height:35px;\"><td>本次录入实验室地址：</td><td colspan=\"3\" style='text-align:left'>");
swCSV.WriteLine(szDevName);
swCSV.WriteLine("</td></tr><tr style=\"height:35px;\"><td colspan=\"4\"></td></tr><tr style=\"height:35px;\"><td style=\"text-align:right\" colspan=\"3\">签名：</td><td></td></tr><tr style=\"height:35px;\"><td style=\"text-align:right\" colspan=\"3\">录入时间：</td><td>");
swCSV.WriteLine(DateTime.Now.ToString("yyyy-MM-dd"));
swCSV.WriteLine("</td></tr></table>");
DownloadFile(Response, swCSV.GetStringBuilder(), "RuleDaySum.csv");
swCSV.Close();
Response.End();
}
