项目进度安排
__mCHdzxPSr3xRUt77pss
__E3WK6Py3xPwqhKwYA5k
true
10
true
false
false
false
true
relatedForm
month
normal
false
0
__L3AxKthmClck5rrDsOk
false
__Bcwc9EwydGqmjEjslvw
public
0){
var whereStr=" where 1=1";
}else if(rtn>0){
var whereStr=" where a.item_projectleader like concat('%','"+getWebUser().getId()+"','%')";
}
if(isNotNull(projectName)){
whereStr+=" and a.item_projectname like concat('%','"+projectName+"','%')"
}
var sql="select a.domainid,"+
"a.ITEM_PROJECTNAME," + //项目名称
"a.ITEM_PROJECTLEADER," + //项目负责人
"a.ITEM_PROJECTTIME," + //立项时间
"a.ITEM_PROJECTTYPE," + //项目类型
"a.ITEM_CUSTOMERNAME," + //客户名称
"a.ITEM_CONTACTNAME," + //联系人姓名
"a.ITEM_CONTACTWAY," + //联系人方式
"a.ITEM_CONTRACTINFORMATION," + //合同信息
"a.ITEM_PROJECTBRIEF," + //项目简介
"a.ITEM_PROJECTADDRESS," + //项目地址
"a.ITEM_ANYBID," + //有无投标
"a.ITEM_ESTIMATEDCONTRACTAMOUNT," + //预计合同金额
"a.ITEM_CONTRACTITEMAMOUNT," + //项目合同金额
"a.ITEM_PLANSTARTTIME," + //计划开始时间
"a.ITEM_SCHEDULEDENDTIME," + //计划结束时间
"a.ITEM_PROJECTDATA," + //项目资料
"a.ITEM_PROJECTNUMBER," + //项目编号
"a.id"+
" from tlk_projectinformation a "+whereStr;
println("sql---------------:"+sql);
return sql;
})()]]>
[]
277
02
0
0