分录中常用方法

//清空分录

kdtFenlu.removeRows();

// 为分录表格中必录项设置颜色

String[] columns = {"F1"};

for(int i = 0; i < columns.length; i++){

kdtEntry.getColumn(columns[i]).getStyleAttributes().setBackground(new Color(255, 255, 220));

}

//获取分录列名

String cellname = kdtEntrys.getHeadRow (0).qetCell (i) .getValue ().toString ();

String key = kdtEntrys.getColumnKey(j);

//设置表

// kdtEntry_detailPanel.setTitle("仓库列表");

// 隐藏分录右上角功能按钮（新增行、插入行、删除行）

KDWorkButton btnAddNew = kdtTest1_detailPanel.getAddNewLineButton();// 新增行

KDWorkButton btnInsert = kdtTest1_detailPanel.getInsertLineButton();// 插入行

KDWorkButton btnRemove = kdtTest1_detailPanel.getRemoveLinesButton();// 删除行

// 设置按钮不可见

btnAddNew.setVisible(false);

btnInsert.setVisible(false);

btnRemove.setVisible(false);

//增加分录行问题

IRow row = null;

int i = 0;

if (kdtEntry.getRowCount() > i) {

row = kdtEntry.getRow(i);

} else {

row = kdtEntry.addRow();

}

//清除分录

kdtEntry.removeRows();

//分录的控制

kdtEntry.getColumn("unit").getStyleAttributes().setHided(true);//隐藏列

kdtEntry.getColumn("unit").getStyleAttributes().setLocked(true);//锁定列使其不可被编辑

kdtEntry.getColumn("unit").getStyleAttributes().setLocked(true);//锁定单元格

//分录判断是否为空

if(this.kdtTest1.getRowCount()<1){

MsgBox.showInfo("请至少添加一条分录！");

return true;

//MsgBox.showWarning("请至少添加一条分录！");  

//SysUtil.abort(); (程序停止)

}else{

for(int i=0;i<kdttest1.getrowcount();i++){< div="" style="">

if(kdtTest1.getCell(i, "testxiangmu").getValue()==null){

MsgBox.showInfo("分录中，第" + (i + 1) + "行中的检验项目必须填写！");

return true;

}

if(kdtTest1.getCell(i, "cankao").getValue()==null){

MsgBox.showInfo("分录中，第" + (i + 1) + "行中的参考标准必须填写！");

return true;

}

if(kdtTest1.getCell(i, "morenzhi").getValue()==null){

MsgBox.showInfo("分录中，第" + (i + 1) + "行中的默认值必须填写！");

return true;

}

}

}

//分录中校验保存数据是否重复（用Map的Key值唯一性，将字段拼接，然后做比较）

Mapmap = new HashMap();

for(int f =0;f<kdtfenlu.getrowcount();f++){< div="" style="">

String str =kdtFenlu.getCell(f, "bianma").getValue()+"_"+kdtFenlu.getCell(f, "name").getValue()+"_"+kdtFenlu.getCell(f, "zubie").getValue();

if(!map.containsKey(str)){

map.put(str, 1);

}else {

MsgBox.showInfo("保存的类型重复");

return true;

}

}

/**

* 设置分录监听（这里应该加到onload方法，在打开时调用）

*/

kdtEntry.addKDTEditListener(new KDTEditAdapter() {

@Override

public void editStopped(KDTEditEvent e) {

try {

onelist(e);

} catch (BOSException e1) {

e1.printStackTrace();

} catch (SQLException e1) {

e1.printStackTrace();

}

}

});

/**

* 分录监听（这个放在外面就好）

*/

public void onelist(KDTEditEvent e) throws BOSException, SQLException {

int rowIndex = e.getRowIndex();

int colIndex = e.getColIndex();

if (colIndex == kdtEntry.getColumnIndex("XXX")) {

if (kdtEntry.getCell(rowIndex, kdtEntry.getColumnIndex("XXX")).getValue() != null

&& !"".equals(kdtEntry.getCell(rowIndex,kdtEntry.getColumnIndex("XXX")).getValue())) {

CostCenterOrgUnitInfo costCenterOrgUnitInfo = (CostCenterOrgUnitInfo) kdtEntry.getCell(rowIndex, "department").getValue();

StorageOrgUnitInfo Storageinfo = (StorageOrgUnitInfo) this.prmtstorageunit.getValue();

String fid = null;

String sql = "XXX";

IRowSet rs = com.kingdee.bos.dao.query.SQLExecutorFactory.getRemoteInstance(sql).executeSQL();

while(rs.next()){

fid = rs.getString(1);

}

}

}

}

/**

* 分录三个小按钮事件（新增分录时，默认赋值）

*/

//新增分录监听器

IDetailPanelListener Entry_detailPanelAddListener=null;

