Banninger/src/rest/openapi/restcontroller/hyworkorder/webapp/titem/titem.java

package openapi.restcontroller.hyworkorder.webapp.titem;

import net.sf.json.JSONObject;
import openapi.base.Controller;
import openapi.base.SQLFactory;
import openapi.base.data.Rows;
import openapi.base.data.db.DBConnect;
import org.apache.commons.lang.StringUtils;

public class titem extends Controller {
 
    public titem(JSONObject content) {
        super(content);
    }


    /**服务物料列表**/
    public String list(){
        if(StringUtils.isBlank(hrid))return getReturnObject_err("hrid为空").toString();
//        if(StringUtils.isBlank(fagentnum))return getReturnObject_err("fagentnum为空").toString();
        if(StringUtils.isBlank(siteid))return getReturnObject_err("siteid为空").toString();
        JSONObject where = content.getJSONObject("where");
        String wherestr="1=1";
//        String s[]={"fstatus"};
//        for (String s1 : s) {
//            if(!where.containsKey(s1)&&!StringUtils.isBlank(where.getString(s1)))return getReturnObject_err("缺少"+s1+"参数").toString();
//        }
        if(where!=null){
            DBConnect dbConnect=new DBConnect();
            SQLFactory factory=new SQLFactory(this,"服务物料查询",pageSize,pageNumber,"fitemno");

            if(where.containsKey("fitemname")&&!StringUtils.isBlank(where.getString("fitemname"))){
                wherestr+=" and (t.fitemname like '%"+where.getString("fitemname")+"%' " +
                        "or t.fitemno like '%"+where.getString("fitemname")+"%' "+
                        "or t.fmodel like '%"+where.getString("fitemname")+"%' "+
                        "or t.fspec like '%"+where.getString("fitemname")+"%' )";
            }
            
            factory.addParameter_SQL("where",wherestr);
            System.out.println(factory.getSQL());
            Rows rows = dbConnect.runSqlQuery(factory.getSQL());

            return getReturnObject_suc_page(rows,false,0).toString();
        }
        return getReturnObject_err("缺少where参数").toString();
    }




}