using System.Data;
using System.Text;
using MES.Service.DB;
using MES.Service.Modes;

namespace MES.Service.service;

public class LoginService
{
    public static OracleSQLHelper SQLHelper = new();

    public DataTable login(string name, string pwd)
    {
        using var db = SqlSugarHelper.GetInstance();
        
        var user = db.Queryable<SysUser>()
            .Where(u => u.Fcode == name)
            .First();
            
        if (user == null) throw new Exception("用户不存在");

        var db_password = ProPass(user.Fpassword);
        if (!pwd.Equals(db_password)) throw new Exception("用户名或者密码错误");

        // 转换为DataTable以保持兼容性
        var userList = new List<SysUser> { user };
        var dataTable = new DataTable();
        
        // 添加需要的列
        dataTable.Columns.Add("FID", typeof(string));
        dataTable.Columns.Add("FCODE", typeof(string));
        dataTable.Columns.Add("FNAME", typeof(string));
        dataTable.Columns.Add("FPASSWORD", typeof(string));
        dataTable.Columns.Add("DEPARTMENTID", typeof(string));
        dataTable.Columns.Add("FACTORY", typeof(string));
        dataTable.Columns.Add("FCOMPANY", typeof(string));
        
        var row = dataTable.NewRow();
        row["FID"] = user.Fid;
        row["FCODE"] = user.Fcode;
        row["FNAME"] = user.Fname;
        row["FPASSWORD"] = user.Fpassword;
        row["DEPARTMENTID"] = user.Departmentid;
        row["FACTORY"] = user.Factory;
        row["FCOMPANY"] = user.Fcompany;
        
        dataTable.Rows.Add(row);
        
        return dataTable;
    }

    public DataTable getUserMenu(string name)
    {
        using var db = SqlSugarHelper.GetInstance();
        
        DataTable dataTable;
        
        if ("PL017".Equals(name))
        {
            var sql = "select PAGE_VIEW,PATH,ICOIMG from MES_SYS_PAGEVIEW";
            dataTable = db.Ado.GetDataTable(sql);
        }
        else
        {
            var sql = @"select PAGE_VIEW,PATH,ICOIMG
                    from (select PAGE_VIEW,PATH,ICOIMG
                          from MES_SYS_GUP_USER a
                                   join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
                                   join SYS_USER_ROLE c on to_char(c.ROLEID) = a.ROLEID
                          where USERID = (select fid from SYS_USER where FCODE = @name)
                          union all
                          select PAGE_VIEW,PATH,ICOIMG
                          from MES_SYS_GUP_USER a
                                   join MES_SYS_PAGEVIEW b on a.PAGEID = b.ID
                          where a.ROLEID = (select FCODE from SYS_USER where FCODE = @name))
                    group by PATH, PAGE_VIEW, ICOIMG";
            dataTable = db.Ado.GetDataTable(sql, new { name = name });
        }

        return dataTable;
    }

    public int resetPassword(string newPwd, string name, string pwd)
    {
        login(name, pwd);
        var passwordHash = encryptPass(newPwd);
        
        using var db = SqlSugarHelper.GetInstance();
        
        return db.Updateable<SysUser>()
            .SetColumns(u => u.Fpassword == passwordHash)
            .Where(u => u.Fcode == name)
            .ExecuteCommand();
    }

    private string encryptPass(string str)
    {
        var b = Encoding.GetEncoding("iso-8859-1").GetBytes(str);
        var temp = (byte[])b.Clone();
        for (var i = 0; i < b.Length; i++) temp[i] = (byte)(b[i] ^ (8 + 18));

        var result =
            8 + Encoding.GetEncoding("iso-8859-1").GetString(temp);
        return result;
    }


    private string ProPass(string src)
    {
        var result = "";
        var first = int.Parse(src.Substring(0, 1));
        var src_tem = src.Substring(1);
        var b = Encoding.GetEncoding("iso-8859-1")
            .GetBytes(src_tem);
        var temp = (byte[])b.Clone();
        for (var i = 0; i < b.Length; i++)
            temp[i] = (byte)(temp[i] ^ (first + 18));

        result = Encoding.GetEncoding("iso-8859-1")
            .GetString(temp);
        return result;
    }
}