CyberX8/Framework/Common/DBCore/WaferHolderHistoryRecord.cs

using Aitex.Core.RT.DBCore;
using Aitex.Core.Util;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MECF.Framework.Common.DBCore
{
    public class WaferHolderHistoryRecord
    { 
        /// <summary>
        /// 增加WaferHolder Arrive历史
        /// </summary>
        /// <param name="waferHolderId"></param>
        /// <param name="currentLocation"></param>
        public static void InsertWaferHolderArriveHistory(string waferHolderId,string currentLocation)
        {
            string sql = string.Format("INSERT INTO wafer_holder_history (wafer_holder_guid,operation_time, station,operation)VALUES ('{0}', '{1}', '{2}', '{3}' );",
               waferHolderId,
               DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"),
               currentLocation,
               "Arrive");

            DB.Insert(sql);
        }
        /// <summary>
        /// 增加WaferHolder Left历史
        /// </summary>
        /// <param name="waferHolderId"></param>
        /// <param name="currentLocation"></param>
        public static void InsertWaferHolderLeftHistory(string waferHolderId, string currentLocation)
        {
            string sql = string.Format("INSERT INTO wafer_holder_history (wafer_holder_guid,operation_time, station,operation)VALUES ('{0}', '{1}', '{2}', '{3}' );",
               waferHolderId,
               DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"),
               currentLocation,
               "Left");

            DB.Insert(sql);
        }
        /// <summary>
        /// 增加WaferHolder Remove历史
        /// </summary>
        /// <param name="waferHolderId"></param>
        /// <param name="currentLocation"></param>
        public static void InsertWaferHolderRemoveHistory(string waferHolderId)
        {
            string sql = string.Format("INSERT INTO wafer_holder_history (wafer_holder_guid,operation_time,operation)VALUES ('{0}', '{1}', '{2}' );",
               waferHolderId,
               DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"),
               "Remove");
            DB.Insert(sql);
        }
        /// <summary>
        /// 增加WaferHolder Delete历史
        /// </summary>
        /// <param name="waferHolderId"></param>
        /// <param name="currentLocation"></param>
        public static void InsertWaferHolderDeleteHistory(string waferHolderId)
        {
            string sql = string.Format("INSERT INTO wafer_holder_history (wafer_holder_guid,operation_time,operation)VALUES ('{0}', '{1}', '{2}' );",
               waferHolderId,
               DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"),
               "Delete");
            DB.Insert(sql);
        }
    } 
}