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.Customer; 52 import org.campware.cream.om.CustomerPeer; 53 54 58 public class CustomerSQL extends CreamAction 59 { 60 protected void initScreen() 61 { 62 setModuleType(ENTITY); 63 setModuleName("CUSTOMER"); 64 } 65 66 76 public void doInsert(RunData data, Context context) 77 throws Exception 78 { 79 Customer entry = new Customer(); 80 data.getParameters().setProperties(entry); 81 82 83 String myCode=data.getParameters().getString("customercode"); 84 85 entry.setCreatedBy(data.getUser().getName()); 86 entry.setCreated(new Date ()); 87 entry.setModifiedBy(data.getUser().getName()); 88 entry.setModified(new Date ()); 89 90 91 if (myCode.equals("AUTO")) 92 { 93 entry.setCustomerCode(getTempCode()); 94 95 Connection conn = Transaction.begin(CustomerPeer.DATABASE_NAME); 96 boolean success = false; 97 try { 98 entry.save(conn); 99 entry.setCustomerCode(getRowCode("CU", entry.getCustomerId())); 100 entry.save(conn); 101 Transaction.commit(conn); 102 success = true; 103 104 } finally { 105 if (!success) Transaction.safeRollback(conn); 106 } 107 } 108 else 109 { 110 entry.save(); 111 } 112 113 } 114 115 123 public void doUpdate(RunData data, Context context) 124 throws Exception 125 { 126 Customer entry = new Customer(); 127 data.getParameters().setProperties(entry); 128 129 String myCode=data.getParameters().getString("customercode"); 130 if (myCode.equals("AUTO")) 131 { 132 entry.setCustomerCode(getRowCode("CU", entry.getCustomerId())); 133 } 134 135 entry.setCreated(parseDateTime(data.getParameters().getString("created"))); 136 entry.setModifiedBy(data.getUser().getName()); 137 entry.setModified(new Date ()); 138 139 entry.setModified(true); 140 entry.setNew(false); 141 entry.save(); 142 143 } 144 145 149 public void doDelete(RunData data, Context context) 150 throws Exception 151 { 152 Criteria criteria = new Criteria(); 153 criteria.add(CustomerPeer.CUSTOMER_ID, data.getParameters().getInt("customerid")); 154 CustomerPeer.doDelete(criteria); 155 } 156 157 161 public void doDeleteselected(RunData data, Context context) 162 throws Exception 163 { 164 int[] delIds= data.getParameters().getInts("rowid"); 165 Criteria criteria = new Criteria(); 166 criteria.addIn(CustomerPeer.CUSTOMER_ID, delIds); 167 CustomerPeer.doDelete(criteria); 168 } 169 170 } 171 | Popular Tags |