| | |
| | | |
| | | import com.yc.action.grid.GridUtils; |
| | | import com.yc.crm.clues.entity.T482103Entity; |
| | | import com.yc.crm.custom.entity.T480601HEntity; |
| | | import com.yc.crm.custom.entity.T480601Entity; |
| | | import com.yc.service.BaseService; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | |
| | | public class CustomImpl extends BaseService implements CustomIfc { |
| | | @Transactional(rollbackFor = Exception.class) |
| | | @Override |
| | | public String saveCustom(T480601HEntity custom) { |
| | | public String saveCustom(T480601Entity custom) { |
| | | String sql = "set nocount on\n"; |
| | | try { |
| | | sql += "declare @docCode varchar(50) \n"; |
| | | sql += "exec sp_newdoccode 482101," + GridUtils.prossSqlParm(custom.getEnterCode()) + ",@docCode output \n"; |
| | | sql += "exec sp_newdoccode t480601," + GridUtils.prossSqlParm(custom.getEnterCode()) + ",@docCode output \n"; |
| | | sql += "insert into t480601H(formId,docDate,periodId,docStatus,companyId,companyName,enterCode,enterName,enterDate," + |
| | | "postCode,postName,postDate,cltCode,cltName,country,province,city,district,street) " + |
| | | "values (" + custom.getFormId() + ",convert(varchar(10),getdate(),120),convert(varchar(7),getdate(),120),0," + |
| | |
| | | } |
| | | @Transactional(rollbackFor = Exception.class) |
| | | @Override |
| | | public Integer updateCustom(T480601HEntity custom) { |
| | | public Integer updateCustom(T480601Entity custom) { |
| | | String sql = "set nocunt on \n"; |
| | | try { |
| | | sql += "update t480601H set modifyCode=" + GridUtils.prossSqlParm(custom.getEnterCode()) + ",modifyName=" + GridUtils.prossSqlParm(custom.getEnterName()) + "," + |
| | |
| | | } |
| | | |
| | | @Override |
| | | public List<T480601HEntity> getCustomList(String userCode) { |
| | | public List<T480601Entity> getCustomList(String userCode) { |
| | | try { |
| | | return null; |
| | | } catch (Exception e) { |
| | |
| | | } |
| | | |
| | | @Override |
| | | public T480601HEntity getCustomInfo(String docCode, String userCode) { |
| | | public T480601Entity getCustomInfo(String docCode, String userCode) { |
| | | try { |
| | | return null; |
| | | } catch (Exception e) { |