public void doWorkInit(HashMap map) throws Exception {
        super.doWorkDefault(map,this);
        this.moveRecord("init", XLet.getString(map.get("#link_edit_initValue")));

		//加入功能按鍵,
		XButton btnOutInvoice = this.getButton("printInvoice"," 列印發票 ", "exePrintInvoice",null, "view");//"view"表示在查詢狀態才enable
        xlay.setLocationAdd(btnOutInvoice, xlay.left+xlay.getTipLabelWidth(), 5);
        XButton btnInvoiceEdit = this.getButton("linkInvoiceEdit"," 發票編輯 ", "doLinkInvoiceEdit",null, "view");
        xlay.addComH(btnOutInvoice,btnInvoiceEdit, "3c","");//距 列印發票 鍵,3個字寬 

        //..............中間程式省略
    }


    //==========================================================================
    //列印發票 
    public void exePrintInvoice() throws Exception {
        //加入功能程式
    }

    //==========================================================================
    //發票編輯 
    public void doLinkInvoiceEdit() throws Exception {
        //加入功能程式
    }

x.add2(rs,1,"D",".郵遞區號編輯","edit.CmzZipCode",1,"edit_1",2,"newimp");

public class CmzZipCode extends XFrameEditI {

    public CmzZipCode() throws Exception {
        this.isVoidWorkMode=true;
        this.isUnvoidWorkMode=true;
        this.convLangTables = "cmzZipCode,x";
        this.filterList = uiFilter("filter");
        this.serviceClassId = "edit.CmzZipCode";
		//this.importRefreFields = "deparId"; //匯入時要參照欄位,
        //this.adjustImportData = new com.dasam.work.XMethod(this,"exeAdjustImportData",null);
    }

    //==========================================================================
    public void doWorkInit(HashMap map) throws Exception {
        super.doWorkDefault(map,this);
        this.moveRecord("init", XLet.getString(map.get("#link_edit_initValue")));

		//editor layout
        //"主碼"
        XEText eId = new XEText(tbl("id"),10,this,"id");
        xlay.add(eId,0,0);
        eId.setFindRecord(this);
        //資料視窗
        XButton2 btnView = XTool.getViewButton("CmzZipCodeView",eId,this,"id", xwbar.getButton("first"));
        xlay.addComH(eId,btnView,1,0);
        editMap.put(btnView,"view");

        //"名稱"
        XEText eName = new XEText(tbl("name"),20,this,"name");
        xlay.add(eName,0,0);

        //"備註"
        XEText eMemo = new XEText(tbl("memo"),20,this,"memo");
        xlay.add(eMemo,0,0);

        this.addEditStateLabel("v",0,0,0);

        this.viewPack();
        setWorkObjectValue(DATA_RS);
        setWorkObjectEditStatus("view");
    }

    
	//==========================================================================
	//加入"匯入"的按鍵
	public HashMap getWorkBarMap() throws Exception {
		if (!this.isPassCtrl("newimp")) return super.getWorkBarMap();//無新增匯入權限,
		return XTool.getImportWorkBarMap(super.getWorkBarMap());//加入 '匯入',
	}

    //==========================================================================
    //excel匯入調整,
    /*public void exeAdjustImportData(boolean isData, XRowSet rs, org.apache.poi.hssf.usermodel.HSSFRow row) throws Exception {
        if (isData){
        	//id, excel第1欄
            Object id = XExport.getCellValue(row.getCell(row.getFirstCellNum()));
            rs.setObject("id",id);
            //name, excel第2欄
            Object name = XExport.getCellValue(row.getCell((short)(row.getFirstCellNum()+1)));
            rs.setObject("name",name);
        }
    }*/
    
}

x.add2(rs,1,"E",".會員郵寄標籤","rpt.CmzMemberMailLabel",1,"report_3",3,null);
x.add2(rs,1,"F",".郵遞區號速查","edit.CmzZipCodeList",1,"list_1",0,"field_cfg",1);//加這行
x.addLine(rs,1);

