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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
| using HH.WMS.Entitys.Algorithm;
| using HH.WMS.Entitys.Basic;
| using HW.Utility.Data;
| using System;
| using System.Collections.Generic;
| using System.Data;
| using System.Data.Common;
| using System.Linq;
| using System.Text;
|
| namespace HW.DAL
| {
| /// <summary>
| /// 供应商表数据处理层
| /// </summary>
| /// <returns></returns>
| /// <history>[HanHe(XDL)] CREATED 2018/06/13</history>
| public class TN_AB_SUPPLIERDAL:BaseDAL
| {
| #region 获取供应商集合
| /// <summary>
| /// 根据表名获取供应商集合
| /// </summary>
| /// <param name="tableName">表名</param>
| /// <returns>供应商集合</returns>
| /// <history>[HanHe(XDL)] CREATED 2018/06/13</history>
| public List<TN_AB_SUPPLIEREntity> GetSupplierList(string tableName)
| {
| string sql = @"SELECT CN_S_ORGAN
| ,CN_GUID
| ,CN_S_MODIFY
| ,CN_S_DEPARTMENT
| ,CN_S_VENDOR_CODE
| ,CN_S_FROM
| ,CN_S_MODIFY_BY
| ,CN_S_CREATOR_BY
| ,CN_S_VENDOR_SHORT_NAME
| ,CN_T_MODIFY
| ,CN_S_CREATE_TYPE
| ,CN_S_VENDOR_NAME
| ,CN_S_CREATOR
| ,CN_S_VENDOR_TYPE
| ,CN_S_VENDOR_LEVEL
| ,S.CN_T_CREATE
| ,CN_S_LEGAL_PERSON
| ,CN_S_STATUS
| ,CN_S_LINKMANN
| ,CN_S_BANK
| ,CN_S_PHONE
| ,CN_S_BANK_ACCOUNT
| ,CN_S_SETTLEMENT_CURRENCY
| ,CN_S_DELIVERY_DESTINATION
| ,CN_S_ZIPCODE
| ,CN_S_ADDRESS
| ,CN_S_EMAIL
| ,CN_S_FAX
| ,CN_S_WEBSITE
| ,CN_S_REMARK
| ,CN_C_INVOICE_ISOK
| ,CN_S_FINANCIAL_NUM
| ,CN_S_VENDOR_FLAG
| ,CN_C_IS_CHECK
| ,CN_S_LINK_STOCK
| ,CN_S_NATIONAL_TAX_NO
| ,CN_S_PRODUCT
| ,CN_S_EAS_CODE
| ,CN_S_BUYER
| ,CN_S_KEY_PREFIX
| ,CN_N_KEY_PREFIX_LEN
| FROM TN_AB_B_SYNCH_LOG L LEFT JOIN TN_AB_SUPPLIER S
| ON L.CN_S_GUID=S.CN_GUID
| WHERE L.CN_S_TABLE_NAME='" + tableName + "' AND L.CN_N_OP_FLAG IN (1,2)";
| DbCommand cmd = DataAccess.GetSqlStringCommand(sql);
| List<TN_AB_SUPPLIEREntity> list = DataAccessExtensive.ExecuteListEntity<TN_AB_SUPPLIEREntity>(this.DataAccess, cmd, SetEntity);
| return list;
| }
|
| /// <summary>
| /// 设置实体的各列
| /// <summary>
| private void SetEntity(TN_AB_SUPPLIEREntity entity, IDataReader reader)
| {
| SetEntityUti(entity, "CN_S_ORGAN", "CN_S_ORGAN", reader);
| SetEntityUti(entity, "CN_GUID", "CN_GUID", reader);
| SetEntityUti(entity, "CN_S_MODIFY", "CN_S_MODIFY", reader);
| SetEntityUti(entity, "CN_S_DEPARTMENT", "CN_S_DEPARTMENT", reader);
| SetEntityUti(entity, "CN_S_VENDOR_CODE", "CN_S_VENDOR_CODE", reader);
| SetEntityUti(entity, "CN_S_FROM", "CN_S_FROM", reader);
| SetEntityUti(entity, "CN_S_MODIFY_BY", "CN_S_MODIFY_BY", reader);
| SetEntityUti(entity, "CN_S_CREATOR_BY", "CN_S_CREATOR_BY", reader);
| SetEntityUti(entity, "CN_S_VENDOR_SHORT_NAME", "CN_S_VENDOR_SHORT_NAME", reader);
| SetEntityUti(entity, "CN_T_MODIFY", "CN_T_MODIFY", reader);
| SetEntityUti(entity, "CN_S_CREATE_TYPE", "CN_S_CREATE_TYPE", reader);
| SetEntityUti(entity, "CN_S_VENDOR_NAME", "CN_S_VENDOR_NAME", reader);
| SetEntityUti(entity, "CN_S_CREATOR", "CN_S_CREATOR", reader);
| SetEntityUti(entity, "CN_S_VENDOR_TYPE", "CN_S_VENDOR_TYPE", reader);
| SetEntityUti(entity, "CN_S_VENDOR_LEVEL", "CN_S_VENDOR_LEVEL", reader);
| SetEntityUti(entity, "CN_T_CREATE", "CN_T_CREATE", reader);
| SetEntityUti(entity, "CN_S_LEGAL_PERSON", "CN_S_LEGAL_PERSON", reader);
| SetEntityUti(entity, "CN_S_STATUS", "CN_S_STATUS", reader);
| SetEntityUti(entity, "CN_S_LINKMANN", "CN_S_LINKMANN", reader);
| SetEntityUti(entity, "CN_S_BANK", "CN_S_BANK", reader);
| SetEntityUti(entity, "CN_S_PHONE", "CN_S_PHONE", reader);
| SetEntityUti(entity, "CN_S_BANK_ACCOUNT", "CN_S_BANK_ACCOUNT", reader);
| SetEntityUti(entity, "CN_S_SETTLEMENT_CURRENCY", "CN_S_SETTLEMENT_CURRENCY", reader);
| SetEntityUti(entity, "CN_S_DELIVERY_DESTINATION", "CN_S_DELIVERY_DESTINATION", reader);
| SetEntityUti(entity, "CN_S_ZIPCODE", "CN_S_ZIPCODE", reader);
| SetEntityUti(entity, "CN_S_ADDRESS", "CN_S_ADDRESS", reader);
| SetEntityUti(entity, "CN_S_EMAIL", "CN_S_EMAIL", reader);
| SetEntityUti(entity, "CN_S_FAX", "CN_S_FAX", reader);
| SetEntityUti(entity, "CN_S_WEBSITE", "CN_S_WEBSITE", reader);
| SetEntityUti(entity, "CN_S_REMARK", "CN_S_REMARK", reader);
| SetEntityUti(entity, "CN_C_INVOICE_ISOK", "CN_C_INVOICE_ISOK", reader);
| SetEntityUti(entity, "CN_S_FINANCIAL_NUM", "CN_S_FINANCIAL_NUM", reader);
| SetEntityUti(entity, "CN_S_VENDOR_FLAG", "CN_S_VENDOR_FLAG", reader);
| SetEntityUti(entity, "CN_C_IS_CHECK", "CN_C_IS_CHECK", reader);
| SetEntityUti(entity, "CN_S_LINK_STOCK", "CN_S_LINK_STOCK", reader);
| SetEntityUti(entity, "CN_S_NATIONAL_TAX_NO", "CN_S_NATIONAL_TAX_NO", reader);
| SetEntityUti(entity, "CN_S_PRODUCT", "CN_S_PRODUCT", reader);
| SetEntityUti(entity, "CN_S_EAS_CODE", "CN_S_EAS_CODE", reader);
| SetEntityUti(entity, "CN_S_BUYER", "CN_S_BUYER", reader);
| SetEntityUti(entity, "CN_S_KEY_PREFIX", "CN_S_KEY_PREFIX", reader);
| SetEntityUti(entity, "CN_N_KEY_PREFIX_LEN", "CN_N_KEY_PREFIX_LEN", reader);
| }
| #endregion
|
|
| }
| }
|
|
