nothing

yl

2022-10-12 ba54e398d0fa596f6dc0604c53141bfc93cccf2c

nothing

 VueWebApi/Controllers/ProductModelController.cs

@@ -381,10 +381,10 @@
            string status = obj["status"].ToString();//启用状态
            string uomcode = obj["uomcode"].ToString(); //计量单位编码
            string quantity = obj["quantity"].ToString(); //基础数量
            string startdate = obj["startdate"].ToString(); //基础数量
            string version = obj["version"].ToString(); //基础数量
            string worklist = obj["worklist"].ToString(); //基础数量
            string opertype = obj["opertype"].ToString(); //基础数量
            string startdate = obj["startdate"].ToString(); //启用日期
            string version = obj["version"].ToString(); //版本号
            string worklist = obj["worklist"].ToString(); //提交数据
            string opertype = obj["opertype"].ToString(); //提交类型
            string username = HttpContext.Current.Request.Cookies["admin"].Value.ToString(); //操作人员
            List<BomSub> objs = Newtonsoft.Json.JsonConvert.DeserializeObject<List<BomSub>>(worklist);
            mes = ProductModelBLL.AddUpdateBoIventory(bomid,parentpartcode, parentpartname, parentpartspec, status, uomcode, quantity, startdate, version, username, opertype, objs);

 VueWebApi/DLL/DAL/ProductModelDAL.cs

@@ -925,8 +925,8 @@
                    string sql0 = @"select ISNULL(IDENT_CURRENT('TBom_Main')+1,1) as id";
                    var dt = DapperHelper.selecttable(sql0);
                    //写入BOM主表
                    sql = @"insert into TBom_Main(materiel_code,quantity,status,version,lm_user,lm_date) 
                            values(@materiel_code,@quantity,@status,@version,@username,@CreateDate)";
                    sql = @"insert into TBom_Main(materiel_code,quantity,status,version,lm_user,lm_date,startdate) 
                            values(@materiel_code,@quantity,@status,@version,@username,@CreateDate,@startdate)";
                    list.Add(new
                    {
                        str = sql,
@@ -937,7 +937,8 @@
                            status = status,
                            version = version,
                            username = username,
                            CreateDate = DateTime.Now.ToString()
                            CreateDate = DateTime.Now.ToString(),
                            startdate= startdate
                        }
                    });
                    //写入BOM子表
@@ -1058,6 +1059,18 @@
            var dynamicParams = new DynamicParameters();
            try
            {
                //判断物料类型是否有关联物料
                sql = @"select materiel_code from TK_Wrk_Man   where materiel_code in (select materiel_code from TBom_Main  where id=@bomid ) and bom_id=@bomid";
                dynamicParams.Add("@bomid", bomid);
                var data0 = DapperHelper.selectdata(sql, dynamicParams);
                if (data0.Rows.Count > 0)
                {
                    mes.code = "300";
                    mes.count = 0;
                    mes.Message = "当前物料清单已被工单关联使用,不允许修改!";
                    mes.data = null;
                    return mes;
                }
                //获取Bom子表数据
                sql = @"select A.seq,B.partcode,B.partname,B.partspec,B.uom_code,T.name as uom_name,
                         A.base_quantity,A.loss_quantity,A.total_quantity,A.pn_type