# edit.CmzZipCodeList 
edit.CmzZipCodeList.filter = [@edit.CmzZipCode.filter]

   public CmzZipCodeList()  throws Exception {
		//frame設定
        this.convLangTables = "cmzZipCode,x";
        this.filterList = uiFilter("filter");
		this.serviceClassId = "edit.CmzZipCodeList";
		//this.setPageRecord(15);
        this.fieldStyle = "{id=wd:10c;ha:c}{name=wd:15c}{memo=wd:15c}{creater=wd:10c}{createTime=wd:15c;ha:c}{updater=wd:10c}{updateTime=wd:15c;ha:c}";
		this.defaultFieldList = "id,name,memo,creater,createTime,updater,updateTime";
        this.fieldList = com.dasam.client.gui.XDlgFieldCfg.getFieldList(getClassFileName(), fieldStyle, defaultFieldList);
		this.linkEditClassId = "edit.CmzZipCode";
        this.isReturnNullClear = true;
    }

	//==========================================================================
	//重載,起始
	public void doWorkInit(HashMap map) throws Exception {
        map.put("xwbar.icon.width","30"); //加大icon
        super.doWorkDefault(map,this); 
		this.viewPack();
	}

    //==========================================================================
    //資料顯示前加工,
    public void doAdjustReturnRs(XRowSet rs) throws Exception {
    	rs.getField("creater").setLangName("建檔人");//欄名
    	//rs.printData(); //debug
    }
    
}

public class CmzZipCodeList extends XServiceListI {


    //==========================================================================
    public HashMap doWorkInit(HashMap map) throws Exception {
        setXUserInformationObject(map, true); //建立user

        setLastUpdateTime(map); //設定查詢筆數參數
        setPageRecord(map); //頁筆數
        this.viewTableName = "cmzZipCode";
        //查詢時用到的參數設定
        if (filterString==null) filterString = XLet.getString(map.get("filter"));
        this.viewSelect = "select a.*  from cmzZipCode a  ";
        this.viewIdField = "id";

        HashMap ret = defaultFunctions(map);
        return ret;
    }

}

        x.setExtendId(data, new String[]{
            "edit.OutStk", //加入出單重載
            "edit.Item",
            "edit.Member",
        }, "_2");

alter table `outStk` add `recName` varchar(50) not null default ''; --收件人
alter table `outStk` add `recTel` varchar(50) not null default ''; --收件人電話
alter table `outStk` add `recMobile` varchar(50) not null default ''; --收件人行動電話
alter table `outStk` add `recAddr` varchar(100) not null default ''; --收件人地址

#出貨單-----------------
outStk.recName = 收件人
outStk.recTel = 電話
outStk.recMobile = 手機
outStk.recAddr = 收貨地

public class OutStk_2 extends OutStk {

    public OutStk_2() throws Exception {
        if (isOutStk){
        	//加入搜尋條件,可以省略
    		this.filterList += ";收件人,a.recName,1;收件地址,a.recAddr,1";
    	}
    }

    //==========================================================================
    //overload客制化,
    public void doAdjustLayout(com.dasam.java.XTabbedPane xtab) throws Exception {
    	if (!isOutStk) return; //退貨單不加
        //整個往下移欄位,
        xlay.moveY(this,"1.2h","memo,creater,createTime,updater,updateTime,subtotal_sum,discount,"
            +"tax,recable,disct,cancelNo,cancelOk,subtotalCost_sum,accDate,itemQty_sum,"
            +this.DETAIL_ITEM);
        xlay.innerHeight += xlay.CHAR_HEIGHT*1.2;

        //"收件人"
        XEText recName = new XEText(tbl("recName"),8,this,"recName");
        xlay.addV(getXEdit("hrId"),recName,0,0);
        //"收件人電話"
        XEText recTel = new XEText(tbl("recTel"),10,this,"recTel");
        xlay.addH(recName,recTel,"-1c","0");
        //"收件人行動電話"
        XEText recMobile = new XEText(tbl("recMobile"),10,this,"recMobile");
        xlay.addH(recTel,recMobile,"-1c","0");
        //"收件人地址"
        XEText recAddr = new XEText(tbl("recAddr"),25,this,"recAddr");
        xlay.addH(recMobile,recAddr,"-1c","0");

        //編輯順序
        this.insertFocusList("outOrderId","recName,recTel,recMobile,recAddr");
    }

}

        x.setExtendId(data, new String[]{
            "rpt.OutStkSign",    //加入這一行,重載原程式設定
            "edit.Item",
            "edit.Member",
        }, "_2");

