CZT
2023-09-06 71c4fa1e27f75ae4b765c95c67a3069c84dc72ba
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
package com.ld.igds.sys.service;
 
import com.bstek.bdf2.core.model.DefaultDept;
import com.bstek.bdf2.core.orm.jdbc.JdbcDao;
import org.springframework.stereotype.Repository;
 
/**
 *
 */
@Repository
public class JdbcDeptServiceImpl extends JdbcDao {
 
    public void saveDefaultDept(DefaultDept data) {
        StringBuffer sql = new StringBuffer();
        sql.append("insert into BDF2_DEPT(");
        sql.append("ID_,");
        sql.append("COMPANY_ID_,");
        sql.append("PARENT_ID_,");
        sql.append("CREATE_DATE_,");
        sql.append("NAME_,");
        sql.append("DESC_,");
        sql.append("TYPE_,");
        sql.append("CODE_,");
        sql.append("PROVINCE_,");
        sql.append("CITY_,");
        sql.append("COUNTRY_,");
        sql.append("LON_,");
        sql.append("LAT_,");
        sql.append("POST_CODE_,");
        sql.append("BUILDING_NUM_,");
        sql.append("OIL_NUM_,");
        sql.append("ADDRESS_,");
        sql.append("CONTACT_,");
        sql.append("PHONE_,");
        sql.append("FAX_,");
 
        sql.append("COMPANY_TYPE_,");
        sql.append("NATURE_,");
        sql.append("LEGAL_PERSON_,");
        sql.append("DEPT_NUM_,");
        sql.append("REGISTER_CODE_,");
        sql.append("CREDIT_CODE_,");
 
        sql.append("DEPOT_NUM_,");
        sql.append("STORAGE_,");
        sql.append("OIL_STORAGE_,");
        sql.append("AREA_,");
        sql.append("ACTING_RESERVE_,");
        sql.append("PROPERTY_RIGHT_,");
        sql.append("VAL_ )");
        sql.append("values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
 
        this.getJdbcTemplate().update(
                sql.toString(),
                new Object[] { data.getId(), data.getCompanyId(), data.getParentId(), data.getCreateDate(),
                        data.getName(), data.getDesc(), data.getType(), data.getCode(),
                        data.getProvince(), data.getCity(), data.getCountry(),
                        data.getLon(), data.getLat(), data.getPostCode(),
                        data.getBuildingNum(), data.getOilNum(), data.getAddress(),
                        data.getContact(), data.getPhone(), data.getFax(),
                        data.getCompanyType(), data.getNature(), data.getLegalPerson(),
                        data.getDeptNum(), data.getRegisterCode(), data.getCreditCode(),
                        data.getDepotNum(), data.getStorage(), data.getOilStorage(),
                        data.getArea(), data.getActingReserve(),
                        data.getPropertyRight(), data.getVal() });
 
    }
}