ERP BOS F7控件的多选
//先找到多选对应是F7控件，尔后将多选的属性选择这true
//定义一个数组用来装多选的值。
protected Object[] createDepArr;
*/
@Override
public void onLoad() throws Exception {
kDTable1.checkParsed();
kDTable1.removeRows();
kDDatePicker1.setDatePattern("yyyy-MM-dd HH:mm:ss");
kDDatePicker2.setDatePattern("yyyy-MM-dd HH:mm:ss");
Calendar cal = Calendar.getInstance();
cal.add(Calendar.DATE, -1);
String yesterday = new SimpleDateFormat( "yyyy-MM-dd ").format(cal.getTime());
SimpleDateFormat matter1 = new SimpleDateFormat("yyyy-MM-dd");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
kDDatePicker1.setValue(sdf.parse(yesterday+ " 07:00:00"));
//F7初始化
CostCenterF7 costCenterF7 = new CostCenterF7();
costCenterF7.setMultiSelect(true);
kDBizPromptBox1.setSelector(costCenterF7);//new CostCenterF7NoPerm()
//点击查询按钮
/**
* output actionbtn_actionPerformed
*/
public void actionbtn_actionPerformed(ActionEvent e) throws Exception
{
/**
* 点击查询
*/
if (UIRuleUtil.isNull(kDDatePicker1.getValue())|| UIRuleUtil.isNull(kDDatePicker2.getValue())) {
MsgBox.showInfo("时间范围选择不正确!必须开始时间与结束时间都选择");
onLoad();
}else{
//清空上次的数据
kDTable1.checkParsed();
kDTable1.removeRows();
//获取查询条件
str = kDDatePicker1.getText().replace("-", "").replace(":", "").replace(" ", "");
str1 = kDDatePicker2.getText().replace("-", "").replace(":", "").replace(" ", "");
//卸货网点
if (kDBizPromptBox1.getText()!=null) {
// Unloadingpoint=kDBizPromptBox1.getText();
//不为空则将F7选择的值赋给数组
createDepArr = (Object[]) kDBizPromptBox1.getValue();
}
//车牌号
if (kDBizPromptBox2.getText()!=null) {
Licenseplate=kDBizPromptBox2.getText();
}
getpd(str,str1,createDepArr,Licenseplate);
}
super.actionbtn_actionPerformed(e);
}
//卸货网点（查询sql）
if (kDBizPromptBox1.getValue()!=null) {
// sql.append("and T10.fname_l2='"+kDBizPromptBox1.getText()+"'").append("\n");
sql.append("and T10.fname_l2 IN ( ").append("\n");
getSqlAddIn(sql, converStringArr(createDepArr));
sql.append(") ").append("\n");
}
public static String[] converStringArr(Object[] arr) {
List<String> list = new ArrayList<String>();
for (Object obj : arr) {
if (obj instanceof DataBaseInfo) {
list.add(((DataBaseInfo) obj).getName().toString());
} else {
list.add(obj.toString());
}
}
return list.toArray(new String[] {});
}
public static void getSqlAddIn(StringBuffer sql, String... strArr) {
sql.append("'");
for (String string : strArr) {
sql.append(string);
sql.append("','");
}
sql.delete(sql.length() - 2, sql.length());
}