public class OutStkSign_2 extends OutStkSign {


    public OutStkSign_2() throws Exception {
        this.reportFormats = new String[]{"標準樣式","","客制樣式","_2"};
        this.serviceClassId = "rpt.OutStkSign_2";
    }

    //==========================================================================
    //<重載>
    public void doWorkInit(HashMap map) throws Exception {
        super.doWorkInit(map);
        getXEdit("reportFormats").setStatic(true);
    }

    //==========================================================================
    public void doMakeReportExtParam() throws Exception {
        super.doMakeReportExtParam();
        if (isOutStk){//改變子報表名稱,只有出貨單,
            String fmt = getXEdit("reportFormats").getValue().toString();
            addReportExtParam("#subreport",  "sys.OutStkDetail2"+fmt); //subreport檔名,
        }
    }

    //==========================================================================
    //報表資料加工,
    public void doAdjustReportRs(XProgressWork xpw, XRowSet rs, HashMap rptParam) throws Exception {
        super.doAdjustReportRs(xpw, rs, rptParam);
        //2009.10.20改為只有在客制樣式時.
        if (this.getReportFormatEditor().getSelectedIndex()==0) return;
        rs.getField("tsDate").setLen(100);
        for (rs.beforeFirst(); rs.next();){
            XRowSet d = rs.getRs("detail_item");
            //明細自動補足7的倍數.
            int ar = d.getRowCount() % 7;
            if (ar>0){ ar=7-ar; for(int i=0; i<ar; i++) d.insertRow(); }
            //加入明細備註
            d.insertField(new XField("cmzMemo",XField.TYPE_STRING,100)); 
            String[] m = XLet.getStringArray(rs.getString("memo"),12);
            for (int i=0; i><m.length; i++) if (d.setRowIndex(i)) d.setString("cmzMemo",m[i]);
            //加入判斷是否結束欄位
            d.insertField(new XField("isEnding",XField.TYPE_STRING,5));
            d.last();
            d.setString("isEnding","1");//不為null表示為ending,
            //日期字串轉換
            String[] dt = rs.getString("tsDate").split("[-]");
            rs.setString("tsDate", dt[0]+" 年 "+dt[1]+" 月 "+dt[2]+" 日");
        }
        //表尾條文轉為字串,
        com.dasam.work.XArrayReport xa = (com.dasam.work.XArrayReport)rptParam.get("ending");
        rptParam.put("ending",xa.getDataString());
        //加入logo圖形
        byte[] logo = com.dasam.work.XFio.readData(XSystem.getSysResource(XSystem.getResourceName("res/logo/logo.jpg")).openStream());
        rptParam.put("logo_img", logo);
    }

}

public class OutStkSign_2 extends OutStkSign {

    public OutStkSign_2(){
        this.adjustMainField = ",d.unitTitle 'cust_unitTitle'";
        this.adjustDetailField = ",b.specif 'itemSpec'";
    }
}

x.add2(rs,1,"A",".產品組合單建立","edit.CmzBomItem",1,"edit_2",2,null);

--** BOM筆狀態
insert ignore bjn_tableState values('cmzBomItem',0,0,0,''); --bom結構

--** BOM結構
create table if not exists `cmzBomItem` (
	`id` varchar(30) not null default '', --商品主碼
	`memo` varchar(250) not null default '', --備註
	`swDel` tinyint unsigned not null default 0, --作廢, 1=yes,

	`creater` varchar(20) not null default '', --建立人員
	`createTime` datetime not null default '0-0-0', --建立時間
	`updater` varchar(20) not null default '', --修改人員
	`updateTime` datetime not null default '0-0-0', --修改時間

	primary key (id)
) type=InnoDB ;

