newpaihao.java

检化验管理系统

package com.snsoft.site.jspbean;

import com.jl.zys.dbaccess.*;
import java.sql.*;
import java.util.*;
import java.text.SimpleDateFormat;


public class newpaihao {
  private int totalpage; //总页数
  private int stride; //跨度
  private int currentpage; //当前页
  private int size = 17; //每页记录数
  private int totalsize; //总记录数

  String paihao = "";
  String biaoshi = "";
  String subt = "";
  //String submit = "";
  //String checkDateA = "";
  //String checkDateB = "";
  String dateA = "";
  String dateB = "";
  String pi_or_cai = "";

  String goods = "";
  String sign = "";
  String name = ""; //制单人
  String company = "";
  String person = "";
  String userids = "";
  String all = "";
  String numid = "";
  String judge = "";
  String checkmen = ""; //审核人
  String chong = "";//当页最后两条记录是否重复
  String idend = "";//记录总数是否减1；n为不减

  String huaxue = "";
  String dibeiP = "";
  String biaomianP = "";
  String dibeiC = "";
  String biaomianC = "";
  String feijinshuC = "";
  String jinxiangC = "";
  String wuliC = "";
  String taxingC = "";

  String check_input_common = ""; //check审核人查询；input制单人查询；common通用查询
  SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd");
  String show = "";//是否分页显示；y分页，n不分页

  public void setPaihao(String paihao){
    this.paihao =paihao;
  }
  public void setBiaoshi(String biaoshi){
    this.biaoshi = biaoshi;
  }
  public void setDateA(String dateA){
    this.dateA = dateA;
  }
  public void setDateB(String dateB){
    this.dateB = dateB;
  }
  public void setPi_or_cai(String pi_or_cai){
    this.pi_or_cai = pi_or_cai;
  }
  public void setChong(String chong){
    this.chong = chong;
  }

//-------------------get方法---------------------------
  public String getDateA(){
    return dateA;
  }
  public String getDateB(){
    return dateB;
  }
  String getPi_or_cai(){
      return pi_or_cai;
  }
  public String getPaihao(){
    return paihao;
  }
  public String getBiaoshi(){
    return biaoshi;
  }
  public String getChong(){
    return chong;
  }
//////-----
  public void setIdend(String idend){
    this.idend = idend;
  }
  public String getIdend(){
    return idend;
  }
//--------------分页中set/get--------------------------
  public void setTotalsize(){//设置记录总数

      //String strf = ""; //strfield();
      MyResultSet rs21 = null;
      setChengfen (paihao);
      String sqlw = sqlwhere (huaxue, dibeiP, biaomianP, wuliC, dibeiC,
                              biaomianC, jinxiangC, feijinshuC, taxingC);
      String strf= strfield(huaxue, dibeiP, biaomianP, wuliC, dibeiC,
                              biaomianC, jinxiangC, feijinshuC, taxingC);
      try {
          String sqlt = "select count(*) " + strf + " where " + sqlw + "";
          //rs = super.executeQuery (sqlt);
          rs21 = DbAccess.querySqlOption(sqlt);
          rs21.next ();
          this.totalsize = rs21.getInt (1);
      if(idend.indexOf("y")!=-1)
          this.totalsize -= 1;
      } catch (Exception e) {
          e.printStackTrace ();
      }
      finally {
        try {
          if (rs21 != null) { rs21.close();}
        }catch (SQLException ex) {}
      }
  }
//-------------------------------------------------------------
  public void setTotalpage(){//设置总页数
    this.totalpage = totalsize/(size-1);
    if(totalsize%(size-1)>0)
      this.totalpage++;
    //System.out.println(totalpage);
  }
  public void setCurrentpage(int currentpage){//设置当前页
    this.currentpage = currentpage;
  }
  public void setStride(int stride){//设置跨度
    this.stride = stride;
  }
  public void setSize(int size){//设置每页记录数
    this.size = size;
  }
  public int getTotalsize(){//--获得总记录数-
    return totalsize;
  }
  public int getTotalpage(){//--获得总页数-
    return totalpage;
  }
  public int getStride(){//获得跨读
    return stride;
  }

