using MyGlassEdit.ng.optima.model;
using MyGlassEdit.ng.optima.util;
using Newtonsoft.Json;
using ng.optima.config;
using ng.optima.server;
using ng.optima.util;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MyGlassEdit.ng.optima.server
{
    public static class AdminDB
    {
        public static bool AdminLogin(string uName,string uPwd) {
            string str = string.Format(@"Select * from optimize_admin where login_name ='{0}' and password ='{1}'", uName, uPwd);
            DataTable dataTable =  MySqlDbHelper.SelectForTable(str);
            if (dataTable == null || dataTable.Rows.Count <= 0) {

                return false;
            }

            List<AdminModel> adminModel = DataTableUtil.ToModel<AdminModel>(dataTable);
            if (adminModel.Count > 1) {
                return false;
            }

            AdminModel admin = adminModel[0];
            admin.login_num++;
            admin.last_login_time = DateTime.Now;//.ToString("yyyy-MM-dd HH:mm:ss");

            LoginAdminInfo.id = admin.Id;
            LoginAdminInfo.name = admin.name;
            LoginAdminInfo.login_name = admin.login_name;
            LoginAdminInfo.limits = admin.limits;
            LoginAdminInfo.login_num = admin.login_num;
            LoginAdminInfo.o_id = admin.o_id;
            LoginAdminInfo.h_id = admin.h_id;
            LoginAdminInfo.m_id = admin.m_id;
            LoginAdminInfo.password = admin.password;
            LoginAdminInfo.last_login_time = admin.last_login_time;
            LoginAdminInfo.last_login_ip = SystemUtil.GetSystemIP();
            LoginAdminInfo.last_logout_time = admin.last_logout_time;

            //获取用户钢化的配置
            //ConfigDB.GetAdminConfig(1,LoginAdminInfo.h_id);
            //获取用户打标的配置
            //ConfigDB.GetAdminConfig(2,LoginAdminInfo.m_id);
            //获取用户系统的配置
            //ConfigDB.GetAdminConfig(3,LoginAdminInfo.o_id);

            SystemConfig.ReadSet();
            OptimaConfig.OptimaConfigRead();

            return UpdateAdminInfo();
        }


        /// <summary>
        /// 更新用户信息
        /// </summary>
        /// <returns></returns>
        public static bool UpdateAdminInfo() {
            StringBuilder sql = new StringBuilder();
            sql.Append("update optimize_admin set");
            sql.AppendFormat(" login_name = '{0}',",LoginAdminInfo.login_name);
            sql.AppendFormat(" password = '{0}',",LoginAdminInfo.password);
            sql.AppendFormat(" m_id = '{0}',",LoginAdminInfo.m_id);
            sql.AppendFormat(" h_id='{0}',", LoginAdminInfo.h_id);
            sql.AppendFormat(" o_id = '{0}',", LoginAdminInfo.o_id);
            sql.AppendFormat(" login_num = '{0}',", LoginAdminInfo.login_num);
            sql.AppendFormat(" last_login_ip = '{0}',", LoginAdminInfo.last_login_ip);
            sql.AppendFormat(" last_login_time = '{0}',",LoginAdminInfo.last_login_time);
            sql.AppendFormat(" last_logout_time = '{0}'",LoginAdminInfo.last_logout_time);
            sql.AppendFormat(" where Id = '{0}'", LoginAdminInfo.id);
            return MySqlDbHelper.Update(sql.ToString());
        }


        public static bool UpdateAdminLoginInfo() {




            return false;
        
        }
        
    }
}