yl
2024-01-18 8024ec8c0300dcffa0caf4e2a030e068a9051bc2
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()
                        }