using System;

namespace MainForm
{
    /// <summary>
    /// 运行数据-单机数据（废弃）
    /// </summary>
    public class WorkingData
    {
        #region 数据
        /// <summary>
        /// 设备代码
        /// </summary>
        public string Equipment_code;
        /// <summary>
        /// 开机时间
        /// </summary>
        public string BootTime;
        /// <summary>
        /// 
        /// </summary>
        public string Bootmoment;
        /// <summary>
        /// 运行时长
        /// </summary>
        public string RunTime;
        /// <summary>
        /// 工作时长
        /// </summary>
        public string WoringTime;
        /// <summary>
        /// 检修时长
        /// </summary>
        public string RepairTime;
        /// <summary>
        /// 故障时长
        /// </summary>
        public string StopTime;
        /// <summary>
        /// 缺料时长
        /// </summary>
        public string NeedTime;
        /// <summary>
        /// 
        /// </summary>
        public string WoringNum;
        /// <summary>
        /// 
        /// </summary>
        public string PlanStopMoment;
        /// <summary>
        /// 
        /// </summary>
        public string Equipment_status;
        /// <summary>
        /// 
        /// </summary>
        public string WorkingQty;
        /// <summary>
        /// 
        /// </summary>
        public string QualifiedQty;
        /// <summary>
        /// 
        /// </summary>
        public string TotalQty;
        /// <summary>
        /// 
        /// </summary>
        public string NGset;
        /// <summary>
        /// 
        /// </summary>
        public string QualifiedRateSet;
        /// <summary>
        /// 
        /// </summary>
        public string RhySet;
        /// <summary>
        /// 更新时间
        /// </summary>
        public string Update_time;
        #endregion 数据

        /// <summary>
        /// 新增数据
        /// </summary>
        /// <param name="date">数据</param>
        /// <returns></returns>
        public string ToStringInsert(string date)
        {
            return string.Format("insert into WorkingData" +
                "(" +
                "Date," +
                "Equipment_code," +
                "BootTime," +
                "Bootmoment," +
                "RunTime," +
                "WoringTime," +
                "RepairTime," +
                "StopTime," +
                "WoringNum," +
                "NeedTime," +
                "PlanStopMoment," +
                "Equipment_status," +
                "WorkingQty," +
                "QualifiedQty," +
                "TotalQty," +
                "NGset," +
                "QualifiedRateSet," +
                "RhySet," +
                "Update_time" +
                ") values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}'," +
                "'{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}');",
                date,
                Equipment_code, 
                BootTime, 
                Bootmoment, 
                RunTime, 
                WoringTime,
                RepairTime,
                StopTime, 
                WoringNum, 
                NeedTime, 
                PlanStopMoment, 
                Equipment_status, 
                WorkingQty, 
                QualifiedQty, 
                TotalQty, 
                NGset, 
                QualifiedRateSet, 
                RhySet,
                Update_time);
        }

        /// <summary>
        /// 修改数据
        /// </summary>
        /// <param name="date">数据</param>
        /// <returns></returns>
        public string ToStringUpdate(string date)
        {
            return string.Format("update WorkingData set " +
                "BootTime = '{0}'," +
                "Bootmoment = '{1}'," +
                "RunTime = '{2}'," +
                "WoringTime = '{3}'," +
                "RepairTime = '{4}'," +
                "StopTime = '{5}'," +
                "WoringNum = '{6}'," +
                "NeedTime = '{7}'," +
                "PlanStopMoment = '{8}'," +
                "Equipment_status = '{9}'," +
                "WorkingQty = '{10}'," +
                "QualifiedQty = '{11}'," +
                "TotalQty = '{12}'," +
                "NGset = '{13}'," +
                "QualifiedRateSet = '{14}'," +
                "RhySet = '{15}'," +
                "Update_time = '{16}' " +
                "where date = '{17}' " +
                "and  Equipment_code = '{18}'",
                BootTime,
                Bootmoment,
                RunTime,
                WoringTime,
                RepairTime,
                StopTime,
                WoringNum,
                NeedTime,
                PlanStopMoment,
                Equipment_status,
                WorkingQty,
                QualifiedQty,
                TotalQty,
                NGset,
                QualifiedRateSet,
                RhySet,
                Update_time,
                date,
                Equipment_code);
        }

        /// <summary>
        /// 查询数据 By Data、设备代号
        /// </summary>
        /// <param name="date">数据</param>
        /// <returns></returns>
        public string ToStringQuery(string date)
        {
            return string.Format("select date from WorkingData " +
                "where date = '{0}'" +
                "and  Equipment_code = '{1}'",
                date,
                Equipment_code);
        }

        /// <summary>
        /// 查询数据 By 开始时间~结束时间、设备代号
        /// </summary>
        /// <param name="startDate">开始时间</param>
        /// <param name="endDate">结束时间</param>
        /// <returns></returns>
        public string ToStringQuery(string startDate, string endDate)
        {
            if (Equipment_code != "All")
            {
                return string.Format(
                "select " +
                "Equipment_code 设备编号, " +
                "BootTime 开机总时间, " +
                "Bootmoment 开机时刻, " +
                "RunTime 运行时间," +
                "WoringTime 故障时间, " +
                "RepairTime 维修时间, " +
                "StopTime 待机时间," +
                "NeedTime 待料时间," +
                "WoringNum 报警次数, " +
                "PlanStopMoment 计划停机, " +
                "Equipment_status 设备状态, " +
                "WorkingQty 加工数量," +
                "QualifiedQty 合格数, " +
                "TotalQty 累计, " +
                "NGset 连续NG报警," +
                "QualifiedRateSet 不合格报警," +
                "RhySet 设计节拍, " +
                "Update_time 更新时间 " +
                "from WorkingData " +
                "where convert(datetime,Update_time,120) " +
                "between convert(datetime, '{0}', 120) " +
                "and     convert(datetime, '{1}', 120)  " +
                "and Equipment_code='{2}'",
                startDate,
                endDate,
                Equipment_code
                );
            }
            else
            {
                return string.Format(
                "select " +
                "Equipment_code 设备编号, " +
                "BootTime 开机总时间, " +
                "Bootmoment 开机时刻, " +
                "RunTime 运行时间," +
                "WoringTime 故障时间, " +
                "RepairTime 维修时间, " +
                "StopTime 待机时间," +
                "NeedTime 待料时间," +
                "WoringNum 报警次数, " +
                "PlanStopMoment 计划停机, " +
                "Equipment_status 设备状态, " +
                "WorkingQty 加工数量," +
                "QualifiedQty 合格数, " +
                "TotalQty 累计, " +
                "NGset 连续NG报警," +
                "QualifiedRateSet 不合格报警," +
                "RhySet 设计节拍, " +
                "Update_time 更新时间 " +
                "from WorkingData " +
                "where convert(datetime,Update_time,120) " +
                "between convert(datetime, '{0}', 120) " +
                "and     convert(datetime, '{1}', 120)  " ,
                startDate,
                endDate
                );
            }
        }
    }
}