  public int getCurrentpage(){//获取当前页
    return currentpage;
  }
  public int getSize(){//获取每页记录数
    return size;
  }
  public void setShow (String show) {
      this.show = show;
  }
  public String getShow () {
      return show;
  }
//------------------打印分页-------------------
  public String show(){
    String willprint = new String();
    int p, Tmpa;
    for (Tmpa = 1; Tmpa <= totalpage; Tmpa++) {
      if (Tmpa + stride < currentpage) { //加了跨度还小于当前页的不显示
        continue;
      }
      if (Tmpa + stride == currentpage) { //刚好够跨度的页数
        p = currentpage - stride-1;
        willprint += "<a href=\"?page=" +
            (currentpage - 1) +
            "&idend=" + idend + "&show=" + show + "&paihao=" + paihao + "&pi_or_cai=" + pi_or_cai +
              "&subt=" + subt + "&biaoshi=" + biaoshi + "&dateA=" + dateA + "&dateB=" +
              dateB + "\" title=\"上页\"><span style=\"border-bottom:#000000 solid 1px;\">[上一页]</span></a>&nbsp;";
      }
      if (Tmpa > currentpage + stride) { //大于当前页+跨度的页面
        break;
      }
      //-----------
      willprint += "<a href=\"?page=" + Tmpa + "&idend=" + idend + "&show=" + show + "&paihao=" + paihao + "&pi_or_cai=" + pi_or_cai +
              "&subt=" + subt + "&biaoshi=" + biaoshi + "&dateA=" + dateA + "&dateB=" +dateB + "\">";
      if(Tmpa!=currentpage){
        willprint +="<span style=\"border-bottom:#000000 solid 1px;\">["+Tmpa+"]</span></a>&nbsp;";
      }else{
        willprint +="<font color=\"#CC0000\">"+Tmpa+"</font></a>&nbsp;";
      }
      //------------
//        System.out.println("tmpa:"+Tmpa);
//        System.out.println("当前页："+currentpage);
//        System.out.println("跨度："+stride);
//        System.out.println("********************");
      if (Tmpa == currentpage + stride ) { //刚好够跨度的页数
        p = currentpage + stride + 1;//& Tmpa<totalpage
        willprint += "<a href=\"?page=" + (currentpage + 1) + "&idend=" + idend + "&show=" + show + "&paihao=" + paihao + "&pi_or_cai=" + pi_or_cai +
              "&subt=" + subt + "&biaoshi=" + biaoshi + "&dateA=" + dateA + "&dateB=" +dateB + "\" title=\"下页\"><span style=\"border-bottom:#000000 solid 1px;\">[下一页]</span></a>";
      }
    }
    return willprint;
  }

//----------------打印分页   show paihao  pi_or_cai biaoshi   checkDateA--checkDateB-- dateA  dateB submit
//  public String showbar(){
//      String willprint = new String ();
//      willprint += "共" + totalsize + "条记录&nbsp;&nbsp;共" + totalpage + "页&nbsp;&nbsp;当前第" + currentpage +
//          "页&nbsp;&nbsp";
//      if (currentpage != 1) {
//          willprint += "<a href=\"?page=1&show=" + show + "&paihao=" + paihao + "&pi_or_cai=" + pi_or_cai +
//              "&subt=" + subt + "&checkDateA=" + checkDateA +
//              "&checkDateB=" + checkDateB + "&dateA=" + dateA + "&dateB=" +
//              dateB + "&submit=" + submit + "\">首　页</a>&nbsp;&nbsp;";
//          willprint += "<a href=\"?page=" + (currentpage - 1) +
//              "&show=" + show + "&paihao=" + paihao + "&pi_or_cai=" + pi_or_cai +
//              "&submit=" + submit + "&checkDateA=" + checkDateA +
//              "&checkDateB=" + checkDateB + "&dateA=" + dateA + "&dateB=" +
//              dateB + "&submit=" + submit + "\">上一页</a>&nbsp;&nbsp;";
//      }
//      if (currentpage != totalpage) {
//          willprint += "<a href=\"?page=" + (currentpage + 1) +
//              "&show=" + show + "&paihao=" + paihao + "&pi_or_cai=" + pi_or_cai +
//              "&submit=" + submit + "&checkDateA=" + checkDateA +
//              "&checkDateB=" + checkDateB + "&dateA=" + dateA + "&dateB=" +
//              dateB + "&submit=" + submit + "\">下一页</a>&nbsp;&nbsp;";
//          willprint += "<a href=\"?page=" + totalpage +
//              "&show=" + show + "&paihao=" + paihao + "&pi_or_cai=" + pi_or_cai +
//              "&submit=" + submit + "&checkDateA=" + checkDateA +
//              "&checkDateB=" + checkDateB + "&dateA=" + dateA + "&dateB=" +
//              dateB + "&submit=" + submit + "\">尾　页</a>";
//      }
//      return willprint;
//  }

