コード例 #1
0
ファイル: User.java プロジェクト: ccivo100/fire
 public Page<Record> getUserPage(int pageNumber, int pageSize) {
   return Db.paginate(
       pageNumber,
       pageSize,
       SqlXmlKit.sql("user.findUserPageBySelect") + blank,
       SqlXmlKit.sql("user.findUserPageByFrom"));
 }
コード例 #2
0
ファイル: Order.java プロジェクト: ccivo100/fire
 /**
  * @描述 查询Operates 分页
  *
  * @param pageNumber
  * @param pageSize
  * @param where
  * @param orderby
  * @param paras
  * @return
  */
 public Page<Record> findOperatesByUserId(
     int pageNumber, int pageSize, String where, String orderby, Object... paras) {
   return Db.paginate(
       pageNumber,
       pageSize,
       getSql("order.findOfferQueryBySelect"),
       getSql("order.findOfferQueryByFrom") + getWhere(where) + orderby,
       paras);
 }
コード例 #3
0
ファイル: Order.java プロジェクト: ccivo100/fire
 /**
  * 根据条件获取Order。
  *
  * @param where
  * @param paras
  * @return
  */
 public Page<Record> findExceptionOrders(
     int pageNumber, int pageSize, String where, Object... paras) {
   return Db.paginate(
       pageNumber,
       pageSize,
       getSql("order.findOrderInfoBySelect"),
       getSql("order.findOrderInfoByFrom") + getWhere(where),
       paras);
 }
コード例 #4
0
  private void select() {
    StringBuffer whee = new StringBuffer();
    List<Object> param = new ArrayList<Object>();
    String startTime = getPara("startTime");
    if (startTime != null && !"".equals(startTime.trim())) {
      whee.append(" and UNIX_TIMESTAMP(p.OrderDate) >= UNIX_TIMESTAMP(?)");
      param.add(startTime);
    }
    setAttr("startTime", startTime);
    String endTime = getPara("endTime");
    if (endTime != null && !"".equals(endTime.trim())) {
      whee.append(" and UNIX_TIMESTAMP(p.OrderDate) <= UNIX_TIMESTAMP(?)");
      param.add(endTime);
    }
    setAttr("endTime", endTime);
    String supplierCode = getPara("supplier.supplierCode");
    if (supplierCodePara != null) supplierCode = supplierCodePara;
    if (supplierCode != null && !"".equals(supplierCode.trim())) {
      whee.append(" and p.SupplierCode = ?");
      param.add(Long.parseLong(supplierCode));
    }
    setAttr("supplierCode", supplierCode);
    setAttr("supplierName", getPara("supplier.supplierName"));

    String storeCd = getPara("store.StoreCode");
    if (storeCd != null && !"".equals(storeCd.trim())) {
      whee.append(" and p.StoreCode = ?");
      param.add(Long.parseLong(storeCd));
    }
    setAttr("StoreCode", storeCd);
    setAttr("StoreName", getPara("store.StoreName"));
    String sql = " from ckjhcheck p  left join  jbsupplier b on p.SupplierCode = b.supplierCode ";
    sql += " left join  jbstore c on p.StoreCode = c.StoreCode ";
    sql += " left join  employee d on d.usr_no = p.EmpCode ";
    sql += " left join  partment e on e.deptCode = p.deptCode ";
    sql += " left join  types t on t.id=p.inoutTypeNo and t.function='入库类型'";
    sql += " where 1=1 ";
    setAttr(
        "page",
        Db.paginate(
            getParaToInt("pageNum", 1),
            getParaToInt("numPerPage", 10),
            "select p.id,p.OrderCode 订单号, p.OrderDate 进货日期,p.remark 备注, t.name 入库类型,p.BillOrderNo 采购单号,p.CKAmount 入库金额, p.payAmount 已付金额,p.checkflag 审核, b.supplierName 供应商,c.StoreName 订货仓库,d.usr_name 业务员, e.`name` 部门 ",
            sql + whee.toString(),
            param.toArray()));
    setAttr(
        "collist",
        new String[] {
          "订单号", "进货日期", "供应商", "业务员", "部门", "收货日期", "订货仓库", "入库类型", "采购单号", "入库金额", "已付金额", "审核",
          "备注"
        });
  }