--** 結構明細
create table if not exists `cmzBomItemDetail` (
	`rela` varchar (30) not null default '', --相關欄,
	`no` smallint unsigned not null default 0, --序號,
	`itemId` varchar (30) not null default '', --商品主碼
	`qty` decimal(9,4) not null default 0, --組合數量

	primary key (rela,no),
	index `ix_itemId` (itemId)
) type=InnoDB;

public class CmzBomItem extends XFrameEditII {

    public CmzBomItem() throws Exception {
        this.convLangTables = "cmzBomItem,x";
        this.filterList = null;
        this.serviceClassId = "edit.CmzBomItem";
        this.itemReferId = "simpleItem";
        this.idField = "id";
        this.editFirstFieldName = null;
        this.editObjectDisable = null;
        this.displayInsertMsg = null;
        this.isCloseTimeWorkMode = false;
        this.isVoidWorkMode = false;
	}

    //==========================================================================
    public void doWorkInit(HashMap map) throws Exception {
		map.put("xwbar.icon.width","32"); //icon size
        super.doWorkDefault(map,this);

        this.moveRecord("init", XLet.getString(map.get("#link_edit_initValue")));

        //layout editor
        XEText eId = new XEText(tbl("id"),15,this,"id");
        xlay.add(eId,0,0);
        eId.setFindRecord(this);
        this.doReference(eId, "cmzBomItem","item_name,name,item_unit,unit");
        //視窗
        XButton2 btnView = XTool.getViewButton("CmzBomItemView",eId,this,"id", xwbar.getButton("first"));
        xlay.addComH(eId,btnView,1,0);
        editMap.put(btnView,"view");
        //商品視窗,
        XButton2 btnItemView = XTool.getViewButton("ItemView",eId,editMap,"id,id,item_name,name,item_unit,unit");
        xlay.addComH(btnView,btnItemView,5,0);
        editMap.put(btnItemView, "new,newas");

        //品名
        XEText eItemName = XEText.createLabelText(null,25,this,"item_name",0,0);
        xlay.addComV(eId,eItemName,0,0);
        //單位
        XEText eItemUnit = XEText.createLabelText(null,6,this,"item_unit",0,0);
        xlay.addComH(eItemName,eItemUnit,5,0);

        //detail
        XEGrid eDetail = getDetailGrid(DETAIL_ITEM);
        xlay.add(eDetail,0,0,0,5);
        //"備註"
        XEText eMemo = new XEText(tbl("memo"),40,this,"memo");
        xlay.add(eMemo,0,0);


        this.addEditStateLabel("v",0,0,0);

        this.viewPack();
        setWorkObjectValue(DATA_RS);
        setWorkObjectEditStatus("view");

    }

    //==========================================================================
    //新筆,資料起始,"new","newas"
    public void setNewRecordData(String workId) throws Exception {
        if (workId.equals("newas")){
            getXEdit(idField).setValue("");
        }
    }

    //==========================================================================
    //相關欄位參照驗証檢查,主要針對"save_edit","save_new","save_newas"
    public boolean isValidateData(String workId) throws Exception{
        if (XLet.isFindId("save_edit,save_new,save_newas",workId)){
            //參照驗証,
            if (!isValidateText("x2,cmzBomItem","id,e,r")) return false;
            //grid驗証,
            if (!((XEGrid)getXEdit(DETAIL_ITEM)).isCheckValidCount("itemId")) return false;
            if (!((XEGrid)getXEdit(DETAIL_ITEM)).isCheckReference("itemId")) return false;
            //檢查子商品內是否有父商品,(只檢查第一階,多階檢查在server端)
            XRowSet rs = ((XEGrid)getXEdit(DETAIL_ITEM)).getGridRowSet("itemId");
            if (rs.isFindRow("itemId", getXEdit("id").getValue().toString().trim())){
                xmsg.err("組合子產品中包含了主產品!","");
                return false;
            }
        }
        return true;
    }

