本文整理汇总了C#中SqlHelper.Get方法的典型用法代码示例。如果您正苦于以下问题：C# SqlHelper.Get方法的具体用法？C# SqlHelper.Get怎么用？C# SqlHelper.Get使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SqlHelper的用法示例。
在下文中一共展示了SqlHelper.Get方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: WriteResponseAsync
protected override async Task WriteResponseAsync(string request, IOutputStream os)
{
var response = new StatusResponse();
if (request.StartsWith("/api/seed"))
{
var sql = new SqlHelper();
sql.SeedDatabase();
}
if (request.StartsWith("/api/status"))
{
var sql = new SqlHelper();
var info = sql.Get();
response.Status = info.CurrentStatus.ToString();
if (info.CurrentStatus == DishwasherStatus.Clean)
{
response.Details = new StatusResponse.CleanStatusDetails
{
DishwasherRun = sql.GetDishwasherRun()
};
}
else if (info.CurrentStatus == DishwasherStatus.Dirty)
{
response.Details = new StatusResponse.DirtyStatusDetails
{
DirtyTime = info.DirtyDateTime
};
}
else if (info.CurrentStatus == DishwasherStatus.Running)
{
response.Details = new StatusResponse.RunningStatusDetails
{
StartTime = info.CurrentRunStart,
RunCycle = info.CurrentCycle
};
}
}
// Show the html
using (Stream resp = os.AsStreamForWrite())
{
string json;
using (MemoryStream jsonStream = new MemoryStream())
{
var serializer = new DataContractJsonSerializer(typeof(StatusResponse));
serializer.WriteObject(jsonStream, response);
jsonStream.Position = 0;
StreamReader sr = new StreamReader(jsonStream);
json = sr.ReadToEnd();
}
byte[] bodyArray = Encoding.UTF8.GetBytes(json);
using (MemoryStream stream = new MemoryStream(bodyArray))
{
string header = String.Format("HTTP/1.1 200 OK\r\n" +
"Content-Length: {0}\r\n" +
"Content-Type: application/json\r\n" +
"Connection: close\r\n\r\n",
stream.Length);
byte[] headerArray = Encoding.UTF8.GetBytes(header);
await resp.WriteAsync(headerArray, 0, headerArray.Length);
await stream.CopyToAsync(resp);
}
await resp.FlushAsync();
}
}