From e2446696b08dff7dfe3df21c8a58acf768203287 Mon Sep 17 00:00:00 2001
From: zhaowc <526854230@qq.com>
Date: 星期五, 23 八月 2024 14:51:23 +0800
Subject: [PATCH] 角色权限页面修改
---
Wms/WMS.BLL/SysServer/MaterialsServer.cs | 12 +++++++-----
HTML/views/WareHouseSetting/Locate.html | 3 ++-
2 files changed, 9 insertions(+), 6 deletions(-)
diff --git a/HTML/views/WareHouseSetting/Locate.html b/HTML/views/WareHouseSetting/Locate.html
index 47e5016..9a63fb7 100644
--- a/HTML/views/WareHouseSetting/Locate.html
+++ b/HTML/views/WareHouseSetting/Locate.html
@@ -209,7 +209,8 @@
//鐩戝惉鎻愪氦
iframeWindow.layui.form.on('submit(' + submitID + ')', function (data) {
var field = data.field; //鑾峰彇鎻愪氦鐨勫瓧娈�
- console.log(field);
+ console.log("瑕佷慨鏀圭殑瀛楁锛�"+field);
+ console.log("瑕佷慨鏀圭殑瀛楁锛�" + field.Temp);
var msg = [];
for (var i = 0; i < checkData.length; i++) {
// msg.push(checkData[i].Id);
diff --git a/Wms/WMS.BLL/SysServer/MaterialsServer.cs b/Wms/WMS.BLL/SysServer/MaterialsServer.cs
index 7321b66..5554355 100644
--- a/Wms/WMS.BLL/SysServer/MaterialsServer.cs
+++ b/Wms/WMS.BLL/SysServer/MaterialsServer.cs
@@ -57,18 +57,20 @@
{
return Db.Queryable<SysMaterials>()
.LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id)
- .LeftJoin<SysPackag>((a, b,c) => a.PackagNo == c.PackagNo)
- //.Where((a,b,c) => c.IsDel == "0")
+ .LeftJoin<SysPackag>((a, b,c) => a.PackagNo == c.PackagNo)
+ .LeftJoin<SysUnit> ((a,b,c,d)=>a.UnitNo == d.UnitNo)
+ .LeftJoin<SysMaterialCategory>((a,b,c,d,e)=>a.CategoryNo == e.CategoryNo)
+ .Where((a,b,c,d,e) => d.IsDel == "0" && e.IsDel =="0")
.WhereIF(!string.IsNullOrEmpty(skuNo), a => a.SkuNo.Contains(skuNo))
- .WhereIF(!string.IsNullOrEmpty(skuName), a => a.SkuNo.Contains(skuName))
+ .WhereIF(!string.IsNullOrEmpty(skuName), a => a.SkuName.Contains(skuName))
.WhereIF(!string.IsNullOrEmpty(auditStatusNo), a => a.AuditStatusNo == auditStatusNo)
.WhereIF(!string.IsNullOrEmpty(type), a => a.Type == type)
.WhereIF(!string.IsNullOrEmpty(isControlled), a => a.IsControlled == isControlled)
.WhereIF(!string.IsNullOrEmpty(isInspect), a => a.IsInspect == isInspect)
.WhereIF(!string.IsNullOrEmpty(environment), a => a.Environment == environment)
.WhereIF(!string.IsNullOrEmpty(categoryNo), a => a.CategoryNo == categoryNo)
- .Where(a => a.IsDel == "0")
- .Select<MaterialsDto>((a, b, c) => new MaterialsDto() { CreateUserName = b.RealName,PackagName = c.PackagName }, true)
+ .Where(a => a.IsDel == "0" )
+ .Select<MaterialsDto>((a, b, c,d,e) => new MaterialsDto() { CreateUserName = b.RealName,PackagName = c.PackagName }, true)
.ToListAsync();
}
--
Gitblit v1.8.0