1 14 package org.compiere.model; 15 16 import java.sql.*; 17 import java.math.*; 18 19 import org.compiere.util.DB; 20 21 28 public class MPInstance_Log 29 { 30 39 public MPInstance_Log (int AD_PInstance_ID, int Log_ID, Timestamp P_Date, 40 int P_ID, BigDecimal P_Number, String P_Msg) 41 { 42 setAD_PInstance_ID(AD_PInstance_ID); 43 setLog_ID(Log_ID); 44 setP_Date(P_Date); 45 setP_ID(P_ID); 46 setP_Number(P_Number); 47 setP_Msg(P_Msg); 48 } 50 55 public MPInstance_Log (ResultSet rs) 56 throws SQLException 57 { 58 setAD_PInstance_ID(rs.getInt("AD_PInstance_ID")); 59 setLog_ID(rs.getInt("Log_ID")); 60 setP_Date(rs.getTimestamp("P_Date")); 61 setP_ID(rs.getInt("P_ID")); 62 setP_Number(rs.getBigDecimal("P_Number")); 63 setP_Msg(rs.getString("P_Msg")); 64 } 66 67 private int m_AD_PInstance_ID; 68 private int m_Log_ID; 69 private Timestamp m_P_Date; 70 private int m_P_ID; 71 private BigDecimal m_P_Number; 72 private String m_P_Msg; 73 74 75 79 public String toString () 80 { 81 StringBuffer sb = new StringBuffer ("PPInstance_Log["); 82 sb.append(m_Log_ID); 83 if (m_P_Date != null) 84 sb.append(",Date=").append(m_P_Date); 85 if (m_P_ID != 0) 86 sb.append(",ID=").append(m_P_ID); 87 if (m_P_Number != null) 88 sb.append(",Number=").append(m_P_Number); 89 if (m_P_Msg != null) 90 sb.append(",").append(m_P_Msg); 91 sb.append("]"); 92 return sb.toString(); 93 } 95 96 100 public boolean save () 101 { 102 StringBuffer sql = new StringBuffer ("INSERT INTO AD_PInstance_Log " 103 + "(AD_PInstance_ID, Log_ID, P_Date, P_ID, P_Number, P_Msg)" 104 + " VALUES ("); 105 sql.append(m_AD_PInstance_ID).append(",") 106 .append(m_Log_ID).append(","); 107 if (m_P_Date == null) 108 { 109 sql.append("NULL,"); 110 } 111 else 112 { 113 sql.append(DB.TO_DATE(m_P_Date, false)).append(","); 114 } 115 if (m_P_ID == 0) 116 { 117 sql.append("NULL,"); 118 } 119 else 120 { 121 sql.append(m_P_ID).append(","); 122 } 123 if (m_P_Number == null) 124 { 125 sql.append("NULL,"); 126 } 127 else 128 { 129 sql.append(m_P_Number).append(","); 130 } 131 if (m_P_Msg == null) 132 { 133 sql.append("NULL)"); 134 } 135 else 136 { 137 sql.append(DB.TO_STRING(m_P_Msg, 2000)).append(")"); 138 } 140 int no = DB.executeUpdate(sql.toString()); 141 return no == 1; 142 } 144 145 public int getAD_PInstance_ID () 146 { 147 return m_AD_PInstance_ID; 148 } 149 150 public void setAD_PInstance_ID (int AD_PInstance_ID) 151 { 152 m_AD_PInstance_ID = AD_PInstance_ID; 153 } 154 155 public int getLog_ID () 156 { 157 return m_Log_ID; 158 } 159 160 public void setLog_ID (int Log_ID) 161 { 162 m_Log_ID = Log_ID; 163 } 164 165 public Timestamp getP_Date () 166 { 167 return m_P_Date; 168 } 169 170 public void setP_Date (Timestamp P_Date) 171 { 172 m_P_Date = P_Date; 173 } 174 175 public int getP_ID () 176 { 177 return m_P_ID; 178 } 179 180 public void setP_ID (int P_ID) 181 { 182 m_P_ID = P_ID; 183 } 184 185 public BigDecimal getP_Number () 186 { 187 return m_P_Number; 188 } 189 190 public void setP_Number (BigDecimal P_Number) 191 { 192 m_P_Number = P_Number; 193 } 194 195 public String getP_Msg () 196 { 197 return m_P_Msg; 198 } 199 200 public void setP_Msg (String P_Msg) 201 { 202 m_P_Msg = P_Msg; 203 } 204 205 }
| Popular Tags
|