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

yl

2024-12-03 84d11937e57ca3d73fa58e123b14de02ad8e8d4e

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

 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,

 VueWebCoreApi/DLL/DAL/ProductModelDAL.cs

@@ -841,16 +841,22 @@
                    //    mes.data = null;
                    //    return mes;
                    //}

                    //获取主表最大ID
                    sql = @"select ISNULL(IDENT_CURRENT('TMateriel_Info')+1,1) as id";
                    var dt = DapperHelper.selecttable(sql);

                    //写入存货分类
                    sql = @"insert into TMateriel_Info(partcode,partname,partspec,idunit,idunitgroup,isSingleUnit,idSubUnitByReport,idUnitByStock,idUnitByPurchase,idUnitBySale,idunitbymanufacture,
                    sql = @"insert into TMateriel_Info(noid,partcode,partname,partspec,idunit,idunitgroup,isSingleUnit,idSubUnitByReport,idUnitByStock,idUnitByPurchase,idUnitBySale,idunitbymanufacture,
                            idinventoryclass,isPurchase,isSale,isMadeSelf,isMaterial,isMadeRequest,idwarehouse,status,lm_user,lm_date,data_sources) 
                            values(@partcode,@partname,@partspec,@idunit,@idunitgroup,@isSingleUnit,@idSubUnitByReport,@idUnitByStock,@idUnitByPurchase,@idUnitBySale,@idunitbymanufacture,
                            values(@noid,@partcode,@partname,@partspec,@idunit,@idunitgroup,@isSingleUnit,@idSubUnitByReport,@idUnitByStock,@idUnitByPurchase,@idUnitBySale,@idunitbymanufacture,
                            @idinventoryclass,@isPurchase,@isSale,@isMadeSelf,@isMaterial,@isMadeRequest,@idwarehouse,@status,@lm_user,@lm_date,@data_sources)";
                    list.Add(new
                    {
                        str = sql,
                        parm = new
                        {
                            noid = int.Parse(dt.Rows[0]["ID"].ToString()),
                            partcode=partcode,
                            partname=partname,
                            partspec=partspec,

 VueWebCoreApi/appsettings.json

@@ -27,7 +27,7 @@
    //session失效时间
    "InProc": "240",
    //Excel导出模板配置IP
    "FileIP": "http://121.196.36.24:8019/",
    "FileIP": "http://121.196.36.24:8036/",
    //jwtkey
    "SigningKey": "Hello World"
  }