1.App版本升级接口 2.模具清单新增、导入添加仓库、库位字段 3.MES工单查询增加明细id关联

yl

2024-01-12 0b26067b6cc5d531938fa79cb540a45e125261d2

 VueWebCoreApi/DLL/DAL/MouldManagerDAL.cs

@@ -102,7 +102,7 @@
        #endregion

        #region[模具清单新增编辑]
        public static ToMessage AddUpdateMouldManger(string mouldcode, string mouldname, string mouldspec, string surplife, string resilife, string status, string mouldpart, string opertype, User us)
        public static ToMessage AddUpdateMouldManger(string mouldcode, string mouldname, string mouldspec,string warehousecode,string location_code, string surplife, string resilife, string status, string mouldpart, string opertype, User us)
        {
            var sql = "";
            var dynamicParams = new DynamicParameters();
@@ -112,8 +112,8 @@
                if (opertype == "Add")
                {
                    //写入模具清单表                                     
                    sql = @"insert into TMouldInfo(code,name,spec,status,surp_life,resi_life,lm_user,lm_date) 
                               values(@code,@name,@spec,@status,@surp_life,@resi_life,@lm_user,@lm_date)";
                    sql = @"insert into TMouldInfo(code,name,spec,status,surp_life,resi_life,lm_user,lm_date,warehousecode,location_code) 
                               values(@code,@name,@spec,@status,@surp_life,@resi_life,@lm_user,@lm_date,@warehousecode,@location_code)";
                    list.Add(new
                    {
                        str = sql,
@@ -125,6 +125,8 @@
                            status = status,
                            surp_life = surplife,
                            resi_life = resilife,
                            warehousecode=warehousecode,
                            location_code=location_code,
                            lm_user = us.usercode,
                            lm_date = DateTime.Now.ToString()
                        }
@@ -169,7 +171,7 @@
                {
                    //修改模具清单表
                    sql = @"update TMouldInfo set name=@name,spec=@spec,status=@status,
                            surp_life=@surp_life,resi_life=@resi_life,lm_user=@lm_user,lm_date=@lm_date where code=@code";
                            surp_life=@surp_life,resi_life=@resi_life,lm_user=@lm_user,lm_date=@lm_date,warehousecode=@warehousecode,location_code=@location_code where code=@code";
                    list.Add(new
                    {
                        str = sql,
@@ -181,6 +183,8 @@
                            status = status,
                            surp_life = surplife,
                            resi_life = resilife,
                            warehousecode = warehousecode,
                            location_code = location_code,
                            lm_user = us.usercode,
                            lm_date = DateTime.Now.ToString()
                        }