Exemplo n.º 1
0
 /// <summary>
 /// 查询入库任务
 /// </summary>
 public void QuereryIntoTask()
 {
     using (WMSAccess access = new WMSAccess())
     {
         try
         {
             List <WMSTask> wMSTasks = access.Select <WMSTask>();
         }
         catch (Exception ex)
         {
         }
     }
 }
Exemplo n.º 2
0
        public List <LocationMaterialInfo> GetStoreDetilyByStore(AreaType areaType, out int storeCout)
        {
            List <LocationMaterialInfo> info;

            //List<LocationMaterialInfo> temp;
            //List<List<LocationMaterialInfo>> tempst = new List<List<LocationMaterialInfo>>();
            using (WMSAccess access = new WMSAccess())
            {
                storeCout = (int)access.ExecuteScalar($"SELECT COUNT(*) FROM [StorageLocation] WHERE [StoreType] ={(int)areaType}");
                //temp = access.ExecuteSelect<LocationMaterialInfo>($"SELECT [LocationRow],[LocationColumn],[LocationLayer] FROM LocationMaterialInfo WHERE [StoreType] ={(int)areaType} GROUP BY [LocationRow], [LocationColumn], [LocationLayer] HAVING COUNT ( * ) >= 1");
                info = access.Select <LocationMaterialInfo>($"SELECT * FROM LocationMaterialInfo WHERE StoreType = {(int)areaType}");
            }
            //for (int i = 0; i < info.Count; i++)
            //{
            //    List<LocationMaterialInfo> temps = info.Where(o => o.LocationRow.Equals(temp[i].LocationRow) && o.LocationColumn.Equals(temp[i].LocationColumn)).ToList();
            //    tempst.Add(temps);
            //}
            return(info);
        }