CyberX8/Framework/Common/DBCore/MFCVerificationDataRecorder.cs

using Aitex.Core.RT.DBCore;
using System;
using System.Collections.Generic;
using System.Data;

namespace MECF.Framework.Common.DBCore
{
    public class MFCVerificationDataRecorder
    {
        public static void Add(MFCVerificationData data)
        {
            string sql = string.Format(
                "INSERT INTO \"mfc_verification_data\"(\"module\" , \"name\" ,\"operate_time\", \"percent10_setpoint\" , \"percent10_calculate\", \"percent20_setpoint\", \"percent20_calculate\", " +
                                                                       "\"percent30_setpoint\" , \"percent30_calculate\", \"percent40_setpoint\", \"percent40_calculate\", " +
                                                                       "\"percent50_setpoint\" , \"percent50_calculate\", \"percent60_setpoint\", \"percent60_calculate\", " +
                                                                       "\"percent70_setpoint\" , \"percent70_calculate\", \"percent80_setpoint\", \"percent80_calculate\", " +
                                                                       "\"percent90_setpoint\" , \"percent90_calculate\", \"percent100_setpoint\", \"percent100_calculate\", \"setpoint\", \"calculate\"" +
                                                                       ")VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}' " +
                                                                       ", '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}'" +
                                                                       ", '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}', '{23}', '{24}');",
                data.Module,
                data.Name,
                DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"),
                data.Percent10Setpoint,
                data.Percent10Calculate,
                data.Percent20Setpoint,
                data.Percent20Calculate,
                data.Percent30Setpoint,
                data.Percent30Calculate,
                data.Percent40Setpoint,
                data.Percent40Calculate,
                data.Percent50Setpoint,
                data.Percent50Calculate,
                data.Percent60Setpoint,
                data.Percent60Calculate,
                data.Percent70Setpoint,
                data.Percent70Calculate,
                data.Percent80Setpoint,
                data.Percent80Calculate,
                data.Percent90Setpoint,
                data.Percent90Calculate,
                data.Percent100Setpoint,
                data.Percent100Calculate,
                data.Setpoint,
                data.Calculate);

            DB.Insert(sql);
        }
        public static List<MFCVerificationData> GetMFCVerificationData(DateTime begin, DateTime end)
        {
            List<MFCVerificationData> result = new List<MFCVerificationData>();

            string sql = string.Format("SELECT * FROM \"mfc_verification_data\" where \"operate_time\" >= '{0}' and \"operate_time\" <= '{1}' order by \"operate_time\" DESC;",
                begin.ToString("yyyy/MM/dd HH:mm:ss.fff"), end.ToString("yyyy/MM/dd HH:mm:ss.fff"));

            DataSet ds = DB.ExecuteDataset(sql);
            if (ds == null)
                return result;
            if (ds.Tables.Count == 0)
                return result;

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                result.Add(new MFCVerificationData()
                {
                    
                    Module=ds.Tables[0].Rows[i]["module"].ToString(),
                    Name = ds.Tables[0].Rows[i]["name"].ToString(),
                    OperateTime=  ds.Tables[0].Rows[i]["operate_time"].ToString(),

                    Percent10Setpoint = (float)ds.Tables[0].Rows[i]["percent10_setpoint"],
                    Percent10Calculate = (float)ds.Tables[0].Rows[i]["percent10_calculate"],
                    Percent20Setpoint = (float)ds.Tables[0].Rows[i]["percent20_setpoint"],
                    Percent20Calculate = (float)ds.Tables[0].Rows[i]["percent20_calculate"],
                    Percent30Setpoint = (float)ds.Tables[0].Rows[i]["percent30_setpoint"],
                    Percent30Calculate = (float)ds.Tables[0].Rows[i]["percent30_calculate"],
                    Percent40Setpoint = (float)ds.Tables[0].Rows[i]["percent40_setpoint"],
                    Percent40Calculate = (float)ds.Tables[0].Rows[i]["percent40_calculate"],
                    Percent50Setpoint = (float)ds.Tables[0].Rows[i]["percent50_setpoint"],
                    Percent50Calculate = (float)ds.Tables[0].Rows[i]["percent50_calculate"],
                    Percent60Setpoint = (float)ds.Tables[0].Rows[i]["percent60_setpoint"],
                    Percent60Calculate = (float)ds.Tables[0].Rows[i]["percent60_calculate"],
                    Percent70Setpoint = (float)ds.Tables[0].Rows[i]["percent70_setpoint"],
                    Percent70Calculate = (float)ds.Tables[0].Rows[i]["percent70_calculate"],
                    Percent80Setpoint = (float)ds.Tables[0].Rows[i]["percent80_setpoint"],
                    Percent80Calculate = (float)ds.Tables[0].Rows[i]["percent80_calculate"],
                    Percent90Setpoint = (float)ds.Tables[0].Rows[i]["percent90_setpoint"],
                    Percent90Calculate = (float)ds.Tables[0].Rows[i]["percent90_calculate"],
                    Percent100Setpoint = (float)ds.Tables[0].Rows[i]["percent100_setpoint"],
                    Percent100Calculate = (float)ds.Tables[0].Rows[i]["percent100_calculate"],


                });
            }

