Exemplo n.º 1
0
 /// <summary>
 /// 建表以及新增数据
 /// </summary>
 /// <param 数据对象="baseProfile"></param>
 /// <returns></returns>
 public result AddBaseProfile(BaseProfile baseProfile, string tableName)
 {
     if (baseProfile == null)
     {
         return(result.fail);
     }
     //在这之前先判断是否安装了mysql数据库,并作出相应提示
     if (!AccessDBBase.ExistMysqlDB())
     {
         return(result.notFoundMySql);
     }
     if (AccessDBApply.CreateTable(tableName))
     {
         if (AccessDBApply.InsertBaseProfile(baseProfile.Temperature, baseProfile.Humidity, baseProfile.ProductLine, baseProfile.remainSolderPercent, baseProfile.usedSolderNum, baseProfile.addTimes, baseProfile.TimePoint, tableName))
         {
             return(result.success);
         }
         else
         {
             return(result.fail);
         }
     }
     else
     {
         return(result.fail);
     }
 }
Exemplo n.º 2
0
 /// <summary>
 /// 开启事件调度器,在调用时务必设置全局bool值让他只执行一次,另可在设置中重置bool值
 /// </summary>
 /// <param 时间范围="timerange"></param>
 /// <returns></returns>
 public bool SettingEventScheduler(string timerange, string tableName)
 {
     if (AccessDBApply.AutoCleanData(timerange, tableName))
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
Exemplo n.º 3
0
 /// <summary>
 /// 清空所有历史数据
 /// </summary>
 /// <returns></returns>
 public bool RemoveAllData(string tableName)
 {
     if (AccessDBApply.DropTable(tableName))
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
Exemplo n.º 4
0
 /// <summary>
 /// 清除某个时间点的数据
 /// </summary>
 /// <param 时间点="timePoint"></param>
 /// <returns></returns>
 public bool RemoveBaseProfile(string starttime, string endtime, string tableName)
 {
     if (AccessDBApply.deleteData_TimeToTime(starttime, endtime, tableName))
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
Exemplo n.º 5
0
 /// <summary>
 /// 查询历史记录(可选范围)返回DataTable
 /// </summary>
 /// <param 起始时间点="startTimePoint"></param>
 /// <param 结束时间点="endTimePoint"></param>
 /// <param 返回数据="Dt"></param>
 /// <returns></returns>
 public bool ReadBaseProfile_dataTable(string startTimePoint, string endTimePoint, out DataTable Dt)
 {
     Dt = AccessDBApply.selectDataTable_baseprofile(startTimePoint, endTimePoint);
     if (Dt == null)
     {
         return(false);
     }
     else
     {
         return(true);
     }
 }
Exemplo n.º 6
0
 /// <summary>
 /// 查询历史记录(可选范围)返回对象list
 /// </summary>
 /// <param 起始时间点="startTimePoint"></param>
 /// <param 结束时间点="endTimePoint"></param>
 /// <param 返回数据对象数组="baseProfileGroup"></param>
 /// <returns></returns>
 public bool ReadBaseProfile_list(string startTimePoint, string endTimePoint, out List <BaseProfile> baseProfileGroup)
 {
     baseProfileGroup = AccessDBApply.selectList_baseprofile(startTimePoint, endTimePoint);
     if (baseProfileGroup == null)
     {
         return(false);
     }
     else
     {
         return(true);
     }
 }
Exemplo n.º 7
0
 /// <summary>
 /// 查询历史记录(单条)
 /// </summary>
 /// <param 查询时间点="timePoint"></param>
 /// <param 返回数据对象="baseprofile"></param>
 /// <returns></returns>
 public bool ReadBaseProfile(string timePoint, out BaseProfile baseprofile)
 {
     baseprofile = AccessDBApply.select_baseprofile(timePoint);
     if (baseprofile == null)
     {
         return(false);
     }
     else
     {
         return(true);
     }
 }