1.化成-导出化成计划：
	添加组装线（实际生产的）；



2.包装--实际欠缺订单查询；
{
	单独写一个，订单完成情况统计；
	1.CK、BT的订单，以跟单方式；
	2.SC的订单，累计显示；
}

3.MRP删除时，连带删除planing表


4.订单完成情况：
	记录号排序，欠订单（红色），SC市场订单用市场订单核算的方式；

5.市场订单，以后查询之前月份的订单{
	1.盘点的数据减掉；
	2.华南代工直接减的（建议做一笔负的订单：此方案可以解决代工难题）；
}




/**********************************************************/





update yy_sys_datapermission  a set a.columnnames='记录号,计划单号,需货期,数量,加酸日期,班次,工厂,组装生产线,生产线,化成线,计划数量,备注,NC成品编码,型号,正反装方式,端子型号,客户,焊接方式,产品图号,槽体标识,警示标识,容量,KVAH,极板型号,正极板（片/只）,负极板（片/只）,槽盖来源,电池槽,电池大盖,电池小盖,液孔塞,提手,提手用量,侧提手,侧提手用量,隔板类型,隔板规格,隔板片数（片/只）,垫片/鞍子规格,垫片/鞍子数量（片/只）,衬板规格,衬板数量（片/只）,电眼规格,电池形式,端子位置,主组装线,组装产能(只/班),滤气片型号,滤气片用量,电池重量,硫酸用量,图纸档案号,生产周期,成品习惯名称,无液习惯名称,副生产线,发放日期,附加1,隔板编码,隔板尺寸,袋式尺寸,隔板用量(M2),玻毡编码,玻毡尺寸,玻毡用量(M2),隔板高度,隔板宽度,玻毡宽度,U8成品编码,无液电池编码,湿荷电池编码,正极板编码,负极板编码,包封极组编码,包封极组型号,包封极组附加描述,消耗定额实施时间,铸焊铅用量(?/只),焊接合金数量(?/只),铸焊剂(g),铅箔纸（g）,硫酸（kg）,无水硫酸钠（kg）,纯水（kg）,电池化成耗电（KWh）,液孔塞1,铅圈铅用量(?/只),PE隔板规格,隔板用量,玻纤,玻纤用量,附加2,警示标示NC码,警示标识代码,警示标识习惯名称,警示标识定额,型号标识NC码,型号标识代码,型号标识习惯名称,型号标识定额,电眼标,防伪标,合格证,使用说明书NC码,使用说明书代码,激光代码标,槽体标示NC码,槽体标示代码,槽体标示条形码,槽体标示习惯名称,槽体标示定额,东风唯一侧标,槽NC编码,电池大盖NC编码,电池小盖NC编码,液孔塞NC码,液孔塞名称,提手NC码,提手名称,衬板NC码,衬板名称,电眼NC码,电眼名称,警示标识助记码,型号标识助记码,使用说明书助记码,槽体标示助记码,直极柱NC码,直极柱规格,直极柱图号,直极柱质量/个,偏极柱NC码,偏极柱图号,偏极柱质量/个,纸箱图号,纸箱名称,纸箱NC码,电池化成周期,电池静置周期,跟踪卡,色标'
    where a.pk_datapermission='402880f8337d0ae801337d2110061112';
update yy_sys_datapermission  a set a.fieldnames='recordcode,plancode,needdate,num,addaciddate,divisions,factory,zzmadeline,madeline,hcline,plnum,vemo,ncfprocode,invtype,pntype,terminaltype,customer,weldingway,proimgcode,tublogo,warningmark,capacity,kvah,platetype,pplatenum,nplatenum,slotcoversource,batterytank,batterybigcover,batterysmallcover,liquidholeplug,handle,handledosage,sidehandle,sidehandledosage,clapboardtype,clapboardspec,clapboardnum,gasketsspec,gasketsnum,foilsspec,foilsnum,magiceyespec,batteryform,terminalposition,mainproductionline,assemblycapacity,gasfiltertype,gasfilterdosage,batteryweight,sulfuricaciddosage,drawingsfilescode,productioncycle,fprouname,noliquiduname,viceproductionline,issuingdate,additional1,clapboardcode,clapboardsize,bagsize,clapboarddosage,bofeltcode,bofeltsize,bofeltdosage,clapboardheight,clapboardwidth,bofeltwidth,u8fprocode,noliquidbatterycode,wetjosebatterycode,areplatecode,negativeplatecode,sea1deextremelygroupcode,sea1deextremelygroupspec,sea1deextremelygroupvemo,consumptionquotaimpltime,zhuhanleaddosage,weldingalloynum,castflux,leadfoil,sulfuricacid,withoutwatersodium,purewater,batterypowerconsumption,liquidholeplugdosage,leadlapleaddosage,peclapboardspec,clapboarddosage1,glassfiber,glassfiberdosage,additional2,warningsignnccode,warningsigncode,warningsignuname,warningsignquota,specsignnccode,specsigncode,specsignuname,specsignquota,magiceyesign,drinklabel,certificate,instructionnccode,instructioncode,lasercodelabel,tubsignnccode,tubsigncode,tubsignbarcode,tubsignuname,tubsignquota,dongfengonlysidemark,slotnccode,bigbatterycovernccode,smallbatterycovernccode,liquidholeplugnccode,liquidholeplugname,handlenccode,handlename,foilsnccode,foilsname,magiceyenccode,magiceyename,warningmarksmnecode,specsignmnecode,instructionmencode,tubsignmnecode,straightacolumnnccode,straightacolumnspec,straightacolumnimgcode,straightacolumnweight,partialextremelycolumnccode,partialextremelycolumnimgcode,partialextremelycolumnweight,cartonimgcode,cartonname,cartonnccode,batteryintocycle,batterystallingcycle,genzongka,colorcode'
     where a.pk_datapermission='402880f8337d0ae801337d2110061112';



2.权限
select t.*,t.rowid from yy_sys_permession t where t.type=0 and t.permessioncode like '1006%' order by t.permessioncode desc;

1	F3103A8A5EE74650ACAB8FD29D5229DE	订单完成情况查询	100622	402880ef31f968e50131f96c2ffb1009	生产计划/订单完成情况查询	2013-10-25 13:50:09	2	0	com.hb.applet.panels.plan.PlOrderFinishedPanel	AAASomAAEAAABnzAAE






化成计划导出：
分AB区；
备注、化成线->组装生产线；
成品客户-移到->无液客户后；