//插入分录监听器

IDetailPanelListener Entry_detailPanelInsertListener=null;

//删除分录监听器

IDetailPanelListener Entry_detailPanelRemoveListener=null;

protected void kdtEntrySetValue(){

//添加新增事件

if(Entry_detailPanelAddListener==null){

Entry_detailPanelAddListener = new IDetailPanelListener(){

//点击事件之前

public void afterEvent(DetailPanelEvent e) throws Exception {

//加需求

}

//点击事件之后

public void beforeEvent(DetailPanelEvent e) throws Exception {

}

};

}

//添加插入事件

if(Entry_detailPanelInsertListener==null){

Entry_detailPanelInsertListener = new IDetailPanelListener(){

public void afterEvent(DetailPanelEvent e) throws Exception {

//加需求

}

public void beforeEvent(DetailPanelEvent e) throws Exception {

//加需求

}

};

}

//添加删除事件

if(Entry_detailPanelRemoveListener==null){

Entry_detailPanelRemoveListener = new IDetailPanelListener(){

public void afterEvent(DetailPanelEvent e) throws Exception {

//加需求

}

public void beforeEvent(DetailPanelEvent e) throws Exception {

//加需求

}

};

}

//添加监听器方法

kdtTest1_detailPanel.addAddListener(Entry_detailPanelAddListener);

kdtTest1_detailPanel.addInsertListener(Entry_detailPanelInsertListener);

kdtTest1_detailPanel.addRemoveListener(Entry_detailPanelRemoveListener);

}

/**

* 获取分录1t列所有行的申请金额汇总

*/

public double getEntryApplyAmountSum(String t){

double amountSum = 0 ;

int count = this.kdtEntry.getRowCount();

for (int i = 0; i < count; i++) {

IRow row = this.kdtEntry.getRow(i);

if(row.getCell(t).getValue()!=null){

amountSum = amountSum +Double.valueOf(row.getCell(t).getValue().toString());

}

}

return amountSum;

}

/**

* 分录的单位和数量转换处理

*/

public double onepanduanidea() {

double amountSum = 0;

int count = this.kdtEntry.getRowCount();

for (int i = 0; i < count; i++) {

IRow row = this.kdtEntry.getRow(i);

if (row.getCell("Qty").getValue() != null && row.getCell("Unit").getValue() != null) {

MeasureUnitInfo t1 = (MeasureUnitInfo) kdtEntry.getCell(i,"Unit").getValue();

String t2 = t1.getCoefficient().toString();

double oneide = Double.valueOf(t2);

amountSum = amountSum + Double.valueOf(row.getCell("Qty").getValue().toString()) * oneide;

}

}

return amountSum;

}

/**

* 合计行

*/

protected void setTableToSumField() {

setTableToSumField(kdtEntry, new String[] { "qty","lossqty" });

IRow footRow = null;

KDTFootManager footManager = kdtEntry.getFootManager();

if (footManager == null) {

footManager = new KDTFootManager(kdtEntry);

footManager.addFootView();

kdtEntry.setFootManager(footManager);

}

// 计算所有指定行的合计值

footRow = footManager.getFootRow(0);

if (footRow == null) {

footRow = footManager.addFootRow(0);

}

footRow.getCell("storage").setValue("合计");

}

//List界面中，点击某一行中的某个单元格，弹出对应单据

@Override

protected void tblMain_tableClicked(KDTMouseEvent e) throws Exception {

super.tblMain_tableClicked(e);

//单击“结果”那一列时

if (e.getColIndex() == 6) {

//取到储存单据ID列的值

String boID = tblMain.getRow(e.getRowIndex()).getCell(9).getValue().toString();

//弹出对应单据

MessageServiceProvider.showWFBill(this, boID.toString());

//com.kingdee.eas.util.client.MsgBox.showInfo(boID);

}

if (e.getColIndex() == 1) {

int[] selectedRows = com.kingdee.bos.ctrl.kdf.table.util.KDTableUtil.getSelectedRows(tblMain);

int rowindex = selectedRows[0];

String bianma = tblMain.getCell(rowindex, 1).getValue().toString();//物料编码

String jieguo = tblMain.getCell(rowindex, 6).getValue().toString();

UIContext map = new com.kingdee.eas.common.client.UIContext(this);

map.put("bianma", bianma);//订单编号

map.put("jieguo", jieguo);

IUIWindow uiWindow = null;

uiWindow = UIFactory.createUIFactory(UIFactoryName.NEWTAB)

.create(RequestFormEditUI.class.getName(), map, null, OprtState.ADDNEW);

uiWindow.show();

}

//隐藏单元格，第9列则取8；true为隐藏，false为显示。

this.tblMain.getColumn(9).getStyleAttributes().setHided(true);