hs.Add(1,new string[]{"INPUT_WGT","录入重量","System.Double","60"}); hs.Add(2,new string[]{"PROD_LINE","产线编码","System.String","60"}); hs.Add(3,new string[]{"SPEC_ABBSYM","标准号","System.String","60"}); hs.Add(4,new string[]{"STEEL_CODE","牌号","System.String","60"}); hs.Add(5,new string[]{"USED_CD","用途","System.String","60"}); hs.Add(6,new string[]{"PRDNM_CD","交货状态","System.String","60"}); hs.Add(7,new string[]{"ISALPHA","是否Alpha(N/Y)","System.String","60"}); hs.Add(8,new string[]{"CUST_ALPHA_NO","客户Alpha编号","System.String","60"}); hs.Add(9,new string[]{"QUALITY_DESIGH_RESULT","品质设计结果","System.String","60"}); hs.Add(10,new string[]{"QUALITY_DESIGH_ERRMSG","品质设计错误信息","System.String","60"}); hs.Add(11,new string[]{"QUALITY_DESIGH_NAME","品质设计人","System.String","60"}); hs.Add(12,new string[]{"QUALITY_DESIGH_DATE","品质设计时间","System.DateTime","60"}); hs.Add(13,new string[]{"ORD_SEND_WGT","发货量","System.Double","60"}); hs.Add(14,new string[]{"ORD_INVOICE_WGT","结算量","System.Double","60"}); hs.Add(15,new string[]{"DELVRY_DATE","交货日期","System.DateTime","60"}); hs.Add(16,new string[]{"INDEX_SEQ","顺序号","System.String","60"}); hs.Add(17,new string[]{"AGENCY_FL","代办标识","System.String","60"}); hs.Add(18,new string[]{"LV_FACTY_TYP","运输方式","System.String","60"}); hs.Add(19,new string[]{"TRANSIT_TYP","运输方式","System.String","60"}); hs.Add(20,new string[]{"DESTINATION","目的地","System.String","60"}); hs.Add(21,new string[]{"STATION_NO","到站编码","System.String","60"}); hs.Add(22,new string[]{"STATION_NM","到站名称","System.String","60"}); hs.Add(23,new string[]{"SPCL_LN_NO","专用线编码","System.String","60"}); hs.Add(24,new string[]{"SPCL_LN_NM","专用线名称","System.String","60"}); hs.Add(25,new string[]{"ISOWNEDCAR","是否自备","System.String","60"}); hs.Add(26,new string[]{"ISSHIPPING","是否船运","System.String","60"}); hs.Add(27,new string[]{"PORT_NO","港口/码头","System.String","60"}); hs.Add(28,new string[]{"PORT_DESC","港口/码头描述","System.String","60"}); hs.Add(29,new string[]{"CARRIER_UNIT","承运单位","System.String","60"}); hs.Add(30,new string[]{"INCEPTCORPCODE","收货单位","System.String","60"}); hs.Add(31,new string[]{"REINCEPTCORP","代收单位","System.String","60"}); hs.Add(32,new string[]{"RECEIVOR","接货人","System.String","60"}); hs.Add(33,new string[]{"TRANSIT_LN_MNY","总费用","System.Double","60"}); hs.Add(34,new string[]{"CUSTM_ORDER_NO","客户合同号","System.String","60"}); hs.Add(35,new string[]{"ORDER_TYP","合同类型","System.String","60"}); hs.Add(36,new string[]{"ORDER_TYP_DESC","合同类型描述","System.String","60"}); hs.Add(37,new string[]{"PROTCL_NO","协议号","System.String","60"}); hs.Add(38,new string[]{"CUSTOMER_NO","客户编码","System.String","60"}); hs.Add(39,new string[]{"CUSTOMER_NM","客户名称","System.String","60"}); hs.Add(40,new string[]{"MARKET_SYS","市场系统","System.String","60"}); hs.Add(41,new string[]{"MARKET_SYS_DESC","市场系统描述","System.String","60"}); hs.Add(42,new string[]{"ABRVITION","简称","System.String","60"}); hs.Add(43,new string[]{"SUPPLY_UNIT","供货单位","System.String","60"}); hs.Add(44,new string[]{"PRICE_FL","计价方式","System.String","60"}); hs.Add(45,new string[]{"CURRENCY","币种","System.String","60"}); hs.Add(46,new string[]{"MNY_ASK_TYP","付款方式","System.String","60"}); hs.Add(47,new string[]{"ADVANCEMONEY","预付款金额","System.Double","60"}); hs.Add(48,new string[]{"ADVANCESCALE","预付款比例","System.Double","60"}); hs.Add(49,new string[]{"STLMT_UNIT_NO","结算单位编码","System.String","60"}); hs.Add(50,new string[]{"STLMT_UNIT_NM","结算单位名称","System.String","60"}); hs.Add(51,new string[]{"FST_DRAWEE_UNIT","首次受票人","System.String","60"}); hs.Add(52,new string[]{"LEGAL_PSN","法人","System.String","60"}); hs.Add(53,new string[]{"AGENT","委托代理人","System.String","60"}); hs.Add(54,new string[]{"ADDRESS","地址","System.String","60"}); hs.Add(55,new string[]{"ZIP_CODE","邮编","System.String","60"}); hs.Add(56,new string[]{"BANK","开户银行","System.String","60"}); hs.Add(57,new string[]{"ACCOUNT","帐号","System.String","60"}); hs.Add(58,new string[]{"TAX_ID","税号","System.String","60"}); hs.Add(59,new string[]{"PHONE","电话","System.String","60"}); hs.Add(60,new string[]{"FAX","传真","System.String","60"}); hs.Add(61,new string[]{"ORDER_WGT","合同量","System.Double","60"}); hs.Add(62,new string[]{"ORDER_MNY_TAX","合同总价(含税)","System.Double","60"}); hs.Add(63,new string[]{"ORDER_MNY_NTAX","合同总价(不含税)","System.Double","60"}); hs.Add(64,new string[]{"MNY_ASK_DESC","付款要求描述","System.String","60"}); hs.Add(65,new string[]{"SIGN_PERSON","签订人","System.String","60"}); hs.Add(66,new string[]{"SIGN_DATE","签订日期","System.DateTime","60"}); hs.Add(67,new string[]{"SIGN_ADDRESS","签订地点","System.String","60"}); hs.Add(68,new string[]{"ORDER_YEAR","合同年度","System.String","60"}); hs.Add(69,new string[]{"ORDER_BDATE","合同开始时间","System.DateTime","60"}); hs.Add(70,new string[]{"ORDER_EDATE","合同结束时间","System.DateTime","60"}); hs.Add(71,new string[]{"ORDER_SCAN_NO","合同扫描件编号","System.String","60"}); hs.Add(72,new string[]{"CUSTOMER_MODEL_FL","是否客户范本","System.String","60"}); hs.Add(73,new string[]{"ORDER_MODEL_NO","合同范本编号","System.String","60"}); hs.Add(74,new string[]{"ORDER_MODEL_DESC","合同范本描述","System.String","60"}); hs.Add(75,new string[]{"SALE_ORG","销售组织","System.String","60"}); hs.Add(76,new string[]{"SALE_ORG_DESC","销售组织描述","System.String","60"}); hs.Add(77,new string[]{"SALE_AREA_NO","销售区域编码","System.String","60"}); hs.Add(78,new string[]{"SALE_AREA_DESC","销售区域描述","System.String","60"}); hs.Add(79,new string[]{"ORDER_STS","合同状态","System.String","60"}); hs.Add(80,new string[]{"ORDER_STS_DESC","合同状态描述","System.String","60"}); hs.Add(81,new string[]{"APPROVAL_MAN","审批人","System.String","60"}); hs.Add(82,new string[]{"APPROVAL_TIME","审批时间","System.DateTime","60"}); hs.Add(83,new string[]{"EFFECT_MAN","生效人","System.String","60"}); hs.Add(84,new string[]{"EFFECT_TIME","生效时间","System.DateTime","60"}); hs.Add(85,new string[]{"CLOSE_MAN","结案人","System.String","60"}); hs.Add(86,new string[]{"CLOSE_TIME","结案时间","System.DateTime","60"}); hs.Add(87,new string[]{"CREATE_DEPT","创建人部门","System.String","60"}); hs.Add(88,new string[]{"REGION_NO","地域片区","System.String","60"}); hs.Add(89,new string[]{"TRANSFEE","运费","System.Double","60"}); hs.Add(90,new string[]{"CARTYPE","车种","System.String","60"}); hs.Add(91,new string[]{"KILOMETERS","公里数","System.String","60"}); hs.Add(92,new string[]{"PRAILWAYADMIN","所属路局","System.String","60"}); hs.Add(93,new string[]{"TELEGRAPHCODE","电报码","System.String","60"}); hs.Add(94,new string[]{"GODIRECTCODE","运行方向","System.String","60"}); hs.Add(95,new string[]{"LOADDOCK","装货码头","System.String","60"}); hs.Add(96,new string[]{"UNLOADDOCK","卸货码头","System.String","60"}); hs.Add(97,new string[]{"SERVICECHARGE","劳务费","System.Double","60"}); hs.Add(98,new string[]{"W_TRAN_LINE","水运线路","System.String","60"}); hs.Add(99,new string[]{"C_TRAN_LINE","汽运线路","System.String","60"}); hs.Add(100,new string[]{"ACCEPT_PERSON","收货人","System.String","60"}); hs.Add(101,new string[]{"OWNED_CITY","所属城市","System.String","60"}); hs.Add(102,new string[]{"REMARK","备注","System.String","60"}); hs.Add(103,new string[]{"PERCODE","身份证","System.String","60"}); hs.Add(104,new string[]{"TELCODE","收货人电话","System.String","60"}); hs.Add(105,new string[]{"FORECORPCODE","子公司编码","System.String","60"}); hs.Add(106,new string[]{"FORECORPNAME","驻外公司名称","System.String","60"}); hs.Add(107,new string[]{"PRINCIPAL","负责人","System.String","60"}); hs.Add(108,new string[]{"FORE_TP","类型区分","System.String","60"}); hs.Add(109,new string[]{"REGION_LVL_NO","行政区域级别编码","System.String","60"}); hs.Add(110,new string[]{"REGION_LVL_NM","行政区域级别名称","System.String","60"}); hs.Add(111,new string[]{"REGION_TYPE_NO","行政区域属性编码","System.String","60"}); hs.Add(112,new string[]{"REGION_TYPE_NM","行政区域属性名称","System.String","60"}); hs.Add(113,new string[]{"REGION_NM","行政区域名称","System.String","60"}); hs.Add(114,new string[]{"P_REGION_NO","上级行政区域编码","System.String","60"}); hs.Add(115,new string[]{"REGION_TYPE","行政区域属性","System.String","60"}); hs.Add(116,new string[]{"CAPITAL_FL","是否首都","System.String","60"}); hs.Add(117,new string[]{"PR_CAPITAL_FL","是否省会","System.String","60"}); hs.Add(118,new string[]{"REGION_SEQ","行政区域顺序","System.String","60"}); hs.Add(119,new string[]{"BIGAREA","行政片区","System.String","60"}); hs.Add(120,new string[]{"CUSTM_LVL","客户等级","System.String","60"}); hs.Add(121,new string[]{"ORG","组织机构","System.String","60"}); hs.Add(122,new string[]{"PY","拼音助记","System.String","60"}); hs.Add(123,new string[]{"CUSTM_USE","用途类型","System.String","60"}); hs.Add(124,new string[]{"CHN_FL","国内/国外","System.String","60"}); hs.Add(125,new string[]{"CUSTM_CTGRY","客户类别","System.String","60"}); hs.Add(126,new string[]{"CUSTM_PRPTY","客户性质","System.String","60"}); hs.Add(127,new string[]{"SALECARD","营业执照","System.String","60"}); hs.Add(128,new string[]{"CUSTM_DATA","客户资质材料","System.String","60"}); hs.Add(129,new string[]{"TRANS_TYP","运输方式","System.String","60"}); hs.Add(130,new string[]{"INCERPTCODE","收货单位","System.String","60"}); hs.Add(131,new string[]{"SHIP_DESTINATION","船运港口","System.String","60"}); hs.Add(132,new string[]{"ORDER_NO","合同号","System.String","60"}); hs.Add(133,new string[]{"ORDER_SEQ","合同行号","System.String","60"}); hs.Add(134,new string[]{"HEIGHT","厚度","System.Double","60"}); hs.Add(135,new string[]{"WIDTH","宽度","System.Double","60"}); hs.Add(136,new string[]{"LENGTH","长度","System.Double","60"}); hs.Add(137,new string[]{"FIXSIZE","定尺方式","System.String","60"}); hs.Add(138,new string[]{"LEN_MIN","下限","System.Double","60"}); hs.Add(139,new string[]{"LEN_MAX","上限","System.Double","60"}); hs.Add(140,new string[]{"WIDTH_MIN","宽度下限","System.Double","60"}); hs.Add(141,new string[]{"WIDTH_MAX","宽度上限","System.Double","60"}); hs.Add(142,new string[]{"SENDSTATUS","切边方式","System.String","60"}); hs.Add(143,new string[]{"ORDER_UNIT","订货计量单位","System.String","60"}); hs.Add(144,new string[]{"ORDER_QTY","订货件数","System.Double","60"}); hs.Add(145,new string[]{"WEIGHT","订货重量","System.Double","60"}); hs.Add(146,new string[]{"DELVRY_RANGE_TPE","交货量差方式","System.String","60"}); hs.Add(147,new string[]{"DELVRY_RANGE_MIN","交货量差下限","System.Double","60"}); hs.Add(148,new string[]{"DELVRY_RANGE_MAX","交货量差上限","System.Double","60"}); hs.Add(149,new string[]{"ISWELDED_HEAT","是否模拟焊后","System.String","60"}); hs.Add(150,new string[]{"NUCLEARSTEEL","核电钢要求","System.String","60"}); hs.Add(151,new string[]{"KHIC","抗HIC试验","System.String","60"}); hs.Add(152,new string[]{"ISPOSTER","保性能判别","System.String","60"}); hs.Add(153,new string[]{"FINAL_USER","最终用户","System.String","60"}); hs.Add(154,new string[]{"FINAL_USER_DESC","最终用户描述","System.String","60"}); hs.Add(155,new string[]{"DELVRY_BDATE","交货开始日期","System.DateTime","60"}); hs.Add(156,new string[]{"DELVRY_EDATE","交货结束日期","System.DateTime","60"}); hs.Add(157,new string[]{"DELVRY_DESC","交货信息描述","System.String","60"}); hs.Add(158,new string[]{"TRANS_DESC","运输信息描述","System.String","60"}); hs.Add(159,new string[]{"ADD_ASK_NO","附加要求编码","System.String","60"}); hs.Add(160,new string[]{"ORDER_ADD_DESC","订货附加要求描述","System.String","60"}); hs.Add(161,new string[]{"ORDER_SPECIAL_FL","产品特殊要求标识","System.String","60"}); hs.Add(162,new string[]{"ORDER_SPECIAL_HEAD","特殊要求技术规范说明","System.String","60"}); hs.Add(163,new string[]{"ORDER_SPECIAL_PATH","技术规范文件路径","System.String","60"}); hs.Add(164,new string[]{"ORDER_SPECIAL_DESC","产品特殊要求描述","System.String","60"}); hs.Add(165,new string[]{"ZBS","质保书","System.String","60"}); hs.Add(166,new string[]{"ORDER_PRICE","订货价","System.Double","60"}); hs.Add(167,new string[]{"TRANS_PRICE","运费","System.Double","60"}); hs.Add(168,new string[]{"TEST_ID","测价序号","System.String","60"}); hs.Add(169,new string[]{"TEST_PRICE","测算价","System.Double","60"}); hs.Add(170,new string[]{"OUT_PRICE","出厂价","System.Double","60"}); hs.Add(171,new string[]{"BALNCE_PRICE","结算价","System.Double","60"}); hs.Add(172,new string[]{"ORDER_LN_STATUS","合同行状态","System.String","60"}); hs.Add(173,new string[]{"REVIEW_STATUS","评审状态","System.String","60"}); hs.Add(174,new string[]{"REVIEW_MSG","评审信息","System.String","60"}); hs.Add(175,new string[]{"REVIEW_DATE","评审时间","System.DateTime","60"}); hs.Add(176,new string[]{"REVIEW_ENTRYDATE","评审结果录入时间","System.DateTime","60"}); hs.Add(177,new string[]{"MEMO","备注","System.String","60"}); hs.Add(178,new string[]{"VALIDFLAG","有效标志","System.String","60"}); hs.Add(179,new string[]{"CREATE_NAME","创建人","System.String","60"}); hs.Add(180,new string[]{"CREATE_TIME","创建时间","System.DateTime","60"}); hs.Add(181,new string[]{"UPDATE_NAME","修改人","System.String","60"}); hs.Add(182,new string[]{"UPDATE_TIME","修改时间","System.DateTime","60"}); hs.Add(183,new string[]{"DELETE_NAME","删除人","System.String","60"}); hs.Add(184,new string[]{"DELETE_TIME","删除时间","System.DateTime","60"}); select ' /// '||chr(13)||'///'|| a.columncaption||chr(13)|| ' /// '||chr(13)|| 'private static string '||a.columnname || ' ;' from SLM_COL_COLUMNDEFINE a order by a.columnname