物流检验记录接口修改 末道工序完工报工自动关单方法开发 登录登出记录接口修改(去掉update,保留insert)

yl

2023-05-08 dac60fce253e085b3c4f4ee049a795f16aed2eba

 VueWebApi/DLL/DAL/LoginDAL.cs

@@ -47,54 +47,25 @@
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"select * from  T_Bas_Login  where usercode=@usercode and  origin=@usertype";
                sql = @"insert into T_Bas_Login(usercode,status,indate,origin) 
                            values(@usercode,'Y',@indate,@usertype)";
                dynamicParams.Add("@usercode", usercode);
                dynamicParams.Add("@usertype", usertype);
                cont = DapperHelper.selectcount(sql, dynamicParams);
                dynamicParams.Add("@indate", DateTime.Now.ToString());
                cont = DapperHelper.SQL(sql, dynamicParams);
                if (cont > 0)
                {
                    sql = @"update T_Bas_Login set indate=@indate,status='Y'  where usercode=@usercode and origin=@usertype";
                    dynamicParams.Add("@usercode", usercode);
                    dynamicParams.Add("@usertype", usertype);
                    dynamicParams.Add("@indate", DateTime.Now.ToString());
                    cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "记录成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "记录失败!";
                        mes.data = null;
                    }
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "记录成功!";
                    mes.data = null;
                }
                else
                {
                    sql = @"insert into T_Bas_Login(usercode,status,indate,origin) 
                            values(@usercode,'Y',@indate,@usertype)";
                    dynamicParams.Add("@usercode", usercode);
                    dynamicParams.Add("@usertype", usertype);
                    dynamicParams.Add("@indate", DateTime.Now.ToString());
                    cont = DapperHelper.SQL(sql, dynamicParams);
                    if (cont > 0)
                    {
                        mes.code = "200";
                        mes.count = 0;
                        mes.Message = "记录成功!";
                        mes.data = null;
                    }
                    else
                    {
                        mes.code = "300";
                        mes.count = 0;
                        mes.Message = "记录失败!";
                        mes.data = null;
                    }
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "记录失败!";
                    mes.data = null;
                }
            }
            catch (Exception e)
@@ -293,7 +264,7 @@

            //重置密码
            sql = @"update [dbo].[TUser] set password=@newpassword where usercode=@usercode and username=@username";
            list.Add(new { str = sql, parm = new { usercode = usercode, username = username,newpassword ="123456" } });
            list.Add(new { str = sql, parm = new { usercode = usercode, username = username, newpassword = "123456" } });
            //写入操作记录表
            sql = @"insert into T_Bas_User_Operlog(usercode,oper_date,oper_type,description,origin) values(@usercode,@oper_date,@oper_type,@description,@origin)";
            list.Add(new
@@ -337,10 +308,11 @@
            RedisHelper redis = new RedisHelper();
            try
            {
                sql = @"update T_Bas_Login set outdate=@outdate,status='N'  where usercode=@usercode and origin=@usertype";
                sql = @"insert into T_Bas_Login(usercode,status,outdate,origin) 
                            values(@usercode,'N',@outdate,@usertype)";
                dynamicParams.Add("@usercode", usercode);
                dynamicParams.Add("@outdate", DateTime.Now.ToString());
                dynamicParams.Add("@usertype", usertype);
                dynamicParams.Add("@outdate", DateTime.Now.ToString());
                cont = DapperHelper.SQL(sql, dynamicParams);
                if (cont > 0)
                {
@@ -378,10 +350,11 @@
            RedisHelper redis = new RedisHelper();
            try
            {
                sql = @"update T_Bas_Login set outdate=@outdate,status='N'  where usercode=@usercode and origin=@usertype";
                sql = @"insert into T_Bas_Login(usercode,status,outdate,origin) 
                            values(@usercode,'N',@outdate,@usertype)";
                dynamicParams.Add("@usercode", usercode);
                dynamicParams.Add("@outdate", DateTime.Now.ToString());
                dynamicParams.Add("@usertype", usertype);
                dynamicParams.Add("@outdate", DateTime.Now.ToString());
                cont = DapperHelper.SQL(sql, dynamicParams);
                if (cont > 0)
                {