新增資料速查程式

註冊時間: 2011-06-09 18:31:13 文章: 73 離線

資料速查是一個類似excel的格式查詢畫面,
直接點二下資料筆, 可以連結到編輯畫面, 我
們用SDK的示範項目 "郵遞區號資料", 來做說明.

A. 主選單項目
src/com/dasam/e3010001/client/SystemDataCmz.java, 新加入行2

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);

B. 設定條件欄位
resource/com/dasam/e3010001/client/res/lang/cmz_ui.ppt

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

C. Client程式
src/com/dasam/e3010001/client/edit/CmzZipCodeList.java

   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
    }
    
}

D. Server程式
src/com/dasam/e3010001/server/edit/CmzZipCodeList.java

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;
    }

}