|
发表于 2009-10-14 11:55:31
|
显示全部楼层
package nc.ui.shsh.refpub;
import nc.ui.bd.ref.AbstractRefModel;
/**
* 说明: 客户非树行参照
* 2007-12-29 下午04:17:13
*/
public class CustomerRefmodel extends AbstractRefModel {
public CustomerRefmodel() {
super();
}
public String[] getFieldCode() {
return new String[]{
"custcode","custname","linkman","address","pk_customer"
};
}
public String[] getFieldName() {
return new String[]{
"客户编号","客户名称","联系人","地址","pk"
};
}
public int getDefaultFieldCount() {
return 5;
}
public String getRefTitle() {
return "客户档案";
}
public String getTableName() {
return "shsh_customer";
}
public String getPkFieldCode() {
return "pk_customer";
}
public String getWherePart() { StringBuffer sb=new StringBuffer();
if(super.getWherePart()==null){
sb.append(" 1=1 ");
}else{
sb.append(super.getWherePart());
}
sb.append(" and isnull(dr,0)=0 ");
return sb.toString();
}
}
红的方法就是放SQL中的where后的语句 |
|