修改车间看板判断条件

yl

2023-09-22 bd14d44a46cd191d0deb15b6f752f9477b818398

 VueWebApi/DLL/DAL/SystemSettingDAL.cs

@@ -5,6 +5,7 @@
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using VueWebApi.Models;
using VueWebApi.Tools;

namespace VueWebApi.DLL.DAL
@@ -375,5 +376,66 @@
            return mes;
        }
        #endregion


        #region[App版本升级接口]
        public static ToMessage AppUpgrade(string rid, string vision)
        {
            var sql = "";
            List<object> list = new List<object>();
            List<AppVersion> obj = new List<AppVersion>();
            var dynamicParams = new DynamicParameters();
            try
            {
                list.Clear();
                sql = @"select *   from TSystemAppUser where rid=@rid and appvesion=@vision";
                dynamicParams.Add("@rid", rid);
                dynamicParams.Add("@vision", vision);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count <= 0)  //不存在
                {
                    //写入本版用户关联表
                    sql = @"insert into  TSystemAppUser(rid,appvesion,lm_date) 
                                values(@rid,@appvesion,@lm_date)";
                    list.Add(new
                    {
                        str = sql,
                        parm = new
                        {
                            rid = rid,
                            appvesion = vision,
                            lm_date = DateTime.Now.ToString()
                        }
                    });
                    bool aa = DapperHelper.DoTransaction(list);
                    list.Clear();
                }
                //查询控制升级表版本数据
                sql = @"select *   from TSystemApp";
                var data1 = DapperHelper.selecttable(sql);
                AppVersion vn = new AppVersion();
                vn.path = data1.Rows[0]["path"].ToString();
                vn.version = data1.Rows[0]["version"].ToString();
                vn.dispyversion = vision;
                vn.activeversion = data1.Rows[0]["activeversion"].ToString();
                vn.mustupgrade = data1.Rows[0]["mustupgrade"].ToString();
                list.Add(vn);

                mes.code = "200";
                mes.count = 0;
                mes.Message = "查询成功!";
                mes.data = list;

            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.count = 0;
                mes.Message = e.Message;
                mes.data = null;
            }
            return mes;
        }
        #endregion
    }
}