1.仓库、库位、存货新增加字段noid

yl

2024-12-03 84d11937e57ca3d73fa58e123b14de02ad8e8d4e

 VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs

@@ -2399,14 +2399,18 @@
                        mes.data = null;
                        return mes;
                    }
                    //获取主表最大ID
                    sql = @"select ISNULL(IDENT_CURRENT('TSecStck')+1,1) as id";
                    var dt = DapperHelper.selecttable(sql);
                    //写入仓库
                    sql = @"insert into TSecStck(code,name,status,ishasPosition,description,lm_user,lm_date,data_sources) 
                            values(@code,@name,@status,@ishasPosition,@description,@lm_user,@lm_date,@data_sources)";
                    sql = @"insert into TSecStck(noid,code,name,status,ishasPosition,description,lm_user,lm_date,data_sources) 
                            values(@noid,@code,@name,@status,@ishasPosition,@description,@lm_user,@lm_date,@data_sources)";
                    list.Add(new
                    {
                        str = sql,
                        parm = new
                        {
                            noid= int.Parse(dt.Rows[0]["ID"].ToString()),
                            code = stckcode,
                            name = stckname,
                            status = status,
@@ -2707,14 +2711,18 @@
                    {
                        parentlocacode = "";
                    }
                    //获取主表最大ID
                    sql = @"select ISNULL(IDENT_CURRENT('TSecLoca')+1,1) as id";
                    var dt = DapperHelper.selecttable(sql);
                    //写入仓位
                    sql = @"insert into TSecLoca(code,name,idwarehouse,idparent,status,description,lm_user,lm_date,data_sources,depth) 
                            values(@code,@name,@idwarehouse,@idparent,@status,@description,@lm_user,@lm_date,@data_sources,@depth)";
                    sql = @"insert into TSecLoca(noid,code,name,idwarehouse,idparent,status,description,lm_user,lm_date,data_sources,depth) 
                            values(@noid,@code,@name,@idwarehouse,@idparent,@status,@description,@lm_user,@lm_date,@data_sources,@depth)";
                    list.Add(new
                    {
                        str = sql,
                        parm = new
                        {
                            noid = int.Parse(dt.Rows[0]["ID"].ToString()),
                            code = locacode,
                            name = locaname,
                            idwarehouse = stckcode,