コード例 #5
0
 public void add() {
   Ckjhcheck ckjhcheck = new Ckjhcheck();
   Jbsupplier jbsupplier = new Jbsupplier();
   Jbstore jbstore = new Jbstore();
   // 采购入库单号
   String ordCdNw = null;
   // 不是采购订单导入
   Long id = getParaToLong(0, 0L);
   List<Object> param = new ArrayList<Object>();
   StringBuffer whee = new StringBuffer();
   whee.append(" and a.OrderCode = ?");
   if (id != 0) { // 修改
     ckjhcheck = Ckjhcheck.dao.findById(id);
     jbsupplier =
         Jbsupplier.dao.findFirst(
             "select * from jbsupplier where supplierCode = ?", ckjhcheck.getStr("SupplierCode"));
     jbstore =
         Jbstore.dao.findFirst(
             "select * from jbstore where StoreCode = ?", ckjhcheck.getStr("StoreCode"));
     param.add(ckjhcheck.get("orderCode"));
   } else {
     synchronized (lock) {
       ordCdNw = BsUtil.getMaxOrdNo("OrderCode", "PK", "ckjhcheck");
     }
     ckjhcheck.set("OrderCode", ordCdNw);
     param.add(ordCdNw);
     // 赋值当前时间
     Date dt = new Date();
     SimpleDateFormat ckDate = new SimpleDateFormat("yyyy-MM-dd");
     ckjhcheck.set("orderdate", ckDate.format(dt));
     // 赋值制单人
     Record m = getCurrentUser();
     ckjhcheck.set("operator", m.getStr("usr_name"));
   }
   String sql =
       "select a.id,b.GoodsCode 商品编号,b.GoodsName 商品名称,b.Model 商品规格,b.BaseUnit 基本单位,b.BRefPrice 原价,a.Discount 折扣, a.Quantity 数量,";
   sql += " a.TaxRate 税率,a.TaxAmount 税额,a.Amount 金额";
   String sqlSelect = " from ckjhcheckdetail a";
   sqlSelect += " left join jbgoods b on a.GoodsCode = b.GoodsCode where 1=1 ";
   Page<Record> redLst =
       Db.paginate(
           getParaToInt("pageNum", 1),
           getParaToInt("numPerPage", 20),
           sql,
           sqlSelect + whee.toString(),
           param.toArray());
   int size = redLst.getList().size();
   // 不足10条,补足10条显示
   if (size < 10) {
     for (int i = 0; i < 10 - size; i++) {
       redLst.getList().add(new Record());
     }
   }
   setAttr("page", redLst);
   setAttr(
       "collist",
       new String[] {"商品编号", "商品名称", "商品规格", "单位", "原价", "折扣%", "数量", "订单金额", "税率%", "税额", "金额"});
   setAttr("ckjhcheck", ckjhcheck);
   setAttr("store", jbstore);
   setAttr("supplier", jbsupplier);
   setAttr(InOutTypeNoSelectTarget.targetName, new InOutTypeNoSelectTarget());
   setAttr(PartmentSelectTarget.targetName, new PartmentSelectTarget());
   setAttr(EmployeeSelectTarget.targetName, new EmployeeSelectTarget());
   render("add.html");
 }
コード例 #6
0
 // 采购入库
 public void cgInStore() {
   Ckjhcheck ckjhcheck = new Ckjhcheck();
   Jbsupplier jbsupplier = new Jbsupplier();
   Jbstore jbstore = new Jbstore();
   List<Object> param = new ArrayList<Object>();
   // 采购入库单号
   String ordCdNw = null;
   synchronized (lock) {
     ordCdNw = BsUtil.getMaxOrdNo("OrderCode", "PK", "ckjhcheck");
   }
   ckjhcheck.set("OrderCode", ordCdNw);
   String obj = getPara();
   Cgorder cgOrd = new Cgorder();
   cgOrd = Cgorder.dao.findFirst("select * from cgorder where orderCode = ?", new Object[] {obj});
   jbsupplier =
       Jbsupplier.dao.findFirst(
           "select * from jbsupplier where supplierCode = ?", cgOrd.getStr("supplierCode"));
   jbstore =
       Jbstore.dao.findFirst(
           "select * from jbstore where StoreCode = ?", cgOrd.getStr("StoreCode"));
   // ckjhcheck.set("OrderCode", ordCdNw);
   ckjhcheck.set("OrderDate", cgOrd.getDate("DeliveryDate"));
   ckjhcheck.set("supplierCode", cgOrd.getStr("supplierCode"));
   ckjhcheck.set("StoreCode", cgOrd.getStr("StoreCode"));
   // ckjhcheck.set("InOutTypeNo", "52");
   ckjhcheck.set("BillOrderNo", cgOrd.getStr("orderCode"));
   ckjhcheck.set("deptCode", cgOrd.getStr("deptcode"));
   ckjhcheck.set("Empcode", cgOrd.getStr("Empcode"));
   ckjhcheck.set("Operator", cgOrd.getStr("Operator"));
   ckjhcheck.set("CheckFlag", 0);
   ckjhcheck.set("SettleTypeFlag", 0);
   StringBuffer whee = new StringBuffer();
   whee.append(" and a.orderCode = ?");
   param.add(obj);
   String sql =
       "select a.id,b.GoodsCode 商品编号,b.GoodsName 商品名称,b.Model 商品规格,b.BaseUnit 基本单位,b.BRefPrice 原价,a.Discount 折扣, a.Quantity 数量,";
   sql += " a.TaxRate 税率,a.TaxAmount 税额,a.Amount 税后金额";
   String sqlSelect = " from cgorderdetail a";
   sqlSelect += " left join jbgoods b on a.GoodsCode = b.GoodsCode where 1=1 ";
   Page<Record> redLst =
       Db.paginate(
           getParaToInt("pageNum", 1),
           getParaToInt("numPerPage", 20),
           sql,
           sqlSelect + whee.toString(),
           param.toArray());
   int size = redLst.getList().size();
   // 不足10条,补足10条显示
   if (size < 10) {
     for (int i = 0; i < 10 - size; i++) {
       redLst.getList().add(new Record());
     }
   }
   setAttr("page", redLst);
   setAttr(
       "collist",
       new String[] {
         "商品编号", "商品名称", "商品规格", "基本单位", "原价", "折扣%", "单价", "数量", "税率%", "折后金额", "税后金额"
       });
   setAttr("ckjhcheck", ckjhcheck);
   setAttr("store", jbstore);
   setAttr("supplier", jbsupplier);
   setAttr(InOutTypeNoSelectTarget.targetName, new InOutTypeNoSelectTarget());
   setAttr(PartmentSelectTarget.targetName, new PartmentSelectTarget());
   setAttr(EmployeeSelectTarget.targetName, new EmployeeSelectTarget());
   render("add.html");
 }