using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Commom.Utility;
using Common;
using Model;

namespace BLL.DAL
{
    public class DAL_ManualControl
    {
        public IList<WCSPlcInfo> GetList(AjaxPlcInfoList Json, ref PageInfo pageInfo)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("select * from WCSPlcInfo  where IsDel = 0 ");

                if (!string.IsNullOrWhiteSpace(Json.Type) )
                {
                    strSql.Append(" and Type = '" + Json.Type + "'  ");
                }
                DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), null, "CreateTime", "", ref pageInfo);
                return ModelConvertHelper<WCSPlcInfo>.DataTableToModel(dt);
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        public bool Add(TaskMonitorModel model, string loginUser)
        {
            bool result = false;
            try
            {
                Hashtable ht = new Hashtable();

                ht["TaskType"] = model.TaskType.AddQuotes();
                ht["InitialAddre"] = "'" + model.InitialAddre + "'";
                ht["Palno"] = "'" + model.Palno + "'";
                ht["TargetAddre"] = "'" + model.TargetAddre + "'";
                ht["State"] = "'0'";
                ht["IsSucceed"] = "'" + model.IsSucceed + "'";
                ht["ErrorStr"] = "'" + model.ErrorStr + "'";
                ht["PriorityLevel"] = model.PriorityLevel;
                ht["Source"] = "'手动'";
                ht["Demo"] = "'"+ model.Demo + "'";

                ht["CreateUser"] = "'" + loginUser + "'";
                ht["CreateTime"] = "Getdate()";
                

                int _ret = DataFactory.SqlDataBase().InsertByHashtableNullParam("TaskMonitor", ht);

                if (_ret == 1) result = true;

                return result;

            }
            catch
            {
                return result;
            }
        }

        public IList<Dictionarys> GetDictionaryItems(Dictionarys dictionarys, ref PageInfo page)
        {
            try
            {
                StringBuilder stringBuilder = new StringBuilder();
                stringBuilder.Append("select * from View_Dictionary_Userinfo where IsDel = 0 and TopCode = 'Access' ");
                if (dictionarys.TopCode != null && dictionarys.TopCode != "")
                {
                    stringBuilder.Append(" and TopCode = " + dictionarys.TopCode.AddQuotes());
                }
                if (dictionarys.TypeName != null && dictionarys.TypeName != "")
                {
                    stringBuilder.Append(" and TypeName like '%" + dictionarys.TypeName + "%' ");
                }
                if (dictionarys.Guid != null && dictionarys.Guid != "")
                {
                    stringBuilder.Append(" and Guid = " + dictionarys.Guid.AddQuotes());
                }

                SqlParam[] para = new SqlParam[]
                {
                };

                DataTable dt = DataFactory.SqlDataBase().GetPageList(stringBuilder.ToString(), para, "TopCode", "ASC", ref page);
                IList<Dictionarys> list = ModelConvertHelper<Dictionarys>.DataTableToModel(dt);

                return list;
            }
            catch
            {
                throw new NotImplementedException();
            }
        }

        public bool IsAutoUpdate(string[] Code)
        {
            bool result = false;
            try
            {
                string[] str = { "WCSAuto" };
                int dt = DataFactory.SqlDataBase().IsExist("Dictionary", "TopCode", str);
                if (dt >= Code.Length)
                {
                    int i = 0;
                    while (i < Code.Length)
                    {
                        StringBuilder sql = new StringBuilder();
                        sql.Append("update Dictionary set Code='" + Code[i] + "' where TopCode='WCSAuto'");
                        int _ret = DataFactory.SqlDataBase().ExecuteBySql(sql);
                        if (_ret >= Code.Length) result = true;
                        i++;
                    }

                }
                return result;

            }
            catch
            {
                return result;
            }
        }
    }
}