"".equals(groupby)){
throw new Exception("请在url后添加groupby参数，" +
"例如：?groupby=fruit");
}

StringBuffer maxSumParameter = new StringBuffer();
ViewBaseField field = null;
ViewDataset datasetResource = this.getDataset("datasetResource");
//@2. 获得需要分配的资源
DBStatement dbStmt = new DBStatement();
dbStmt.setDataSource("custom");
dbStmt.setSql("select * from mark_resource " +
"where groupby = :groupby order by orderby");
dbStmt.parameters().setString("groupby", groupby);
List result = dbStmt.queryForList();
dbStmt.close();
//@3. 为datasetResource添加字段
for(int i=0,size = result.size(); i<size; i++){
VariantSet vs = (VariantSet)result.get;
field = (ViewBaseField) datasetResource.
addField(vs.getString("id"));
field.setDataType("int");
field.setDefaultValue(0);
field.setLabel(vs.getString("title"));
maxSumParameter.append(field.getName() + ":" +
vs.getInt("total") + ";");
}
datasetResource.parameters().setString("$maxSumString",
maxSumParameter.toString());
}
}

"".equals(groupby)){
throw new Exception("请在url后添加groupby参数，" +
"例如：?groupby=fruit");
}

//@2. 向datasetResource中添加初始化的记录，并构造resourceRecordMap
DBStatement dbStmt = new DBStatement();
dbStmt.setDataSource("custom");
dbStmt.setSql(DBStatement.SELECT, "mark_people");
List peopleList = dbStmt.queryForList();
dbStmt.close();
Map resourceRecordMap = new HashMap(peopleList.size());
for(int i=0; i<peopleList.size(); i++){
VariantSet vs = (VariantSet)peopleList.get;
Record r = dataset.insertRecord();
r.setString("key",vs.getString("id"));
r.setString("name",vs.getString("name"));
r.setState(Record.STATE_NONE);
resourceRecordMap.put(vs.getString("id"), r);
}
dataset.moveFirst();

//@3. 为datasetResource填充真正的数据
dbStmt.setSql(DBStatement.SELECT, "mark_people_resource");
dbStmt.parameters().setString("groupby", groupby);
List peopleResourceList = dbStmt.queryForList();
dbStmt.close();
for(int i=0; i<peopleResourceList.size(); i++){
VariantSet vs = (VariantSet)peopleResourceList.get;
String peopleId = vs.getString("people");
Record resource = (Record)resourceRecordMap.get(peopleId);
if(null != resource){
resource.setInt(vs.getString("resource"), 1);
resource.setState(Record.STATE_NONE);
}
}
}
}

sum===null){return;}
var resultSum = 0;
switch(value){
case "0":
Base.setFieldSum(null, field, parseInt(sum)-1);
break;
case "1":
resultSum = parseInt(sum)+1;
if(resultSum > parseInt(field.maxSum)){
return new DoradoException("已经达到了最大数量，不能再分配了");
}else{
Base.setFieldSum(null, field, resultSum);
}
break;
default:
alert("other.value = " + value);
}
}

fieldName=="name"){continue;}
field.maxSum = getFieldMaxSum(field.getName());
}
}
/**
* 给dataset添加约束
* @param Dataset dataset
* @param Record record
* @param Field field
* @param Any value
* 注:在dataset.beforeChange事件中调用的,仅仅用到了field和value参数
*/
Base.updateFieldSum = function(dataset, record, field, value){
var sum = field.sum;
if(sum===undefined

sum===null){return;}
var resultSum = 0;
switch(value){
case "0":
Base.setFieldSum(null, field, parseInt(sum)-1);
break;
case "1":
resultSum = parseInt(sum)+1;
if(resultSum > parseInt(field.maxSum)){
return new DoradoException("已经达到了最大数量，不能再分配了");
}else{
Base.setFieldSum(null, field, resultSum);
}
break;
default:
alert("other.value = " + value);
}
}
/**
* 初始化datatable.column
* @param Dataset dataset
* @param DataTable datatable
* 注:根据dataset给datatable添加column,并设置column的相关属性和事件
*/
Base.initDatatableColumn = function(dataset,datatable){
var fieldCount = dataset.getFieldCount();
var field,column,fieldName;
for(var i=0; i<fieldCount; i++){
field = dataset.getField;
fieldName = field.getName();
switch(fieldName){
case "key":
break;
case "name":
EventManager.addDoradoEvent(datatable.getColumn("name"),"onFooterRefresh",
function(column, cell, value){
cell.innerHTML = "已分配/总量";
});
break;
default:
column = datatable.addColumn(fieldName);
column.setField(fieldName);
column.setRendererType("checkbox");
column.setAlign("center");
EventManager.addDoradoEvent(column, "onFooterRefresh", Base.drawFooter);
}
}
}

