7eb67db2a4aaf371b6cbd645bcfaedbf383a9404.svn-base 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129
  1. package UIM.UIM05;
  2. import java.sql.PreparedStatement;
  3. import java.sql.ResultSet;
  4. import java.sql.SQLException;
  5. import java.util.ArrayList;
  6. import java.util.Map;
  7. import java.sql.CallableStatement;
  8. import java.sql.Connection;
  9. import java.util.List;
  10. import org.springframework.jdbc.support.rowset.SqlRowSet;
  11. import UIB.COM.XmlSqlParsersFactory;
  12. import CoreFS.SA01.CoreIComponent;
  13. import CoreFS.SA06.CoreReturnObject;
  14. import CoreFS.SA06.CoreSqlType;
  15. /**
  16. * 总貌图
  17. *
  18. * @author siy
  19. * @date 2011-11-24
  20. */
  21. public class UIM050010 extends CoreIComponent {
  22. /**
  23. * 查询酸轧实时生产钢卷
  24. *
  25. * @return
  26. * @throws SQLException
  27. */
  28. public CoreReturnObject getPltcmData() throws SQLException {
  29. CoreReturnObject cro = new CoreReturnObject();
  30. try {
  31. String sql = XmlSqlParsersFactory.getSql("UIM050010_01.SELECT");
  32. cro = this.getDao("KgDao").ExcuteQuery(sql);
  33. } catch (Exception ex) {
  34. }
  35. return cro;
  36. }
  37. /**
  38. * 查询连退实时生产钢卷
  39. *
  40. * @return
  41. * @throws SQLException
  42. */
  43. public CoreReturnObject getCalData() throws SQLException {
  44. CoreReturnObject cro = new CoreReturnObject();
  45. try {
  46. String sql = XmlSqlParsersFactory.getSql("UIM050010_02.SELECT");
  47. cro = this.getDao("KgDao").ExcuteQuery(sql);
  48. } catch (Exception ex) {
  49. }
  50. return cro;
  51. }
  52. /**
  53. * 查询重卷实时生产钢卷
  54. *
  55. * @return
  56. * @throws SQLException
  57. */
  58. public CoreReturnObject getRclData() throws SQLException {
  59. CoreReturnObject cro = new CoreReturnObject();
  60. try {
  61. String sql = XmlSqlParsersFactory.getSql("UIM050010_03.SELECT");
  62. cro = this.getDao("KgDao").ExcuteQuery(sql);
  63. } catch (Exception ex) {
  64. }
  65. return cro;
  66. }
  67. /**
  68. * 查询酸轧实时生产钢卷
  69. *
  70. * @return
  71. * @throws SQLException
  72. */
  73. public CoreReturnObject getPltcmInfo() throws SQLException {
  74. CoreReturnObject cro = new CoreReturnObject();
  75. try {
  76. String sql = XmlSqlParsersFactory.getSql("UIM050010_04.SELECT");
  77. cro = this.getDao("KgDao").ExcuteQuery(sql);
  78. } catch (Exception ex) {
  79. }
  80. return cro;
  81. }
  82. /**
  83. * 查询连退实时生产钢卷
  84. *
  85. * @return
  86. * @throws SQLException
  87. */
  88. public CoreReturnObject getCalInfo() throws SQLException {
  89. CoreReturnObject cro = new CoreReturnObject();
  90. try {
  91. String sql = XmlSqlParsersFactory.getSql("UIM050010_05.SELECT");
  92. cro = this.getDao("KgDao").ExcuteQuery(sql);
  93. } catch (Exception ex) {
  94. }
  95. return cro;
  96. }
  97. /**
  98. * 查询重卷实时生产钢卷
  99. *
  100. * @return
  101. * @throws SQLException
  102. */
  103. public CoreReturnObject getRclInfo() throws SQLException {
  104. CoreReturnObject cro = new CoreReturnObject();
  105. try {
  106. String sql = XmlSqlParsersFactory.getSql("UIM050010_06.SELECT");
  107. cro = this.getDao("KgDao").ExcuteQuery(sql);
  108. } catch (Exception ex) {
  109. }
  110. return cro;
  111. }
  112. }