´Ó·ÖÎö¼ÒÖеõ½¹ÉƱÊý¾Ý£¡C#Ô´Âë £¨´úÂëºÜ³¤£¬½¨Òé»ðºü£©

´Ó·ÖÎö¼ÒÖеõ½¹ÉƱÊý¾Ý£¡ ÆäÖÐ×öÁËÒ»²¿·ÖÐ޸ģ¬ÐèҪעÒâ £¡ÔÚ·ÖÎö¼Ò2006ÖÐÈ¡³öÊý¾Ý£¡

using System; using System.Collections; using System.Text; using System.Text.RegularExpressions; using System.IO; using Microsoft.Win32; using System.Runtime.InteropServices; using System.Data.SqlClient; using System.Data; //using System.DateTime; namespace myData { [ProgId("myData.FxjData"),ComVisible(true)] public class FxjData { public enum DataTypes { /// <summary> /// ´úÂë /// </summary> dm, /// <summary> /// <a href="http://1.optbbs.com/d/quote.html" target="_blank" class="relatedlink">ÐÐÇé</a> /// </summary> hq, /// <summary> /// ·Ö±Ê³É½» /// </summary> hqmb, /// <summary> /// ¶¯Ì¬ÐÐÇé /// </summary> hq0, /// <summary> /// Îå·ÖÖÓÐÐÇé /// </summary> hq5, /// <summary> /// ³ýȨÊý¾Ý /// </summary> cq, /// <summary> /// ¹É±¾½á¹¹ /// </summary> cw0, /// <summary> /// ·ÖºìËÍÅä /// </summary> fp, /// <summary> /// ´úÂë /// </summary> gb, /// <summary> /// ´úÂë /// </summary> gd, /// <summary> /// ×îвÆÎñÊý¾Ý /// </summary> cw, /// <summary> /// »ù½ð¾»Öµ /// </summary> jjjz, /// <summary> /// »ù½ðͶ×Ê×éºÏ /// </summary> jjzh, /// <summary> /// °å¿é /// </summary> bk, /// <summary> /// ÆÀ¼¶ /// </summary> pj, /// <summary> /// ¸´È¨ÐÐÇé /// </summary> hqfq }; //ÐÐ˳ÐòÓëDatatypeÒ»Ö£¬ÁзֱðΪ±íÃû¡¢±íÖÐÎÄÃû¡¢¶ÔÓ¦ÎļþÃû£¨GetTablesº¯ÊýÖи³Öµ£© private string[,] tableNames = new string[,] { #region ±íÃû {"dm","´úÂë",""}, {"hq","ÐÐÇé",""}, {"hqmb","·Ö±Ê³É½»",""}, {"hq0","¶¯Ì¬ÐÐÇé",""}, {"hq5","Îå·ÖÖÓÐÐÇé",""}, {"cq","³ýȨÊý¾Ý",""}, {"cw0","×îвÆÎñÊý¾Ý",""}, {"fp","·ÖºìËÍÅä",""}, {"gb","¹É±¾½á¹¹",""}, {"gd","Ê®´ó¹É¶«",""}, {"cw","²ÆÎñÊý¾Ý",""}, {"jjjz","»ù½ð¾»Öµ",""}, {"jjzh","»ù½ðͶ×Ê×éºÏ",""}, {"bk","°å¿é",""}, {"pj","ÆÀ¼¶",""}, {"hqfq","¸´È¨ÐÐÇé",""} #endregion }; /// <summary> /// ÒÀ¿¿Êý¾ÝÎļþλÖà Öع¹ /// </summary> /// <param name="fxjPath">c:/fxj/</param> /// <param name="fxjDataPath">c:/fxj/data</param> public FxjData(string fxjPath, string fxjDataPath) { this.fxjPath = fxjPath; this.fxjDataPath = fxjDataPath; } /// <summary> /// ÒÀ¿¿×¢²á±íÖع¹ /// </summary> public FxjData() { try { //´Ó×¢²á±íÖжÁÈ¡·ÖÎö¼ÒÊý¾ÝĿ¼£¬Èçc:/fxj/data RegistryKey keyFxj; RegistryKey keySoftware = Registry.LocalMachine.OpenSubKey("Software"); keyFxj = keySoftware.OpenSubKey("FXJ"); if (keyFxj == null) { keyFxj = keySoftware.OpenSubKey("Huitianqi"); if (keyFxj == null) { fxjPath = ""; fxjDataPath = ""; msg = "ûÓÐÕÒµ½·ÖÎö¼Ò°²×°ÐÅÏ¢£¡"; return; } } RegistryKey keySuperstk = keyFxj.OpenSubKey("SUPERSTK"); if (keySuperstk != null) { fxjPath = (string)keySuperstk.GetValue("InstPath"); if (fxjPath != "") { fxjPath = fxjPath.ToUpper(); if (fxjPath != "" && fxjPath.EndsWith(@"/") == false) fxjPath = fxjPath + @"/"; fxjDataPath = fxjPath + @"DATA/"; fxjDataPath = fxjDataPath.ToUpper(); RegistryKey keyMarket = keySuperstk.OpenSubKey("Market"); if (keyMarket != null) { string[] marketSubKeyNames = keyMarket.GetSubKeyNames(); if (marketSubKeyNames.Length > 0) { RegistryKey[] marketSubKey = new RegistryKey[marketSubKeyNames.Length]; fxjMarket = new string[marketSubKeyNames.Length, 3]; for (int i = 0; i < marketSubKeyNames.Length; i++) { marketSubKey[i] = keyMarket.OpenSubKey(marketSubKeyNames[i]); if (marketSubKey[i] != null) { fxjMarket[i, 0] = marketSubKeyNames[i]; fxjMarket[i, 1] = (string)marketSubKey[i].GetValue("name"); fxjMarket[i, 2] = (string)marketSubKey[i].GetValue("shortname"); } } for (int i = 0; i < marketSubKeyNames.Length; i++) { int lastI = marketSubKeyNames.Length - 1; if (fxjMarket[i, 0].ToUpper() == "SH") { string[] temp = new string[3]; temp[0] = fxjMarket[0, 0]; temp[1] = fxjMarket[0, 1]; temp[2] = fxjMarket[0, 2]; fxjMarket[0, 0] = fxjMarket[i, 0]; fxjMarket[0, 1] = fxjMarket[i, 1]; fxjMarket[0, 2] = fxjMarket[i, 2]; fxjMarket[i, 0] = temp[0]; fxjMarket[i, 1] = temp[1]; fxjMarket[i, 2] = temp[2]; } if (fxjMarket[i, 0].ToUpper() == "SZ") { string[] temp = new string[3]; temp[0] = fxjMarket[1, 0]; temp[1] = fxjMarket[1, 1]; temp[2] = fxjMarket[1, 2]; fxjMarket[1, 0] = fxjMarket[i, 0]; fxjMarket[1, 1] = fxjMarket[i, 1]; fxjMarket[1, 2] = fxjMarket[i, 2]; fxjMarket[i, 0] = temp[0]; fxjMarket[i, 1] = temp[1]; fxjMarket[i, 2] = temp[2]; } if (fxjMarket[i, 0].ToUpper() == "$$") { string[] temp = new string[3]; temp[0] = fxjMarket[lastI, 0]; temp[1] = fxjMarket[lastI, 1]; temp[2] = fxjMarket[lastI, 2]; fxjMarket[lastI, 0] = fxjMarket[i, 0]; fxjMarket[lastI, 1] = fxjMarket[i, 1]; fxjMarket[lastI, 2] = fxjMarket[i, 2]; fxjMarket[i, 0] = temp[0]; fxjMarket[i, 1] = temp[1]; fxjMarket[i, 2] = temp[2]; } } } } return; } } } catch (Exception ex) { msg = ex.Message; } } struct fileStruct { public string fileName;//ÎļþÃû public int startAddress, blockSize, recordSize;//ÆðʼµØÖ·£¬Ã¿¿é³¤¶È£¬¼Ç¼³¤¶È public bool codeIsLong, isIndexDataStruct; //codeIsLongË÷ÒýÖеĴúÂë°üº¬ÓÐ<a href="http://https://www.optbbs.com/tag-163997.html" target="_blank" class="relatedlink">Êг¡</a>´úÂëSH¡¢SZµÈ;isIndexDataStructÏóDay.DatÄÇÑùµÄ½á¹¹¼´ÓÉË÷Òý+Êý¾Ý×é³É; public string[,] fields;//×ֶΠpublic fileStruct(DataTypes fileType) { fileName = ""; startAddress = 0; blockSize = 0; recordSize = 0; codeIsLong = false; isIndexDataStruct = true; string fieldString = ""; //×Ö¶ÎÃû£¬×ֶαêÇ©£¬ÀàÐÍ£¬³¤¶È×ֶΣ¬´æ´¢Ë³Ðò£¬Æ«ÒÆÁ¿ switch (fileType) { #region ´úÂë±ístkinfo51.dat case DataTypes.dm: fileName = "STKINFO51.DAT"; startAddress = 0x845898; blockSize = 0; recordSize = 248; codeIsLong = false; isIndexDataStruct = false; fieldString = "dm,´úÂë,code,10,0,0,;" + "jc,¼ò³Æ,string,32,1,10,;" + "py,Æ´Òô,string,10,2,42,"; break; #endregion #region ·ÖºìËÍÅästkinfo51.dat case DataTypes.cq: fileName = "STKINFO51.DAT"; startAddress = 0x14; blockSize = 2116; recordSize = 20; codeIsLong = false; isIndexDataStruct = false; fieldString = "dm,´úÂë,code,10,0,0,;" + "rq,ÈÕÆÚ,date,4,0,0,;" + "sgbl,Ë͹ɱÈÀý,single,4,1,4,;" + "pgbl,Åä¹É±ÈÀý,single,4,2,8,;" + "pgjg,Åä¹É¼Û¸ñ,single,4,3,12,;" + "fh,·Öºì,single,4,4,16,"; break; #endregion #region ²ÆÎñÊý¾Ý£¨¼òµ¥£©stkinfo51.dat case DataTypes.cw0: fileName = "STKINFO51.DAT"; startAddress = 0x794; blockSize = 2116; recordSize = 196; codeIsLong = false; isIndexDataStruct = false; fieldString = "dm,´úÂë,code,10,0,0,;" + "rq,¸üÐÂÈÕÆÚ,date,4,38,192,;" + "zgb,×ܹɱ¾,single,4,0,0,;" + "gjg,¹ú¼Ò¹É,single,4,1,4,;" + "fqrg,·¢ÆðÈË·¨È˹É,single,4,2,8,;" + "frg,·¨È˹É,single,4,3,12,;" + "b,B¹É,single,4,4,16,;" + "h,H¹É,single,4,5,20,;" + "a,Á÷ͨA¹É,single,4,6,24,;" + "zgg,Ö°¹¤¹É,single,4,7,28,;" + "a2zpg,A2תÅä¹É,single,4,8,32,;" + "bszzc,×Ü×ʲú,single,4,9,36,;" + "bsldzc,Á÷¶¯×ʲú,single,4,10,40,;" + "bsgdzc,¹Ì¶¨×ʲú,single,4,11,44,;" + "bswxzc,ÎÞÐÎ×ʲú,single,4,12,48,;" + "bscqtz,³¤ÆÚͶ×Ê,single,4,13,52,;" + "bsldfz,Á÷¶¯¸ºÕ®,single,4,14,56,;" + "bscqfz,³¤ÆÚ¸ºÕ®,single,4,15,60,;" + "bszbgj,×ʱ¾¹«»ý½ð,single,4,16,64,;" + "mggjj,ÿ¹É¹«»ý½ð,single,4,17,68,;" + "bsgdqy,¹É¶«È¨Òæ,single,4,18,72,;" + "iszysl,Ö÷ÓªÊÕÈë,single,4,19,76,;" + "iszylr,Ö÷ÓªÀûÈó,single,4,20,80,;" + "isqtlr,ÆäËûÀûÈó,single,4,21,84,;" + "isyylr,ÓªÒµÀûÈó,single,4,22,88,;" + "istzsy,Ͷ×ÊÊÕÒæ,single,4,23,92,;" + "isbtsr,²¹ÌùÊÕÈë,single,4,24,96,;" + "isyywsz,ÓªÒµÍâÊÕÖ§,single,4,25,100,;" + "issytz,ÉÏÄêËðÒæµ÷Õû,single,4,26,104,;" + "islrze,ÀûÈó×ܶî,single,4,27,108,;" + "isshlr,Ë°ºóÀûÈó,single,4,28,112,;" + "isjlr,¾»ÀûÈó,single,4,29,116,;" + "iswfplr,δ·ÖÅäÀûÈó,single,4,30,120,;" + "mgwfplr,ÿ¹Éδ·ÖÅäÀûÈó,single,4,31,124,;" + "mgsy,ÿ¹ÉÊÕÒæ,single,4,32,128,;" + "mgjzc,ÿ¹É¾»×ʲú,single,4,33,132,;" + "tzmgjzc,µ÷Õûÿ¹É¾»×ʲú,single,4,34,136,;" + "gdqybl,¹É¶«È¨Òæ±ÈÂÊ,single,4,35,140,;" + "jzcsyl,¾»×ʲúÊÕÒæÂÊ,single,4,36,144,"; //"unknown,(δ֪),string,44,37,148,;" break; #endregion #region ×îÐÂÐÐÇéstkinfo51.dat case DataTypes.hq0: fileName = "STKINFO51.DAT"; startAddress = 0x845898; blockSize = 0; recordSize = 248; codeIsLong = false; isIndexDataStruct = false; fieldString = "dm,´úÂë,code,10,0,0,;" + "jc,¼ò³Æ,string,32,1,10,;" + "py,Æ´Òô,string,10,2,42,;" + "rq,¸üÐÂʱ¼ä,datetime,4,5,60,;" + "wrjl,ÎåÈÕ¾ùÁ¿,single,4,6,64,;" + "zs,×òÊÕ,single,4,7,68,;" + "jk,½ñ¿ª,single,4,8,72,;" + "zg,×î¸ß,single,4,9,76,;" + "zd,×îµÍ,single,4,10,80,;" + "zx,×îÐÂ,single,4,11,84,;" + "zss,×ÜÊÖÊý,single,4,12,88,;" + "je,½ð¶î,single,4,13,92,;" + "xss,ÏÖÊÖÊý,single,4,14,96,;" + "sbcj,Éϱʳɽ»¼Û,single,4,29,156,;" + "dbcj,µ±±Ê³É½»¼Û,single,4,30,160,;" + "np,ÄÚÅÌ,single,4,27,148,;" + "wp,ÍâÅÌ,single,4,28,152,;" + "mr1jg,ÂòÒ»¼Û,single,4,15,100,;" + "mr1sl,ÂòÒ»Á¿,single,4,18,112,;" + "mr2jg,Âò¶þ¼Û,single,4,16,104,;" + "mr2sl,Âò¶þÁ¿,single,4,19,116,;" + "mr3jg,ÂòÈý¼Û,single,4,17,108,;" + "mr3sl,ÂòÈýÁ¿,single,4,20,120,;" + "mr4jg,ÂòËļÛ,single,4,32,168,;" + "mr4sl,ÂòËÄÁ¿,single,4,34,176,;" + "mr5jg,ÂòÎå¼Û,single,4,33,172,;" + "mr5sl,ÂòÎåÁ¿,single,4,35,180,;" + "mc1jg,ÂôÒ»¼Û,single,4,21,124,;" + "mc1sl,ÂôÒ»Á¿,single,4,24,136,;" + "mc2jg,Âô¶þ¼Û,single,4,22,128,;" + "mc2sl,Âô¶þÁ¿,single,4,25,140,;" + "mc3jg,ÂôÈý¼Û,single,4,23,132,;" + "mc3sl,ÂôÈýÁ¿,single,4,26,144,;" + "mc4jg,ÂôËļÛ,single,4,36,184,;" + "mc4sl,ÂôËÄÁ¿,single,4,38,192,;" + "mc5jg,ÂôÎå¼Û,single,4,37,188,;" + "mc5sl,ÂôÎåÁ¿,single,4,39,196,"; //"jd,¾«¶È,int,4,3,52,;" + //"scbz,ɾ³ý±êÖ¾,int,4,4,56,"; //"unknown,(δ֪),int,4,31,164,;" + //",(δ֪),,48,40,200,;" break; #endregion #region ·Ö±Ê³É½»Êý¾ÝÎļþreport.dat£¨½á¹¹Í¬day.dat£¬µ«ÆäÖÐһЩÊý¾Ý²»ÊÇÖ±½Ó±£´æ£© case DataTypes.hqmb: fileName = "REPORT.DAT"; startAddress = 0x41000; blockSize = 4068; recordSize = 36; codeIsLong = false; isIndexDataStruct = false;//²»ÍêÈ«µÈͬÓÚday.dat½á¹¹£¬Òò´Ëµ¥¶À´¦Àí fieldString = "dm,´úÂë,code,10,0,0,;" + "rq,ÈÕÆÚ,datetime,4,0,0,;" + "zjcj,×î½ü³É½»¼Û,single,4,1,4,;" + "zss,×ÜÊÖÊý,single,4,2,8,calc;" + "je,½ð¶î,single,4,3,12,;" + "xss,ÏÖÊÖÊý,single,4,2,8,;" + "mm,ÄÚÍâÅÌ,string,2,16,35,;" + "mr1jg,ÂòÒ»¼Û,single,1,10,28,;" + "mr1sl,ÂòÒ»Á¿,single,2,4,16,;" + "mr2jg,Âò¶þ¼Û,single,1,11,29,;" + "mr2sl,Âò¶þÁ¿,single,2,5,18,;" + "mr3jg,ÂòÈý¼Û,single,1,12,30,;" + "mr3sl,ÂòÈýÁ¿,single,2,6,20,;" + "mc1jg,ÂôÒ»¼Û,single,1,13,31,;" + "mc1sl,ÂôÒ»Á¿,single,2,7,22,;" + "mc2jg,Âô¶þ¼Û,single,1,14,32,;" + "mc2sl,Âô¶þÁ¿,single,2,8,24,;" + "mc3jg,ÂôÈý¼Û,single,1,15,33,;" + "mc3sl,ÂôÈýÁ¿,single,2,9,26,"; //ÒÔÀàÊý¾ÝÀàÐͲ»ÊÇ´æ´¢ÀàÐÍ£¬³ÌÐòÖв»Ö±½ÓÓÃʵ¼ÊÊý¾ÝÀàÐÍ£ºÂò/ÂôXÁ¿Îªshort£¬Âò/ÂôX¼ÛΪbyte //ÏÖÊÖÊýͨ¹ýµ±×ÜÊÖÊý¼ÆËã¶øµÃ£¬Ó¦¸Ã·ÅÔÚ×ÜÊÖÊýºóÃæ break; #endregion #region ÈÕÏßÊý¾ÝÎļþday.dat case DataTypes.hq: fileName = "DAY.DAT"; startAddress = 0x41000; blockSize = 8192; recordSize = 32; codeIsLong = false; fieldString = "dm,´úÂë,code,10,0,0,;" + "rq,ÈÕÆÚ,date,4,1,0,;" + "kp,¿ªÅÌ,single,4,2,4,B;" + "zg,×î¸ß,single,4,3,8,B;" + "zd,×îµÍ,single,4,4,12,B;" + "sp,ÊÕÅÌ,single,4,5,16,B;" + "sl,³É½»ÊýÁ¿,single,4,6,20,A;" + "je,³É½»½ð¶î,single,4,7,24,"; break; #endregion #region 5·ÖÖÓÊý¾ÝÎļþmin.dat case DataTypes.hq5: fileName = "MIN.DAT"; startAddress = 0x41000; blockSize = 8192; recordSize = 32; codeIsLong = false; fieldString = "dm,´úÂë,code,10,0,0,;" + "rq,ÈÕÆÚ,datetime,4,1,0,;" + "kp,¿ªÅÌ,single,4,2,4,B;" + "zg,×î¸ß,single,4,3,8,B;" + "zd,×îµÍ,single,4,4,12,B;" + "sp,ÊÕÅÌ,single,4,5,16,B;" + "sl,³É½»ÊýÁ¿,single,4,6,20,A;" + "je,³É½»½ð¶î,single,4,7,24,"; break; #endregion #region ·ÖºìËÍÅäÊý¾ÝÎļþexprof.fdt case DataTypes.fp: fileName = "EXPROF.FDT"; startAddress = 0x41000; blockSize = 3776; recordSize = 236; codeIsLong = true; fieldString = "dm,´úÂë,code,12,0,0,;" + "cqrq,³ýȨÈÕÆÚ,date,4,23,176,;" + "sgbl,Ë͹ɱÈÀý,double,8,1,12,;" + "sgdjr,Ë͹ɹÉȨµÇ¼ÇÈÕ,date,4,2,20,;" + "sgcqr,Ë͹ɳýȨÈÕ,date,4,3,24,;" + "sgssr,ºì¹ÉÉÏÊÐÈÕ,date,4,4,28,;" + "zzbl,תÔö±ÈÀý,double,8,5,32,;" + "zzdjr,תÔö¹ÉȨµÇ¼ÇÈÕ,date,4,6,40,;" + "zzcqr,תÔö³ýȨÈÕ,date,4,7,44,;" + "zzssr,תÔöÉÏÊÐÈÕ,date,4,8,48,;" + "fhbl,·Öºì±ÈÀý,double,8,9,52,;" + "fhdjr,·Öºì¹ÉȨµÇ¼ÇÈÕ,date,4,10,60,;" + "fhcxr,·Öºì³ýÏ¢ÈÕ,date,4,11,64,;" + "fhpxr,·ÖºìÅÉÏ¢ÈÕ,date,4,12,68,;" + "pgbl,Åä¹É±ÈÀý,double,8,13,72,;" + "pgdjr,Åä¹É¹ÉȨµÇ¼ÇÈÕ,date,4,14,80,;" + "pgcqr,Åä¹É³ýȨ»ù×¼ÈÕ,date,4,15,84,;" + "pgjkqsr,Åä¹É½É¿îÆðʼÈÕ,date,4,16,88,;" + "pgjkzzr,Åä¹É½É¿îÖÕÖ¹ÈÕ,date,4,17,92,;" + "pgssr,Åä¹É¿ÉÁ÷ͨÉÏÊÐÈÕ,date,4,18,96,;" + "pgjg,Åä¹É¼Û¸ñ,single,4,19,100,;" + "frgpgbl,¹«ÖÚ¹ÉÊÜÈ÷¨È˹ÉÅä¹É±ÈÀý,double,8,20,104,;" + "frgmgzrf,ÈϹº·¨È˹ÉÅä¹Éÿ¹ÉתÈ÷Ñ,single,4,21,112,;" + "pgzcxs,Åä¹ÉÖ÷³ÐÏúÉÌ,string,60,22,116,;" + "bgrq,±¨¸æÈÕÆÚ,date,4,24,180,;" + "dshrq,¶­Ê»áÈÕÆÚ,date,4,25,184,;" + "gdhrq,¹É¶«»áÈÕÆÚ,date,4,26,188,;" + "fhggrq,·Öºì¹«¸æÈÕÆÚ,date,4,27,192,;" + "zgbjs,×ܹɱ¾»ùÊý,double,8,28,196,;" + "sgsl,Ë͹ÉÊýÁ¿,double,8,29,204,;" + "zzsl,תÔöÊýÁ¿,double,8,30,212,;" + "sjpgs,ʵ¼ÊÅä¹É×ÜÊý,double,8,31,220,;" + "cqhzgb,³ýȨºó×ܹɱ¾,double,8,32,228"; break; #endregion #region ¹É±¾½á¹¹Capital.fdt case DataTypes.gb: fileName = "CAPITAL.FDT"; startAddress = 0x41000; blockSize = 3488; recordSize = 218; codeIsLong = true; fieldString = "dm,´úÂë,code,12,0,0;" + "rq,ÈÕÆÚ,date,4,17,214;" + "zgb,×ܹɱ¾,double,8,1,12;" + "gjg,¹ú¼Ò¹É,double,8,2,20;" + "fqrg,·¢ÆðÈ˹É,double,8,3,28;" + "frg,·¨È˹É,double,8,4,36;" + "ybfrps,Ò»°ã·¨ÈËÅäÊÛ,double,8,5,44;" + "zgg,ÄÚ²¿Ö°¹¤¹É,double,8,6,52;" + "a,Á÷ͨA¹É,double,8,7,60;" + "zltzag,Õ½ÂÔͶ×ÊA¹É,double,8,8,68;" + "zpg,תÅä¹É,double,8,9,76;" + "jjps,»ù½ðÅäÊÛ,double,8,10,84;" + "h,H¹É,double,8,11,92;" + "b,B¹É,double,8,12,100;" + "yxg,ÓÅÏȹÉ,double,8,13,108;" + "ggcg,¸ß¼¶¹ÜÀíÈËÔ±³Ö¹É,double,8,14,116;" + "gbbdyy,¹É±¾±ä¶¯Ô­Òò,string,56,15,124;" + "gbbdyylb,¹É±¾±ä¶¯Ô­ÒòÀà±ð,string,34,16,180"; break; #endregion #region ²ÆÎñÊý¾ÝFinance.fdt case DataTypes.cw: fileName = "FINANCE.FDT"; startAddress = 0x41000; blockSize = 14848; recordSize = 464; codeIsLong = true; fieldString = "dm,´úÂë,code,12,0,0,;" + "rq,ÈÕÆÚ,date,4,,460,;" + "bsdqtzje,¶ÌÆÚͶ×ʾ»¶î,double,8,1,12,;" + "bsyszkje,Ó¦ÊÕÕÊ¿î¾»¶î,double,8,2,20,;" + "bschje,´æ»õ¾»¶î,double,8,3,28,;" + "bsldzc,Á÷¶¯×ʲú,double,8,4,36,;" + "bscqtzje,³¤ÆÚͶ×ʾ»¶î,double,8,5,44,;" + "bsgdzc,¹Ì¶¨×ʲú,double,8,6,52,;" + "bswxzc,ÎÞÐμ°ÆäËû×ʲú,double,8,7,60,;" + "bszzc,×Ü×ʲú,double,8,8,68,;" + "bsdqjk,¶ÌÆÚ½è¿î,double,8,9,76,;" + "bsyfzk,Ó¦¸¶ÕÊ¿î,double,8,10,84,;" + "bsldfz,Á÷¶¯¸ºÕ®,double,8,11,92,;" + "bscqfz,³¤ÆÚ¸ºÕ®,double,8,12,100,;" + "bsfz,¸ºÕ®ºÏ¼Æ,double,8,13,108,;" + "bsgb,¹É±¾,double,8,14,116,;" + "bsssgdqy,ÉÙÊý¹É¶«È¨Òæ,double,8,15,124,;" + "bsgdqy,¹É¶«È¨Òæ,double,8,16,132,;" + "bszbgj,×ʱ¾¹«»ý,double,8,17,140,;" + "bsyygj,Ó¯Ó๫»ý,double,8,18,148,;" + "iszysr,Ö÷ÓªÒµÎñÊÕÈë¾»¶î,double,8,1,156,;" + "iszycb,Ö÷ÓªÒµÎñ³É±¾,double,8,2,164,;" + "iszylr,Ö÷ÓªÒµÎñÀûÈó,double,8,3,172,;" + "isqtlr,ÆäËüÒµÎñÀûÈó,double,8,4,180,;" + "isyyfy,ÓªÒµ·ÑÓÃ,double,8,5,188,;" + "isglfy,¹ÜÀí·ÑÓÃ,double,8,6,196,;" + "iscwfy,²ÆÎñ·ÑÓÃ,double,8,7,204,;" + "istzsy,Ͷ×ÊÊÕÒæ,double,8,8,212,;" + "islrze,ÀûÈó×ܶî,double,8,9,220,;" + "issds,ËùµÃË°,double,8,10,228,;" + "isjlr,¾»ÀûÈó,double,8,11,236,;" + "iskchjlr,¿Û³ý¾­³£ÐÔËðÒæºóµÄ¾»ÀûÈó,double,8,12,244,;" + "iswfplr,δ·ÖÅäÀûÈó,double,8,13,252,;" + "cfjyhdxjlr,¾­Óª»î¶¯ÏÖ½ðÁ÷Èë,double,8,1,260,;" + "cfjyhdxjlc,¾­Óª»î¶¯ÏÖ½ðÁ÷³ö,double,8,2,268,;" + "cfjyhdxjje,¾­Óª»î¶¯Ïֽ𾻶î,double,8,3,276,;" + "cftzxjlr,Ͷ×ÊÏÖ½ðÁ÷Èë,double,8,4,284,;" + "cftzxjlc,Ͷ×ÊÏÖ½ðÁ÷³ö,double,8,5,292,;" + "cftzxjje,Ͷ×ÊÏֽ𾻶î,double,8,6,300,;" + "cfczxjlr,³ï´ëÏÖ½ðÁ÷Èë,double,8,7,308,;" + "cfczxjlc,³ï´ëÏÖ½ðÁ÷³ö,double,8,8,316,;" + "cfczxjje,³ï´ëÏֽ𾻶î,double,8,9,324,;" + "cfxjjze,ÏÖ½ð¼°ÏÖ½ðµÈ¼ÛÎï¾»Ôö¶î,double,8,10,332,;" + "cfxsspxj,ÏúÊÛÉÌÆ·ÊÕµ½µÄÏÖ½ð,double,8,11,340,;" + "mgsy,ÿ¹ÉÊÕÒæ,single,4,1,348,;" + "mgjzc,ÿ¹É¾»×ʲú,single,4,2,352,;" + "tzmgjzc,µ÷Õûºóÿ¹É¾»×ʲú,single,4,3,356,;" + "mgzbgjj,ÿ¹É×ʱ¾¹«»ý½ð,single,4,4,360,;" + "mgwfplr,ÿ¹Éδ·ÖÅäÀûÈó,single,4,5,364,;" + "mgjyxjllje,ÿ¹É¾­Óª»î¶¯²úÉúµÄÏÖ½ðÁ÷Á¿¾»¶î,single,4,6,368,;" + "mgxjzjje,ÿ¹ÉÏÖ½ð¼°ÏÖ½ðµÈ¼ÛÎïÔö¼Ó¾»¶î,single,4,7,372,;" + "mll,ëÀûÂÊ,single,4,8,376,;" + "zyywlrl,Ö÷ÓªÒµÎñÀûÈóÂÊ,single,4,9,380,;" + "jll,¾»ÀûÂÊ,single,4,10,384,;" + "zzcbcl,×Ü×ʲú±¨³êÂÊ,single,4,11,388,;" + "jzcsyl,¾»×ʲúÊÕÒæÂÊ,single,4,12,392,;" + "xsxjzb,ÏúÊÛÉÌÆ·ÊÕµ½µÄÏÖ½ðÕ¼Ö÷ÓªÊÕÈë±ÈÀý,single,4,13,396,;" + "yszczzl,Ó¦ÊÕÕÊ¿îÖÜתÂÊ,single,4,14,400,;" + "chzzl,´æ»õÖÜתÂÊ,single,4,15,404,;" + "gdzczzl,¹Ì¶¨×ʲúÖÜתÂÊ,single,4,16,408,;" + "zyywzzl,Ö÷ÓªÒµÎñÔö³¤ÂÊ,single,4,17,412,;" + "jlrzzl,¾»ÀûÈóÔö³¤ÂÊ,single,4,18,416,;" + "zzczzl,×Ü×ʲúÔö³¤ÂÊ,single,4,19,420,;" + "jzczzl,¾»×ʲúÔö³¤ÂÊ,single,4,20,424,;" + "ldbl,Á÷¶¯±ÈÂÊ,single,4,21,428,;" + "sdbl,ËÙ¶¯±ÈÂÊ,single,4,22,432,;" + "zcfzbl,×ʲú¸ºÕ®±ÈÂÊ,single,4,23,436,;" + "fzbl,¸ºÕ®±ÈÂÊ,single,4,24,440,;" + "gdqybl,¹É¶«È¨Òæ±ÈÂÊ,single,4,25,444,;" + "gdzcbl,¹Ì¶¨×ʲú±ÈÂÊ,single,4,26,448,;" + "kchmgjlr,¿Û³ý¾­³£ÐÔËðÒæºóÿ¹É¾»ÀûÈó,single,4,27,452,"; break; #endregion #region Ê®´ó¹É¶«stkhold.fdt case DataTypes.gd: fileName = "STKHOLD.FDT"; startAddress = 0x41000; blockSize = 17568; recordSize = 2196; codeIsLong = true; fieldString = "dm,´úÂë,code,12,0,0,;" + "rq,ÈÕÆÚ,date,4,66,2192,;" + "gd1mc,¹É¶«1Ãû³Æ,string,160,1,12,;" + "gd1cgsl,¹É¶«1³Ö¹ÉÊýÁ¿,double,8,2,172,;" + "gd1cgbl,¹É¶«1³Ö¹É±ÈÀý,single,4,3,180,;" + "gd1bz,¹É¶«1±¸×¢,string,20,4,184,;" + "gd1fr,¹É¶«1·¨ÈË,string,8,5,204,;" + "gd1jyfw,¹É¶«1¾­Óª·¶Î§,string,16,6,212,;" + "gd2mc,¹É¶«2Ãû³Æ,string,160,7,228,;" + "gd2cgsl,¹É¶«2³Ö¹ÉÊýÁ¿,double,8,8,388,;" + "gd2cgbl,¹É¶«2³Ö¹É±ÈÀý,single,4,9,396,;" + "gd2bz,¹É¶«2±¸×¢,string,20,10,400,;" + "gd2fr,¹É¶«2·¨ÈË,string,8,11,420,;" + "gd2jyfw,¹É¶«2¾­Óª·¶Î§,string,16,12,428,;" + "gd3mc,¹É¶«3Ãû³Æ,string,160,13,444,;" + "gd3cgsl,¹É¶«3³Ö¹ÉÊýÁ¿,double,8,14,604,;" + "gd3cgbl,¹É¶«3³Ö¹É±ÈÀý,single,4,15,612,;" + "gd3bz,¹É¶«3±¸×¢,string,20,16,616,;" + "gd3fr,¹É¶«3·¨ÈË,string,8,17,636,;" + "gd3jyfw,¹É¶«3¾­Óª·¶Î§,string,16,18,644,;" + "gd4mc,¹É¶«4Ãû³Æ,string,160,19,660,;" + "gd4cgsl,¹É¶«4³Ö¹ÉÊýÁ¿,double,8,20,820,;" + "gd4cgbl,¹É¶«4³Ö¹É±ÈÀý,single,4,21,828,;" + "gd4bz,¹É¶«4±¸×¢,string,20,22,832,;" + "gd4fr,¹É¶«4·¨ÈË,string,8,23,852,;" + "gd4jyfw,¹É¶«4¾­Óª·¶Î§,string,16,24,860,;" + "gd5mc,¹É¶«5Ãû³Æ,string,160,25,876,;" + "gd5cgsl,¹É¶«5³Ö¹ÉÊýÁ¿,double,8,26,1036,;" + "gd5cgbl,¹É¶«5³Ö¹É±ÈÀý,single,4,27,1044,;" + "gd5bz,¹É¶«5±¸×¢,string,20,28,1048,;" + "gd5fr,¹É¶«5·¨ÈË,string,8,29,1068,;" + "gd5jyfw,¹É¶«5¾­Óª·¶Î§,string,16,30,1076,;" + "gd6mc,¹É¶«6Ãû³Æ,string,160,31,1092,;" + "gd6cgsl,¹É¶«6³Ö¹ÉÊýÁ¿,double,8,32,1252,;" + "gd6cgbl,¹É¶«6³Ö¹É±ÈÀý,single,4,33,1260,;" + "gd6bz,¹É¶«6±¸×¢,string,20,34,1264,;" + "gd6fr,¹É¶«6·¨ÈË,string,8,35,1284,;" + "gd6jyfw,¹É¶«6¾­Óª·¶Î§,string,16,36,1292,;" + "gd7mc,¹É¶«7Ãû³Æ,string,160,37,1308,;" + "gd7cgsl,¹É¶«7³Ö¹ÉÊýÁ¿,double,8,38,1468,;" + "gd7cgbl,¹É¶«7³Ö¹É±ÈÀý,single,4,39,1476,;" + "gd7bz,¹É¶«7±¸×¢,string,20,40,1480,;" + "gd7fr,¹É¶«7·¨ÈË,string,8,41,1500,;" + "gd7jyfw,¹É¶«7¾­Óª·¶Î§,string,16,42,1508,;" + "gd8mc,¹É¶«8Ãû³Æ,string,160,43,1524,;" + "gd8cgsl,¹É¶«8³Ö¹ÉÊýÁ¿,double,8,44,1684,;" + "gd8cgbl,¹É¶«8³Ö¹É±ÈÀý,single,4,45,1692,;" + "gd8bz,¹É¶«8±¸×¢,string,20,46,1696,;" + "gd8fr,¹É¶«8·¨ÈË,string,8,47,1716,;" + "gd8jyfw,¹É¶«8¾­Óª·¶Î§,string,16,48,1724,;" + "gd9mc,¹É¶«9Ãû³Æ,string,160,49,1740,;" + "gd9cgsl,¹É¶«9³Ö¹ÉÊýÁ¿,double,8,50,1900,;" + "gd9cgbl,¹É¶«9³Ö¹É±ÈÀý,single,4,51,1908,;" + "gd9bz,¹É¶«9±¸×¢,string,20,52,1912,;" + "gd9fr,¹É¶«9·¨ÈË,string,8,53,1932,;" + "gd9jyfw,¹É¶«9¾­Óª·¶Î§,string,16,54,1940,;" + "gd10mc,¹É¶«10Ãû³Æ,string,160,55,1956,;" + "gd10cgsl,¹É¶«10³Ö¹ÉÊýÁ¿,double,8,56,2116,;" + "gd10cgbl,¹É¶«10³Ö¹É±ÈÀý,single,4,57,2124,;" + "gd10bz,¹É¶«10±¸×¢,string,20,58,2128,;" + "gd10fr,¹É¶«10·¨ÈË,string,8,59,2148,;" + "gd10jyfw,¹É¶«10¾­Óª·¶Î§,string,16,60,2156,;" + "gdzs,¹É¶«×ÜÊý,int,4,61,2172,;" + "gjgfrggds,¹ú¼Ò¹É·¨È˹ɹɶ«Êý,int,4,62,2176,;" + "aggds,Á÷ͨ¹ÉA¹É¹É¶«Êý,int,4,63,2180,;" + "bggds,Á÷ͨ¹ÉB¹É¹É¶«Êý,int,4,64,2184,"; break; #endregion #region »ù½ðÖܱ¨fundweek.fdt case DataTypes.jjjz: fileName = "FUNDWEEK.FDT"; startAddress = 0x41000; blockSize = 12032; recordSize = 188; codeIsLong = true; fieldString = "dm,´úÂë,code,12,0,0,;" + "rq,ÈÕÆÚ,date,4,13,184,;" + "dwjz,»ù½ðµ¥Î»¾»Öµ,single,4,6,152,;" + "jjze,»ù½ð¾»Öµ×ܶî,double,8,5,144,;" + "gm,»ù½ð¹æÄ£,double,8,4,136,;" + "dwcz,»ù½ðµ¥Î»³õÖµ,single,4,7,156,;" + "tzhjz,»ù½ðµ÷Õûºó¾»Öµ,single,4,8,160,;" + "tzhcz,»ù½ðµ÷Õûºó³õÖµ,single,4,9,164,;" + "zzl,»ù½ðÔö³¤ÂÊ(%),double,8,10,168,;" + "ljjz,»ù½ðÀۼƾ»Öµ,single,4,11,176,;" + "slrq,»ù½ðÉèÁ¢ÈÕÆÚ,date,4,1,12,;" + "glr,»ù½ð¹ÜÀíÈË,string,60,2,16,;" + "tgr,»ù½ðÍйÜÈË,string,60,3,76," ;//12Ϊ±£Áô×ֶΠbreak; #endregion #region »ù½ðͶ×Ê×éºÏfunddiv.fdt case DataTypes.jjzh: fileName = "FUNDDIV.FDT"; startAddress = 0x41000; blockSize = 8320; recordSize = 260; codeIsLong = true; fieldString = "dm,´úÂë,code,12,0,0,;" + "bgrq,±¨¸æÈÕÆÚ,date,4,31,252,;" + "zzrq,½ØÖ¹ÈÕÆÚ,date,4,32,256,;" + "dm1,֤ȯ1´úÂë,string,12,1,12,;" + "sz1,֤ȯ1ÊÐÖµ,double,8,2,24,;" + "bl1,֤ȯ1Õ¼¾»Öµ±ÈÀý(%),single,4,3,32,;" + "dm2,֤ȯ2´úÂë,string,12,4,36,;" + "sz2,֤ȯ2ÊÐÖµ,double,8,5,48,;" + "bl2,֤ȯ2Õ¼¾»Öµ±ÈÀý(%),single,4,6,56,;" + "dm3,֤ȯ3´úÂë,string,12,7,60,;" + "sz3,֤ȯ3ÊÐÖµ,double,8,8,72,;" + "bl3,֤ȯ3Õ¼¾»Öµ±ÈÀý(%),single,4,9,80,;" + "dm4,֤ȯ4´úÂë,string,12,10,84,;" + "sz4,֤ȯ4ÊÐÖµ,double,8,11,96,;" + "bl4,֤ȯ4Õ¼¾»Öµ±ÈÀý(%),single,4,12,104,;" + "dm5,֤ȯ5´úÂë,string,12,13,108,;" + "sz5,֤ȯ5ÊÐÖµ,double,8,14,120,;" + "bl5,֤ȯ5Õ¼¾»Öµ±ÈÀý(%),single,4,15,128,;" + "dm6,֤ȯ6´úÂë,string,12,16,132,;" + "sz6,֤ȯ6ÊÐÖµ,double,8,17,144,;" + "bl6,֤ȯ6Õ¼¾»Öµ±ÈÀý(%),single,4,18,152,;" + "dm7,֤ȯ7´úÂë,string,12,19,156,;" + "sz7,֤ȯ7ÊÐÖµ,double,8,20,168,;" + "bl7,֤ȯ7Õ¼¾»Öµ±ÈÀý(%),single,4,21,176,;" + "dm8,֤ȯ8´úÂë,string,12,22,180,;" + "sz8,֤ȯ8ÊÐÖµ,double,8,23,192,;" + "bl8,֤ȯ8Õ¼¾»Öµ±ÈÀý(%),single,4,24,200,;" + "dm9,֤ȯ9´úÂë,string,12,25,204,;" + "sz9,֤ȯ9ÊÐÖµ,double,8,26,216,;" + "bl9,֤ȯ9Õ¼¾»Öµ±ÈÀý(%),single,4,27,224,;" + "dm10,֤ȯ10´úÂë,string,12,28,228,;" + "sz10,֤ȯ10ÊÐÖµ,double,8,29,240,;" + "bl10,֤ȯ10Õ¼¾»Öµ±ÈÀý(%),single,4,30,248,"; break; #endregion #region °å¿éuserdata/block case DataTypes.bk: fileName = "BLOCK.DEF"; startAddress = 0; blockSize = 0; recordSize = 248; codeIsLong = false; isIndexDataStruct = false; fieldString = "lb,Àà±ð,string,20,0,0,;" + "bk,°å¿é,string,20,1,10,;" + "dm,֤ȯ´úÂë,string,10,2,42,"; break; #endregion #region ÆÀ¼¶ case DataTypes.pj: fileName = "ÆÀ¼¶.str"; startAddress = 0; blockSize = 256; recordSize = 256; codeIsLong = true; isIndexDataStruct = false; fieldString = "dm,֤ȯ´úÂë,string,12,0,0,;" + "pj,ÆÀ¼¶,string,2,2,0,;" + "sm,˵Ã÷,string,244,2,0,"; break; #endregion #region ¸´È¨ÐÐÇ飬¼ÆËã¶øµÃ case DataTypes.hqfq: fileName = "DAY.DAT"; startAddress = 0x41000; blockSize = 8192; recordSize = 32; codeIsLong = false; fieldString = "dm,´úÂë,code,10,0,0,;" + "rq,ÈÕÆÚ,date,4,1,0,;" + "kp,¿ªÅ̸´È¨¼Û,single,4,2,4,B;" + "zg,×î¸ß¸´È¨¼Û,single,4,3,8,B;" + "zd,×îµÍ¸´È¨¼Û,single,4,4,12,B;" + "sp,ÊÕÅ̸´È¨¼Û,single,4,5,16,B;" + "sl,¸´È¨³É½»ÊýÁ¿,single,4,6,20,A;" + "je,³É½»½ð¶î,single,4,7,24,;" + "spsyl,ÊÕÅÌÊÕÒæÂÊ,single,4,0,0,"; break; #endregion } string[] fieldLine = fieldString.Split(new char[] { ';' }); fields = new string[fieldLine.Length, 7]; for (int i = 0; i < fieldLine.Length; i++) { string[] field = fieldLine[i].Split(new char[] { ',' }, 7); for (int j = 0; j < field.Length; j++) { fields[i, j] = field[j]; } } } } private string fxjPath = ""; private string fxjDataPath = ""; private string[,] fxjMarket; private string msg = ""; private DateTime date19700101 = new DateTime(1970, 1, 1); private FileStream fs; private BinaryReader br; private void checkFileStream(string fxjFileName) { if (this.fs == null || (this.fs != null && this.fs.Name.ToUpper() != fxjFileName)) { if (this.fs != null) { fs.Close(); br.Close(); } fs = new FileStream(fxjFileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite); br = new BinaryReader(fs); } } public string Version { get { return ("0.7"); } } public int Error { get { if (msg != "") return 1; else return 0; } } public string Msg { get { return (msg); } } public string FxjPath //ÊôÐÔFxjPath { get { return (fxjPath); } set { fxjPath = value; fxjPath = fxjPath.Trim().ToUpper(); if (fxjPath != "" && !fxjPath.EndsWith(@"/")) { fxjPath += @"/"; } fxjPath = fxjPath.ToUpper(); } } public string FxjDataPath //ÊôÐÔFxjDataPath { get { return (fxjDataPath); } set { fxjDataPath = value; fxjDataPath = fxjDataPath.Trim().ToUpper(); if (fxjDataPath != "" && !fxjDataPath.EndsWith(@"/")) { fxjDataPath += @"/"; } fxjDataPath = fxjDataPath.ToUpper(); } } public string[,] GetMarkets() { return (fxjMarket); } public string[,] GetTables() { if (tableNames[0, 2] == "") { for (int i = 0; i < tableNames.GetLength(0); i++) { DataTypes d = (DataTypes)Enum.Parse(typeof(DataTypes), tableNames[i, 0].ToLower()); fileStruct fxjFileStruct = new fileStruct(d); tableNames[i, 2] = fxjFileStruct.fileName; } } return tableNames; } public string GetTableDef(string dataType, string descDataType, bool delOldTable) { dataType = dataType.Trim(); descDataType = descDataType.Trim(); string result = ""; fileStruct fxjFileStruct = new fileStruct((DataTypes)Enum.Parse(typeof(DataTypes), dataType.ToLower())); switch (descDataType.ToUpper()) { case "SAS": for (int i = 0; i < fxjFileStruct.fields.GetLength(0); i++) { if (result != "") result += ","; result += fxjFileStruct.fields[i, 0];//×ֶΠif (" ,code,string".IndexOf(fxjFileStruct.fields[i, 2]) > 0) { result += " char(" + fxjFileStruct.fields[i, 3] + ") format=$" + fxjFileStruct.fields[i, 3] + "."; //×Ö·û´® } else if (" ,int,single,double".IndexOf(fxjFileStruct.fields[i, 2]) > 0) { result += " num "; //ÊýÖµÀàÐÍ } else if (" ,date".IndexOf(fxjFileStruct.fields[i, 2]) > 0) { result += " num format=YYMMDD10."; //dateÀàÐÍ } else if (" ,datetime".IndexOf(fxjFileStruct.fields[i, 2]) > 0) { result += " num format=datetime."; //datetimeÀàÐÍ } result += " label='" + fxjFileStruct.fields[i, 1] + "'";//±êÇ© } result = "create table FinData." + dataType + "(" + result + ");"; if (delOldTable == true) { result = "drop table FinData." + dataType + ";" + result; } result = "proc sql;" + result + "quit;"; break; case "SASINPUT"://ÓÃÓÚSASÖ±½Ó¶ÁÈ¡Êý¾ÝʱËùÓõÄINPUTÓï¾ä£¬Ðè½øÒ»²½ÐÞ¸Ä for (int i = 0; i < fxjFileStruct.fields.GetLength(0); i++) { if (" ,code,string".IndexOf(fxjFileStruct.fields[i, 2]) > 0) { result += " @(p+" + fxjFileStruct.fields[i, 5] + ") " + fxjFileStruct.fields[i, 0] + " $" + fxjFileStruct.fields[i, 3] + "."; //×Ö·û´® } else if (" ,int,date,datetime".IndexOf(fxjFileStruct.fields[i, 2]) > 0) { result += " @(p+" + fxjFileStruct.fields[i, 5] + ") " + fxjFileStruct.fields[i, 0] + " ib" + fxjFileStruct.fields[i, 3] + "."; //ÊýÖµÀàÐÍ } else if (" ,single".IndexOf(fxjFileStruct.fields[i, 2]) > 0) { result += " @(p+" + fxjFileStruct.fields[i, 5] + ") " + fxjFileStruct.fields[i, 0] + " float" + fxjFileStruct.fields[i, 3] + "."; //ÊýÖµÀàÐÍ } else if (" ,double".IndexOf(fxjFileStruct.fields[i, 2]) > 0) { result += " @(p+" + fxjFileStruct.fields[i, 5] + ") " + fxjFileStruct.fields[i, 0] + " rb" + fxjFileStruct.fields[i, 3] + "."; //ÊýÖµÀàÐÍ } } break; case "FIELDS"://Áгö×Ö¶ÎÃû³Æ for (int i = 0; i < fxjFileStruct.fields.GetLength(0); i++) { result += " " + fxjFileStruct.fields[i, 0]; } break; default: result = ""; break; } return result; } public string GetCodeType(string code) { code = code.Trim().ToUpper(); if (Regex.IsMatch(code, @"(SH000300)") == true) { return "zs"; } if (Regex.IsMatch(code, @"(SH60[0-8]/d{3})|(SH90/d{4})|(SZ00[01256789]/d{3})|(SZ20/d{4})|(SZ4[02]/d{4})") == true) { return "gp"; } else if (Regex.IsMatch(code, @"(SH00000/d)|(SH00001[0-6])") == true) { return "zs"; } else if (Regex.IsMatch(code, @"(SH[012]/d{5})|(SZ1[0123]/d{4})") == true && Regex.IsMatch(code, @"(SH181/d{3})") == false && Regex.IsMatch(code, @"(SH190/d{3})") == false) { return "zq"; } else if (Regex.IsMatch(code, @"(SH5[01]/d{4})|(SZ184/d{3})|(SZ1[56]/d{4})") == true) { return "jj"; } else if (Regex.IsMatch(code, @"(SH58/d{4})|(SZ03/d{4})") == true) { return "qz"; } else if (Regex.IsMatch(code, @"(SH000/d{3})|(SZ399/d{3})|(SH8[013]/d{4})") == true) { return "zs"; } return ""; } private string[] GetCodes(string Market) //¶ÁÈ¡Day.datÖеĴúÂë { //»¦ÊÐÖ¸Êý´úÂëת»»±í,·ÖÎö¼Òͬʱ±£´æ»¦ÊÐÁ½Àà´úÂë string[,] codesRename = new string[,] { {"SH1A0001","SH000001"}, {"SH1A0002","SH000002"}, {"SH1A0003","SH000003"}, {"SH1B0001","SH000004"}, {"SH1B0002","SH000005"}, {"SH1B0004","SH000006"}, {"SH1B0005","SH000007"}, {"SH1B0006","SH000008"}, {"SH1B0007","SH000010"}, {"SH1B0008","SH000011"}, {"SH1B0009","SH000012"}, {"SH1B0010","SH000013"}, {"SH1C0003","SH000016"} }; long len = -1; long pos = 0; int flag; if (FxjDataPath == "") { msg = @"ÎÞ·¨ÔÚ×¢²á±íÖе½·ÖÎö¼ÒÊý¾ÝÎļþĿ¼£¬Çë×ÔÐн«ÊôÐÔ FxjDataPathÉèÖÃΪÓÐЧ·¾¶£¬Èçc:/fxj/data/¡£"; return new string[1] { null }; } Market = Market.Trim().ToUpper(); if (Market == "") { msg = "Market²ÎÊýÖ»ÄÜÊÇÊг¡¼ò³Æ£¬È绦ÊÐΪSH£¬ÉîÊÐΪSZ£¬Ïã¸ÛΪHKµÈ¡£"; return null; } string FxjFile = fxjDataPath + Market + @"/DAY.DAT"; msg = ""; if (!File.Exists(FxjFile)) //DAY.DATÎļþ²»´æÔÚ { msg = FxjFile + "²»´æÔÚ£¡"; return new string[1] { null }; } try { this.checkFileStream(FxjFile); int secCounts = 0;//ÎļþÖÐ֤ȯ×ÜÊý string code = ""; len = fs.Length; fs.Position = 0; flag = br.ReadInt32(); if (flag == -65823756) //0xFC139BF4 { fs.Position = 12; secCounts = br.ReadInt32(); string[] codes = new string[secCounts]; for (int i = 0; i < secCounts; i++) { pos = 24 + 64 * i; if (pos <= len) { fs.Position = pos; code = new string(br.ReadChars(10));//·ÖÎö¼ÒÓÃ10¸ö×Ö½Ú±£´æ´úÂ룬һ°ãÓÃ6¸ö×Ö½Ú code = Market + code.Replace("/0", ""); code = code.Replace("HKHK", "HK"); //Ïã¸Û֤ȯ´úÂë±¾Éí±£´æΪHKxxxx code = code.ToUpper(); for (int icode = 0; icode < codesRename.GetLength(0); icode++) { code = code.Replace(codesRename[icode, 0], codesRename[icode, 1]); } codes[i] = code; } } //fs.Close(); msg = ""; return codes; } } catch (Exception e) { msg = e.Message; } return new string[1] { null }; } public string[,] GetFields(string dataType) { msg = ""; try { DataTypes d = (DataTypes)Enum.Parse(typeof(DataTypes), dataType.ToLower()); return GetFields(d); } catch { msg = @"ÊäÈëµÄ²ÎÊýÓÐÎó¡£²ÎÊýÖ»ÄÜÊÇ:"; foreach (string s in Enum.GetNames(typeof(DataTypes))) msg += " /"" + s + "/""; msg += @" »òÕß "; foreach (int i in Enum.GetValues(typeof(DataTypes))) msg += " " + i.ToString(); return new string[1, 1] { { null } }; } } private string[,] GetFields(DataTypes dataType) { msg = ""; try { fileStruct fxjFileStruct = new fileStruct(dataType); string[,] fields = new string[fxjFileStruct.fields.GetLength(0), 3]; //fields[0, 0] = "<×Ö¶ÎÃû>"; fields[0, 1] = "<º¬Òå>"; fields[0, 2] = "<ÀàÐÍ>"; for (int i = 0; i < fxjFileStruct.fields.GetLength(0); i++) { for (int j = 0; j < 3; j++) { fields[i, j] = fxjFileStruct.fields[i, j]; } } return fields; } catch { msg = "´íÎó"; return new string[1, 1] { { null } }; } } /// <summary> /// ¶ÁÈ¡Êý¾Ý /// </summary> /// <param name="dataType">Êý¾ÝÀàÐÍ</param> /// <param name="code">´úÂë sh6000</param> /// <param name="iRecordCount">Òª¶ÁÈ¡µÄÊý¾ÝÌõÊý Èç¹ûÊÇ0 ÔòµÃµ½ËùÓеÄÊý¾Ý</param> /// <returns></returns> public string[,] GetData(string dataType, string code, int iRecordCount) { return GetData(dataType, code, "", iRecordCount); } /// <summary> /// ¶ÁÈ¡Êý¾Ý /// </summary> /// <param name="dataType">Êý¾ÝÀàÐÍ</param> /// <param name="code">´úÂë sh6000</param> /// <param name="newFileName">Ò»°ãΪ¿Õ£¬½öÓÃÓÚ¶ÁÈ¡ÀúÊ··Ö±Ê³É½»Êý¾Ý</param> /// <param name="iRecordCount">Òª¶ÁÈ¡µÄÊý¾ÝÌõÊý Èç¹ûÊÇ0 ÔòµÃµ½ËùÓеÄÊý¾Ý</param> /// <returns></returns> public string[,] GetData(string dataType, string code, string newFileName, int iRecordCount) { try { DataTypes d = (DataTypes)Enum.Parse(typeof(DataTypes), dataType.ToLower()); return GetData(d, code, newFileName, iRecordCount); } catch { msg = @"ÊäÈëµÄ²ÎÊýÓÐÎó¡£µÚÒ»¸ö²ÎÊýÖ»ÄÜÊÇ:"; foreach (string s in Enum.GetNames(typeof(DataTypes))) msg += " /"" + s + "/""; msg += @" »òÕß "; foreach (int i in Enum.GetValues(typeof(DataTypes))) msg += " " + i.ToString(); return new string[1, 1] { { null } }; } } /// <summary> /// ¶ÁÈ¡Êý¾Ý /// </summary> /// <param name="dataType">Êý¾ÝÀàÐÍ</param> /// <param name="code">´úÂë sh60000</param> /// <param name="newFileName">Ò»°ãΪ¿Õ£¬½öÓÃÓÚ¶ÁÈ¡ÀúÊ··Ö±Ê³É½»Êý¾Ý</param> /// <param name="iRecordCount">Òª¶ÁÈ¡µÄÊý¾ÝÌõÊý Èç¹ûÊÇ0 ÔòµÃµ½ËùÓеÄÊý¾Ý</param> /// <returns></returns> private string[,] GetData(DataTypes dataType, string code, string newFileName, int iRecordCount) //¶ÁÈ¡Êý¾Ý£¬ÖØÔØ { if (dataType == DataTypes.bk) { return GetBK(code); } if (dataType == DataTypes.pj) { return GetPJ(code); } if (dataType == DataTypes.hqfq) { //¸ù¾ÝÊÇ·ñΪ0 ÉèÖà ÊÇ·ñÊǵõ½×îºóÒ»Ìì(×îÐÂÊÕÅ̼ÛÈÕÆÚ)µÄ¼Û¸ñ if (iRecordCount != 0) { return GetHqfq(code, newFileName, false); } else { return GetHqfq(code, newFileName, true); } } #region ¶ÁÈ¡Êý¾ÝÇ°³õʼ»¯ msg = ""; fileStruct fxjFileStruct = new fileStruct(dataType); if (newFileName != "") fxjFileStruct.fileName = newFileName; //Èç¹ûÓû§ÖØÐÂÖ¸¶¨ÁËÎļþÃû code = code.Trim().ToUpper(); if (code == "") { msg = @"CODE²ÎÊý²»¿ÉΪ¿Õ¡£ÇëÌṩ֤ȯ´úÂ룬ÈçSZ000001¡£"; return new string[1, 1] { { null } }; } ArrayList recordList = new ArrayList(); int intField; float floatField; double doubleField; //string stringField; System.Globalization.CultureInfo cnCultureInfo = new System.Globalization.CultureInfo("zh-CN"); string market = code.Substring(0, 2); int recordCounts = 0; short[] blocks = new short[25]; long len = -1; long pos = 0; if (this.FxjDataPath == "") { msg = @"ÎÞ·¨ÔÚ×¢²á±íÖе½·ÖÎö¼ÒÊý¾ÝÎļþĿ¼£¬Çë×ÔÐн«ÊôÐÔ FxjDataPathÉèÖÃΪÓÐЧ·¾¶£¬Èçc:/fxj/data/¡£"; return new string[1, 1] { { null } }; } string FxjFile = fxjDataPath + fxjFileStruct.fileName; FxjFile = FxjFile.ToUpper(); if (!File.Exists(FxjFile)) { FxjFile = fxjDataPath + market + @"/" + fxjFileStruct.fileName; } msg = ""; if (!File.Exists(FxjFile)) { msg = fxjFileStruct.fileName + "ûÓÐÕÒµ½£¡"; return new string[1, 1] { { null } }; } #endregion if (fxjFileStruct.isIndexDataStruct == true) { #region ´¦ÀíDAY.DATµÈ½á¹¹£¨Ë÷Òý/Êý¾Ý£©µÄÊý¾Ý try { this.checkFileStream(FxjFile); int secCounts = 0;//ÎļþÖÐ֤ȯ×ÜÊý string code0 = ""; len = fs.Length; fs.Position = 12; secCounts = br.ReadInt32(); bool codeRead = false; for (int i = 0; i < secCounts && codeRead == false; i++) { pos = 24 + 64 * i; if (pos <= len) { fs.Position = pos; //code0 = new string(br.ReadChars(10));//·ÖÎö¼ÒÓÃ10¸ö×Ö½Ú±£´æ´úÂ룬һ°ãÓÃ8¸ö×Ö½Ú code0 = System.Text.Encoding.Default.GetString(br.ReadBytes(10)); code0 = code0.Replace("/0", ""); code0 = code0.Replace("HKHK", "HK"); //Ïã¸Û֤ȯ´úÂë±¾Éí±£´æΪHKxxxx if (fxjFileStruct.codeIsLong == false && code == market + code0 || fxjFileStruct.codeIsLong == true && code == code0) { recordCounts = br.ReadInt32(); for (int j = 0; j < 25; j++) { blocks[j] = br.ReadInt16(); } codeRead = true; } } } int iRecord = 1;//¼Ç¼ int iBlock = 0;//µÚiBlock¿é int fieldCounts = fxjFileStruct.fields.GetLength(0); while (iBlock < 25 && blocks[iBlock] != -1) { int r = 0; while (iRecord < recordCounts + 1 && r < fxjFileStruct.blockSize / fxjFileStruct.recordSize) //16=3776/236 { string[] record = new string[fieldCounts]; pos = fxjFileStruct.startAddress + blocks[iBlock] * fxjFileStruct.blockSize + r * fxjFileStruct.recordSize; for (int iField = 0; iField < fieldCounts; iField++) { fs.Position = pos + Convert.ToInt64(fxjFileStruct.fields[iField, 5]); switch (fxjFileStruct.fields[iField, 2].ToLower()) { case "code": //code0 = new string(br.ReadChars(8));//ÓÐ12λ£¬Êµ¼ÊÓÃÁË8룬µÚ9-12λһ°ãΪ/0£¬ÓÐʱÊÇ´íÎó×Ö½Ú£¬ÒòΪֻ¶Á8λ //code0 = code0.Replace("/0", ""); record[iField] = code; break; case "date": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddDays(intField / 86400)).ToString("yyyy-MM-dd")); break; case "datetime": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddSeconds(intField)).ToString("yyyy-MM-dd HH:mm:ss")); break; case "int": intField = br.ReadInt32(); record[iField] = intField.ToString("D", cnCultureInfo); break; case "single": //floatField = br.ReadSingle(); //if (fxjFileStruct.fields[iField, 6].ToUpper() == "A") floatField *= 100; //record[iField] = floatField.ToString("G", cnCultureInfo); doubleField = (double)br.ReadSingle(); if (fxjFileStruct.fields[iField, 6].ToUpper() == "A") doubleField *= 100; record[iField] = doubleField.ToString("_jj_qz".IndexOf(this.GetCodeType(code)) > 0 ? "F3" : "F", cnCultureInfo); break; case "double": doubleField = br.ReadDouble(); record[iField] = doubleField.ToString("F", cnCultureInfo); break; case "string": record[iField] = System.Text.Encoding.Default.GetString(br.ReadBytes(Convert.ToInt32(fxjFileStruct.fields[iField, 3]))).Replace("/0", ""); break; } } recordList.Add(record); r = r + 1; iRecord = iRecord + 1; } iBlock = iBlock + 1; } //fs.Close(); //ÉèÖÃÏÔʾµÄÊý¾ÝÌõÊý if (iRecordCount == 0 || iRecordCount > recordList.Count) { iRecordCount = recordList.Count; } string[,] records = new string[recordList.Count, fieldCounts]; for (int i = 0; i < iRecordCount; i++) { //µ¹ÐòÈ¡³ö string[] record0 = (string[])recordList[recordList.Count - 1 - i]; //string[] record0 = (string[])recordList[i]; for (int j = 0; j < fieldCounts; j++) { records[i, j] = record0[j]; } } if (records.GetLength(0) == 0) msg = "ûÓжÁµ½Êý¾Ý!"; return records; } catch (Exception e) { msg = e.Message; } #endregion } else { switch (dataType) { case DataTypes.dm: #region ´úÂë±í£¨´¦ÀíSTKINFO51.DATµÈ½á¹¹µÄÊý¾Ý£© try { this.checkFileStream(FxjFile); string[,] codesRename = new string[,] { {"SH1A0001","SH000001"}, {"SH1A0002","SH000002"}, {"SH1A0003","SH000003"}, {"SH1B0001","SH000004"}, {"SH1B0002","SH000005"}, {"SH1B0004","SH000006"}, {"SH1B0005","SH000007"}, {"SH1B0006","SH000008"}, {"SH1B0007","SH000010"}, {"SH1B0008","SH000011"}, {"SH1B0009","SH000012"}, {"SH1B0010","SH000013"}, {"SH1C0003","SH000016"} }; int secCounts = 0;//ÎļþÖÐ֤ȯ×ÜÊý string code0 = ""; fs.Position = 8; secCounts = br.ReadInt32(); int fieldCounts = fxjFileStruct.fields.GetLength(0); for (int i = 0; i < secCounts; i++) { pos = fxjFileStruct.startAddress + i * fxjFileStruct.recordSize; fs.Position = pos; code0 = System.Text.Encoding.Default.GetString(br.ReadBytes(10)); code0 = code0.Replace("/0", ""); code0 = code0.Replace("HKHK", "HK"); //Ïã¸Û֤ȯ´úÂë±¾Éí±£´æΪHKxxxx if (Regex.IsMatch(code0, @"(1[ABC]00/d/d)") == false) { string[] recordFieldName = new string[fieldCounts]; string[] record = new string[fieldCounts]; for (int iField = 0; iField < fieldCounts; iField++) { fs.Position = pos + Convert.ToInt64(fxjFileStruct.fields[iField, 5]); switch (fxjFileStruct.fields[iField, 2].ToLower()) { case "code": record[iField] = fxjFileStruct.codeIsLong == true ? code0 : market + code0; record[iField] = record[iField].Replace("HKHK", "HK"); for (int icode = 0; icode < codesRename.GetLength(0); icode++) { record[iField] = record[iField].Replace(codesRename[icode, 0], codesRename[icode, 1]); } break; case "date": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddDays(intField / 86400)).ToString("yyyy-MM-dd")); break; case "datetime": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddSeconds(intField)).ToString("yyyy-MM-dd HH:mm:ss")); break; case "int": intField = br.ReadInt32(); record[iField] = intField.ToString("D"); break; case "single": floatField = br.ReadSingle(); if (fxjFileStruct.fields[iField, 6].ToUpper() == "A") floatField *= 100; record[iField] = floatField.ToString("F"); break; case "double": doubleField = br.ReadDouble(); record[iField] = doubleField.ToString("F"); break; case "string": record[iField] = System.Text.Encoding.Default.GetString(br.ReadBytes(Convert.ToInt32(fxjFileStruct.fields[iField, 3]))).Replace("/0", ""); break; } } recordList.Add(record); } } //fs.Close(); //ÉèÖÃÏÔʾµÄÊý¾ÝÌõÊý if (iRecordCount == 0 || iRecordCount > recordList.Count) { iRecordCount = recordList.Count; } string[,] records = new string[recordList.Count, fieldCounts]; for (int i = 0; i < iRecordCount; i++) { //µ¹ÐòÈ¡³ö string[] record0 = (string[])recordList[recordList.Count - 1 - i]; //string[] record0 = (string[])recordList[i]; for (int j = 0; j < fieldCounts; j++) { records[i, j] = record0[j]; } } if (records.GetLength(0) == 0) msg = "ûÓжÁµ½Êý¾Ý!"; return records; } catch (Exception e) { msg = e.Message; } #endregion break; case DataTypes.hq0: #region ×îÐÂÐÐÇ飨´¦ÀíSTKINFO51.DATµÈ½á¹¹µÄÊý¾Ý£© try { this.checkFileStream(FxjFile); int secCounts = 0;//ÎļþÖÐ֤ȯ×ÜÊý string code0 = ""; fs.Position = 8; secCounts = br.ReadInt32(); int fieldCounts = fxjFileStruct.fields.GetLength(0); bool hasCode = false; for (int i = 0; i < secCounts && hasCode == false; i++) { pos = fxjFileStruct.startAddress + i * fxjFileStruct.recordSize; fs.Position = pos; code0 = System.Text.Encoding.Default.GetString(br.ReadBytes(10)); code0 = code0.Replace("/0", ""); code0 = code0.Replace("HKHK", "HK"); //Ïã¸Û֤ȯ´úÂë±¾Éí±£´æΪHKxxxx if (fxjFileStruct.codeIsLong == false && code == market + code0 || fxjFileStruct.codeIsLong == true && code == code0) { hasCode = true; string[] record = new string[fieldCounts]; for (int iField = 0; iField < fieldCounts; iField++) { fs.Position = pos + Convert.ToInt64(fxjFileStruct.fields[iField, 5]); switch (fxjFileStruct.fields[iField, 2].ToLower()) { case "code": record[iField] = code; break; case "date": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddDays(intField / 86400)).ToString("yyyy-MM-dd")); break; case "datetime": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddSeconds(intField)).ToString("yyyy-MM-dd HH:mm:ss")); break; case "int": intField = br.ReadInt32(); record[iField] = intField.ToString("D"); break; case "single": //floatField = br.ReadSingle(); //if (fxjFileStruct.fields[iField, 6].ToUpper() == "A") floatField *= 100; //record[iField] = Math.Round(floatField, 2).ToString("F"); doubleField = (double)br.ReadSingle(); if (fxjFileStruct.fields[iField, 6].ToUpper() == "A") doubleField *= 100; record[iField] = doubleField.ToString("_jj_qz".IndexOf(this.GetCodeType(code)) > 0 ? "F3" : "F", cnCultureInfo); break; case "double": doubleField = br.ReadDouble(); record[iField] = Math.Round(doubleField, 2).ToString("F"); break; case "string": record[iField] = System.Text.Encoding.Default.GetString(br.ReadBytes(Convert.ToInt32(fxjFileStruct.fields[iField, 3]))).Replace("/0", ""); break; } } recordList.Add(record); } } //fs.Close(); //ÉèÖÃÏÔʾµÄÊý¾ÝÌõÊý if (iRecordCount == 0 || iRecordCount > recordList.Count) { iRecordCount = recordList.Count; } string[,] records = new string[recordList.Count, fieldCounts]; for (int i = 0; i < iRecordCount; i++) { //µ¹ÐòÈ¡³ö string[] record0 = (string[])recordList[recordList.Count - 1 - i]; //string[] record0 = (string[])recordList[i]; for (int j = 0; j < fieldCounts; j++) { records[i, j] = record0[j]; } } if (records.GetLength(0) == 0) msg = "ûÓжÁµ½Êý¾Ý!"; return records; } catch (Exception e) { msg = e.Message; } #endregion break; case DataTypes.cq: #region ·ÖºìËÍÅ䣨´¦ÀíSTKINFO51.DATµÈ½á¹¹µÄÊý¾Ý£© try { this.checkFileStream(FxjFile); int secCounts = 0;//ÎļþÖÐ֤ȯ×ÜÊý string code0 = ""; fileStruct fxjdmStruct = new fileStruct(DataTypes.dm);// ´úÂëµÄ½á¹¹ int dmpos = 0; fs.Position = 8; secCounts = br.ReadInt32(); int fieldCounts = fxjFileStruct.fields.GetLength(0); bool hasCode = false; for (int i = 0; i < secCounts && hasCode == false; i++) { dmpos = fxjdmStruct.startAddress + i * fxjdmStruct.recordSize; fs.Position = dmpos; code0 = System.Text.Encoding.Default.GetString(br.ReadBytes(10)); code0 = code0.Replace("/0", ""); code0 = code0.Replace("HKHK", "HK"); //Ïã¸Û֤ȯ´úÂë±¾Éí±£´æΪHKxxxx if (fxjdmStruct.codeIsLong == false && code == market + code0 || fxjdmStruct.codeIsLong == true && code == code0) { hasCode = true; int iRecord = 0; pos = fxjFileStruct.startAddress + i * fxjFileStruct.blockSize + iRecord * fxjFileStruct.recordSize; fs.Position = pos; while (br.ReadInt32() != 0) { string[] record = new string[fieldCounts]; for (int iField = 0; iField < fieldCounts; iField++) { fs.Position = pos + Convert.ToInt64(fxjFileStruct.fields[iField, 5]); switch (fxjFileStruct.fields[iField, 2].ToLower()) { case "code": record[iField] = code; break; case "date": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddDays(intField / 86400)).ToString("yyyy-MM-dd")); break; case "datetime": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddSeconds(intField)).ToString("yyyy-MM-dd HH:mm:ss")); break; case "int": intField = br.ReadInt32(); record[iField] = intField.ToString("D"); break; case "single": floatField = br.ReadSingle(); if (fxjFileStruct.fields[iField, 6].ToUpper() == "A") floatField *= 100; record[iField] = Math.Round(floatField, 2).ToString("F"); break; case "double": doubleField = br.ReadDouble(); record[iField] = Math.Round(doubleField, 2).ToString("F"); break; case "string": record[iField] = System.Text.Encoding.Default.GetString(br.ReadBytes(Convert.ToInt32(fxjFileStruct.fields[iField, 3]))).Replace("/0", ""); break; } } recordList.Add(record); iRecord = iRecord + 1; pos = fxjFileStruct.startAddress + i * fxjFileStruct.blockSize + iRecord * fxjFileStruct.recordSize; fs.Position = pos; } } } //fs.Close(); //ÉèÖÃÏÔʾµÄÊý¾ÝÌõÊý if (iRecordCount == 0 || iRecordCount > recordList.Count) { iRecordCount = recordList.Count; } string[,] records = new string[recordList.Count, fieldCounts]; for (int i = 0; i < iRecordCount; i++) { //µ¹ÐòÈ¡³ö string[] record0 = (string[])recordList[recordList.Count - 1 - i]; //string[] record0 = (string[])recordList[i]; for (int j = 0; j < fieldCounts; j++) { records[i, j] = record0[j]; } } if (records.GetLength(0) == 0) msg = "ûÓжÁµ½Êý¾Ý!"; return records; } catch (Exception e) { msg = e.Message; } #endregion break; case DataTypes.cw0: #region ²ÆÎñÊý¾Ý--¼òµ¥£¨´¦ÀíSTKINFO51.DATµÈ½á¹¹µÄÊý¾Ý£© try { this.checkFileStream(FxjFile); int secCounts = 0;//ÎļþÖÐ֤ȯ×ÜÊý string code0 = ""; fileStruct fxjdmStruct = new fileStruct(DataTypes.dm);// ´úÂëµÄ½á¹¹ int dmpos = 0; fs.Position = 8; secCounts = br.ReadInt32(); int fieldCounts = fxjFileStruct.fields.GetLength(0); bool hasCode = false; for (int i = 0; i < secCounts && hasCode == false; i++) { dmpos = fxjdmStruct.startAddress + i * fxjdmStruct.recordSize; fs.Position = dmpos; code0 = System.Text.Encoding.Default.GetString(br.ReadBytes(10)); code0 = code0.Replace("/0", ""); code0 = code0.Replace("HKHK", "HK"); //Ïã¸Û֤ȯ´úÂë±¾Éí±£´æΪHKxxxx if (fxjdmStruct.codeIsLong == false && code == market + code0 || fxjdmStruct.codeIsLong == true && code == code0) { hasCode = true; int iRecord = 0; pos = fxjFileStruct.startAddress + i * fxjFileStruct.blockSize + iRecord * fxjFileStruct.recordSize; fs.Position = pos; string[] record = new string[fieldCounts]; for (int iField = 0; iField < fieldCounts; iField++) { fs.Position = pos + Convert.ToInt64(fxjFileStruct.fields[iField, 5]); switch (fxjFileStruct.fields[iField, 2].ToLower()) { case "code": record[iField] = code; break; case "date": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddDays(intField / 86400)).ToString("yyyy-MM-dd")); break; case "datetime": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddSeconds(intField)).ToString("yyyy-MM-dd HH:mm:ss")); break; case "int": intField = br.ReadInt32(); record[iField] = intField.ToString("D"); break; case "single": floatField = br.ReadSingle(); if (fxjFileStruct.fields[iField, 6].ToUpper() == "A") floatField *= 100; record[iField] = Math.Round(floatField, 2).ToString("F"); break; case "double": doubleField = br.ReadDouble(); record[iField] = Math.Round(doubleField, 2).ToString("F"); break; case "string": record[iField] = System.Text.Encoding.Default.GetString(br.ReadBytes(Convert.ToInt32(fxjFileStruct.fields[iField, 3]))).Replace("/0", ""); break; } } recordList.Add(record); } } //fs.Close(); //ÉèÖÃÏÔʾµÄÊý¾ÝÌõÊý if (iRecordCount == 0 || iRecordCount > recordList.Count) { iRecordCount = recordList.Count; } string[,] records = new string[recordList.Count, fieldCounts]; for (int i = 0; i < iRecordCount; i++) { //µ¹ÐòÈ¡³ö string[] record0 = (string[])recordList[recordList.Count - 1 - i]; //string[] record0 = (string[])recordList[i]; for (int j = 0; j < fieldCounts; j++) { records[i, j] = record0[j]; } } if (records.GetLength(0) == 0) msg = "ûÓжÁµ½Êý¾Ý!"; return records; } catch (Exception e) { msg = e.Message; } #endregion break; case DataTypes.hqmb: #region ´¦ÀíReport.DATÊý¾Ý£¨½á¹¹ÀàËÆDAY.DAT£¬µ«ÓÐЩÊýÖµÐèÒª½øÒ»²½¼ÆËã¶øÀ´£© try { this.checkFileStream(FxjFile); int secCounts = 0;//ÎļþÖÐ֤ȯ×ÜÊý string code0 = ""; len = fs.Length; fs.Position = 12; secCounts = br.ReadInt32(); bool codeRead = false; for (int i = 0; i < secCounts && codeRead == false; i++) { pos = 24 + 64 * i; if (pos <= len) { fs.Position = pos; //code0 = new string(br.ReadChars(10));//·ÖÎö¼ÒÓÃ10¸ö×Ö½Ú±£´æ´úÂ룬һ°ãÓÃ8¸ö×Ö½Ú code0 = System.Text.Encoding.Default.GetString(br.ReadBytes(10)); code0 = code0.Replace("/0", ""); code0 = code0.Replace("HKHK", "HK"); //Ïã¸Û֤ȯ´úÂë±¾Éí±£´æΪHKxxxx if (fxjFileStruct.codeIsLong == false && code == market + code0 || fxjFileStruct.codeIsLong == true && code == code0) { recordCounts = br.ReadInt32(); for (int j = 0; j < 25; j++) { blocks[j] = br.ReadInt16(); } codeRead = true; } } } int iRecord = 1;//¼Ç¼ int iBlock = 0;//µÚiBlock¿é int fieldCounts = fxjFileStruct.fields.GetLength(0); while (iBlock < 25 && blocks[iBlock] != -1) { int r = 0; while (iRecord < recordCounts + 1 && r < fxjFileStruct.blockSize / fxjFileStruct.recordSize) //16=3776/236 { string[] record = new string[fieldCounts]; pos = fxjFileStruct.startAddress + blocks[iBlock] * fxjFileStruct.blockSize + r * fxjFileStruct.recordSize; for (int iField = 0; iField < fieldCounts; iField++) { fs.Position = pos + Convert.ToInt64(fxjFileStruct.fields[iField, 5]); switch (fxjFileStruct.fields[iField, 0].ToLower()) //ÕâÀïÓë¶ÁÈ¡DAY.DATÓ÷¨²»Í¬£¬ÅжϵÄÊÇ´úÂë¶ø²»ÊÇÀàÐÍ { case "dm": record[iField] = code; break; case "rq": intField = br.ReadInt32(); record[iField] = (intField == 0 ? "" : (date19700101.AddSeconds(intField)).ToString("yyyy-MM-dd HH:mm:ss")); break; case "zjcj": case "zss": case "je": floatField = br.ReadSingle(); record[iField] = floatField.ToString("_jj_qz".IndexOf(this.GetCodeType(code)) > 0 ? "F3" : "F"); break; case "mr1sl": case "mr2sl": case "mr3sl": case "mc1sl": case "mc2sl": case "mc3sl": record[iField] = br.ReadUInt16().ToString("D"); break; case "mr1jg": case "mr2jg": case "mr3jg": case "mc1jg": case "mc2jg": case "mc3jg": float jg = br.ReadSByte(); if ("_jj_qz".IndexOf(this.GetCodeType(code)) > 0) { jg = Convert.ToSingle(record[2]) + jg / 1000; record[iField] = jg.ToString("F3"); } else { jg = Convert.ToSingle(record[2]) + jg / 100; record[iField] = jg.ToString("F"); } break; case "xss": record[iField] = "";//ÏÖÊÖÊýÔÚÏÂÃæ¼ÆËã break; case "mm": int mm = br.ReadSByte(); record[iField] = ""; if (mm == -128) record[iField] = "ÄÚÅÌ"; //-128 = 0x80 if (mm == -64) record[iField] = "ÍâÅÌ"; //-64 = 0xC0 break; } } recordList.Add(record); r = r + 1; iRecord = iRecord + 1; } iBlock = iBlock + 1; } //fs.Close(); //ÉèÖÃÏÔʾµÄÊý¾ÝÌõÊý if (iRecordCount == 0 || iRecordCount > recordList.Count) { iRecordCount = recordList.Count; } float zssSaved = 0; string[,] records = new string[recordList.Count, fieldCounts]; for (int i = 0; i < iRecordCount; i++) { //µ¹ÐòÈ¡³ö string[] record0 = (string[])recordList[recordList.Count - 1 - i]; //string[] record0 = (string[])recordList[i]; for (int j = 0; j < fieldCounts; j++) { if (j == 5) //ÏÖÊÖÊý { record0[j] = (Convert.ToSingle(record0[3]) - zssSaved).ToString(); zssSaved = Convert.ToSingle(record0[3]); } records[i, j] = record0[j]; } } if (records.GetLength(0) == 0) msg = "ûÓжÁµ½Êý¾Ý!"; return records; } catch (Exception e) { msg = e.Message; } #endregion break; } } msg = "·µ»Ø¿ÕÊý×é¡£"; return new string[1, 1] { { null } }; } private string[,] GetBK(string code)//°å¿é¶¨ÒåÊý¾Ý { msg = ""; fileStruct fxjFileStruct = new fileStruct(DataTypes.bk); if (code == null) code = ""; code = code.Trim().ToUpper(); ArrayList recordList = new ArrayList(); if (this.FxjDataPath == "") { msg = @"ÎÞ·¨ÔÚ×¢²á±íÖе½·ÖÎö¼ÒÊý¾ÝÎļþĿ¼£¬Çë×ÔÐн«ÊôÐÔ FxjDataPathÉèÖÃΪÓÐЧ·¾¶£¬Èçc:/fxj/data/¡£"; return new string[1, 1] { { null } }; } string FxjBlockPath = fxjDataPath; FxjBlockPath = FxjBlockPath.ToUpper().Replace("//DATA//", "//USERDATA//BLOCK//"); //¼ÙÉèĿ¼Öк¬ÓÐdataÎÄ×Ö string FxjFile = FxjBlockPath + fxjFileStruct.fileName; msg = ""; if (!File.Exists(FxjFile)) { msg = "°å¿éÎļþÎÞ·¨ÕÒµ½¡£"; return new string[1, 1] { { null } }; } try { this.checkFileStream(FxjFile); string bklines = ""; string lb = ""; string bk = ""; string bkFile = ""; string dmLines = ""; int n = -1; bklines = System.Text.Encoding.Default.GetString(br.ReadBytes((int)fs.Length)); string[] bks = bklines.Replace("/r/n", "/n").Split(new Char[] { '/n' }); for (int i = 0; i < bks.Length; i++) { if (bks[i] != "") { bks[i] = bks[i].Trim(); if (bks[i].StartsWith("[") && bks[i].EndsWith("]")) { lb = bks[i].Replace("[", "").Replace("]", ""); } else { bk = bks[i]; if (bk != "") { if (code == "" || (code != "" && bk.ToUpper() == code)) { bkFile = FxjBlockPath + bk + ".blk"; if (File.Exists(bkFile)) { StreamReader bkReader = new StreamReader(bkFile); bkReader.Read(); bkReader.Read(); dmLines = bkReader.ReadToEnd(); dmLines = dmLines.Replace("/x05", "/0").Replace("/0Z00", "/0/0/0/0").Replace("/0/0/0/0", ","); string[] dms = dmLines.Split(','); string[,] record = new string[dms.Length, 3]; for (int r = 0; r < dms.Length; r++) { if (dms[r] != "") { n = n + 1; record[r, 0] = lb; record[r, 1] = bk; record[r, 2] = dms[r]; } } recordList.Add(record); } } } } } } //fs.Close(); if (n > 0) { string[,] records = new string[n + 1, 3]; int rr = 0; for (int i = 0; i < recordList.Count; i++) { string[,] record0 = (string[,])recordList[i]; for (int j = 0; j < record0.GetLength(0); j++) { if (record0[j, 0] != null && record0[j, 1] != null && record0[j, 2] != null) { records[rr, 0] = record0[j, 0]; records[rr, 1] = record0[j, 1]; records[rr, 2] = record0[j, 2]; rr = rr + 1; } } } if (records.GetLength(0) == 0) msg = "ûÓжÁµ½Êý¾Ý!"; return records; } } catch (Exception e) { msg = e.Message; } return new string[1, 1] { { null } }; } private string[,] GetPJ(string code)//ÆÀ¼¶Êý¾Ý { msg = ""; fileStruct fxjFileStruct = new fileStruct(DataTypes.pj); code = code.Trim().ToUpper(); ArrayList recordList = new ArrayList(); if (this.FxjDataPath == "") { msg = @"ÎÞ·¨ÔÚ×¢²á±íÖе½·ÖÎö¼ÒÊý¾ÝÎļþĿ¼£¬Çë×ÔÐн«ÊôÐÔ FxjDataPathÉèÖÃΪÓÐЧ·¾¶£¬Èçc:/fxj/data/¡£"; return new string[1, 1] { { null } }; } string fxjSubPath = fxjDataPath; fxjSubPath = fxjSubPath.ToUpper().Replace("//DATA//", "//USERDATA//SelfData//"); //¼ÙÉèĿ¼Öк¬ÓÐdataÎÄ×Ö string FxjFile = fxjSubPath + fxjFileStruct.fileName; msg = ""; if (!File.Exists(FxjFile)) { msg = fxjFileStruct.fileName + "ÎÞ·¨ÕÒµ½¡£"; return new string[1, 1] { { null } }; } try { this.checkFileStream(FxjFile); int n = 0; int pos = fxjFileStruct.startAddress + n * fxjFileStruct.recordSize; fs.Position = pos; while (br.PeekChar() != -1) { string[] record = new string[3]; pos = fxjFileStruct.startAddress + n * fxjFileStruct.recordSize; fs.Position = pos; record[0] = System.Text.Encoding.Default.GetString(br.ReadBytes(8));//dm if (code == "" || (code != "" && code == record[0])) { fs.Position = pos + 12; record[2] = System.Text.Encoding.Default.GetString(br.ReadBytes(244)); record[1] = record[2].Substring(0, 2).Trim(); record[2] = record[2].Replace("/0", "").Trim(); if (record[0] != "") recordList.Add(record); } n = n + 1; } //fs.Close(); if (n > 0) { string[,] records = new string[recordList.Count, 3]; for (int i = 0; i < recordList.Count; i++) { string[] record0 = (string[])recordList[i]; if (record0[0] != null) { records[i, 0] = record0[0]; records[i, 1] = record0[1]; records[i, 2] = record0[2]; } } if (records.GetLength(0) == 0) msg = "ûÓжÁµ½Êý¾Ý!"; return records; } } catch (Exception e) { msg = e.Message; } return new string[1, 1] { { null } }; } /// <summary> /// ¸´È¨¼Û¸ñ,·ÖºìÔÙͶ×Ê,ÏòÇ°¸´È¨·¨ /// </summary> /// <param name="code">¹ÉƱ´úÂë SH600000</param> /// <param name="newFileName">Ò»°ã²»ÓÃ</param> /// <param name="isLastDay">ÊÇ·ñÊǵõ½×îºóÒ»Ìì(×îÐÂÊÕÅ̼ÛÈÕÆÚ)µÄ¼Û¸ñ£¬Èç¹û true Ôò£ºÅжÏ×îºóÒ»ÌìÊÇ·ñÓгýȨÐÅÏ¢£¨ÓУº·µ»ØËùÓеĸ´È¨ºóÊý¾Ý£¬Ã»ÓУº·µ»Ø×îºóÒ»ÌìµÄÊý¾Ý£©¡£Èç¹ûfalseÔò£ºÖ±½Ó·µ»ØËùÓеĸ´È¨ÐÅÏ¢ </param> /// <returns></returns> private string[,] GetHqfq(string code, string newFileName, bool isLastDay) { // FxjData fxj = new FxjData(); string[,] hq = this.GetData("hq", code, newFileName, 0); if (this.Error != 0 || hq.GetLength(1) < 4) { return new string[1, 1] { { null } }; } string[,] x = new string[hq.GetLength(0), 9]; //µÃµ½ËùÓеijýȨÐÅÏ¢ string[,] cq = this.GetData("cq", code, newFileName, 0); string fmt = "_jj_qz".IndexOf(this.GetCodeType(code)) > 0 ? "F3" : "F"; //Èç¹û if (isLastDay) { //Èç¹ûûÓн»Ò×ÐÐÇ飬¿ÉÄÜûÓÐÉÏÊеĹÉƱ ÆäʵÉÏÃæÒѾ­ÅÐ¶Ï if (hq.GetLength(0) == 0) { return null; } //Èç¹û´ÓûÓгýȨÐÅÏ¢ if (cq.GetLength(0) == 0) { //Èç¹û×îºóÒ»ÌìûÓгýȨÐÅÏ¢ string[,] lastData = new string[1, 9]; for (int k = 0; k < 8; k++) { lastData[0, k] = hq[0, k];//×îºóÒ»Ìõ¼Ç¼ } //·µ»Ø×îºóÒ»Ìì return lastData; } // ÐÐÇé ºÍ ³ýȨÐÅÏ¢¶¼´æÔÚ string hqLastDate = hq[0, 1]; string cqLastDate = cq[cq.GetLength(0) - 1, 1]; if (!hqLastDate.Equals(cqLastDate)) { //Èç¹û×îºóÒ»ÌìûÓгýȨÐÅÏ¢ string[,] lastData = new string[1, 9]; for (int k = 0; k < 8; k++) { lastData[0, k] = hq[0, k];//×îºóÒ»Ìõ¼Ç¼ } //·µ»Ø×îºóÒ»Ìì return lastData; } } if (this.Error != 0 || cq.GetLength(1) < 4 || cq.GetLength(0) == 0) //ûÓгýȨÐÅÏ¢ { for (int i = 0; i < hq.GetLength(0); i++) { for (int j = 0; j < hq.GetLength(1); j++) { x[i, j] = hq[i, j]; } if (i == 0) { x[i, hq.GetLength(1)] = "0.00000"; } else { x[i, hq.GetLength(1)] = (Single.Parse(hq[i, 5]) / Single.Parse(hq[i - 1, 5]) - 1).ToString("0.00000"); } } } else //ÓгýȨÐÅÏ¢ { DateTime[] cqdt = new DateTime[cq.GetLength(0)]; for (int j = 0; j < cq.GetLength(0); j++) cqdt[j] = new DateTime(int.Parse(cq[j, 1].Split('-')[0]), int.Parse(cq[j, 1].Split('-')[1]), int.Parse(cq[j, 1].Split('-')[2])); int i0 = hq.GetLength(0) - 1; DateTime hqdt_1, hqdt; double kp_1, zg_1, zd_1, sp_1, kp, zg, zd, sp, kpx, zgx, zdx, spx, sgbl, kpsyl, zgsyl, zdsyl, spsyl, pgbl, pgjg, fh; for (int k = 0; k < 8; k++) { x[i0, k] = hq[i0, k];//×îºóÒ»Ìõ¼Ç¼ } x[0, 8] = "0.00000"; kpx = double.Parse(x[i0, 2]); zgx = double.Parse(x[i0, 3]); zdx = double.Parse(x[i0, 4]); spx = double.Parse(x[i0, 5]); for (int i = i0; i > 0; i--) { sgbl = 0; pgbl = 0; pgjg = 0; fh = 0; hqdt_1 = new DateTime(int.Parse(hq[i - 1, 1].Split('-')[0]), int.Parse(hq[i - 1, 1].Split('-')[1]), int.Parse(hq[i - 1, 1].Split('-')[2])); hqdt = new DateTime(int.Parse(hq[i, 1].Split('-')[0]), int.Parse(hq[i, 1].Split('-')[1]), int.Parse(hq[i, 1].Split('-')[2])); for (int j = 0; j < cq.GetLength(0); j++) { if (hqdt_1 < cqdt[j] && cqdt[j] <= hqdt) { sgbl = double.Parse(cq[j, 2]); pgbl = double.Parse(cq[j, 3]); pgjg = double.Parse(cq[j, 4]); fh = double.Parse(cq[j, 5]); } } x[i - 1, 0] = hq[i - 1, 0];//dm x[i - 1, 1] = hq[i - 1, 1];//rq //syl=1+µÚtÈÕÊÕÒæÂÊ =( tÈÕÊÕÅ̼Û*(1+Ë͹ɱÈÀý+Åä¹É±ÈÀý)+·Öºì½ð¶î-Åä¹É¼Û¸ñ*Åä¹É±ÈÀý)/(t-1ÈÕÊÕÅ̼Û) kp = double.Parse(hq[i, 2]); zg = double.Parse(hq[i, 3]); zd = double.Parse(hq[i, 4]); sp = double.Parse(hq[i, 5]); kp_1 = double.Parse(hq[i - 1, 2]); zg_1 = double.Parse(hq[i - 1, 3]); zd_1 = double.Parse(hq[i - 1, 4]); sp_1 = double.Parse(hq[i - 1, 5]); kpsyl = (kp * (1 + sgbl + pgbl) + fh - pgjg * pgbl) / kp_1; zgsyl = (zg * (1 + sgbl + pgbl) + fh - pgjg * pgbl) / zg_1; zdsyl = (zd * (1 + sgbl + pgbl) + fh - pgjg * pgbl) / zd_1; spsyl = (sp * (1 + sgbl + pgbl) + fh - pgjg * pgbl) / sp_1; kpx = kpx / kpsyl; zgx = zgx / zgsyl; zdx = zdx / zdsyl; spx = spx / spsyl; x[i - 1, 2] = kpx.ToString(fmt); x[i - 1, 3] = zgx.ToString(fmt); x[i - 1, 4] = zdx.ToString(fmt); x[i - 1, 5] = spx.ToString(fmt); x[i - 1, 6] = hq[i - 1, 6];//sl ³É½»Á¿Î´¸´È¨ x[i - 1, 7] = hq[i - 1, 7];//je x[i, 8] = (spsyl - 1).ToString("0.00000");//spsyl ÊÕÅ̼ÛÊÕÒæÂÊ } } return x; } } }