/**
* 设置field.sum
* @param Dataset dataset
* @param Field field
* @param int sum [optional]
* 注:如果sum没有值,则遍历dataset计算sum
*/
Base.setFieldSum = function(dataset, field, sum){
var fieldName = field.getName();
if(fieldName=="key"

fieldName=="name"){return;}
//@1. 如果参数sum没有值,表示需要进行初始化
if(sum===undefined

sum===null

sum === ""){
var resultSum = 0;
dataset.disableControls();
var record = dataset.getFirstRecord();
while(record){
resultSum += record.getValue(fieldName);
record = record.getNextRecord();
}
dataset.enableControls();
field["sum"] = resultSum;
}else{
//@2. 如果sum有值,直接赋值便可
field["sum"] = sum;
}
}
/**
* 获得field.sum
* @param Dataset dataset
* @param Field field
* @param int defaultSum [reserve]
* 注:默认返回0
*/
Base.getFieldSum = function(dataset, field, defaultSum){
var resultSum = field["sum"];
if(resultSum===undefined

resultSum===null

resultSum===""){return 0;}
else{return resultSum}
}


/**
* 画datatable.column.footer
* @param Column column
* @param HTMLelement cell
* @param Any value
* 注:在datatable.column.onFooterRefresh事件中使用
*/
Base.drawFooter = function(column, cell, value){
var field = baseDataset.getField(column.getField());
var footHtml ="<div style='width:100%;text-align:center'>"
+ Base.getFieldSum(baseDataset, field)
+ "/" + field.maxSum + "</div>";
cell.innerHTML = footHtml;
}


/**
* DataTable的变为编辑状态
* @param DataTable datatable
*/
Base.DataTabletoEditState = function (datatable){
var columnCount = datatable.getColumnCount();
var column;
for(var i=0; i<columnCount; i++){
column = datatable.getColumn;
if(column.getRendererType() == "checkbox"

column.getEditorType()=="checkbox"){
column.setRendererType("checkbox");
column.setEditorType();
}
}
datatable.rebuild();
datatable.refresh();
}
/**
* DataTable的变为只读状态
* @param DataTable datatable
*/
Base.DataTabletoReadState = function (datatable){
var columnCount = datatable.getColumnCount();
var column;
for(var i=0; i<columnCount; i++){
column = datatable.getColumn;
if(column.getRendererType() == "checkbox"

column.getEditorType()=="checkbox"){
column.setRendererType();
column.setEditorType("checkbox");
}
}
datatable.rebuild();
datatable.refresh();
}

"".equals(groupby)){
throw new Exception("请在url后添加groupby参数，例如：" +
"?groupby=fruit");
}
//@1. 删除旧的资源分配数据
DBStatement dbStmt = new DBStatement();
dbStmt.setDataSource("custom");
dbStmt.setSql(DBStatement.DELETE, "mark_people_resource");
dbStmt.parameters().setString("groupby", groupby);
dbStmt.execute();
dbStmt.close();

//@2. 持久化新的资源分配数据
RecordIterator ri = datasetResource.recordIterator();
FieldSet fs = datasetResource.fieldSet();
int fieldCount = fs.getCount();
while(ri.hasNext()){
Record r = ri.nextRecord();
for(int i=0; i<fieldCount; i++){
String fieldName = fs.getField.getName();
if(fieldName.equals("key")

fieldName.equals("name")){
continue;
}
String fieldValue = r.getString(fieldName);
if(Integer.parseInt(fieldValue)==1){
dbStmt.setSql(DBStatement.INSERT,
"mark_people_resource");
dbStmt.parameters().setString("people",
r.getString("key"));
dbStmt.parameters().setString("resource",
fieldName);
dbStmt.parameters().setString("groupby",
groupby);
dbStmt.execute();
}
}
}
dbStmt.close();
}