修改物料类别，调整物料信息页面

yuyou_x

2024-02-01 49b484da5f9d4cde8e47764891a5e112b2883e5d

 Wms/WMS.BLL/SysServer/MaterialCategoryServer.cs

@@ -60,7 +60,7 @@
                {
                    Id = a.Id,

                    CategoryNo = a.CategoryNo, //类别号
                    CategoryNo = a.CategoryNo, //类别编码
                    CategoryName = a.CategoryName, //类别名称

                    AreaNo = a.AreaNo, //区域号
@@ -215,7 +215,7 @@
                Db.BeginTran();
                SysMaterialCategory list = new SysMaterialCategory()
                {
                    CategoryNo = category.CategoryNo, //类别号
                    CategoryNo = category.CategoryNo, //类别编码
                    CategoryName = category.CategoryName, //类别名称

                    AreaNo = category.AreaNo, //区域编码
@@ -256,6 +256,8 @@
                string msg = "";
                //获取类别信息
                var categoryInfo = Db.Queryable<SysMaterialCategory>().First(a => a.IsDel == "0" && a.Id == category.Id);
                //获取类别对应物料信息
                var matelist = Db.Queryable<SysMaterials>().Where(a=>a.IsDel == "0" && a.CategoryNo == categoryInfo.CategoryNo).ToList();
                //获取区域信息
                var area = Db.Queryable<SysStorageArea>().First(a => category.AreaNo.Contains(a.AreaNo) && a.IsDel == "0");

@@ -265,16 +267,21 @@
                }

                Db.BeginTran();
                categoryInfo.CategoryNo = category.CategoryNo; //类别号
                categoryInfo.CategoryNo = category.CategoryNo; //类别编码
                categoryInfo.CategoryName = category.CategoryName; //类别名称
                categoryInfo.AreaNo = category.AreaNo; //区域编码
                categoryInfo.Demo = category.Demo; //备注
                categoryInfo.UpdateUser = category.CreateUser; //更改人
                categoryInfo.UpdateTime = Db.GetDate(); //更改时间


                Db.Updateable(categoryInfo).ExecuteCommand();

                foreach (var item in matelist)
                {
                    item.CategoryNo = categoryInfo.CategoryNo;
                }
                Db.Updateable(matelist).ExecuteCommand();

                Db.CommitTran();

                msg = "编辑类别信息成功！";