TbColumnAndCaption.cs 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Data;
  6. using CoreFS.CA06;
  7. using System.ComponentModel;
  8. using System.Drawing;
  9. using System.Windows.Forms;
  10. using Infragistics.Win.UltraWinGrid;
  11. using System.Collections;
  12. namespace Core.StlMes.Client.Sale.UI.Balance.StaticData
  13. {
  14. public class TbColumnAndCaption
  15. {
  16. public static Hashtable GetDataSetColumnLength()
  17. {
  18. Hashtable hs = new Hashtable();
  19. hs.Add("OUTSTOCKMNY",80);
  20. hs.Add("TRANSMNY", 120);
  21. hs.Add(ORD_SEQ, 50);
  22. hs.Add(ORD_LN_DLY, 50);
  23. hs.Add(ISPRECLOSE, 50);
  24. hs.Add("SHIPNO", 80);
  25. hs.Add("SHIPPRICE", 70);
  26. hs.Add("ORD_NO", 100);
  27. hs.Add("ASKPLAN_ID", 100);
  28. hs.Add("MONEY", 80);
  29. hs.Add("PRICE", 70);
  30. hs.Add("SPETKEY", 100);
  31. hs.Add("STEELCODEKEY", 70);
  32. hs.Add("ADJUSTPRICEPERSON", 80);
  33. hs.Add("ADJUSTPRICEREASON", 60);
  34. hs.Add("AFFIRMPERSON", 80);
  35. hs.Add("AFFIRMTIME", 80);
  36. hs.Add("TICKETTYPE", 60);
  37. hs.Add("TICKETNUM", 60);
  38. hs.Add("MONEY_TYPE", 80);
  39. hs.Add("TRANS_TYPE", 60);
  40. hs.Add("MOTORMANNAME", 100);
  41. hs.Add("REG_ID", 80);
  42. hs.Add("REG_DTIME", 80);
  43. hs.Add("AFFRIM_ID", 80);
  44. hs.Add("AFFRIM_TIME", 80);
  45. hs.Add("TALLYSHEET_NO", 120);
  46. hs.Add("BATCH_NO", 100);
  47. hs.Add("QUANTITY", 50);
  48. hs.Add("WEIGHT", 60);
  49. hs.Add("ACT_WGT", 70);
  50. hs.Add("BUYERCODE",150);
  51. hs.Add("BUYERNAME",150);
  52. hs.Add("INVOICENO_ORG", 150);
  53. hs.Add("FST_DRAWEE_UNIT", 150);
  54. hs.Add("CUSTOMER_NO", 150);
  55. hs.Add("CUSTOMER_NM", 150);
  56. hs.Add("RECEIV_NO", 150);
  57. hs.Add("RECEIV_NM", 150);
  58. hs.Add("MODEL_DESC", 50);
  59. hs.Add("CONTAIN_TAX", 50);
  60. hs.Add("SEND_NUM", 70);
  61. hs.Add("ORDER_UNIT", 50);
  62. hs.Add("OUTWEIGHT", 80);
  63. hs.Add("LISTNUMBER", 120);
  64. return hs;
  65. }
  66. public static Hashtable GetDataSetColumnType()
  67. {
  68. Hashtable hs = new Hashtable();
  69. hs.Add("SELECT", "System.Boolean");
  70. hs.Add("TRANSMNY", "System.Decimal");
  71. hs.Add("MONEY", "System.Decimal");
  72. hs.Add("TICKETNUM", "System.Decimal");
  73. hs.Add("TRANSNUM", "System.Decimal");
  74. hs.Add("QUANTITY", "System.Decimal");
  75. hs.Add("WEIGHT", "System.Decimal");
  76. hs.Add("OUTSTOCKMNY", "System.Decimal");
  77. hs.Add("SEND_NUM", "System.Decimal");
  78. return hs;
  79. }
  80. public static Hashtable GetColumnAndCaption()
  81. {
  82. Hashtable hs = new Hashtable();
  83. hs.Add("SHIPNO", "船号");
  84. hs.Add("BUYERCODE", "结算单位编码");
  85. hs.Add("BUYERNAME", "结算单位");
  86. hs.Add("INCEPTCORPCODE", "收货单位");
  87. hs.Add("QUANTITY", "支数");
  88. hs.Add("WEIGHT", "重量");
  89. hs.Add("MONEY", "金额");
  90. hs.Add("OUTSTOCKMNY", "吊装费");
  91. hs.Add("TRANSMNY", "运费");
  92. hs.Add("ISPRECLOSE", "划断");
  93. hs.Add("ORD_NO", "合同号");
  94. hs.Add("ORD_SEQ", "合同行");
  95. hs.Add("ORD_LN_DLY", "交货行");
  96. hs.Add("SPETKEY", "规格");
  97. hs.Add("STEELCODEKEY", " 钢级(牌号)");
  98. hs.Add("PRICE", "单价");
  99. hs.Add("AFFRIMPERSON", "确认人");
  100. hs.Add("AFFIRMTIME", "确认时间");
  101. hs.Add("BASEPRICE", "订单价");
  102. hs.Add("FORECORPCODE", "子公司");
  103. hs.Add("STATIONCODE", "到站");
  104. hs.Add("TALLYSHEET_NO", "理货单");
  105. hs.Add("BATCH_NO", " 炉批号");
  106. hs.Add("ACT_WGT", "重量");
  107. hs.Add("TICKETTYPE", "类型");
  108. hs.Add("TICKETNUM", "票据数");
  109. hs.Add("TRANS_TYPE", "运输类型");
  110. hs.Add("MOTORMANNAME", "承运公司");
  111. hs.Add("REG_ID", "维护人");
  112. hs.Add("REG_DTIME", "维护时间");
  113. hs.Add("AFFRIM_ID", "确认人");
  114. hs.Add("AFFRIM_TIME", "确认时间");
  115. hs.Add("MONEY_TYPE", "费用类型");
  116. hs.Add("ASKPLAN_ID", "提单号");
  117. hs.Add("TRANS_TYPE_NAME", "运输方式");
  118. hs.Add("REALINVOICENO_ORG", "首次真实发票号");
  119. hs.Add("REALINVOICENO", "末次真实发票号");
  120. hs.Add("INVOICENO", "末次结算单号");
  121. hs.Add("MONEY_ORG", "首次结算金额");
  122. hs.Add("PRICE_ORG", "单价");
  123. hs.Add("INVOICENO_ORG", "结算单号");
  124. hs.Add("INVOICENO_SEQ_ORG", "序号");
  125. hs.Add("TICKETPERSON", "确认人");
  126. hs.Add("TICKETDATE", "确认时间");
  127. hs.Add("CATEGORY", "品名");
  128. hs.Add("SPEC_ABBSYMNAME", "标准");
  129. hs.Add("STD_STYLE_DESC", "标准类别");
  130. hs.Add("MODEL_DESC", "扣型");
  131. hs.Add("ORDER_UNIT", "计量单位");
  132. hs.Add("SALE_AREA_DESC", "销售区域");
  133. hs.Add("SEND_NUM", "实发量");
  134. hs.Add("RECEIV_ADDR", "指定地址");
  135. hs.Add("DELVRY_ADDR", "交货地点");
  136. hs.Add("AGENCY_FL", "是否代办");
  137. hs.Add("ISREALCLOSE", "虚单关闭状态");
  138. hs.Add("TICKETSTATUS", "提单是否确认");
  139. hs.Add("INVOICEPERSON_ORG", "首次编单人");
  140. hs.Add("INVOICEDATE_ORG", "首次编单时间");
  141. hs.Add("INVOICEPERSON", "末次编单人");
  142. hs.Add("INVOICEDATE", "末次编单时间");
  143. hs.Add("CONTAIN_TAX", "是否含税");
  144. hs.Add("REALINVOICENO_DATE", "发票时间");
  145. hs.Add("REALINVOICENO_DATE_ORG", "发票时间");
  146. hs.Add("SUPPLY_UNIT_DESC", "制造商");
  147. return hs;
  148. }
  149. public static string ORD_LEN = "ORD_LEN";
  150. public static string CATEGORY = "CATEGORY";
  151. public static string ISPOSTER = "ISPOSTER";
  152. public static string ISNEWCHECKORG = "ISNEWCHECKORG";
  153. public static string HEIGHTJD = "HEIGHTJD";
  154. public static string IS_KP = "IS_KP";
  155. public static string CRK_CD3 = "CRK_CD3";
  156. public static string TRS_MNY_SY_DS = "TRS_MNY_SY_DS";
  157. public static string BUYERNAME = "BUYERNAME";
  158. public static string PLID = "PLID";
  159. public static string PRODLINE = "PRODLINE";
  160. public static string STATIONNAME = "STATIONNAME";
  161. public static string PRD_WIDHT = "PRD_WIDHT";
  162. public static string INVOICEDATE = "INVOICEDATE";
  163. public static string AFFRIMPERSON = "AFFRIMPERSON";
  164. public static string PRODUCTLINE = "PRODUCTLINE";
  165. public static string INVOICENOZ = "INVOICENOZ";
  166. public static string CARFMONEY = "CARFMONEY";
  167. public static string DOCKNAME = "DOCKNAME";
  168. public static string ISAREACODE = "ISAREACODE";
  169. public static string ISOUT = "ISOUT";
  170. public static string ISCLEAR = "ISCLEAR";
  171. public static string SPETKEY = "SPETKEY";
  172. public static string ACT_LEN_MIN = "ACT_LEN_MIN";
  173. public static string MODEL_DESC = "MODEL_DESC";
  174. public static string PRD_QTY = "PRD_QTY";
  175. public static string CATEGORYNAME = "CATEGORYNAME";
  176. public static string STEELNAME = "STEELNAME";
  177. public static string SAMPLINGREQUEST = "SAMPLINGREQUEST";
  178. public static string GWTEMP = "GWTEMP";
  179. public static string DDL = "DDL";
  180. public static string SND_STATUS = "SND_STATUS";
  181. public static string FIXSIZE = "FIXSIZE";
  182. public static string ISPINZ = "ISPINZ";
  183. public static string CASTPROCESS = "CASTPROCESS";
  184. public static string TRS_MNY_HY = "TRS_MNY_HY";
  185. public static string PRICE = "PRICE";
  186. public static string REG_ID = "REG_ID";
  187. public static string REG_DTIME = "REG_DTIME";
  188. public static string MOD_ID = "MOD_ID";
  189. public static string NCSTION = "NCSTION";
  190. public static string SND_CITY = "SND_CITY";
  191. public static string ORD_NO = "ORD_NO";
  192. public static string PRD_TYPE = "PRD_TYPE";
  193. public static string PLANDATE = "PLANDATE";
  194. public static string SND_DEPT = "SND_DEPT";
  195. public static string TRANS_TYPE_NAME = "TRANS_TYPE_NAME";
  196. public static string MOTORMANNAME_DESC = "MOTORMANNAME_DESC";
  197. public static string STATIONCODE = "STATIONCODE";
  198. public static string SPET = "SPET";
  199. public static string LENGTH = "LENGTH";
  200. public static string PRD_PLY = "PRD_PLY";
  201. public static string PRD_LENGTH = "PRD_LENGTH";
  202. public static string QUANTITY = "QUANTITY";
  203. public static string WEIGHT = "WEIGHT";
  204. public static string INVOICEPERSON = "INVOICEPERSON";
  205. public static string BALANCESTATUS = "BALANCESTATUS";
  206. public static string ADJUSTPRICEPERSON = "ADJUSTPRICEPERSON";
  207. public static string TRAINREMARK = "TRAINREMARK";
  208. public static string DECRDATE = "DECRDATE";
  209. public static string ISPRECLOSE = "ISPRECLOSE";
  210. public static string PRD_OUTDIA = "PRD_OUTDIA";
  211. public static string MODEL_CODE = "MODEL_CODE";
  212. public static string CJ_TEMP = "CJ_TEMP";
  213. public static string FIXSIZE_DESC = "FIXSIZE_DESC";
  214. public static string FIX_TYPE = "FIX_TYPE";
  215. public static string CUTSIDESTATE = "CUTSIDESTATE";
  216. public static string ZJQUANTITY = "ZJQUANTITY";
  217. public static string TOT_DEC_RSLT_CD = "TOT_DEC_RSLT_CD";
  218. public static string TRS_MNY_HY_DS = "TRS_MNY_HY_DS";
  219. public static string ISTEST = "ISTEST";
  220. public static string ORD_PRICE = "ORD_PRICE";
  221. public static string STATUS_CD = "STATUS_CD";
  222. public static string LISTNUMBER = "LISTNUMBER";
  223. public static string PACTINDEX = "PACTINDEX";
  224. public static string BUYERKINDCODE = "BUYERKINDCODE";
  225. public static string PRD_ROLL_DTIME = "PRD_ROLL_DTIME";
  226. public static string SND_LOCATION = "SND_LOCATION";
  227. public static string BLN_BUYER = "BLN_BUYER";
  228. public static string BLN_BUYERNAME = "BLN_BUYERNAME";
  229. public static string LEASEDLINE = "LEASEDLINE";
  230. public static string LEASEDLINENAME = "LEASEDLINENAME";
  231. public static string DELIVY_PLACE_NAME = "DELIVY_PLACE_NAME";
  232. public static string MONEY = "MONEY";
  233. public static string TICKETPERSON = "TICKETPERSON";
  234. public static string BASEPRICE = "BASEPRICE";
  235. public static string ISWATERCARRIAGE = "ISWATERCARRIAGE";
  236. public static string ZYFMONEY = "ZYFMONEY";
  237. public static string TALLYSHEET_NO = "TALLYSHEET_NO";
  238. public static string SENDBEGINDATE = "SENDBEGINDATE";
  239. public static string ORD_OUTDIA = "ORD_OUTDIA";
  240. public static string ONEWEIGHT = "ONEWEIGHT";
  241. public static string ACT_LEN_MAX = "ACT_LEN_MAX";
  242. public static string PRD_INDIA = "PRD_INDIA";
  243. public static string STEELCODE = "STEELCODE";
  244. public static string STEELCODEDJ = "STEELCODEDJ";
  245. public static string CHK_ORG = "CHK_ORG";
  246. public static string ISTS = "ISTS";
  247. public static string BCFLAG = "BCFLAG";
  248. public static string KPWIDTH = "KPWIDTH";
  249. public static string XG_CRET_NO = "XG_CRET_NO";
  250. public static string TRS_MNY = "TRS_MNY";
  251. public static string TRS_MNY_SY = "TRS_MNY_SY";
  252. public static string MINTOLERANCE = "MINTOLERANCE";
  253. public static string INV_NO = "INV_NO";
  254. public static string ASKPLAN_ID_SEQ = "ASKPLAN_ID_SEQ";
  255. public static string LOADVEHICLE_NO = "LOADVEHICLE_NO";
  256. public static string TRANS_CAR_NO = "TRANS_CAR_NO";
  257. public static string SND_DTIME = "SND_DTIME";
  258. public static string TRAN_CAR_TYPE = "TRAN_CAR_TYPE";
  259. public static string ISWATERCARRAGE = "ISWATERCARRAGE";
  260. public static string MONEY_ORG = "MONEY_ORG";
  261. public static string INVOICENO_ORG = "INVOICENO_ORG";
  262. public static string INVOICENO_SEQ_ORG = "INVOICENO_SEQ_ORG";
  263. public static string ADJUSTPRICEREASON = "ADJUSTPRICEREASON";
  264. public static string REALINVOICENO_DATE = "REALINVOICENO_DATE";
  265. public static string ISCHECKSCAR = "ISCHECKSCAR";
  266. public static string INVOICETRANSMONEY = "INVOICETRANSMONEY";
  267. public static string ADJUPRICEFILE = "ADJUPRICEFILE";
  268. public static string VINVOICEFLAG = "VINVOICEFLAG";
  269. public static string FST_DRAWEE_UNIT = "FST_DRAWEE_UNIT";
  270. public static string PLANT = "PLANT";
  271. public static string ORD_INDIA = "ORD_INDIA";
  272. public static string PACT_SPY_WEIGHT = "PACT_SPY_WEIGHT";
  273. public static string DIAMTER = "DIAMTER";
  274. public static string PRD_WTH = "PRD_WTH";
  275. public static string PD_NAME = "PD_NAME";
  276. public static string DR_TS = "DR_TS";
  277. public static string CHECKORG_FL = "CHECKORG_FL";
  278. public static string CJS_GS = "CJS_GS";
  279. public static string ISOVERLEN = "ISOVERLEN";
  280. public static string TRUN_SPETKEY = "TRUN_SPETKEY";
  281. public static string TESTPRICE = "TESTPRICE";
  282. public static string PZORDWEIGTH = "PZORDWEIGTH";
  283. public static string DYORD_WEI = "DYORD_WEI";
  284. public static string PRD_ID = "PRD_ID";
  285. public static string FORECORPNAME = "FORECORPNAME";
  286. public static string SLAB_NO = "SLAB_NO";
  287. public static string RECV_UNIT_TYPE = "RECV_UNIT_TYPE";
  288. public static string AFFIRMTIME = "AFFIRMTIME";
  289. public static string PRICE_ORG = "PRICE_ORG";
  290. public static string REMARK = "REMARK";
  291. public static string ISHEAT = "ISHEAT";
  292. public static string DOCKCODE = "DOCKCODE";
  293. public static string CHECKORG = "CHECKORG";
  294. public static string TRANSMONEYSY1 = "TRANSMONEYSY1";
  295. public static string AREACODE = "AREACODE";
  296. public static string PLANT_DESC = "PLANT_DESC";
  297. public static string PSPETKEY = "PSPETKEY";
  298. public static string ORD_THK = "ORD_THK";
  299. public static string PD_TYPE = "PD_TYPE";
  300. public static string STEELCODEKEY = "STEELCODEKEY";
  301. public static string SPEC_NAME = "SPEC_NAME";
  302. public static string MLHH = "MLHH";
  303. public static string JBGCDJ = "JBGCDJ";
  304. public static string CHECKORGDJ = "CHECKORGDJ";
  305. public static string DTMR_GRD = "DTMR_GRD";
  306. public static string DTMR_RSLT = "DTMR_RSLT";
  307. public static string SUANXI = "SUANXI";
  308. public static string CRK_CD2 = "CRK_CD2";
  309. public static string PACKAGE_LEVEL = "PACKAGE_LEVEL";
  310. public static string TRS_MNY_QY = "TRS_MNY_QY";
  311. public static string LOADDOCK = "LOADDOCK";
  312. public static string UNLOADDOCK = "UNLOADDOCK";
  313. public static string PLY = "PLY";
  314. public static string WIDTH = "WIDTH";
  315. public static string AFFRIMPERSON_ORG = "AFFRIMPERSON_ORG";
  316. public static string AFFIRMTIME_ORG = "AFFIRMTIME_ORG";
  317. public static string PICKSTORAGETIME = "PICKSTORAGETIME";
  318. public static string PRICE_INPUTPERSON_ORG = "PRICE_INPUTPERSON_ORG";
  319. public static string PRICE_PRE_ORG = "PRICE_PRE_ORG";
  320. public static string TRANSMONEY = "TRANSMONEY";
  321. public static string ISREPLAN = "ISREPLAN";
  322. public static string TZRSON = "TZRSON";
  323. public static string ISSHENNENI = "ISSHENNENI";
  324. public static string ISLOCKPRICE = "ISLOCKPRICE";
  325. public static string ORD_WTH = "ORD_WTH";
  326. public static string PRD_LEN = "PRD_LEN";
  327. public static string CAL_WGT = "CAL_WGT";
  328. public static string SPEC_ABBSYMNAME = "SPEC_ABBSYMNAME";
  329. public static string KHIC = "KHIC";
  330. public static string HDG = "HDG";
  331. public static string ZPOSTER = "ZPOSTER";
  332. public static string PLYJD = "PLYJD";
  333. public static string EXTSHAPE_DEC_GRD = "EXTSHAPE_DEC_GRD";
  334. public static string APRC_DEC_RSLT = "APRC_DEC_RSLT";
  335. public static string CRK_CD1 = "CRK_CD1";
  336. public static string TOT_DEC_RSLT = "TOT_DEC_RSLT";
  337. public static string TEST_ID = "TEST_ID";
  338. public static string OLADIV = "OLADIV";
  339. public static string ORD_SEQ = "ORD_SEQ";
  340. public static string BUYERCODE = "BUYERCODE";
  341. public static string BUYERKINDNAME = "BUYERKINDNAME";
  342. public static string FORECORPCODE = "FORECORPCODE";
  343. public static string SND_REMARK = "SND_REMARK";
  344. public static string BLN_DEPT = "BLN_DEPT";
  345. public static string RECV_UNIT = "RECV_UNIT";
  346. public static string TRANS_TYPE = "TRANS_TYPE";
  347. public static string MOTORMANNAME = "MOTORMANNAME";
  348. public static string INVOICENO_SEQ = "INVOICENO_SEQ";
  349. public static string BALANCESTATUS_ORG = "BALANCESTATUS_ORG";
  350. public static string PRICE_INPUTPEDATE = "PRICE_INPUTPEDATE";
  351. public static string PRICE_INPUTPEDATE_ORG = "PRICE_INPUTPEDATE_ORG";
  352. public static string REALINVOICENO = "REALINVOICENO";
  353. public static string TICKETDATE = "TICKETDATE";
  354. public static string INCEPTCORPCODE = "INCEPTCORPCODE";
  355. public static string CLEARFLAG = "CLEARFLAG";
  356. public static string BALANCENO = "BALANCENO";
  357. public static string STANDROLLER = "STANDROLLER";
  358. public static string TZDATE = "TZDATE";
  359. public static string TJYY = "TJYY";
  360. public static string TRANSMONEYQC = "TRANSMONEYQC";
  361. public static string BATCH_NO = "BATCH_NO";
  362. public static string ORD_STL = "ORD_STL";
  363. public static string ORD_WGT = "ORD_WGT";
  364. public static string PRD_THK = "PRD_THK";
  365. public static string ACT_WGT = "ACT_WGT";
  366. public static string SPEC_ABBSYM = "SPEC_ABBSYM";
  367. public static string SPEC_CODE = "SPEC_CODE";
  368. public static string PM_PZ = "PM_PZ";
  369. public static string CUTSIDESTATE_DESC = "CUTSIDESTATE_DESC";
  370. public static string WIDTH_10MM = "WIDTH_10MM";
  371. public static string RCL_STATE = "RCL_STATE";
  372. public static string ZJHEIGHT = "ZJHEIGHT";
  373. public static string PACKAGE_FL = "PACKAGE_FL";
  374. public static string SAL_PRC = "SAL_PRC";
  375. public static string TRS_MNY_QY_DS = "TRS_MNY_QY_DS";
  376. public static string MOD_DTIME = "MOD_DTIME";
  377. public static string ASKPLAN_ID = "ASKPLAN_ID";
  378. public static string ORD_LN_DLY = "ORD_LN_DLY";
  379. public static string SND_TYPE = "SND_TYPE";
  380. public static string RP_RECV_UNIT = "RP_RECV_UNIT";
  381. public static string DELIVY_PLACE_CODE = "DELIVY_PLACE_CODE";
  382. public static string INVOICENO = "INVOICENO";
  383. public static string INVOICEPERSON_ORG = "INVOICEPERSON_ORG";
  384. public static string INVOICEDATE_ORG = "INVOICEDATE_ORG";
  385. public static string PRICE_INPUTPERSON = "PRICE_INPUTPERSON";
  386. public static string PRICE_PRE = "PRICE_PRE";
  387. public static string BASEPRICEFILE = "BASEPRICEFILE";
  388. public static string DECRERSON = "DECRERSON";
  389. public static string ISINVOICENOLOCKED = "ISINVOICENOLOCKED";
  390. public static string TICKETSTATUS = "TICKETSTATUS";
  391. }
  392. }