public void execute(String action, Obationable o, RunData data, Object arg) throws Exception {
HttpServletRequest request = data.getRequest();
initQueryItem(data.getRequest());
QueryBasic queryBasic = fixedQuery;
queryBasic.setSearchValue(data.getRequest());
String SQL = ""; // queryBasic.getWhereQuery();
dwdm = request.getParameter("dwdm");
dwmc = request.getParameter("dwmc");
cpbm = request.getParameter("cpbm");
product = request.getParameter("product");
String dwtxid = request.getParameter("dwtxid");
String cpid = request.getParameter("cpid");
String zk$a = request.getParameter("zk$a");
String zk$b = request.getParameter("zk$b");
if (dwtxid.length() > 0) SQL = SQL + " AND a.dwtxid=" + dwtxid;
if (cpid.length() > 0) SQL = SQL + " AND a.cpid=" + cpid;
if (zk$a.length() > 0) SQL = SQL + " AND a.zk>=" + zk$a;
if (zk$b.length() > 0) SQL = SQL + " AND a.zk<=" + zk$b;
SQL =
combineSQL(
CUSTOMER_PRODUCT_DISCOUNT_SQL,
"?",
new String[] {fgsid, user.getHandleDeptValue(), SQL});
if (!dsxs_khcpzkTable.getQueryString().equals(SQL)) {
dsxs_khcpzkTable.setQueryString(SQL);
dsxs_khcpzkTable.setRowMax(null);
}
}
/**
* 初始化查询的各个列
*
* @param request web请求对象
*/
private void initQueryItem(HttpServletRequest request) {
if (isInitQuery) return;
EngineDataSet master = dsSaleOrderProduct;
// EngineDataSet detail = dsDetailTable;
if (!master.isOpen()) master.open();
// 初始化固定的查询项目
fixedQuery = new QueryFixedItem();
fixedQuery.addShowColumn(
"",
new QueryColumn[] {
new QueryColumn(master.getColumn("tdbh"), null, null, null, null, "="), // 提单编号
new QueryColumn(master.getColumn("dwtxid"), null, null, null, null, "="), // 购货单位
new QueryColumn(master.getColumn("sfrq"), null, null, null, "a", ">="), // 提单日期
new QueryColumn(master.getColumn("sfrq"), null, null, null, "b", "<="), // 提单日期
new QueryColumn(master.getColumn("deptid"), null, null, null, null, "=") // 部门id
});
isInitQuery = true;
}
/**
* 得到固定查询的用户输入的值
*
* @param col 查询项名称
* @return 用户输入的值
*/
public final String getFixedQueryValue(String col) {
return fixedQuery.getSearchRow().get(col);
}
public void execute(String action, Obationable o, RunData data, Object arg) throws Exception {
HttpServletRequest request = data.getRequest();
String nf = request.getParameter("nf");
String yf = request.getParameter("yf");
String dwtxid = request.getParameter("dwtxid");
String dwmc = request.getParameter("dwmc");
if (nf.equals("") || yf.equals("") || dwtxid.equals("")) {
data.setMessage(showJavaScript("alert('缺少查询条件!')"));
return;
}
Date stdate = new SimpleDateFormat("yyyy-MM-dd").parse(nf + "-" + yf + "-1"); // 当前月份第一天
Calendar calendar = new GregorianCalendar();
calendar.setTime(stdate);
int days = calendar.getActualMaximum(Calendar.DATE); // 当前月份的天数
engine.project.LookUp corpBean =
engine.project.LookupBeanFacade.getInstance(
request, engine.project.SysConstant.BEAN_CORP);
// corpBean.regConditionData("dwtxid",new String[]{dwtxid});
corpBean.regData(new String[] {dwtxid});
RowMap corprow = corpBean.getLookupRow(dwtxid);
String addr = corprow.get("addr");
String tel = corprow.get("tel");
String cz = corprow.get("cz");
masterRow.put("nf", nf);
masterRow.put("yf", yf);
masterRow.put("dwmc", dwmc);
masterRow.put("startday", "1");
masterRow.put("endday", days + "");
masterRow.put("addr", addr);
masterRow.put("tel", tel);
masterRow.put("cz", cz);
initQueryItem(data.getRequest());
QueryBasic queryBasic = fixedQuery;
queryBasic.setSearchValue(data.getRequest());
String SQL = queryBasic.getWhereQuery();
if (SQL.length() > 0) SQL = " AND " + SQL;
String sql = combineSQL(XSDZ_SQL, "?", new String[] {fgsID, SQL});
sql = sql + " and djlx in(1,2,4,5)";
System.out.print(sql);
if (dsXsTable.isOpen()) dsXsTable.close();
setDataSetProperty(dsXsTable, sql);
dsXsTable.open();
sql = combineSQL(XSDZ_SQL, "?", new String[] {fgsID, SQL});
sql = sql + " and djlx=8";
if (dsJsTable.isOpen()) dsJsTable.close();
setDataSetProperty(dsJsTable, sql);
dsJsTable.open();
sql = combineSQL(XSDZ_SQL, "?", new String[] {fgsID, SQL});
sql = sql + " and djlx=-1";
if (dsThTable.isOpen()) dsThTable.close();
setDataSetProperty(dsThTable, sql);
dsThTable.open();
sql = combineSQL(XSDZ_SQL, "?", new String[] {fgsID, SQL});
sql = sql + " and djlx=7";
if (dsQtTable.isOpen()) dsQtTable.close();
setDataSetProperty(dsQtTable, sql);
dsQtTable.open();
initRowInfo(true);
initRowInfo(false);
}
