其他出库增加库存

cdk

4 天以前 95584843043327d4fa12481f0cf3e6c0785fcc26

 service/base/LoginService.cs

@@ -2,24 +2,49 @@
using NewPdaSqlServer.DB;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.util;
using SqlSugar;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;

namespace NewPdaSqlServer.service.@base;

public class LoginService : RepositoryNoEntity
{
    public SysUser login(string name, string pwd)
    public dynamic login(string name, string pwd)
    {

        var strPass = UtilityHelper.MD5Encrypt32(pwd);
        var sysUser = Db.Queryable<SysUser>()
            .Where(s => s.Account == name
                        && s.Password == strPass).First();
        //var sysUser = Db.Queryable<SysUser>()
        //    .Where(s => s.Account == name
        //                && s.Password == strPass).First();

        if (sysUser == null) throw new Exception("用户不存在");

        var db_password = sysUser.Password;
        if (!strPass.Equals(db_password)) throw new Exception("用户名或者密码错误");

        return sysUser;

        var parameters = new[]
        {
        new SugarParameter("@pi_account", name),
        new SugarParameter("@pi_password", strPass),
        new SugarParameter("@inP1", null),
        new SugarParameter("@inP2", null),
        new SugarParameter("@inP3", null)
    };

        try
        {
            var sysUser = Db.Ado.SqlQuery<dynamic>("EXEC prc_pda_login_selUserOrgInfo @pi_account,@pi_password,@inP1,@inP2,@inP3", parameters).First();

            if (sysUser == null) throw new Exception("用户不存在");

            var db_password = sysUser.Password;
            if (!strPass.Equals(db_password)) throw new Exception("用户名或者密码错误");
            return sysUser;
        }
        catch (Exception ex)
        {
            // 保留原有异常处理逻辑
            throw new Exception($"{ex.Message}");
        }

    }

    public List<dynamic> getUserMenu(string name)
@@ -123,4 +148,34 @@
        //return sysUser;
        return null;
    }

    public dynamic changeOrg(dynamic query)
    {
        if (query == null) throw new ArgumentNullException(nameof(query), "参数对象不能为 null");

        if (string.IsNullOrEmpty(query.userName?.ToString()))
            throw new ArgumentException("用户名不允许为空", nameof(query.userName));

        var parameters = new[]
        {
        new SugarParameter("@pi_account", query.userName),
        new SugarParameter("@inP1", null),
        new SugarParameter("@inP2", null),
        new SugarParameter("@inP3", null)
        };

        try
        {
            var orgInfo = Db.Ado.SqlQuery<dynamic>("EXEC prc_pda_my_selOrgInfo @pi_account,@inP1,@inP2,@inP3", parameters);

            //if (sysUser.Count < 1) throw new Exception("用户不存在关联组织");
            return orgInfo;
        }
        catch (Exception ex)
        {
            // 保留原有异常处理逻辑
            throw new Exception($"{ex.Message}");
        }

    }
}