            ds.Clear();

            return result;
        }
        public static void AddTenPointsData(MFCVerificationTenPointsData data)
        {
            string sql = string.Format(
                "INSERT INTO \"mfc_verification_data_tenpoints\"(\"module\" , \"name\" ,\"operate_time\", \"percent10_setpoint\" , \"percent10_calculate\", \"percent20_setpoint\", \"percent20_calculate\", " +
                                                                       "\"percent30_setpoint\" , \"percent30_calculate\", \"percent40_setpoint\", \"percent40_calculate\", " +
                                                                       "\"percent50_setpoint\" , \"percent50_calculate\", \"percent60_setpoint\", \"percent60_calculate\", " +
                                                                       "\"percent70_setpoint\" , \"percent70_calculate\", \"percent80_setpoint\", \"percent80_calculate\", " +
                                                                       "\"percent90_setpoint\" , \"percent90_calculate\", \"percent100_setpoint\", \"percent100_calculate\"" +
                                                                       ")VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}' " +
                                                                       ", '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}'" +
                                                                       ", '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}');",
                data.Module,
                data.Name,
                DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"),
                data.Percent10Setpoint,
                data.Percent10Calculate,
                data.Percent20Setpoint,
                data.Percent20Calculate,
                data.Percent30Setpoint,
                data.Percent30Calculate,
                data.Percent40Setpoint,
                data.Percent40Calculate,
                data.Percent50Setpoint,
                data.Percent50Calculate,
                data.Percent60Setpoint,
                data.Percent60Calculate,
                data.Percent70Setpoint,
                data.Percent70Calculate,
                data.Percent80Setpoint,
                data.Percent80Calculate,
                data.Percent90Setpoint,
                data.Percent90Calculate,
                data.Percent100Setpoint,
                data.Percent100Calculate);

            DB.Insert(sql);
        }
        public static List<MFCVerificationTenPointsData> GetMFCVerificationTenPointsData()
        {
            List<MFCVerificationTenPointsData> result = new List<MFCVerificationTenPointsData>();

            string sql = string.Format("SELECT * FROM \"mfc_verification_data_tenpoints\"  order by \"operate_time\" DESC;");

            DataSet ds = DB.ExecuteDataset(sql);
            if (ds == null)
                return result;
            if (ds.Tables.Count == 0)
                return result;

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                result.Add(new MFCVerificationTenPointsData()
                {
                    Module = ds.Tables[0].Rows[i]["module"].ToString(),
                    Name = ds.Tables[0].Rows[i]["name"].ToString(),
                    OperateTime = ds.Tables[0].Rows[i]["operate_time"].ToString(),
                    Percent10Setpoint = (float)ds.Tables[0].Rows[i]["percent10_setpoint"],
                    Percent10Calculate = (float)ds.Tables[0].Rows[i]["percent10_calculate"],
                    Percent20Setpoint = (float)ds.Tables[0].Rows[i]["percent20_setpoint"],
                    Percent20Calculate = (float)ds.Tables[0].Rows[i]["percent20_calculate"],
                    Percent30Setpoint = (float)ds.Tables[0].Rows[i]["percent30_setpoint"],
                    Percent30Calculate = (float)ds.Tables[0].Rows[i]["percent30_calculate"],
                    Percent40Setpoint = (float)ds.Tables[0].Rows[i]["percent40_setpoint"],
                    Percent40Calculate = (float)ds.Tables[0].Rows[i]["percent40_calculate"],
                    Percent50Setpoint = (float)ds.Tables[0].Rows[i]["percent50_setpoint"],
                    Percent50Calculate = (float)ds.Tables[0].Rows[i]["percent50_calculate"],
                    Percent60Setpoint = (float)ds.Tables[0].Rows[i]["percent60_setpoint"],
                    Percent60Calculate = (float)ds.Tables[0].Rows[i]["percent60_calculate"],
                    Percent70Setpoint = (float)ds.Tables[0].Rows[i]["percent70_setpoint"],
                    Percent70Calculate = (float)ds.Tables[0].Rows[i]["percent70_calculate"],
                    Percent80Setpoint = (float)ds.Tables[0].Rows[i]["percent80_setpoint"],
                    Percent80Calculate = (float)ds.Tables[0].Rows[i]["percent80_calculate"],
                    Percent90Setpoint = (float)ds.Tables[0].Rows[i]["percent90_setpoint"],
                    Percent90Calculate = (float)ds.Tables[0].Rows[i]["percent90_calculate"],
                    Percent100Setpoint = (float)ds.Tables[0].Rows[i]["percent100_setpoint"],
                    Percent100Calculate = (float)ds.Tables[0].Rows[i]["percent100_calculate"]
                });
            }