    //======================================================================
    //明細grid,
    public XEGrid getDetailGrid(String fieldName) throws Exception {
        //取得rs表結構,
        XRowSet rs = new XRowSet((HashMap)mainRs.getObject(DETAIL_ITEM));
        //column
        XEGridColumn[] cols = new XEGridColumn[]{
            new XEGridColumn(tbl("itemId"), new XEText(rs.getField("itemId")),14,0),//"品 碼"
            new XEGridColumn(tbl2("itemName"), null, rs.getField("itemName"),24,0), //"品 名"
            new XEGridColumn(tbl("qty"), new XEText(rs.getField("qty")),8,0),//"數量"
            new XEGridColumn(tbl("unit"), null, rs.getField("itemUnit"),6,0), //"單位"
        };
        //建立grid
        XEGrid g = new XEGrid("", cols, 10, 300, this, fieldName);
        g.setReturnFields("#itemId,qty");
        g.getColumn("itemId").setViewButton(XTool.getViewButton("ItemView",this,"exeDetailItemView",new Object[]{g,""}));
		((XEText)g.getColumn("itemId").editor).setLinkEditClassId("edit.Item");
        ((XEText)g.getColumn("qty").editor).setMinEditValue(new Integer(1));
		//開始建構grid
        g.makeWorking();

        g.addChangeValueAction(this,"exeDetailChangeValue",null);
        g.setLinkEditClassId("itemId;edit.Item");
		return g;
    }

    //==========================================================================
    //設定一筆資料,
    //isId : 是否設定主碼,
    //ixData : 目前編輯的row index
    public void setDetailItemData(XEGrid g, XRowSet rs, int ixData, boolean isId) throws Exception {
		if (isId) g.getColumn("itemId").setValue(ixData, rs==null? "" : rs.getString("id"));
        if (ixData==g.getDataIndex()) g.getColumn("itemId").editor.setReference(rs!=null); //要設定editor,否則setValue()時會重設setReference(),
        g.getColumn("itemId").setReference(ixData, rs!=null); //若有檢查要設定參照成功,
        g.getColumn("itemName").setValue(ixData, rs==null? "" : rs.getString("name"));
        g.getColumn("qty").setValue(ixData, rs==null? "" : "1");
        g.getColumn("itemUnit").setValue(ixData, rs==null? "" : rs.getString("unit"));
    }


}

public class CmzBomItem extends XServiceEditII {

    private static final String editDetailTableName = "cmzBomItemDetail";

    public CmzBomItem(){
        this.tableStateId = "cmzBomItem";
        this.editTableName = tableStateId;
        this.editIdField = "id";
        this.editSelect="select a.*, b.name 'item_name', b.unit 'item_unit' from cmzBomItem a   left join item b on b.id=a.id ";
        this.editSelectDetail="select a.itemId,a.qty, concat(if(b.swDel=1,'*',''),b.name) as 'itemName', b.unit 'itemUnit' from cmzBomItemDetail a  left join item b on b.id=a.itemId ";
        this.editProperty = "CLS_MAIN,id, CLS_MUSTX,updateTime"; //必要上傳欄位,
        //個別設定
        this.setDeleteWorkMode(true); //用刪除,
        this.isCloseTimeWorkMode = false; //不使用結帳日,
        this.isAutoSortListNo = false; //新增時,不自排單碼
        this.editOrderBy="a.id"; //找資料排序碼,
    }

    //==========================================================================
    public HashMap doWorkInit(HashMap map) throws Exception {
        setXUserInformationObject(map, true); //建立user

        setLastUpdateTime(map);
        if (filterString==null) filterString = XLet.getString(map.get("filter"));

        HashMap ret = defaultFunctions(map);
        return ret;
    }

