正清河 仓库看板、车间综合看板接口

yl

2023-09-13 d11b595b22ae25e49e24f298ba2ca58528bda532

 VueWebApi/DLL/DAL/LoginDAL.cs

@@ -28,7 +28,9 @@
        {

            //执行sql
            strProcName = "select *  from [dbo].[TUser] where usercode=@username and password=@password and is_delete='0'";
            strProcName = @"select *  from TUser U
                            left join TOrganization T on U.stu_torgcode = T.org_code
                            where U.usercode =@username and U.password =@password and U.is_delete = '0'";
            //创建参数
            listStr.Add(new SqlParameter("@username", username));
            listStr.Add(new SqlParameter("@password", password));
@@ -40,18 +42,19 @@
        #endregion

        #region [写入登录记录表]
        public static ToMessage LoginBas(string usercode, string usertype)
        public static ToMessage LoginBas(string usercode, string usertype,string stu_torgcode)
        {
            var sql = "";
            var cont = 0;
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"insert into T_Bas_Login(usercode,status,indate,origin) 
                            values(@usercode,'Y',@indate,@usertype)";
                sql = @"insert into T_Bas_Login(usercode,status,indate,origin,torg_code) 
                            values(@usercode,'Y',@indate,@usertype,@stu_torgcode)";
                dynamicParams.Add("@usercode", usercode);
                dynamicParams.Add("@usertype", usertype);
                dynamicParams.Add("@indate", DateTime.Now.ToString());
                dynamicParams.Add("@stu_torgcode", stu_torgcode);
                cont = DapperHelper.SQL(sql, dynamicParams);
                if (cont > 0)
                {
@@ -301,7 +304,7 @@
        #endregion

        #region[PC登出]
        public static ToMessage LoginOut(int userid, string usercode, string username, string usertype)
        public static ToMessage LoginOut(int userid, string usercode, string username, string usertype,string stu_torgcode)
        {
            var sql = "";
            var cont = 0;
@@ -309,15 +312,16 @@
            RedisHelper redis = new RedisHelper();
            try
            {
                sql = @"insert into T_Bas_Login(usercode,status,outdate,origin) 
                            values(@usercode,'N',@outdate,@usertype)";
                sql = @"insert into T_Bas_Login(usercode,status,outdate,origin,torg_code) 
                            values(@usercode,'N',@outdate,@usertype,@stu_torgcode)";
                dynamicParams.Add("@usercode", usercode);
                dynamicParams.Add("@usertype", usertype);
                dynamicParams.Add("@outdate", DateTime.Now.ToString());
                dynamicParams.Add("@stu_torgcode", stu_torgcode);
                cont = DapperHelper.SQL(sql, dynamicParams);
                if (cont > 0)
                {
                    redis.Remove(Enterprise + "LoginUserID" + usertype + userid, 0); //删除redis
                    redis.Remove(Enterprise + stu_torgcode + "LoginUserID" + usertype + userid, 0); //删除redis
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "登出成功!";
@@ -343,7 +347,7 @@
        #endregion

        #region[App登出]
        public static ToMessage LoginAppOut(int userid, string usercode, string username, string usertype)
        public static ToMessage LoginAppOut(int userid, string usercode, string username, string usertype,string stu_torgcode)
        {
            var sql = "";
            var cont = 0;
@@ -351,15 +355,16 @@
            RedisHelper redis = new RedisHelper();
            try
            {
                sql = @"insert into T_Bas_Login(usercode,status,outdate,origin) 
                            values(@usercode,'N',@outdate,@usertype)";
                sql = @"insert into T_Bas_Login(usercode,status,outdate,origin,torg_code) 
                            values(@usercode,'N',@outdate,@usertype,@stu_torgcode)";
                dynamicParams.Add("@usercode", usercode);
                dynamicParams.Add("@usertype", usertype);
                dynamicParams.Add("@outdate", DateTime.Now.ToString());
                dynamicParams.Add("@stu_torgcode", stu_torgcode);
                cont = DapperHelper.SQL(sql, dynamicParams);
                if (cont > 0)
                {
                    redis.Remove(Enterprise + "LoginUserID" + usertype + userid, 1); //删除redis
                    redis.Remove(Enterprise + stu_torgcode + "LoginUserID" + usertype + userid, 1); //删除redis
                    mes.code = "200";
                    mes.count = 0;
                    mes.Message = "登出成功!";
@@ -385,12 +390,30 @@
        #endregion

        #region[App登录查询安灯呼叫信息]
        public static ToMessage LoginAppAnDonMessage(string rid, string usercode, string username, string usertype)
        public static ToMessage LoginAppAnDonMessage(string rid, string usercode, string username, string usertype,string stu_torgcode,string stu_torgtypecode)
        {
            var sql = "";
            string search = "";
            var dynamicParams = new DynamicParameters();
            try
            {
                switch (stu_torgtypecode)
                {
                    case "":
                        search += "and T.description=@description ";
                        dynamicParams.Add("@description", "W");
                        break;
                    case "D":
                        search += "and child.org_code=@stu_torgcode ";
                        dynamicParams.Add("@stu_torgcode", stu_torgcode);
                        break;
                    case "W":
                        search += "and T.org_code=@stu_torgcode ";
                        dynamicParams.Add("@stu_torgcode", stu_torgcode);
                        break;
                    default:
                        break;
                }
                sql = @"select B.eqp_code,E.name as eqp_name,B.wkshp_code,T.org_name as wkshp_name,
                        A.type as typecode,D.name as typename,B.start_user,B.start_date   
                        from TAnDnMessagePush A
@@ -399,7 +422,8 @@
                        left  join TOrganization T on B.wkshp_code=T.org_code 
                        left  join TAnDonType D on A.type=d.code
                        left  join TUser U on A.resp_user=U.usercode
                        where A.resp_user=@usercode and B.status='START' and U.rid=@rid  and T.description='W'";
                        left join TOrganization as child on T.parent_id=child.id 
                        where A.resp_user=@usercode and B.status='START' and U.rid=@rid "+search;
                dynamicParams.Add("@usercode", usercode);
                dynamicParams.Add("@rid", rid);
                var data = DapperHelper.selectdata(sql, dynamicParams);