出貨單編輯, 加入收件人,電話,地址欄位

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

一般在做網站訂單時, 常會有收件人的姓名, 電話, 行動,
收貨地址, 跟一般進銷存的出貨單不太一樣.

這裡用重載出貨單程式的方式加入這些欄位, 分成以下
的步驟來實作.

A. 主選單項目
src/com/dasam/e3010001/client/SystemDataCmz.java

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

B. 建立資料庫
resource/cmz.sql
加好後再用維護指令執行 database.update.cmz

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 ''; --收件人地址

C. 資料庫欄名中文對照
resource/com/dasam/e3010001/client/res/lang/cmz_table.ppt
加入以下欄名對照.

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

D. Client出貨單編輯重載
src/com/dasam/e3010001/client/edit/OutStk_2.java

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

}