using System;
using Dapper;
using HNWD.Pregrant.Model;
using System.Collections.Generic;
using System.Text;

namespace HNWD.Pregrant.DataAccess
{
    public class WD_VerInfoDataAccess : GenericDataAccess<WD_VerInfo>
    {
        private WD_VerInfo wd_VerInfo = null;

        public WD_VerInfoExt ext = new WD_VerInfoExt();


        private readonly static WD_VerInfoDataAccess wd_VerInfoDataAccess = new WD_VerInfoDataAccess(null);
        private readonly static object lockobj = new object();

        public static WD_VerInfoDataAccess GetInstance()
        {
            lock (lockobj)
            {
                return wd_VerInfoDataAccess;
            }
        }  


        private WD_VerInfoDataAccess(WD_VerInfo wd_VerInfo)
        {
            this.wd_VerInfo = wd_VerInfo;

       }

        public List<WD_VerInfo> QueryAll()
        {
            string strSql = " select {0} from [WD_VerInfo]  ";

            ext.messageDataList = this.Query(strSql, new WD_VerInfo());
            ext.messageDataList.ForEach(f => f.bSuccess = this.bSuccess);
            ext.messageDataList.ForEach(f => f.Code = this.Code);
            ext.messageDataList.ForEach(f => f.Message = this.Message);
            ext.messageDataList.ForEach(f => f.Rows = this.Rows);
            ext.bSuccess = this.bSuccess;
            ext.Code = this.Code;
            ext.Message = this.Message;
            ext.Rows = this.Rows;

            return ext.messageDataList;

        }


        public void Business(List<WD_VerInfo> il, List<WD_VerInfo> ul, List<WD_VerInfo> dl)
        { 
            string strSql_i = " INSERT INTO [WD_VerInfo] ([VER_DEVICETYPE],[VER_INFO],[VER_FILEPATH],[VER_DATETIME]) VALUES ('{0}' ,  '{1}', '{2}',  '{3}') ";
            string strSql_u = "";
            string strSql_d = "";
        
            StringBuilder sb_i = new StringBuilder();

            foreach (WD_VerInfo wd in il)
            {
                sb_i.AppendFormat(strSql_i, wd.VER_DEVICETYPE, wd.VER_INFO, wd.VER_FILEPATH, wd.VER_DATETIME);

                sb_i.AppendFormat(" update [WD_RunProfile] SET [UpdateFlag]= '{0}' ;" , wd.VER_DEVICETYPE) ;
            }


            this.Execute(sb_i.ToString(), strSql_u, strSql_d);



        }
                
  
    }
}