  public void setChengfen(String paihao){
      this.huaxue = "钢坯" + paihao + "化学成分";
      this.dibeiP = "钢坯" + paihao + "低倍";
      this.biaomianP = "钢坯" + paihao + "表面质量";
      this.dibeiC = "圆钢" + paihao + "低倍";
      this.biaomianC = "圆钢" + paihao + "表面质量";
      this.feijinshuC = "圆钢" + paihao + "非金属夹杂物";
      this.jinxiangC = "圆钢" + paihao + "金相";
      this.wuliC = "圆钢" + paihao + "物理性能";
      this.taxingC = "圆钢" + paihao + "塔形";
  }

//----------------------------------------------------
  public String strfield(String A,String B,String C,String D,String E,String F,String G,String H,String I){
      String strfield="";

      strfield = "FROM " + A + ""+
          " LEFT OUTER JOIN " + B + " ON " + A + ".标识 = " + B + ".标识"+
          " LEFT OUTER JOIN " + C + " ON " + A + ".标识 = " + C + ".标识 ";

      if(pi_or_cai.equals("c")){//p代表钢坯
          strfield = "FROM " + A + "" +
              " LEFT OUTER JOIN " + B + " ON " + A + ".标识 = " + B + ".标识" +
              " LEFT OUTER JOIN " + C + " ON " + A + ".标识 = " + C + ".标识 " +
              " LEFT OUTER JOIN " + D + " ON " + A + ".标识 = " + D + ".标识 " +
              " LEFT OUTER JOIN " + E + " ON " + A + ".标识 = " + E + ".标识 " +
              " LEFT OUTER JOIN " + F + " ON " + A + ".标识 = " + F + ".标识 " +
              " LEFT OUTER JOIN " + G + " ON " + A + ".标识 = " + G + ".标识 " +
              " LEFT OUTER JOIN " + H + " ON " + A + ".标识 = " + H + ".标识 " +
              " LEFT OUTER JOIN " + I + " ON " + A + ".标识 = " + I + ".标识 ";
      }
      return strfield;
  }

//------------------------------------------------------------
//  public String userFindPH_jiance() throws SQLException{
//      String str = "";
//      if(biaoshi.length()!=0||(checkDateA.length()!= 0 && !dateA.equals("单击选择时间"))||(checkDateB.length() != 0 && !dateB.equals("单击选择时间"))){
//          str = userFindPH();
//      }else{
//          str = "请选择查询时间或者标识！";
//      }
//
//      return str;
//  }

//------------------------------------------------------------
  public String sqlwhere(String A,String B,String C,String D,String E,String F,String G,String H,String I){

      String sqlwhere  = "";
      sqlwhere = " " + A + ".作废 = 'n' and " + A + ".审核结束 = 'y'";

      try {
          if(!subt.equals("模糊查询")){
              if (biaoshi.length () != 0) {
                  sqlwhere = sqlwhere + " " + "and "+A+".标识 = '" + biaoshi + "'";
              }
          }else{
              if (biaoshi.length () != 0) {
                  sqlwhere = sqlwhere + " " + "and "+A+".标识 like '%" + biaoshi + "%'";
              }
          }
          if (dateA.length()==10) {
              sqlwhere = sqlwhere + " " + "and "+A+".日期 >= DATEADD( dd , 0 ,'" + dateA +
                  "' )";
          }
          if (dateB.length()==10) {
              sqlwhere = sqlwhere + " " + "and " + A +
                  ".日期 <= DATEADD( dd , 0 ,'" + dateB +
                  "' )";
          }
      } catch (Exception e) {
          e.getMessage ();
      }
      //System.out.println(sqlwhere);
      return sqlwhere;
  }

//-------------------生成查询语句---------------------------

  public String sqlFindPH(String A,String B,String C,String D,String E,String F,String G,String H,String I){

      String sqlw =sqlwhere(A,B,C,D,E,F,G,H,I);
      String strf= strfield(A,B,C,D,E,F,G,H,I);