            ds.Clear();

            return result;
        }
        public static void AddOnePointData(MFCVerificationOnePointData data)
        {
            string sql = 
                $"INSERT INTO \"mfc_verification_data_onepoint\"(\"module\" , \"name\" ,\"operate_time\", \"setpoint\" , \"calculate\") VALUES ('{data.Module}', '{data.Name}', '{DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff")}', '{data.Setpoint}', '{data.Calculate}');";

            DB.Insert(sql);
        }
        public static List<MFCVerificationOnePointData> GetMFCVerificationOnePointData()
        {
            List<MFCVerificationOnePointData> result = new List<MFCVerificationOnePointData>();

            string sql = string.Format("SELECT * FROM \"mfc_verification_data_onepoint\"  order by \"operate_time\" DESC;");

            DataSet ds = DB.ExecuteDataset(sql);
            if (ds == null)
                return result;
            if (ds.Tables.Count == 0)
                return result;

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                result.Add(new MFCVerificationOnePointData()
                {
                    Module = ds.Tables[0].Rows[i]["module"].ToString(),
                    Name = ds.Tables[0].Rows[i]["name"].ToString(),
                    OperateTime = ds.Tables[0].Rows[i]["operate_time"].ToString(),
                    Setpoint = (float)ds.Tables[0].Rows[i]["setpoint"],
                    Calculate = (float)ds.Tables[0].Rows[i]["calculate"],
                });
            }

            ds.Clear();

            return result;
        }


    }
    public class MFCVerificationOnePointData
    {
        public string Module { get; set; }
        public string Name { get; set; }
        public string OperateTime { get; set; }
        public float Setpoint { get; set; }
        public float Calculate { get; set; }    
    }
    public class MFCVerificationTenPointsData
    {
        public string Module { get; set; }
        public string Name { get; set; }
        public string OperateTime { get; set; }

        public float Percent10Setpoint { get; set; }
        public float Percent10Calculate { get; set; }
        public float Percent20Setpoint { get; set; }
        public float Percent20Calculate { get; set; }
        public float Percent30Setpoint { get; set; }
        public float Percent30Calculate { get; set; }
        public float Percent40Setpoint { get; set; }
        public float Percent40Calculate { get; set; }
        public float Percent50Setpoint { get; set; }
        public float Percent50Calculate { get; set; }
        public float Percent60Setpoint { get; set; }
        public float Percent60Calculate { get; set; }
        public float Percent70Setpoint { get; set; }
        public float Percent70Calculate { get; set; }
        public float Percent80Setpoint { get; set; }
        public float Percent80Calculate { get; set; }
        public float Percent90Setpoint { get; set; }
        public float Percent90Calculate { get; set; }
        public float Percent100Setpoint { get; set; }
        public float Percent100Calculate { get; set; }
    }
    public class MFCVerificationData
    {
        public string Module { get; set; }
        public string Name { get; set; }
        public string OperateTime { get; set; }

        public float Percent10Setpoint { get; set; }
        public float Percent10Calculate { get; set; }
        public float Percent20Setpoint { get; set; }
        public float Percent20Calculate { get; set; }
        public float Percent30Setpoint { get; set; }
        public float Percent30Calculate { get; set; }
        public float Percent40Setpoint { get; set; }
        public float Percent40Calculate { get; set; }
        public float Percent50Setpoint { get; set; }
        public float Percent50Calculate { get; set; }
        public float Percent60Setpoint { get; set; }
        public float Percent60Calculate { get; set; }
        public float Percent70Setpoint { get; set; }
        public float Percent70Calculate { get; set; }
        public float Percent80Setpoint { get; set; }
        public float Percent80Calculate { get; set; }
        public float Percent90Setpoint { get; set; }
        public float Percent90Calculate { get; set; }
        public float Percent100Setpoint { get; set; }
        public float Percent100Calculate { get; set; }
        public float Setpoint { get; set; }
        public float Calculate { get; set; }
    }
}