/// <summary>
/// 查找历史数据最小值
/// </summary>
/// <param name="tagName"></param>
/// <returns></returns>
public static double MinOfHistory(string tagName)
{
try
{
string filtString = "tagName=" + "'" + tagName + "'";
DataRow[] drs = HistoryDataTable.Select(filtString);
//return decimal.Parse(dr[2].ToString());//返回查找到的数值
double min = double.MaxValue;
foreach (DataRow dr in drs)
{
double d = double.Parse(dr[2].ToString());
if (d < min)
{
min = d;
}
}
return(min);
}
catch (Exception ex)
{
return(0);
throw ex; //抛出异常
}
}
public override global::System.Data.DataTable Clone()
{
HistoryDataTable cln = ((HistoryDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
private void InitClass()
{
this.DataSetName = "WutModels";
this.Prefix = "";
this.Namespace = "http://tempuri.org/WutModels.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableHistory = new HistoryDataTable();
base.Tables.Add(this.tableHistory);
}
internal void InitVars(bool initTable)
{
this.tableHistory = ((HistoryDataTable)(base.Tables["History"]));
if ((initTable == true))
{
if ((this.tableHistory != null))
{
this.tableHistory.InitVars();
}
}
}
/// <summary>
/// 读取历史数据
/// </summary>
/// <param name="tagName"></param>
/// <param name="dateTime"></param>
/// <returns></returns>
public static decimal GetHistoryData(string tagName, string dateTime)
{
try
{
string filtString = "time=" + "'" + dateTime + "'" + " and tagName=" + "'" + tagName + "'";
DataRow dr = HistoryDataTable.Select(filtString).First();
return(decimal.Parse(dr[2].ToString()));//返回查找到的数值
}
catch (Exception ex)
{
return(0);
throw ex;//抛出异常
}
}
/// <summary>
/// 历史数据第一个值
/// </summary>
/// <param name="tagName"></param>
/// <returns></returns>
public static double firstOfHistory(string tagName)
{
double value = 0.0;
try
{
string filtString = "tagName=" + "'" + tagName + "'";
DataRow[] drs = HistoryDataTable.Select(filtString);
value = double.Parse(drs.First()[2].ToString());
return(value);
}
catch (Exception ex)
{
return(0);
throw ex; //抛出异常
}
}
/// <summary>
/// 历史数据求和
/// </summary>
/// <param name="tagName"></param>
/// <returns></returns>
public static decimal GetHistoryDataSum(string tagName, int exceptFirst)
{
//exceptFirst 是否舍去8点的数据,这里并不具有通用型,后续需要钙胶囊
try
{
string filtString = "tagName=" + "'" + tagName + "'";
DataRow[] drs = HistoryDataTable.Select(filtString);
int firstHour = DateTime.Parse(drs[0][0].ToString()).Hour;
decimal sum = 0;
if (exceptFirst == 0)
{
for (int i = 0; i < drs.Length; i++)
{
sum += decimal.Parse(drs[i][2].ToString());
}
}
else
{
if (firstHour == 8)
{
for (int i = 1; i < drs.Length; i++)
{
sum += decimal.Parse(drs[i][2].ToString());
}
}
else
{
for (int i = 0; i < drs.Length; i++)
{
sum += decimal.Parse(drs[i][2].ToString());
}
}
}
return(sum);
}
catch (Exception ex)
{
return(0);
throw ex; //抛出异常
}
}
public LinguaSpaceDataSet()
{
// Vocabulary
tableVocabularies = new VocabulariesDataTable();
tableTypes = new TypesDataTable();
tableWords = new WordsDataTable();
tableMeanings = new MeaningsDataTable();
tableTranslations = new TranslationsDataTable();
tableSynonyms = new SynonymsDataTable();
tableAntonyms = new AntonymsDataTable();
// Profile
tableProfiles = new ProfilesDataTable();
tableActions = new ActionsDataTable();
tableHistory = new HistoryDataTable();
this.Tables.AddRange(new DataTable[] { tableVocabularies, tableTypes, tableWords, tableMeanings, tableTranslations, tableSynonyms, tableAntonyms, tableProfiles, tableActions, tableHistory });
tableTypes.DefaultView.Sort = Strings.POSITION;
tableWords.DefaultView.Sort = "Word, TypeId";
tableMeanings.DefaultView.Sort = "WordId, Position";
tableTranslations.DefaultView.Sort = "MeaningId, Position";
tableSynonyms.DefaultView.Sort = "MeaningId, Position";
tableAntonyms.DefaultView.Sort = "MeaningId, Position";
tableHistory.DefaultView.Sort = "MeaningId";
AddForeignKey(tableTypes, tableWords, Strings.TYPE_ID, Strings.FK_WORDS_TYPES, false);
AddForeignKey(tableWords, tableMeanings, Strings.WORD_ID, Strings.FK_MEANINGS_WORDS, true);
AddForeignKey(tableMeanings, tableTranslations, Strings.MEANING_ID, Strings.FK_TRANSLATIONS_MEANINGS, true);
AddForeignKey(tableMeanings, tableSynonyms, Strings.MEANING_ID, Strings.FK_SYNONYMS_MEANINGS, true);
AddForeignKey(tableMeanings, tableAntonyms, Strings.MEANING_ID, Strings.FK_ANTONYMS_MEANINGS, true);
AddForeignKey(tableWords, tableSynonyms, Strings.WORD_ID, Strings.FK_SYNONYMS_WORDS, true);
AddForeignKey(tableWords, tableAntonyms, Strings.WORD_ID, Strings.FK_ANTONYMS_WORDS, true);
AddForeignKey(tableMeanings, tableHistory, Strings.MEANING_ID, Strings.MEANING_ID, Strings.FK_HISTORY_MEANINGS, false, false);
AddForeignKey(tableVocabularies, tableHistory, Strings.VOCABULARY_ID, Strings.VOCABULARY_ID, Strings.FK_HISTORY_VOCABULARIES, false, false);
this.EnforceConstraints = true;
}
/// <summary>
/// 计算历史数据平均值
/// </summary>
/// <param name="tagName"></param>
/// <returns></returns>
public static double avgOfHistory(string tagName)
{
try
{
string filtString = "tagName=" + "'" + tagName + "'";
DataRow[] drs = HistoryDataTable.Select(filtString);
//return decimal.Parse(dr[2].ToString());//返回查找到的数值
double avg = 0.0;
double sum = 0.0;
foreach (DataRow dr in drs)
{
double d = double.Parse(dr[2].ToString());
sum += d;
}
avg = sum / drs.Length;
return(avg);
}
catch (Exception ex)
{
return(0);
throw ex; //抛出异常
}
}
private void InitClass() {
this.DataSetName = "Database1DataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/Database1DataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableAsset_Info = new Asset_InfoDataTable();
base.Tables.Add(this.tableAsset_Info);
this.tableHistory = new HistoryDataTable();
base.Tables.Add(this.tableHistory);
this.tableDepreciation_Years = new Depreciation_YearsDataTable();
base.Tables.Add(this.tableDepreciation_Years);
global::System.Data.ForeignKeyConstraint fkc;
fkc = new global::System.Data.ForeignKeyConstraint("FK_History_Asset Info", new global::System.Data.DataColumn[] {
this.tableHistory.Asset_IDColumn}, new global::System.Data.DataColumn[] {
this.tableAsset_Info.Asset_IDColumn});
this.tableAsset_Info.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.Cascade;
fkc.UpdateRule = global::System.Data.Rule.Cascade;
fkc = new global::System.Data.ForeignKeyConstraint("FK_Asset Info_History", new global::System.Data.DataColumn[] {
this.tableAsset_Info.Asset_IDColumn}, new global::System.Data.DataColumn[] {
this.tableHistory.Asset_IDColumn});
this.tableHistory.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.Cascade;
fkc.UpdateRule = global::System.Data.Rule.Cascade;
this.relationFK_History_Asset_Info = new global::System.Data.DataRelation("FK_History_Asset Info", new global::System.Data.DataColumn[] {
this.tableHistory.Asset_IDColumn}, new global::System.Data.DataColumn[] {
this.tableAsset_Info.Asset_IDColumn}, false);
this.Relations.Add(this.relationFK_History_Asset_Info);
this.relationFK_Asset_Info_History = new global::System.Data.DataRelation("FK_Asset Info_History", new global::System.Data.DataColumn[] {
this.tableAsset_Info.Asset_IDColumn}, new global::System.Data.DataColumn[] {
this.tableHistory.Asset_IDColumn}, false);
this.Relations.Add(this.relationFK_Asset_Info_History);
}
internal void InitVars(bool initTable) {
this.tableAsset_Info = ((Asset_InfoDataTable)(base.Tables["Asset Info"]));
if ((initTable == true)) {
if ((this.tableAsset_Info != null)) {
this.tableAsset_Info.InitVars();
}
}
this.tableHistory = ((HistoryDataTable)(base.Tables["History"]));
if ((initTable == true)) {
if ((this.tableHistory != null)) {
this.tableHistory.InitVars();
}
}
this.tableDepreciation_Years = ((Depreciation_YearsDataTable)(base.Tables["Depreciation Years"]));
if ((initTable == true)) {
if ((this.tableDepreciation_Years != null)) {
this.tableDepreciation_Years.InitVars();
}
}
this.relationFK_History_Asset_Info = this.Relations["FK_History_Asset Info"];
this.relationFK_Asset_Info_History = this.Relations["FK_Asset Info_History"];
}
internal HistoryRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableHistory = ((HistoryDataTable)(this.Table));
}
internal HistoryRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableHistory = ((HistoryDataTable)(this.Table));
}
