ERP订单查询，订单下达、订单关闭功能开发

yl

2022-06-28 fcca000072a8cfae98c1cb3dadce0512b19083cc

 VueWebApi/DLL/DAL/MaterialManagerDAL.cs

@@ -258,7 +258,7 @@
                }
                // --------------查询指定数据--------------
                var total = 0; //总条数
                var sql = @"select A.code,A.name,A.description,A.stock_code,B.name as stock_name,A.lm_user,A.lm_date  
                var sql = @"select A.id,A.code,A.name,A.description,A.stock_code,B.name as stock_name,A.lm_user,A.lm_date  
                            from T_Sec_Loca A
                            left join T_Sec_Stck B on A.stock_code=B.code
                            where A.is_delete<>'1' " + search;
@@ -288,7 +288,7 @@
                if (operType == "Add")
                {
                    var sql = @"insert into T_Sec_Loca(code,name,description,stock_code,lm_user,lm_date) 
                            values(@storagecode,@storagename,@description,@username,@CreateDate)";
                            values(@storagecode,@storagename,@description,@stockcode,@username,@CreateDate)";
                    dynamicParams.Add("@storagecode", storagecode);
                    dynamicParams.Add("@storagename", storagename);
                    dynamicParams.Add("@description", description);