9bb0526b37adbaffcc7aff430f9d40b02103d577.svn-base 1.3 KB

1234567891011121314151617181920212223242526272829303132333435
  1. package QCM.QCM01.QCM0102;
  2. import java.sql.ResultSet;
  3. import java.sql.SQLException;
  4. import java.util.ArrayList;
  5. import CoreFS.SA06.CoreReturnObject;
  6. import CoreFS.SA01.CoreIComponent;
  7. import QCM.COMMUNAL.communalClass;
  8. import QCM.COMMUNAL.sqlCount;
  9. public class SavePhy extends CoreIComponent {
  10. CoreReturnObject cro = new CoreReturnObject();
  11. StringBuffer sqlucomm = new StringBuffer();
  12. int count=0;
  13. ResultSet rs=null;
  14. //参数:项目代码、项目名称、大类描述、材质检验项代码、缺陷分类描述、备注、修改人ID、修改人
  15. public CoreReturnObject Save(ArrayList BaseChem) {
  16. sqlCount countWay= new sqlCount();
  17. count=countWay.countData("QCM_BASE_PHY","PHY_GRP_CODE",(String)BaseChem.get(6),1);
  18. if(count>0){
  19. sqlucomm=new StringBuffer();
  20. sqlucomm.append("update QCM_BASE_PHY "+
  21. "set PHY_GRP_DESC=?,PHY_DESC_L=?,DEFECT_TYPE_DESC=?,"+
  22. "MEMO=?, UPDATE_ID=?,UPDATE_NAME=?,UPDATE_TIME=TO_DATE('"+communalClass.getDate()+"','YYYY-MM-DD HH24:MI:SS')" +
  23. " where PHY_GRP_CODE=? ");
  24. Object[] obj=new Object[]{BaseChem.get(0),BaseChem.get(1),BaseChem.get(2),BaseChem.get(3),BaseChem.get(4),BaseChem.get(5),BaseChem.get(6)};
  25. try {
  26. cro = this.getDao("KgDao").ExcuteNonQuery(sqlucomm.toString(),obj);
  27. } catch (SQLException e) {
  28. e.printStackTrace();
  29. }
  30. }
  31. return cro;
  32. }
  33. }