/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="record">数据记录属性</param>
/// <returns></returns>
public static int AddHeatRecords(Model.Record record)
{
string sql = "insert into [HeatDataSheet]([serialNumber],[operatorName],[jobNumber],[voltage],[current],[power],[frequency],[energy],[temperature1],[temperature2],[temperature3],[temperature4],[flow1],[flow2],[flow3],[pressure],[heatTime],[coolingTime])";
sql += "values (@serialNumber,@operatorName,@jobNumber,@voltage,@current,@power,@frequency,@energy,@temperature1,@temperature2,@temperature3,@temperature4,@flow1,@flow2,@flow3,@pressure,@heatTime,@coolingTime)";
OleDbParameter[] para = new OleDbParameter[]
{
new OleDbParameter("@serialNumber", string.IsNullOrEmpty(record.serialNumber) ? "" : record.serialNumber),
new OleDbParameter("@operatorName", string.IsNullOrEmpty(record.operatorName) ? "" : record.operatorName),
new OleDbParameter("@jobNumber", string.IsNullOrEmpty(record.jobNumber) ? "" : record.jobNumber),
new OleDbParameter("@voltage", string.IsNullOrEmpty(record.voltage) ? "" : record.voltage),
new OleDbParameter("@current", string.IsNullOrEmpty(record.current) ? "" : record.current),
new OleDbParameter("@power", string.IsNullOrEmpty(record.power) ? "" : record.power),
new OleDbParameter("@frequency", string.IsNullOrEmpty(record.frequency) ? "" : record.frequency),
new OleDbParameter("@energy", string.IsNullOrEmpty(record.energy) ? "" : record.energy),
new OleDbParameter("@temperature1", string.IsNullOrEmpty(record.temperature1) ? "" : record.temperature1),
new OleDbParameter("@temperature2", string.IsNullOrEmpty(record.temperature2) ? "" : record.temperature2),
new OleDbParameter("@temperature3", string.IsNullOrEmpty(record.temperature3) ? "" : record.temperature3),
new OleDbParameter("@temperature4", string.IsNullOrEmpty(record.temperature4) ? "" : record.temperature4),
new OleDbParameter("@flow1", string.IsNullOrEmpty(record.flow1) ? "" : record.flow1),
new OleDbParameter("@flow2", string.IsNullOrEmpty(record.flow2) ? "" : record.flow2),
new OleDbParameter("@flow3", string.IsNullOrEmpty(record.flow3) ? "" : record.flow3),
new OleDbParameter("@pressure", string.IsNullOrEmpty(record.pressure) ? "" : record.pressure),
new OleDbParameter("@heatTime", string.IsNullOrEmpty(record.heatTime.ToString()) ? "" : record.heatTime.ToString()),
new OleDbParameter("@coolingTime", string.IsNullOrEmpty(record.coolingTime.ToString()) ? "" : record.coolingTime.ToString()),
};
return(DBHelp.ExecuteCommand(sql, para));
}
// 解析 JSON 数组提取记录
private static void getRecordsFromJsonArray(JArray jsonArray)
{
// 解析 JSON 数组
for (int i = 0; i < jsonArray.Count; ++i)
{
JObject record = JObject.Parse(jsonArray[i].ToString());
Model.Record _record = new Model.Record();
_record.id = record["_id"].ToString();
_record.title = record["title"].ToString();
_record.content = record["content"].ToString();
_record.image = record["image"].ToString();
_record.audio = record["audio"].ToString();
_record.video = record["video"].ToString();
_record.userId = record["userId"].ToString();
_record.date = record["date"].ToString().Split(' ')[0];
_record.favoriteNum = record["favoriteNum"].ToObject <int>().ToString();
string avatar = Helper.NetworkHelper.SERVER + record["userAvatar"].ToString();
_record.userAvatar = new BitmapImage(new Uri(avatar));
_record.nickname = record["nickname"].ToString();
allRecords.Add(_record);
if (_record.userId == UserStore.userId)
{
userRecords.Add(_record);
}
}
}
// 从本地数据库加载所有记录
public static void loadAllRecordsFromDB()
{
using (var statement = connection.Prepare("SELECT * FROM Records"))
{
Store.RecordStore.allRecords.Clear();
Store.RecordStore.userRecords.Clear();
while (SQLiteResult.ROW == statement.Step())
{
Model.Record record = new Model.Record();
record.id = (string)statement[0];
record.userId = (string)statement[1];
record.title = (string)statement[2];
record.content = (string)statement[3];
record.image = (string)statement[4];
record.audio = (string)statement[5];
record.video = (string)statement[6];
record.date = (string)statement[7];
record.nickname = (string)statement[8];
record.favoriteNum = (string)statement[9];
Uri avatar = new Uri((string)statement[10]);
record.userAvatar = new BitmapImage(avatar);
Store.RecordStore.allRecords.Add(record);
if (record.userId == Store.UserStore.userId)
{
Store.RecordStore.userRecords.Add(record);
}
}
}
}
public static Record createViewModel(Model.Record modelRecord)
{
var mappedType = Model.TypeMap.Get(modelRecord.GetType());
return((mappedType != null) ?
(Record)Activator.CreateInstance(mappedType, modelRecord) :
new Record(modelRecord));
}
private Model.Record NewlyCreatedRecord()
{
var recordModel = new Model.Record()
{
Id = "1",
ApplicationName = "SERVICE-A",
IsActive = true,
Name = "SiteName",
Value = "voidu.com",
Type = "String"
};
return(recordModel);
}
/// <summary>
/// 更新一条检测记录
/// </summary>
/// <param name="record">数据记录属性</param>
/// <returns></returns>
public static bool UpdateKJRecordByNO(Model.Record record)
{
try
{
//string sql = "update [DataSheet] set ";
//sql += "[kjh]='" + record.kjh + "'";
//sql += " where [qh]=" + "'" + record.qh + "'";
//DBHelp.ExecuteCommand(sql);
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw;
}
}
/// <summary>
/// 根据SQL语句查询所有的记录
/// </summary>
/// <param name="safeSql">SQL语句</param>
/// <returns></returns>
public static List <Model.Record> GetRecordBySql(string safeSql)
{
List <Model.Record> list = new List <Model.Record>();
list.Clear();
try
{
DataSet ds = DBHelp.GetDataSet(safeSql);
if (ds == null)
{
return(list);
}
foreach (DataRow row in ds.Tables[0].Rows)
{
Model.Record record = new Model.Record();
record.serialNumber = row["serialNumber"].ToString();
record.operatorName = row["operatorName"].ToString();
record.jobNumber = row["jobNumber"].ToString();
record.voltage = row["voltage"].ToString();
record.current = row["current"].ToString();
record.power = row["power"].ToString();
record.frequency = row["frequency"].ToString();
record.energy = row["energy"].ToString();
record.temperature1 = row["temperature1"].ToString();
record.temperature2 = row["temperature2"].ToString();
record.temperature3 = row["temperature3"].ToString();
record.temperature4 = row["temperature4"].ToString();
record.flow1 = row["flow1"].ToString();
record.flow2 = row["flow2"].ToString();
record.flow3 = row["flow3"].ToString();
record.pressure = row["pressure"].ToString();
record.heatTime = row["heatTime"].ToString();
record.coolingTime = row["coolingTime"].ToString();
list.Add(record);
}
return(list);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw;
}
}
public void Post_Insert()
{
// Arrange
var recordContract = new RecordContract
{
ApplicationName = "testAppName",
DataType = "dataType",
Version = "version1",
Value = "value"
};
var record = new Model.Record
{
ApplicationName = "testAppName",
DataType = "dataType",
Version = "version1",
Value = "value"
};
var req = new MockHttpRequest
{
Body = RecordFunctionTests.GenerateStreamFromString(_record)
};
var mapper = Substitute.For <IMapper>();
mapper.Map <Model.Record>(Arg.Any <RecordContract>()).Returns(record);
var repo = Substitute.For <IRepository>();
repo.UpsertRecord(Arg.Any <Model.Record>()).Returns(Task.FromResult <Model.Record>(record));
var logger = Substitute.For <ILogger <Records> >();
var target = new Records(repo, mapper);
// Act
var result = target.Post(req, logger).Result;
// Assert
Assert.IsType <CreatedResult>(result);
}
public void Post_Insert()
{
// Arrange
var recordContract = new RecordContract
{
ApplicationName = "testAppName",
DataType = "dataType",
Version = "version1",
Value = "value"
};
var record = new Model.Record
{
ApplicationName = "testAppName",
DataType = "dataType",
Version = "version1",
Value = "value"
};
var mapper = Substitute.For <IMapper>();
mapper.Map <Model.Record>(Arg.Any <RecordContract>()).Returns(record);
var repo = Substitute.For <IRepository>();
repo.UpsertRecord(Arg.Any <Model.Record>()).Returns(Task.FromResult <Model.Record>(record));
var logger = Substitute.For <ILogger <RecordsController> >();
var target = new RecordsController(repo, logger, mapper)
{
Url = Substitute.For <IUrlHelper>()
};
// Act
var result = target.Post(recordContract).Result;
// Assert
Assert.IsType <CreatedResult>(result);
}
public void Add(Model.Task task, RecordType recordType)
{
var record = new Model.Record();
record.time = DateTime.Now;
switch (recordType)
{
case RecordType.Insert:
record.Description = "任务" + task.title + "被添加，最新进度：" + task.finishedProgress + "/" + task.totalProgress + task.progressUnit + "(" + Math.Round(task.finishedProgress * 100.0d / task.totalProgress, 2) + "%)";
break;
case RecordType.Update:
record.Description = "任务" + task.title + "被修改，最新进度：" + task.finishedProgress + "/" + task.totalProgress + task.progressUnit + "(" + Math.Round(task.finishedProgress * 100.0d / task.totalProgress, 2) + "%)";
break;
case RecordType.Delete:
record.Description = "任务" + task.title + "被删除";
break;
}
dao.Add(record);
}
public void Test_CreateNewDynamicConfig()
{
var recordModel = new Model.Record()
{
ApplicationName = "SERVICE-A",
IsActive = true,
Name = "SiteName",
Value = "voidu.com",
Type = "String"
};
// Arrange
var mockLogger = new Mock <ILogger <BaseController <Model.Record> > >();
var mockRepo = new Mock <RecordRepository>("mongodb://localhost:27017/test?retryWrites=true&w=majority", "configuration", "records");
var cs = mockRepo.Setup(repo => repo.Create(recordModel))
.Returns(NewlyCreatedRecord());
var controller = new RecordController(mockRepo.Object, mockLogger.Object);
var resultForCreate = controller.Create(recordModel);
Assert.IsType <Microsoft.AspNetCore.Mvc.RedirectToActionResult>(resultForCreate.Result);
Assert.Equal(1, resultForCreate.Id);
}
public Record(Model.Record record)
{
modelRecord = record;
}
protected override async void OnNavigatedTo(NavigationEventArgs e)
{
Frame rootFrame = Window.Current.Content as Frame;
//如果页面可以回退，则显示回退按钮
if (rootFrame.CanGoBack)
{
SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility =
AppViewBackButtonVisibility.Visible;
SystemNavigationManager.GetForCurrentView().BackRequested += goBackToLastPage;
}
else
{
SystemNavigationManager.GetForCurrentView().AppViewBackButtonVisibility =
AppViewBackButtonVisibility.Collapsed;
}
currentRecord = ((Model.Record)e.Parameter);
if (currentRecord.favoriteNum == "-1")
{
isEdit = true;
currentRecord.favoriteNum = "0";
}
//await (new MessageDialog(currentRecord.audio)).ShowAsync();
//同步顶栏信息
avatarInTopBar.ImageSource = currentRecord.userAvatar;
publisher.Text = currentRecord.nickname;
//同步宽屏标题、文字信息
title1.Text = currentRecord.title;
content1.Text = currentRecord.content;
//同步窄屏标题、文字信息
title2.Text = currentRecord.title;
content2.Text = currentRecord.content;
//判断是否显示图片、音频、视频
if (currentRecord.image != "")
{
image1.Visibility = Visibility.Visible; //宽屏
image2.Visibility = Visibility.Visible; //窄屏
BitmapImage newSource = null;
string _newSource = Helper.NetworkHelper.SERVER + currentRecord.image;
newSource = new BitmapImage(new Uri(_newSource));
image1.Source = image2.Source = newSource;
}
if (currentRecord.audio != "")
{
//宽屏
player1.Visibility = Visibility.Visible;
//窄屏
player2.Visibility = Visibility.Visible;
string newSource = Helper.NetworkHelper.SERVER + currentRecord.audio;
player1.Source = MediaSource.CreateFromUri(new Uri(newSource, UriKind.Absolute));
player2.Source = MediaSource.CreateFromUri(new Uri(newSource, UriKind.Absolute));
}
if (currentRecord.video != "")
{
//宽屏
player1.Visibility = Visibility.Visible;
//窄屏
player2.Visibility = Visibility.Visible;
string newSource = Helper.NetworkHelper.SERVER + currentRecord.video;
player1.Source = MediaSource.CreateFromUri(new Uri(newSource, UriKind.Absolute));
player2.Source = MediaSource.CreateFromUri(new Uri(newSource, UriKind.Absolute));
}
//同步点赞数
favoriteNum.Text = currentRecord.favoriteNum;
//解析点赞头像组
JObject res = await Helper.NetworkHelper.recordDetail(currentRecord.id);
if (res["result"].ToString() == Helper.NetworkHelper.SUCCESS)
{
JObject records = JObject.Parse(res["record"].ToString());
JArray favoriters = JArray.Parse(records["favoriter"].ToString());
gridView.IsItemClickEnabled = false;
gridView.Name = "gridView";
gridView.Margin = new Thickness(30, 0, 0, 0);
for (int i = 0; i < favoriters.Count; ++i)
{
string _newFavoriter = Helper.NetworkHelper.SERVER + favoriters[i].ToString();
Ellipse ellipse = new Ellipse();
ImageBrush newFavoriter = new ImageBrush();
newFavoriter.ImageSource = new BitmapImage(new Uri(_newFavoriter));
ellipse.Fill = newFavoriter;
ellipse.Height = ellipse.Width = 60;
gridView.Items.Add(ellipse);
}
// Add the grid view to a parent container in the visual tree.
likeList.Children.Add(gridView);
//获取更详细的发布时间
publishTime.Text = records["date"].ToString();
}
dataTransferManager = DataTransferManager.GetForCurrentView();
dataTransferManager.DataRequested += dataRequested;
}
private async void publishClick(object sender, RoutedEventArgs e)
{
JObject res1 = await Helper.NetworkHelper.postRecord(title.Text, content.Text, Store.UserStore.onlineId);
if (res1["result"].ToString() == Helper.NetworkHelper.SUCCESS)
{
JObject records = JObject.Parse(res1["record"].ToString());
JObject res2 = null;
if (isImage)
{
res2 = await Helper.NetworkHelper.uploadImage(file, Store.UserStore.onlineId, records["_id"].ToString());
}
else if (isAudio)
{
res2 = await Helper.NetworkHelper.uploadAudio(file, Store.UserStore.onlineId, records["_id"].ToString());
}
else if (isVideo)
{
res2 = await Helper.NetworkHelper.uploadVideo(file, Store.UserStore.onlineId, records["_id"].ToString());
}
if (res2 != null)
{
if (res2["result"].ToString() == Helper.NetworkHelper.SUCCESS)
{
await(new MessageDialog("发布成功！")).ShowAsync();
Store.RecordStore.loadAllRecordsFromServer();
Model.Record newRecord1 = new Model.Record();
newRecord1.id = records["_id"].ToString();
newRecord1.userId = Store.UserStore.userId;
newRecord1.title = title.Text;
newRecord1.content = content.Text;
newRecord1.date = System.DateTime.Now.ToString();
newRecord1.nickname = Store.UserStore.nickname;
newRecord1.favoriteNum = "-1";
newRecord1.userAvatar = Store.UserStore.avatar;
newRecord1.image = newRecord1.audio = newRecord1.video = "";
if (isImage)
{
newRecord1.image = res2["path"].ToString();
}
else if (isAudio)
{
newRecord1.audio = res2["path"].ToString();
}
else if (isVideo)
{
newRecord1.video = res2["path"].ToString();
}
(Window.Current.Content as Frame).Navigate(typeof(DetailPage), newRecord1);
}
else
{
await(new MessageDialog("上传失败！")).ShowAsync();
await Helper.NetworkHelper.deleteRecord(Store.UserStore.onlineId, records["_id"].ToString());
}
}
if (res2 == null)
{
await(new MessageDialog("发布成功！")).ShowAsync();
Store.RecordStore.loadAllRecordsFromServer();
Model.Record newRecord = new Model.Record();
newRecord.id = records["_id"].ToString();
newRecord.userId = Store.UserStore.userId;
newRecord.title = title.Text;
newRecord.content = content.Text;
newRecord.image = newRecord.video = newRecord.audio = "";
newRecord.date = System.DateTime.Now.ToString();
newRecord.nickname = Store.UserStore.nickname;
newRecord.favoriteNum = "-1";
newRecord.userAvatar = Store.UserStore.avatar;
(Window.Current.Content as Frame).Navigate(typeof(DetailPage), newRecord);
}
}
else
{
await(new MessageDialog("发布失败！")).ShowAsync();
}
}
public void Add(Model.Record record)
{
db.Insert(tableName,record);
}
