ldj/database/picklable.sql

<EFBFBD><EFBFBD>use dwms4;

	 SELECT top 1 1 FROM t_wmsOutPickLable_tmp 
	 select * from v_stockGoods  where goodsId ='G30JGSGEADZ' and batch='161101' ;

	 SELECT *  FROM [dwms4].[dbo].[t_wmsOutPickDetail] where pickOrderNo ='PICK050000025191' and goodsId ='G30F1R90GSZ' and batch='161208' ;
	 select * from t_wmsStockRecord where id = 42392

	 select * from t_wmsLocation where locationId = '2B1101-25' and  elabAddress =0 and volType =0 and elabId >0; 

	  SELECT count(*),elabId ,elabAddress FROM t_wmsOutPickLable_tmp group by elabId,elabAddress order by elabId;
	  SELECT * FROM t_wmsOutPickLable_tmp;
      
	  select pickOrderNo, elabId,elabAddress,count,color ,state from t_wmsOutPickLable_tmp where 1=1
	  --and  state = 0
	  order by pickOrderNo;


	  select elabId,elabAddress,count,color ,state from t_wmsOutPickLable_tmp where 1=1
	  --and  state = 0
	  order by elabId;


	  	  select count(*),elabId,elabAddress,color from t_wmsOutPickLable_tmp  group by elabId,elabAddress,color;
		   
		  
		  select * from t_node where parentid =136;


		    select count(*),elabId ,port from t_wmsOutPickLable_tmp  group by elabId,port;
	 ;

	   select * from t_wmsOutPickLable_tmp where elabId =5 order by elabaddress;



	   SELECT elabid as ele_lab_id,elabAddress as ele_address,port,count as pick_count,count - pickCount as send_count,
	    color ,color as ele_order  FROM [t_wmsOutPickLable_tmp] a  where  state =0 order by ele_order, color
                           

						 
      select * from v_stockOutPickDetailValidation where (   desk >0) and orderState <= 5