using System.Data;
using System.Text;

namespace NewPdaSqlServer.service;

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

    public DataTable login(string name, string pwd)
    {
        // var sql =
        //     string.Format(@"select * from SYS_USER where FCODE = '{0}'",
        //         name);
        // var dataTable = SQLHelper.ExecuteQuery(sql);
        // if (dataTable.Rows.Count <= 0) throw new Exception("用户不存在");
        //
        // var row = dataTable.Rows[0];
        // var db_password = row["FPASSWORD"].ToString();
        // db_password = ProPass(db_password);
        // if (!pwd.Equals(db_password)) throw new Exception("用户名或者密码错误");
        //
        // return dataTable;
        return null;
    }

    public DataTable getUserMenu(string name)
    {
        // var sql = "";
        //
        // if ("PL017".Equals(name))
        //     sql = "select PAGE_VIEW,PATH,ICOIMG from  MES_SYS_PAGEVIEW";
        // else
        //     sql = string.Format(@"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 = '{0}')
        //                   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 = '{0}'))
        //             group by PATH, PAGE_VIEW, ICOIMG", name);
        //
        // return SQLHelper.ExecuteQuery(sql);
        return null;
    }

    public int resetPassword(string newPwd, string name, string pwd)
    {
        // login(name, pwd);
        // var passwordHash = encryptPass(newPwd);
        // var sql = string.Format(
        //     @"update SYS_USER set FPASSWORD = '{0}' where FCODE = '{1}'",
        //     passwordHash,
        //     name);
        // return SQLHelper.ExecuteNonQuery(sql);
        return 0;
    }

    //解密
    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;
    }
}