    //==========================================================================
    //只執行明細,main在XServiceEditII.insertRecord_detail()會處理
    //己有作trans的指令,
    public void insertRecord_detail(HashMap map, XRowSet rs) throws Exception {
        //detail
        XRowSet rs2 = new XRowSet((HashMap)rs.getObject(DETAIL_ITEM));
        String rela = rs.getString("id");
        String[] values = XSql.getValues(null,rs2,null,false,false,false); //讀取所有set組字串,

        for (int i=0; rs2.setRowIndex(i); i++){
			//新增一筆明細
			String fixValues = new StringBuffer("'").append(rela).append("',")//額外加入insert sql
				.append(i+1).toString();
			String insert = new StringBuffer("insert ").append(editDetailTableName).append(" ")
				.append( XSql.toInsert(values[i],"rela,no",fixValues) )
				.append(";").toString();
			xdb().exeSql(insert); //執行新增
        }

        //多階檢查子品中,是否包含子品,
        XRowSet bom = CmzBomLevelList.getBomData(xdb(),rela);
        if (XLet.getInt(bom.max("lvl"))>10) throwWorkException(">組合子產品超過了10個階層!");
        if (bom.isFindRow("itemId",rela)){//子產品中,找到有母品存在,
            int lvl = bom.getInt("lvl");
            String bomPath = rela;
            while(bom.previous()){
                //if (bom.getInt("lvl")<1) break;//為root階層,
                if (bom.getInt("lvl")<lvl){
                    lvl=bom.getInt("lvl");
                    bomPath = bom.getString("itemId")+"\n"+bomPath;//結構路徑
                }
            }
            bomPath = rela+"\n"+bomPath;
            throwWorkException(">組合子產品中包含了主產品! 結構:  \n"+bomPath);
        }
    }

    //==========================================================================
    //更新作業,
    public void updateRecord_detail_old(HashMap map, XRowSet rs) throws Exception {
        String idValue = rs.getString(editIdField);
        deleteRecord_detail(map, idValue); //做回帳,及刪除,
    }

    //--------------------------------------------------------------------------
    //新資料,直接用insert,
    public void updateRecord_detail_new(HashMap map, XRowSet rs) throws Exception {
        insertRecord_detail(map, rs);
    }

    //==========================================================================
    //會先回帳,再刪除,
    public void deleteRecord_detail(HashMap map, String idValue) throws Exception {
        voidRecord_detail(map, idValue);
        //刪除明細
        String sql = new StringBuffer("delete from ").append(editDetailTableName)
            .append(" where rela='").append(idValue).append("';").toString();
        xdb().exeSql(sql);
    }

    //==========================================================================
    //作廢明細筆. 主要是依idValue做明細筆的回帳,
    public void voidRecord_detail(HashMap map, String idValue) throws Exception {
    }


}

x.add2(rs,2,"B",".會員年費單列表","rpt.CmzMemberYearFeeList",1,"report_1",3,null);

public class CmzMemberYearFeeList extends XFrameReport {


    public CmzMemberYearFeeList() throws Exception {
        //this.langTableId = "rpt";
        this.convLangTables = "cmzMemberYearFee,member,x";
        this.serviceClassId = "rpt.CmzMemberYearFeeList";
        //this.isViewDebug = true;
    }

    //==========================================================================
    //重載,起始
    public void doWorkInit(HashMap map) throws Exception {
        super.doWorkDefault(map,this);

        //編輯項目
        this.addXETextRange("年度",6,"tsYear",DATE_Y,20,true,"time",null);
        XLib.memberId(this,true,"會員");
        XLib.sw(this,true,"狀態","swState","swState.def","{def=255}{left=2}{right=2}");

        setOtherFilterBegin();//----------
		XLib.tsDate(this,true,"收款日");
        XLib.swDel(this,true);
		setOtherFilterEnd();//----------

        addEndingAndFormats();
        this.viewPack();
        this.doWorkBarAction("init");

    }

    //==========================================================================
    //組合報表的條件式文字,
    public void doMakeReportExtParam() throws Exception {
        this.addReportExtParam("filter1", getFilters("@tsYear, &&, @memberId"));
        this.addReportExtParam("filter2", getFilters("@tsDate, &&, swState"));
        this.addReportExtParam("filter3", getFilters("&&, swDel"));
    }

