正清和质量看板接口功能 修改存货查询功能

yl

2023-09-12 54cf93766639d96ed2bdd101440d2ce9f2538e7e

 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
@@ -43,9 +44,9 @@
                //search = search.Substring(3);//截取索引2后面的字符
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select A.right_code,A.right_name,B.prefix,B.filingdate,B.incbit  from TRight A
                var sql = @"select A.right_code,A.right_name,B.prefix,B.filingdate,B.incbit,A.Type  from TRight A
                     left join T_CodeRules B on A.right_code=B.rightcode
                     where A.Type='PC' and A.parent_id<>'0' and A.is_delete<>'1' " + search + "";
                     where  A.parent_id<>'0' and A.is_delete<>'1' and A.is_rcode<>'N' " + search + "";
                var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
                mes.code = "200";
                mes.Message = "查询成功!";
@@ -71,15 +72,25 @@
            var dynamicParams = new DynamicParameters();
            try
            {
                sql = @"select rightcode from  T_CodeRules  where rightcode=@rightcode";
                sql = @"select rightcode,value from  T_CodeRules  where rightcode=@rightcode";
                dynamicParams.Add("@rightcode", rightcode);
                var data = DapperHelper.selectdata(sql, dynamicParams);
                if (data.Rows.Count > 0)
                {
                    sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,lm_user=@lm_user,lm_date=@CreateDate where rightcode=@rightcode";
                    string value = data.Rows[0]["value"].ToString();
                    if (decimal.Parse(incbit) > value.Length) 
                    {
                       decimal cnum = decimal.Parse(incbit) - value.Length;
                        for (int i = 0; i < cnum; i++)
                        {
                            value = "0" + value;
                        }
                    }
                    sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,value=@value,lm_user=@lm_user,lm_date=@CreateDate where rightcode=@rightcode";
                    dynamicParams.Add("@prefix", prefix);
                    dynamicParams.Add("@filingdate", filingdate);
                    dynamicParams.Add("@incbit", incbit);
                    dynamicParams.Add("@value", value);
                    dynamicParams.Add("@lm_user", lm_user);
                    dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
                    dynamicParams.Add("@rightcode", rightcode);
@@ -153,6 +164,17 @@
            return mes;
        }
        #endregion



        #region[生成系统条码(自定义)]
        public static ToMessage LabelBarCode(string rightcode, string partcode, string qty, string onelabqty)
        {
            mes = AppLableBarCode.EncodingSeach(rightcode, partcode, qty, onelabqty);
            return mes;
        }
        #endregion



        #region[车间公告列表]
@@ -354,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
    }
}