实体更新

Ben Lin

2024-06-11 483a3f07d02c44b21d1afc4244c7eb3c60da8788

 Tiger.Business/SYS/Biz.SYS_BS_LOGIN.cs

@@ -7,6 +7,7 @@
using System.Threading.Tasks;
using Rhea.Common;
using Tiger.IBusiness;
using Dm.filter.log;

namespace Tiger.Business
{
@@ -81,63 +82,73 @@
                {
                    if (user.STATUS_CODE == "ENABLE")
                    {
                        var org_code=Db.Queryable<V_USER_ORG>().Where(q=>q.USER_ID == userInfo.USER_CODE && q.ORG_CODE==userInfo.ORG_CODE).First();
                        if (org_code !=null)
                        var fty = userInfo.FTY_CODE ?? "QXXC";
                        MES_FACTORY _factory = Db.Queryable<MES_FACTORY>()
                                                .Where(x => x.FTY_CODE == fty)
                                                .ToList()[0];

                        SYS_BS_LOGIN logininfo = new SYS_BS_LOGIN
                        {
                            var fty = userInfo.FTY_CODE ?? "QXXC";
                            MES_FACTORY _factory = Db.Queryable<MES_FACTORY>()
                                                    .Where(x => x.FTY_CODE == fty)
                                                    .ToList()[0];

                            SYS_BS_LOGIN logininfo = new SYS_BS_LOGIN
                            {
                                USER_ID = user.USER_ID,
                                USER_NAME = user.USER_NAME,
                                LAST_ACCESS = DateTime.Now,
                                CREATE_TIME = DateTime.Now,
                                STATUS_CODE = user.STATUS_CODE,
                                CLIENT_IP = userInfo?.ip,
                                FTY_CODE = _factory.FTY_CODE,
                                FTY_NAME = _factory.FTY_NAME,
                                TOKEN = userInfo.Token ?? Guid.NewGuid().ToString("N"),
                                ID = Guid.NewGuid().ToString("N"),
                                ACCOUNT_TYPE = 0,
                                ORG_CODE = userInfo.ORG_CODE
                            };
                            LOG_BS_LOGIN loginlog = new()
                            {
                                //FACTORY = _factory.FTY_CODE,
                                USER_ID = user.USER_ID,
                                LOGIN_FROM = $"{userInfo?.ad_info?.nation}->{userInfo?.ad_info?.province}->{userInfo?.ad_info?.city};IP:{userInfo?.ip}",
                                LOGIN_TIME = DateTime.Now

                            };
                            //保存登录日志
                            var db = Business.Biz.Db;
                            var dbTran = db.UseTran(() =>
                            {
                                db.Insertable(loginlog).ExecuteCommand();

                                if (logininfo != null)
                                {
                                    var deres = db.Storageable(logininfo).ExecuteCommand();
                                }
                                res.Data = logininfo;
                            });
                            if (!dbTran.IsSuccess)
                            {
                                res.IsSuccessed = false;
                                res.Data = null;
                                res.LocaleMsg = L("SYS.Login.dbTranError");
                            }
                            res.Data = logininfo; 
                            USER_ID = user.USER_ID,
                            USER_NAME = user.USER_NAME,
                            LAST_ACCESS = DateTime.Now,
                            CREATE_TIME = DateTime.Now,
                            STATUS_CODE = user.STATUS_CODE,
                            CLIENT_IP = userInfo?.ip,
                            FTY_CODE = _factory.FTY_CODE,
                            FTY_NAME = _factory.FTY_NAME,
                            TOKEN = userInfo.Token ?? Guid.NewGuid().ToString("N"),
                            ID = Guid.NewGuid().ToString("N"),
                            ACCOUNT_TYPE = 0,
                            ORG_CODE = userInfo.ORG_CODE
                        };
                        var org_code=Db.Queryable<V_USER_ORG>().Where(q=>q.USER_ID == userInfo.USER_CODE && q.ORG_CODE==userInfo.ORG_CODE).First();
                        if (org_code != null)
                        {
                            logininfo.ORG_CODE = org_code.ORG_CODE;
                        }
                        else
                        {
                            var prod_code = Db.Queryable<V_USER_PROD>().Where(q => q.USER_ID == userInfo.USER_CODE && q.PROD_CODE == userInfo.PROD_CODE).First();
                            if (prod_code != null)
                            {
                                logininfo.FTY_CODE = prod_code.PROD_CODE;
                                logininfo.FTY_NAME = prod_code.PROD_NAME;
                            }
                            else
                            {
                                res.IsSuccessed = false;
                                res.Data = null;
                                res.LocaleMsg = L("SYS.Login.isNotOrgCode");//用户没有该据点的权限 }
                            }
                        }
                        LOG_BS_LOGIN loginlog = new()
                        {
                            //FACTORY = _factory.FTY_CODE,
                            USER_ID = user.USER_ID,
                            LOGIN_FROM = $"{userInfo?.ad_info?.nation}->{userInfo?.ad_info?.province}->{userInfo?.ad_info?.city};IP:{userInfo?.ip}",
                            LOGIN_TIME = DateTime.Now

                        };
                        //保存登录日志
                        var db = Business.Biz.Db;
                        var dbTran = db.UseTran(() =>
                        {
                            db.Insertable(loginlog).ExecuteCommand();

                            if (logininfo != null)
                            {
                                var deres = db.Storageable(logininfo).ExecuteCommand();
                            }
                            res.Data = logininfo;
                        });
                        if (!dbTran.IsSuccess)
                        {
                            res.IsSuccessed = false;
                            res.Data = null;
                            res.LocaleMsg = L("SYS.Login.isNotOrgCode");//用户没有该据点的权限
                            res.LocaleMsg = L("SYS.Login.dbTranError");
                        }
                        res.Data = logininfo;
                    }
                    else
                    {