1 package org.campware.cream.modules.actions; 2 3 42 43 import java.util.Date ; 44 import org.apache.velocity.context.Context; 45 46 import org.apache.turbine.util.RunData; 47 import org.apache.torque.util.Criteria; 48 import org.apache.torque.util.Transaction; 49 import java.sql.Connection ; 50 51 import org.campware.cream.om.Product; 52 import org.campware.cream.om.ProductPeer; 53 54 58 public class ProductSQL extends CreamAction 59 { 60 protected void initScreen() 61 { 62 setModuleType(ENTITY); 63 setModuleName("PRODUCT"); 64 } 65 75 public void doInsert(RunData data, Context context) 76 throws Exception 77 { 78 Product entry = new Product(); 79 data.getParameters().setProperties(entry); 80 81 82 String myCode=data.getParameters().getString("productcode"); 83 84 entry.setCreatedBy(data.getUser().getName()); 85 entry.setCreated(new Date ()); 86 entry.setModifiedBy(data.getUser().getName()); 87 entry.setModified(new Date ()); 88 89 if (myCode.equals("AUTO")) 90 { 91 entry.setProductCode(getTempCode()); 92 93 Connection conn = Transaction.begin(ProductPeer.DATABASE_NAME); 94 boolean success = false; 95 try { 96 entry.save(conn); 97 entry.setProductCode(getRowCode("PR", entry.getProductId())); 98 entry.save(conn); 99 Transaction.commit(conn); 100 success = true; 101 102 } finally { 103 if (!success) Transaction.safeRollback(conn); 104 } 105 } 106 else 107 { 108 entry.save(); 109 } 110 111 } 112 113 121 public void doUpdate(RunData data, Context context) 122 throws Exception 123 { 124 Product entry = new Product(); 125 data.getParameters().setProperties(entry); 126 127 String myCode=data.getParameters().getString("productcode"); 128 if (myCode.equals("AUTO")) 129 { 130 entry.setProductCode(getRowCode("PR", entry.getProductId())); 131 } 132 133 entry.setCreated(parseDateTime(data.getParameters().getString("created"))); 134 entry.setModifiedBy(data.getUser().getName()); 135 entry.setModified(new Date ()); 136 137 entry.setModified(true); 138 entry.setNew(false); 139 entry.save(); 140 141 } 142 143 147 public void doDelete(RunData data, Context context) 148 throws Exception 149 { 150 Criteria criteria = new Criteria(); 151 criteria.add(ProductPeer.PRODUCT_ID, data.getParameters().getInt("productid")); 152 ProductPeer.doDelete(criteria); 153 } 154 155 159 public void doDeleteselected(RunData data, Context context) 160 throws Exception 161 { 162 int[] delIds= data.getParameters().getInts("rowid"); 163 Criteria criteria = new Criteria(); 164 criteria.addIn(ProductPeer.PRODUCT_ID, delIds); 165 ProductPeer.doDelete(criteria); 166 } 167 168 } 169 | Popular Tags |