    //==========================================================================
    //報表資料加工,
    public void doAdjustReportRs(XProgressWork xpw, XRowSet rs, HashMap rptParam) throws Exception {
        HashMap state = this.tblMap("swState.def");
        //加入主表欄位,
        rs.insertField(new XField("state_txt", XField.TYPE_STRING,50));
        rs.insertField(new XField("del_txt", XField.TYPE_STRING,50));
        for (int i=0; rs.setRowIndex(i); i++){
            rs.setObject("state_txt", state.get(rs.getString("swState"))); //狀態,
            rs.setString("del_txt", rs.getBoolean("swDel")?"**":""); //作廢文字
        }
        //rs.printData();
    }

}

public class CmzMemberYearFeeList extends XServiceReport {

    //==========================================================================
    //make,
    public HashMap makeReport(HashMap map) throws Exception {
        XRowSet rs = XRowSet.getRowSet(map);
        String where = XSql.getWhere(rs,"a.tsYear=@, a.memberId=@, a.recDate:tsDate=@, a.swState==, a.swDel==");
        String sql = new StringBuffer()
            .append("select a.id, a.tsYear, a.memberId, a.money, a.swState, a.recDate, a.swDel, b.name 'member_name' ")
            .append("from cmzMemberYearFee a ")
            .append("left join member b on b.id=a.memberId ")
            .append(where).toString();
        xdb().exeSql(sql);
        return this.getReturnMapReport(rs);
    }

}

x.add2(rs,1,"D",".郵遞區號編輯","edit.CmzZipCode",1,"edit_1",2,null);

insert ignore bjn_tableState values('cmzZipCode',0,0,0,'');

create table if not exists `cmzZipCode` (
	`id` varchar(10) not null default '',
	`name` varchar(50) not null default '', --簡稱
	`memo` varchar(100) not null default '', --備註
	`swDel` tinyint unsigned not null default 0, --作廢, 1=yes,

	`creater` varchar(20) not null default '', --建立人員
	`createTime` datetime not null default '0-0-0', --建立時間
	`updater` varchar(20) not null default '', --修改人員
	`updateTime` datetime not null default '0-0-0', --修改時間

    primary key (id)
) type=InnoDB ;

#============ cmz_table.ppt ============
#區碼-----------------
cmzZipCode.id = 區碼 || 区码
cmzZipCode.name = 名稱

#============ cmz_ui.ppt ============
#----------- edit.CmzZipCode ------------
edit.CmzZipCode.filter = a.id,1;a.name,1;[@x.memo,tbl],a.memo,1;[@x.swDel,tbl],a.swDel,2
# edit.CmzZipCodeView 
edit.CmzZipCodeView.title = [@XTool.view_button.CmzZipCodeView,cls]
edit.CmzZipCodeView.filter = [@edit.CmzZipCode.filter]

#============ cmz_xclass.ppt ============
XTool.view_button.CmzZipCodeView = 郵遞區號資料視窗 || 邮递区号资料视窗

public class CmzZipCodeView extends com.dasam.client.gui.XDlgView {

    public CmzZipCodeView()  throws Exception {
        this.convLangTables = "cmzZipCode";
        this.setTitle(ui("title"));
        this.filterList = uiFilter("filter");
        this.serviceClassId = "edit.CmzZipCodeView";
        this.fieldStyle = "{id=wd:80;ha:c}{name=wd:220}";
        this.fieldList = "id,name";
    }

}

public class CmzZipCodeView extends XServiceListI {

    public HashMap doWorkInit(HashMap map) throws Exception {
        setXUserInformationObject(map, true); //建立user
        setLastUpdateTime(map);
        setPageRecord(map); //頁筆數
        this.tableStateId = "cmzZipCode";
        this.viewTableName = tableStateId;
        if (filterString==null) filterString = XLet.getString(map.get("filter"));
        this.viewSelect = "select a.id, concat(if(swDel=1,'*',''),name) as 'name', swDel from cmzZipCode a ";

        return defaultFunctions(map);
    }

}

public class CmzZipCode extends XFrameEditI {

    public CmzZipCode() throws Exception {
        this.isVoidWorkMode=true;
        this.isUnvoidWorkMode=true;
        this.convLangTables = "cmzZipCode,x";
        this.filterList = uiFilter("filter");
        this.serviceClassId = "edit.CmzZipCode";
    }

