1.select t.*,t.rowid from yy_sys_permession t where t.type=0 and t.permessioncode like '100604%' order by t.permessioncode;
	23	BA6825CEFCF448E580A9C1DF333C3E9C	缺料提示	100604	402880ef31f968e50131f96c2ffb1009	生产计划/缺料提示	2012-02-28 10:00:00	2	0		AAAU8LAAEAAAD/pAAM
	24	2FED2046A45A4233A394FF1CF37C4DF9	组装欠缺	10060401	BA6825CEFCF448E580A9C1DF333C3E9C	生产计划/缺料提示/欠组装	2012-08-23 11:50:00	3	0	com.hb.applet.panels.PlWarnZzPanel	AAAU8LAAEAAAD/pAAL
	25	A867FB231E3748EDAB99957F8E6455D8	极板欠缺	10060402	BA6825CEFCF448E580A9C1DF333C3E9C	生产计划/缺料提示/缺极板	2012-08-24 11:50:00	3	0	com.hb.applet.panels.PlWarnPlatePanel	AAAU8LAAEAAAD/pAAK

2.select t.*,t.rowid from yy_sys_datapermission t where t.datapermissioncode in('10060202','10060302');
	1	402880f8337d0ae801337d2110060802	10060202	市场订单_查询表	com.hb.applet.panels.PlMarketOrderPanel	tableData	"记录号,计划单号,成品电池编码,焊接方式,无液电池编码,需货期,客户,电池型号,数量,正反装,端头,生产线,班定额,极板型号,正极板数量,负极板数量,成品习惯名称,无液习惯名称,KVAH,生产周期,正极板编码,负极板编码,已加酸电池编码,电池静置时间,纸箱NC码,备注,添加时间	recordcode,plancode,ncfprocode,weldingway,noliquidbatterycode,needdate,customer,invtype,num,pntype,terminaltype,mainproductionline,assemblycapacity,platetype,pplatenums,nplatenums,fprouname,noliquiduname,kvahs,productioncycle,areplatecode,negativeplatecode,wetjosebatterycode,batterystallingcycle,cartonnccode,vemo,createtime					2012-03-02 16:25:06	0	0	100	AAAU8EAAGAACe1xAAC
	2	402880f8337d0ae801337d2110060702	10060302	订单汇总_查询表	com.hb.applet.panels.PlOrderCollePanel	tableData	记录号,计划单号,成品电池编码,焊接方式,无液电池编码,需货期,客户,电池型号,数量,正反装,端头,生产线,班定额,极板型号,正极板数量,负极板数量,成品习惯名称,无液习惯名称,KVAH,生产周期,正极板编码,负极板编码,已加酸电池编码,电池静置时间,纸箱NC码,订单托盘号,码盘只数,添加时间	recordcode,plancode,ncfprocode,weldingway,noliquidbatterycode,needdate,customer,invtype,num,pntype,terminaltype,mainproductionline,assemblycapacity,platetype,pplatenums,nplatenums,fprouname,noliquiduname,kvahs,productioncycle,areplatecode,negativeplatecode,wetjosebatterycode,batterystallingcycle,cartonnccode,palletno,palletcapacity,createtime					2012-03-02 16:25:06	0	0	100	AAAU8EAAGAACe1yAAB
	

3.
-- Add/modify columns 
alter table YY_PL_ORDERCOLLECTION add effzznum_ NUMBER(18,4);
alter table YY_PL_ORDERCOLLECTION add zznum_ NUMBER(18,4);
-- Add comments to the columns 
comment on column YY_PL_ORDERCOLLECTION.effzznum_
  is '有效组装数量';
comment on column YY_PL_ORDERCOLLECTION.zznum_
  is '组装数量';

4.yy_pl_plateio_temp

5.struts-nzw.xml
  applicationContext-nzw.xml
  
 

  
  






