BD_MOUDLE_BODY.cs 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550
  1. #pragma warning disable 1591
  2. using PL.Base;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Data;
  6. using PL.Server.Entity;
  7. using PL.Server.Entity.Entity;
  8. namespace FMS.Entity
  9. {
  10. public partial class BD_MOUDLE_BODY : EntityBase
  11. {
  12. public BD_MOUDLE_BODY()
  13. {
  14. base.Table = new TableInfo { Name = "FMS_BD_MOUDLE_BODY" };
  15. base.Columns = BD_MOUDLE_BODY_COLUMN.Instance;
  16. this.Init();
  17. }
  18. public BD_MOUDLE_BODY(string keyField):this()
  19. {
  20. base.KeyField = keyField;
  21. }
  22. public BD_MOUDLE_BODY(string keyField,string keyValue):this()
  23. {
  24. base.KeyField = keyField;
  25. this[keyField]= keyValue;
  26. }
  27. public BD_MOUDLE_BODY(EntityBase entityBase)
  28. : this()
  29. {
  30. this.Data = entityBase.Data;
  31. }
  32. #region DataMember
  33. /// <summary>
  34. /// 主键
  35. /// </summary>
  36. public string GUID
  37. {
  38. get
  39. {
  40. return this.TextAccess["GUID"];
  41. }
  42. set
  43. {
  44. this.TextAccess["GUID"] = value;
  45. }
  46. }
  47. /// <summary>
  48. /// 表头主键
  49. /// </summary>
  50. public string HEAD_GUID
  51. {
  52. get
  53. {
  54. return this.TextAccess["HEAD_GUID"];
  55. }
  56. set
  57. {
  58. this.TextAccess["HEAD_GUID"] = value;
  59. }
  60. }
  61. /// <summary>
  62. /// 服务编号
  63. /// </summary>
  64. public string SERVICE_ID
  65. {
  66. get
  67. {
  68. return this.TextAccess["SERVICE_ID"];
  69. }
  70. set
  71. {
  72. this.TextAccess["SERVICE_ID"] = value;
  73. }
  74. }
  75. /// <summary>
  76. /// 客户编码
  77. /// </summary>
  78. public string CUSTOM_CODE
  79. {
  80. get
  81. {
  82. return this.TextAccess["CUSTOM_CODE"];
  83. }
  84. set
  85. {
  86. this.TextAccess["CUSTOM_CODE"] = value;
  87. }
  88. }
  89. /// <summary>
  90. /// 客户名称
  91. /// </summary>
  92. public string CUSTOM_NAME
  93. {
  94. get
  95. {
  96. return this.TextAccess["CUSTOM_NAME"];
  97. }
  98. set
  99. {
  100. this.TextAccess["CUSTOM_NAME"] = value;
  101. }
  102. }
  103. /// <summary>
  104. /// 收费标准
  105. /// </summary>
  106. public string RECEIVE_STANDARD_ID
  107. {
  108. get
  109. {
  110. return this.TextAccess["RECEIVE_STANDARD_ID"];
  111. }
  112. set
  113. {
  114. this.TextAccess["RECEIVE_STANDARD_ID"] = value;
  115. }
  116. }
  117. /// <summary>
  118. /// 收费单价
  119. /// </summary>
  120. public System.Nullable<double> RECEIVE_PRICE
  121. {
  122. get
  123. {
  124. return this.DoubleAccess["RECEIVE_PRICE"];
  125. }
  126. set
  127. {
  128. this.DoubleAccess["RECEIVE_PRICE"] = value;
  129. }
  130. }
  131. /// <summary>
  132. /// 收费单价币制
  133. /// </summary>
  134. public string RECEIVE_CURR_ID
  135. {
  136. get
  137. {
  138. return this.TextAccess["RECEIVE_CURR_ID"];
  139. }
  140. set
  141. {
  142. this.TextAccess["RECEIVE_CURR_ID"] = value;
  143. }
  144. }
  145. /// <summary>
  146. /// 最低收费
  147. /// </summary>
  148. public System.Nullable<double> RECEIVE_MIN
  149. {
  150. get
  151. {
  152. return this.DoubleAccess["RECEIVE_MIN"];
  153. }
  154. set
  155. {
  156. this.DoubleAccess["RECEIVE_MIN"] = value;
  157. }
  158. }
  159. /// <summary>
  160. /// 最高收费
  161. /// </summary>
  162. public System.Nullable<double> RECEIVE_MAX
  163. {
  164. get
  165. {
  166. return this.DoubleAccess["RECEIVE_MAX"];
  167. }
  168. set
  169. {
  170. this.DoubleAccess["RECEIVE_MAX"] = value;
  171. }
  172. }
  173. /// <summary>
  174. /// 小数长度
  175. /// </summary>
  176. public System.Nullable<double> DECIMAL_LENGTH
  177. {
  178. get
  179. {
  180. return this.DoubleAccess["DECIMAL_LENGTH"];
  181. }
  182. set
  183. {
  184. this.DoubleAccess["DECIMAL_LENGTH"] = value;
  185. }
  186. }
  187. /// <summary>
  188. /// 进位方式
  189. /// </summary>
  190. public string RECEIVE_MANTISSA_TYPE_ID
  191. {
  192. get
  193. {
  194. return this.TextAccess["RECEIVE_MANTISSA_TYPE_ID"];
  195. }
  196. set
  197. {
  198. this.TextAccess["RECEIVE_MANTISSA_TYPE_ID"] = value;
  199. }
  200. }
  201. /// <summary>
  202. /// 备注
  203. /// </summary>
  204. public string REAMRK
  205. {
  206. get
  207. {
  208. return this.TextAccess["REAMRK"];
  209. }
  210. set
  211. {
  212. this.TextAccess["REAMRK"] = value;
  213. }
  214. }
  215. /// <summary>
  216. /// 创建人
  217. /// </summary>
  218. public string CREATE_USER
  219. {
  220. get
  221. {
  222. return this.TextAccess["CREATE_USER"];
  223. }
  224. set
  225. {
  226. this.TextAccess["CREATE_USER"] = value;
  227. }
  228. }
  229. /// <summary>
  230. /// 创建日期
  231. /// </summary>
  232. public System.Nullable<DateTime> CREATE_DATE
  233. {
  234. get
  235. {
  236. return this.DateAccess["CREATE_DATE"];
  237. }
  238. set
  239. {
  240. this.DateAccess["CREATE_DATE"] = value;
  241. }
  242. }
  243. /// <summary>
  244. /// 修改人
  245. /// </summary>
  246. public string UPDATE_USER
  247. {
  248. get
  249. {
  250. return this.TextAccess["UPDATE_USER"];
  251. }
  252. set
  253. {
  254. this.TextAccess["UPDATE_USER"] = value;
  255. }
  256. }
  257. /// <summary>
  258. /// 修改日期
  259. /// </summary>
  260. public System.Nullable<DateTime> UPDATE_DATE
  261. {
  262. get
  263. {
  264. return this.DateAccess["UPDATE_DATE"];
  265. }
  266. set
  267. {
  268. this.DateAccess["UPDATE_DATE"] = value;
  269. }
  270. }
  271. /// <summary>
  272. /// 创建人真实姓名
  273. /// </summary>
  274. public string CREATE_USER_NAME
  275. {
  276. get
  277. {
  278. return this.TextAccess["CREATE_USER_NAME"];
  279. }
  280. set
  281. {
  282. this.TextAccess["CREATE_USER_NAME"] = value;
  283. }
  284. }
  285. /// <summary>
  286. /// 更新人真是姓名
  287. /// </summary>
  288. public string UPDATE_USER_NAME
  289. {
  290. get
  291. {
  292. return this.TextAccess["UPDATE_USER_NAME"];
  293. }
  294. set
  295. {
  296. this.TextAccess["UPDATE_USER_NAME"] = value;
  297. }
  298. }
  299. /// <summary>
  300. /// 集团代码
  301. /// </summary>
  302. public string GROUP_CODE
  303. {
  304. get
  305. {
  306. return this.TextAccess["GROUP_CODE"];
  307. }
  308. set
  309. {
  310. this.TextAccess["GROUP_CODE"] = value;
  311. }
  312. }
  313. /// <summary>
  314. /// 集团名称
  315. /// </summary>
  316. public string GROUP_NAME
  317. {
  318. get
  319. {
  320. return this.TextAccess["GROUP_NAME"];
  321. }
  322. set
  323. {
  324. this.TextAccess["GROUP_NAME"] = value;
  325. }
  326. }
  327. /// <summary>
  328. /// 公司代码
  329. /// </summary>
  330. public string COMPANY_CODE
  331. {
  332. get
  333. {
  334. return this.TextAccess["COMPANY_CODE"];
  335. }
  336. set
  337. {
  338. this.TextAccess["COMPANY_CODE"] = value;
  339. }
  340. }
  341. /// <summary>
  342. /// 公司名称
  343. /// </summary>
  344. public string COMPANY_NAME
  345. {
  346. get
  347. {
  348. return this.TextAccess["COMPANY_NAME"];
  349. }
  350. set
  351. {
  352. this.TextAccess["COMPANY_NAME"] = value;
  353. }
  354. }
  355. /// <summary>
  356. /// 组织代码
  357. /// </summary>
  358. public string NODE_CODE
  359. {
  360. get
  361. {
  362. return this.TextAccess["NODE_CODE"];
  363. }
  364. set
  365. {
  366. this.TextAccess["NODE_CODE"] = value;
  367. }
  368. }
  369. /// <summary>
  370. /// 组织名称
  371. /// </summary>
  372. public string NODE_NAME
  373. {
  374. get
  375. {
  376. return this.TextAccess["NODE_NAME"];
  377. }
  378. set
  379. {
  380. this.TextAccess["NODE_NAME"] = value;
  381. }
  382. }
  383. #endregion
  384. #region Query Method
  385. public BD_MOUDLE_BODY SingleOrDefault()
  386. {
  387. return new EntityBuilder<BD_MOUDLE_BODY>().ToEntityBySql(this.SQLSelect);
  388. }
  389. public BD_MOUDLE_BODY SingleOrDefault(object ts)
  390. {
  391. return new EntityBuilder<BD_MOUDLE_BODY>().ToEntityBySql(this.SQLSelect, ts);
  392. }
  393. public List<BD_MOUDLE_BODY> ToList()
  394. {
  395. return new EntityBuilder<BD_MOUDLE_BODY>().ToListBySql(this.SQLSelect);
  396. }
  397. public List<BD_MOUDLE_BODY> ToList(object ts)
  398. {
  399. return new EntityBuilder<BD_MOUDLE_BODY>().ToListBySql(this.SQLSelect, ts);
  400. }
  401. public static BD_MOUDLE_BODY SingleOrDefault(string sql)
  402. {
  403. return SingleOrDefault(sql, null);
  404. }
  405. public static BD_MOUDLE_BODY SingleOrDefault(string sql,object ts)
  406. {
  407. List<BD_MOUDLE_BODY> list = ToListBySql(sql, ts);
  408. if (list.Count == 0) return null;
  409. else
  410. {
  411. return list[0];
  412. }
  413. }
  414. public static List<BD_MOUDLE_BODY> ToListBySql(string sql)
  415. {
  416. return ToListBySql(sql, null);
  417. }
  418. public static List<BD_MOUDLE_BODY> ToListBySql(string sql, object ts)
  419. {
  420. return new EntityBuilder<BD_MOUDLE_BODY>().ToListBySql(sql, ts);
  421. }
  422. public static List<BD_MOUDLE_BODY> ToList(DataTable data)
  423. {
  424. return new EntityBuilder<BD_MOUDLE_BODY>().ToList(data);
  425. }
  426. #endregion
  427. public static TDAL<BD_MOUDLE_BODY, BD_MOUDLE_BODY_FIELD> DAL
  428. {
  429. get
  430. {
  431. return new TDAL<BD_MOUDLE_BODY, BD_MOUDLE_BODY_FIELD>();
  432. }
  433. }
  434. public static BD_MOUDLE_BODY_FIELD Fields
  435. {
  436. get { return BD_MOUDLE_BODY_FIELD.Instance; }
  437. }
  438. public static EntityBuilder<BD_MOUDLE_BODY> EntityBuilder = new EntityBuilder<BD_MOUDLE_BODY>();
  439. }
  440. internal class BD_MOUDLE_BODY_COLUMN : BaseColumn
  441. {
  442. public static BD_MOUDLE_BODY_COLUMN Instance;
  443. static BD_MOUDLE_BODY_COLUMN()
  444. {
  445. Instance = new BD_MOUDLE_BODY_COLUMN();
  446. }
  447. private BD_MOUDLE_BODY_COLUMN()
  448. {
  449. base.ListColumn.Add(new ColumnInfo() { Name = "GUID", Type = "TEXT" ,NText=false });
  450. base.ListColumn.Add(new ColumnInfo() { Name = "HEAD_GUID", Type = "TEXT" ,NText=false });
  451. base.ListColumn.Add(new ColumnInfo() { Name = "SERVICE_ID", Type = "TEXT" ,NText=false });
  452. base.ListColumn.Add(new ColumnInfo() { Name = "CUSTOM_CODE", Type = "TEXT" ,NText=false });
  453. base.ListColumn.Add(new ColumnInfo() { Name = "CUSTOM_NAME", Type = "TEXT" ,NText=false });
  454. base.ListColumn.Add(new ColumnInfo() { Name = "RECEIVE_STANDARD_ID", Type = "TEXT" ,NText=false });
  455. base.ListColumn.Add(new ColumnInfo() { Name = "RECEIVE_PRICE", Type = "NUMBER" ,NText=false });
  456. base.ListColumn.Add(new ColumnInfo() { Name = "RECEIVE_CURR_ID", Type = "TEXT" ,NText=false });
  457. base.ListColumn.Add(new ColumnInfo() { Name = "RECEIVE_MIN", Type = "NUMBER" ,NText=false });
  458. base.ListColumn.Add(new ColumnInfo() { Name = "RECEIVE_MAX", Type = "NUMBER" ,NText=false });
  459. base.ListColumn.Add(new ColumnInfo() { Name = "DECIMAL_LENGTH", Type = "NUMBER" ,NText=false });
  460. base.ListColumn.Add(new ColumnInfo() { Name = "RECEIVE_MANTISSA_TYPE_ID", Type = "TEXT" ,NText=false });
  461. base.ListColumn.Add(new ColumnInfo() { Name = "REAMRK", Type = "TEXT" ,NText=false });
  462. base.ListColumn.Add(new ColumnInfo() { Name = "CREATE_USER", Type = "TEXT" ,NText=true });
  463. base.ListColumn.Add(new ColumnInfo() { Name = "CREATE_DATE", Type = "DATE" ,NText=false });
  464. base.ListColumn.Add(new ColumnInfo() { Name = "UPDATE_USER", Type = "TEXT" ,NText=true });
  465. base.ListColumn.Add(new ColumnInfo() { Name = "UPDATE_DATE", Type = "DATE" ,NText=false });
  466. base.ListColumn.Add(new ColumnInfo() { Name = "CREATE_USER_NAME", Type = "TEXT" ,NText=false });
  467. base.ListColumn.Add(new ColumnInfo() { Name = "UPDATE_USER_NAME", Type = "TEXT" ,NText=false });
  468. base.ListColumn.Add(new ColumnInfo() { Name = "GROUP_CODE", Type = "TEXT" ,NText=false });
  469. base.ListColumn.Add(new ColumnInfo() { Name = "GROUP_NAME", Type = "TEXT" ,NText=false });
  470. base.ListColumn.Add(new ColumnInfo() { Name = "COMPANY_CODE", Type = "TEXT" ,NText=false });
  471. base.ListColumn.Add(new ColumnInfo() { Name = "COMPANY_NAME", Type = "TEXT" ,NText=false });
  472. base.ListColumn.Add(new ColumnInfo() { Name = "NODE_CODE", Type = "TEXT" ,NText=false });
  473. base.ListColumn.Add(new ColumnInfo() { Name = "NODE_NAME", Type = "TEXT" ,NText=false });
  474. }
  475. }
  476. public class BD_MOUDLE_BODY_FIELD
  477. {
  478. private static BD_MOUDLE_BODY_FIELD instance;
  479. public static BD_MOUDLE_BODY_FIELD Instance
  480. {
  481. get
  482. {
  483. if (instance == null)
  484. {
  485. instance = new BD_MOUDLE_BODY_FIELD();
  486. }
  487. return instance;
  488. }
  489. }
  490. public readonly string GUID = "GUID";
  491. public readonly string HEAD_GUID = "HEAD_GUID";
  492. public readonly string SERVICE_ID = "SERVICE_ID";
  493. public readonly string CUSTOM_CODE = "CUSTOM_CODE";
  494. public readonly string CUSTOM_NAME = "CUSTOM_NAME";
  495. public readonly string RECEIVE_STANDARD_ID = "RECEIVE_STANDARD_ID";
  496. public readonly string RECEIVE_PRICE = "RECEIVE_PRICE";
  497. public readonly string RECEIVE_CURR_ID = "RECEIVE_CURR_ID";
  498. public readonly string RECEIVE_MIN = "RECEIVE_MIN";
  499. public readonly string RECEIVE_MAX = "RECEIVE_MAX";
  500. public readonly string DECIMAL_LENGTH = "DECIMAL_LENGTH";
  501. public readonly string RECEIVE_MANTISSA_TYPE_ID = "RECEIVE_MANTISSA_TYPE_ID";
  502. public readonly string REAMRK = "REAMRK";
  503. public readonly string CREATE_USER = "CREATE_USER";
  504. public readonly string CREATE_DATE = "CREATE_DATE";
  505. public readonly string UPDATE_USER = "UPDATE_USER";
  506. public readonly string UPDATE_DATE = "UPDATE_DATE";
  507. public readonly string CREATE_USER_NAME = "CREATE_USER_NAME";
  508. public readonly string UPDATE_USER_NAME = "UPDATE_USER_NAME";
  509. public readonly string GROUP_CODE = "GROUP_CODE";
  510. public readonly string GROUP_NAME = "GROUP_NAME";
  511. public readonly string COMPANY_CODE = "COMPANY_CODE";
  512. public readonly string COMPANY_NAME = "COMPANY_NAME";
  513. public readonly string NODE_CODE = "NODE_CODE";
  514. public readonly string NODE_NAME = "NODE_NAME";
  515. }
  516. }