    public void doWorkInit(HashMap map) throws Exception {
        super.doWorkDefault(map,this);
        this.moveRecord("init", XLet.getString(map.get("#link_edit_initValue")));

		//editor layout
        //"主碼"
        XEText eId = new XEText(tbl("id"),10,this,"id");
        xlay.add(eId,0,0);
        eId.setFindRecord(this);
        //資料視窗
        XButton2 btnView = XTool.getViewButton("CmzZipCodeView",eId,this,"id", xwbar.getButton("first"));
        xlay.addComH(eId,btnView,1,0);
        editMap.put(btnView,"view");

        //"名稱"
        XEText eName = new XEText(tbl("name"),20,this,"name");
        xlay.add(eName,0,0);

        //"備註"
        XEText eMemo = new XEText(tbl("memo"),20,this,"memo");
        xlay.add(eMemo,0,0);

        this.addEditStateLabel("v",0,0,0);

        this.viewPack();
        setWorkObjectValue(DATA_RS);
        setWorkObjectEditStatus("view");
    }

}

public class CmzZipCode extends XServiceEditI {

    public HashMap doWorkInit(HashMap map) throws Exception {
        setXUserInformationObject(map, true); //建立user
        setLastUpdateTime(map);
        this.tableStateId = "cmzZipCode";
        this.editTableName = tableStateId;
        this.setDeleteWorkMode(false); //設定使用作廢方式,
        this.isUnvoidWorkMode=true; //設定可使用回復作廢方式,
		if (filterString==null) filterString = XLet.getString(map.get("filter"));
        this.editSelect="select * from cmzZipCode a ";

        HashMap ret = defaultFunctions(map);
        return ret;
    }

}

package com.dasam.e3010001.client;

import com.dasam.work.XRowSet;
import com.dasam.work.XLet;
import com.dasam.client.menu.XMenuAdd;
import com.dasam.client.XSystem;


public class SystemDataCmz {


    //--------------------------------------------------------------------------
    //data : 原menu資料,要預防原系統的class id名稱,
    //insPoint : menu內定統一要加入的點,也可以自己設定,內定:"_window"
    public static XRowSet addMenuData(XRowSet data, String insPoint) throws Exception {
        XMenuAdd x = new XMenuAdd();
        XRowSet rs = x.createRsMenu();//開空menu

        //加入menu,名稱前加".",表示不轉語系,
        x.add0(rs,"X",".客制","_XX",null);
            x.add2(rs,1,"A",".產品組合單建立","edit.CmzBomItem",1,"edit_2",2,null);
            x.add2(rs,1,"B",".產品多階展開表","rpt.CmzBomLevelList",1,"report_1",3,null);
            x.addLine(rs,1);
            x.add2(rs,1,"C",".取得主機時間","cmz_get_server_time",1,null,0,null);
            x.addLine(rs,1);
            x.add2(rs,1,"D",".郵遞區號編輯","edit.CmzZipCode",1,"edit_1",2,null);
            x.add2(rs,1,"E",".會員郵寄標籤","rpt.CmzMemberMailLabel",1,"report_3",3,null);
            x.addLine(rs,1);
            x.add1(rs,1,"Z",".會員年費管理","_X_Z",null);
                x.add2(rs,2,"A",".會員年費單編輯","edit.CmzMemberYearFee",1,"edit_1",2,null);
                x.add2(rs,2,"B",".會員年費單列表","rpt.CmzMemberYearFeeList",1,"report_1",3,null);

        //將結構加在'視窗'之前
        data = com.dasam.client.system.XSystemData.insertMenuData(data, rs, insPoint);

        //做原程式extends,
        //Item_2 --> Item == 商品加入組合頁簽
        //Member_2 --> Member == 會員加入郵遞區號
        x.setExtendId(data, new String[]{
            "edit.Item",
            "edit.Member",
        }, "_2");

        //刪除原系統menu
        //x.delete(data, "edit.OutStk");
        return data;
    }



    //--------------------------------------------------------------------------
    //執行授權的序號
    public static boolean isAuthorize() throws Exception {
        return true;
        //return XSystem.isPassSerial("01-001-0104,01-001-0105");
    }

}