{"id":19,"date":"2016-05-16T08:25:16","date_gmt":"2016-05-16T00:25:16","guid":{"rendered":"http:\/\/www.inhhh.com\/?p=19"},"modified":"2016-05-16T08:25:16","modified_gmt":"2016-05-16T00:25:16","slug":"%e6%94%b9%e5%86%99%e7%ad%96%e7%95%a5%e4%b8%ba%e7%8e%8btsking-%e6%ba%90%e4%bb%a3%e7%a0%81-%e5%a2%9e%e5%8a%a0-sql%e5%ad%98%e5%82%a8%e4%b8%89-%e5%88%9b%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%ba%93%e8%a1%a8","status":"publish","type":"post","link":"http:\/\/www.inhhh.com\/blog\/?p=19","title":{"rendered":"\u6539\u5199\u7b56\u7565\u4e3a\u738bTSKING (\u6e90\u4ee3\u7801) \u589e\u52a0 SQL\u5b58\u50a8\u4e09  \u521b\u5efa\u6570\u636e\u5e93\u8868"},"content":{"rendered":"<p>\/\/\u7f16\u5199\u4e86\u51e0\u4e2a\u8fde\u63a5\u6570\u636e\u5e93\u7684\u51fd\u6570\uff0c\u7531\u4e8e\u662f\u516c\u5171\u51fd\u6570\uff0c\u53ef\u4ee5\u72ec\u7acb\u7f16\u5199\u5728\u65b0\u7684\u6587\u4ef6\u4e2d\uff0c\u4f8b\u5982\u6211\u81ea\u5df1\u5efa\u4e86\u4e00\u4e2aStkFunction.h ,StkFunction.cpp\u4e0a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20\" src=\"http:\/\/www.inhhh.com\/blog\/wp-content\/uploads\/2016\/05\/Dbcnn.jpg\" alt=\"Dbcnn\" width=\"383\" height=\"653\" srcset=\"http:\/\/www.inhhh.com\/blog\/wp-content\/uploads\/2016\/05\/Dbcnn.jpg 383w, http:\/\/www.inhhh.com\/blog\/wp-content\/uploads\/2016\/05\/Dbcnn-176x300.jpg 176w\" sizes=\"auto, (max-width: 383px) 100vw, 383px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u5728CStkLibWnd \u4e2d\u589e\u52a0\u4e86\u6570\u636e\u5e93\u76f8\u5173\u7684\u53d8\u91cf\u53ca\u521d\u59cb\u5316\u7684\u51fd\u6570\uff0c<br \/>\nBOOL m_IsSqlDBConnect; \/\/\u662f\u5426\u5df2\u7ecf\u8fde\u63a5Sql Db<\/p>\n<p>_ConnectionPtr m_pCnn; \/\/\u8fde\u63a5\u6570\u636e\u5e93<\/p>\n<p>CSPString m_szConnString;\/\/\u8fde\u63a5\u5b57\u7b26\u4e32<\/p>\n<p>DBInitTable() ; \/\/\u6570\u636e\u5e93\u521d\u59cb\u5316<br \/>\nCnnExecuteSql(CSPString sSql, bool nErr); \/\/\u6267\u884cSql\u547d\u4ee4<\/p>\n<p>\/\/\/\/\/\/\/\/\u7528\u4e8e\u6267\u884cSql\u547d\u4ee4<\/p>\n<p>int CStkLibWnd::CnnExecuteSql(CSPString sSql, bool nErr)<br \/>\n{<br \/>\n_variant_t vntRecs[100];<br \/>\nlong lRecs=1;<br \/>\nif(nErr)<br \/>\n{<br \/>\ntry<br \/>\n{<br \/>\nm_pCnn-&gt;Execute(_bstr_t(sSql),<br \/>\nvntRecs,<br \/>\nadCmdText);<br \/>\n}<br \/>\ncatch(_com_error e)<br \/>\n{<br \/>\nlRecs=0;<br \/>\n}<br \/>\n}<br \/>\nelse<br \/>\n{<br \/>\nm_pCnn-&gt;Execute(_bstr_t(sSql),<br \/>\nvntRecs,<br \/>\nadCmdText);<br \/>\n}<br \/>\nreturn lRecs;<br \/>\n}<\/p>\n<p>\/\/ DBInitTable() \u53ea\u9700\u8981\u8fd0\u884c\u4e00\u6b21\u5373\u53ef\uff0c\u628atest()\u7684\u6539\u4e00\u4e0b\u5e76\u8fd0\u884c\u4e00\u6b21\u5c31\u597d\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>int CStkLibWnd::DBInitTable()<br \/>\n{<\/p>\n<p>CSPString sSql = &#8220;&#8221;;<br \/>\nint nflase =0;<\/p>\n<p>\/\/1. \u8bc1\u5238\u4ee3\u7801\u8868<\/p>\n<p>sSql= &#8220;CREATE TABLE STK_STOCK( \\n&#8221;<br \/>\n&#8220;m_wMarket [varchar](8), \\n&#8221;<br \/>\n&#8220;m_szLabel Varchar(10), \\n&#8221;<br \/>\n&#8220;m_szName Varchar(32), \\n&#8221;<br \/>\n&#8220;m_szPingYing [varchar](10), \\n&#8221;<br \/>\n&#8220;m_nUnit numeric(4), \\n&#8221;<br \/>\n&#8220;m_nDigit numeric(4), \\n&#8221;<br \/>\n&#8220;m_fLastClose [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_time] [datetime] ) \\n&#8221;;<br \/>\nnflase += CnnExecuteSql(sSql, true);<br \/>\n\/\/2. \u5b9e\u884c\u884c\u60c5<br \/>\nsSql= &#8220;CREATE TABLE STK_REPORT( \\n&#8221;<br \/>\n&#8220;[m_cbSize] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_wMarket] [varchar](8), \\n&#8221;<br \/>\n&#8220;[m_szLabel] [varchar](10) ,\\n&#8221;<br \/>\n&#8220;[m_szName] [varchar](30), \\n&#8221;<br \/>\n&#8220;[m_time] [datetime] , \\n&#8221;<br \/>\n&#8220;[m_dwFlag] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_fLast] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fOpen] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fHigh] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fLow] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fNew] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fVolume] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fAmount] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice1] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume1] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice1] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume1] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice2] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume2] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice2] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume2] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice3] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume3] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice3] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume3] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice4] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume4] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice4] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume4] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice5] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume5] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice5] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume5] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fAvgPrice] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_dwTickAll] [varchar](4)) \\n&#8221;;<\/p>\n<p>nflase += CnnExecuteSql(sSql, true);<\/p>\n<p>\/\/3. \u5206\u7b14\u6570\u636e\uff08\u76d8\u53e3\uff09 \u4e3b\u8868<\/p>\n<p>sSql= &#8220;CREATE TABLE STK_TICK_HDR ( \\n&#8221;<br \/>\n&#8220;[m_wMarket] [varchar](8), \\n&#8221;<br \/>\n&#8220;[m_szLabel] [varchar](10), \\n&#8221;<br \/>\n&#8220;[m_lDate] DateTime, \\n&#8221;<br \/>\n&#8220;[m_fLastClose] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fOpen] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_nAllCount] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_nCount] [numeric](18,6)) \\n&#8221;;<\/p>\n<p>nflase += CnnExecuteSql(sSql, true);<\/p>\n<p>\/\/4. \u5206\u7b14\u6570\u636e\uff08\u76d8\u53e3\uff09 \u4ece\u8868<\/p>\n<p>sSql= &#8220;CREATE TABLE STK_TICK( \\n&#8221;<br \/>\n&#8220;[m_wMarket] [varchar](8), \\n&#8221;<br \/>\n&#8220;[m_szLabel] [varchar](10) ,\\n&#8221;<br \/>\n&#8220;[m_szName] [varchar](30), \\n&#8221;<br \/>\n&#8220;[m_time] DateTime, \\n&#8221;<br \/>\n&#8220;[m_lTime] DateTime, \\n&#8221;<br \/>\n&#8220;[m_fHigh] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fLow] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fNewPrice] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fVolume] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fAmount] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_lStroke] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice1] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume1] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice1] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume1] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice2] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume2] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice2] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume2] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice3] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume3] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice3] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume3] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice4] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume4] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice4] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume4] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyPrice5] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fBuyVolume5] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellPrice5] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fSellVolume5] [numeric](18,6))\\n&#8221;;<br \/>\nnflase += CnnExecuteSql(sSql, true);<\/p>\n<p>\/\/5. \u8865\u5145\u9664\u6743\u6570\u636e<\/p>\n<p>sSql= &#8220;CREATE TABLE STK_POWER ( \\n&#8221;<br \/>\n&#8220;[m_dwHeadTag] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_wMarket] [varchar](8), \\n&#8221;<br \/>\n&#8220;[m_szLabel] [varchar](10), \\n&#8221;<br \/>\n&#8220;[m_time] DateTime, \\n&#8221;<br \/>\n&#8220;[m_fGive] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fPei] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fPeiPrice] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fProfit] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_dwReserved] [varchar](4)) \\n&#8221;;<br \/>\nnflase += CnnExecuteSql(sSql, true);<\/p>\n<p>\/\/6. \u5206\u65f6\u6570\u636e<\/p>\n<p>sSql= &#8220;CREATE TABLE STK_KDATA_MIN (\\n&#8221;<br \/>\n&#8220;[m_dwHeadTag] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_wMarket] [varchar](8), \\n&#8221;<br \/>\n&#8220;[m_szLabel] [varchar](10), \\n&#8221;<br \/>\n&#8220;[m_date] DateTime, \\n&#8221;<br \/>\n&#8220;[m_time] DateTime, \\n&#8221;<br \/>\n&#8220;[m_fOpen] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fHigh] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fLow] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fClose] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fVolume] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fAmount] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_dwAdvance] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_dwDecline] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_dwReserved] [varchar](4)) \\n&#8221;;<br \/>\nnflase += CnnExecuteSql(sSql, true);<br \/>\n\/\/7. \u65e5\u7ebf\u6570\u636e\u8868<\/p>\n<p>sSql= &#8220;CREATE TABLE STK_KDATA_DAY( \\n&#8221;<br \/>\n&#8220;[m_dwHeadTag] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_wMarket] [varchar](8), \\n&#8221;<br \/>\n&#8220;[m_szLabel] [varchar](10), \\n&#8221;<br \/>\n&#8220;[m_time] DateTime, \\n&#8221;<br \/>\n&#8220;[m_fOpen] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fHigh] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fLow] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fClose] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fVolume] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fAmount] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_wAdvance] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_wDecline] [varchar](4)) \\n&#8221;;<br \/>\nnflase += CnnExecuteSql(sSql, true);<br \/>\n\/\/8. 1\u5206\u949f\u6570\u636e\u7ebf<\/p>\n<p>sSql= &#8220;CREATE TABLE STK_KDATA_MIN1 (\\n&#8221;<br \/>\n&#8220;[m_dwHeadTag] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_wMarket] [varchar](8), \\n&#8221;<br \/>\n&#8220;[m_szLabel] [varchar](10), \\n&#8221;<br \/>\n&#8220;[m_date] DateTime, \\n&#8221;<br \/>\n&#8220;[m_time] DateTime, \\n&#8221;<br \/>\n&#8220;[m_fOpen] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fHigh] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fLow] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fClose] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fVolume] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fAmount] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_dwAdvance] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_dwDecline] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_dwReserved] [varchar](4)) \\n&#8221;;<br \/>\nnflase += CnnExecuteSql(sSql, true);<\/p>\n<p>\/\/9. 5\u5206\u949f\u6570\u636e\u7ebf<br \/>\nsSql= &#8220;CREATE TABLE STK_KDATA_MIN5 ( \\n&#8221;<br \/>\n&#8220;[m_dwHeadTag] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_wMarket] [varchar](8), \\n&#8221;<br \/>\n&#8220;[m_szLabel] [varchar](10), \\n&#8221;<br \/>\n&#8220;[m_date] DateTime, \\n&#8221;<br \/>\n&#8220;[m_time] DateTime, \\n&#8221;<br \/>\n&#8220;[m_fOpen] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fHigh] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fLow] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fClose] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fVolume] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_fAmount] [numeric](18,6), \\n&#8221;<br \/>\n&#8220;[m_dwAdvance] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_dwDecline] [varchar](4), \\n&#8221;<br \/>\n&#8220;[m_dwReserved] [varchar](4)) \\n&#8221;;<br \/>\nnflase += CnnExecuteSql(sSql, true);<\/p>\n<p>\/\/10. \u64cd\u4f5c\u8bb0\u5f55\u8868<\/p>\n<p>sSql= &#8220;CREATE TABLE STK_LOG ( \\n&#8221;<br \/>\n&#8221; m_date DateTime, \\n&#8221;<br \/>\n&#8221; m_Updated [varchar](10), \\n&#8221;<br \/>\n&#8221; m_nCount [numeric](8), \\n&#8221;<br \/>\n&#8221; m_wMarket [varchar](10), \\n&#8221;<br \/>\n&#8221; m_szLabel [varchar](10), \\n&#8221;<br \/>\n&#8221; m_Type [varchar](30)) \\n&#8221;;<br \/>\nnflase += CnnExecuteSql(sSql, true);<\/p>\n<p>&nbsp;<\/p>\n<p>\/\/11. \u57fa\u672c\u4fe1\u606f\u8868<br \/>\nsSql= &#8220;create table basedata( \\n&#8221;<br \/>\n&#8220;m_dwMarket varchar(8),\\n&#8221; \/\/ DWORD ; \u8bc1\u5238\u5e02\u573a\u7c7b\u578b,see CStock::StockMarket<br \/>\n&#8220;m_szCode varchar(8),\\n&#8221; \/\/ char m_szCode[STKLIB_MAX_CODE2]; \/\/ \u8bc1\u5238\u4ee3\u7801,\u4ee5&#8217;\\0&#8217;\u7ed3\u5c3e<br \/>\n&#8220;m_szDomain varchar(20),\\n&#8221; \/\/ char m_szDomain[STKLIB_MAX_DOMAIN]; \/\/ \u677f\u5757<br \/>\n&#8220;m_szProvince varchar(20),\\n&#8221; \/\/ char m_szProvince[STKLIB_MAX_PROVINCE]; \/\/ \u7701\u4efd<br \/>\n&#8220;m_time datetime,\\n&#8221; \/\/ time_t m_time; \/\/ \u65e5\u671f\uff0ctime_t<br \/>\n&#8220;m_date datetime,\\n&#8221; \/\/ DWORD m_date; \/\/ \u65e5\u671f Format is YYYYMMDD for base data<br \/>\n&#8220;m_reporttype numeric(18,6),\\n&#8221; \/\/ LONG m_reporttype; \/\/ \u62a5\u544a\u7c7b\u578b\uff1a\u5e74\u62a5\u3001\u4e2d\u62a5\u3001\u5b63\u62a5<br \/>\n&#8220;m_fErate_dollar numeric(18,6),\\n&#8221; \/\/ float m_fErate_dollar; \/\/ \u5f53\u671f\u7f8e\u5143\u6c47\u7387<br \/>\n&#8220;m_fErate_hkdollar numeric(18,6),\\n&#8221; \/\/float m_fErate_hkdollar; \/\/ \u5f53\u671f\u6e2f\u5e01\u6c47\u7387 &#8211;\/\/ \u2605\u507f\u503a\u80fd\u529b<br \/>\n&#8220;m_fRatio_liquidity numeric(18,6),\\n&#8221; \/\/ float m_fRatio_liquidity; \/\/ \u6d41\u52a8\u6bd4\u7387<br \/>\n&#8220;m_fRatio_quick numeric(18,6),\\n&#8221; \/\/ float m_fRatio_quick; \/\/ \u901f\u52a8\u6bd4\u7387<br \/>\n&#8220;m_fVelocity_receivables numeric(18,6),\\n&#8221; \/\/ float m_fVelocity_receivables; \/\/ \u5e94\u6536\u5e10\u6b3e\u5468\u7387&#8211;\/\/ \u2605\u7ecf\u8425\u80fd\u529b<br \/>\n&#8220;m_fVelocity_merchandise numeric(18,6),\\n&#8221; \/\/ float m_fVelocity_merchandise; \/\/ \u5b58\u8d27\u5468\u8f6c\u7387<br \/>\n&#8220;m_fMain_income numeric(18,6),\\n&#8221; \/\/ float m_fMain_income; \/\/ \u4e3b\u8425\u4e1a\u52a1\u6536\u5165<br \/>\n&#8220;m_fCash_ps numeric(18,6),\\n&#8221; \/\/ float m_fCash_ps; \/\/ \u6bcf\u80a1\u51c0\u73b0\u91d1\u6d41\u91cf&#8211;\/\/ \u2605\u76c8\u5229\u80fd\u529b<br \/>\n&#8220;m_fProfit_margin numeric(18,6),\\n&#8221; \/\/ float m_fProfit_margin; \/\/ \u4e3b\u8425\u4e1a\u52a1\u5229\u6da6\u7387 %<br \/>\n&#8220;m_fNetasset_yield numeric(18,6),\\n&#8221; \/\/ float m_fNetasset_yield; \/\/ \u51c0\u8d44\u4ea7\u6536\u76ca\u7387 %<br \/>\n&#8220;m_datebegin datetime,\\n&#8221; \/\/ DWORD m_datebegin; \/\/ \u4e0a\u5e02\u65e5\u671f Format is YYYYMMDD-\/\/ \u2605\u8d44\u672c\u7ed3\u6784<br \/>\n&#8220;m_fShare_count_total varchar(20),\\n&#8221; \/\/ float m_fShare_count_total; \/\/ \u603b\u80a1\u672c<br \/>\n&#8220;m_fShare_count_a varchar(20),\\n&#8221; \/\/ float m_fShare_count_a; \/\/ \u6d41\u901aA\u80a1<br \/>\n&#8220;m_fShare_count_b varchar(20),\\n&#8221; \/\/float m_fShare_count_b; \/\/ \u6d41\u901aB\u80a1<br \/>\n&#8220;m_fShare_count_h varchar(20),\\n&#8221; \/\/float m_fShare_count_h; \/\/ \u6d41\u901aH\u80a1<br \/>\n&#8220;m_fShare_count_national varchar(20),\\n&#8221; \/\/float m_fShare_count_national; \/\/ \u56fd\u6709\u80a1<br \/>\n&#8220;m_fShare_count_corp varchar(20),\\n&#8221; \/\/float m_fShare_count_corp; \/\/ \u6cd5\u4eba\u80a1<br \/>\n&#8220;m_fProfit_psud varchar(20),\\n&#8221; \/\/float m_fProfit_psud; \/\/ \u6bcf\u80a1\u672a\u5206\u914d\u5229\u6da6<br \/>\n&#8220;m_fAsset varchar(20),\\n&#8221; \/\/float m_fAsset; \/\/ \u603b\u8d44\u4ea7<br \/>\n&#8220;m_fRatio_holderright varchar(20),\\n&#8221; \/\/float m_fRatio_holderright; \/\/ \u80a1\u4e1c\u6743\u76ca\u6bd4\u7387<br \/>\n&#8220;m_fRatio_longdebt varchar(20),\\n&#8221; \/\/float m_fRatio_longdebt; \/\/ \u957f\u671f\u8d1f\u503a\u7387<br \/>\n&#8220;m_fRatio_debt varchar(20),\\n&#8221; \/\/float m_fRatio_debt; \/\/ \u8d44\u4ea7\u8d1f\u503a\u7387&#8211;\/\/ \u2605\u6295\u8d44\u6536\u76ca\u80fd\u529b<br \/>\n&#8220;m_fNetasset_ps varchar(20),\\n&#8221; \/\/float m_fNetasset_ps; \/\/ \u6bcf\u80a1\u51c0\u8d44\u4ea7<br \/>\n&#8220;m_fNetasset_ps_regulate varchar(20),\\n&#8221; \/\/float m_fNetasset_ps_regulate; \/\/ \u8c03\u6574\u6bcf\u80a1\u51c0\u8d44\u4ea7<br \/>\n&#8220;m_fEps varchar(20),\\n&#8221; \/\/float m_fEps; \/\/ \u6bcf\u80a1\u6536\u76ca<br \/>\n&#8220;m_fEps_deduct varchar(20),\\n&#8221; \/\/float m_fEps_deduct; \/\/ \u6263\u9664\u540e\u6bcf\u80a1\u6536\u76ca<br \/>\n&#8220;m_fNet_profit varchar(20),\\n&#8221; \/\/float m_fNet_profit; \/\/ \u51c0\u5229\u6da6<br \/>\n&#8220;m_fMain_profit varchar(20),\\n&#8221; \/\/float m_fMain_profit; \/\/ \u4e3b\u8425\u4e1a\u52a1\u5229\u6da6<br \/>\n&#8220;m_fTotal_profit varchar(20),\\n&#8221; \/\/float m_fTotal_profit; \/\/ \u5229\u6da6\u603b\u989d&#8211;\/\/ \u2605\u589e\u957f\u7387<br \/>\n&#8220;m_fProfit_inc varchar(20),\\n&#8221; \/\/float m_fProfit_inc; \/\/ \u4e3b\u8425\u5229\u6da6\u589e\u957f\u7387%<br \/>\n&#8220;m_fIncome_inc varchar(20),\\n&#8221; \/\/float m_fIncome_inc; \/\/ \u4e3b\u8425\u6536\u5165\u589e\u957f\u7387%<br \/>\n&#8220;m_fAsset_inc varchar(20),\\n&#8221; \/\/float m_fAsset_inc; \/\/ \u603b\u8d44\u4ea7\u589e\u957f\u7387%&#8221; &#8211;\/\/ \u2605\u6280\u672f\u6570\u636e\u7edf\u8ba1\u503c<br \/>\n&#8220;m_fYield_average varchar(20),\\n&#8221; \/\/float m_fYield_average; \/\/ \u5e73\u5747\u6536\u76ca\u7387%<br \/>\n&#8220;m_fYield_stddev varchar(20),\\n&#8221; \/\/float m_fYield_stddev; \/\/ \u6536\u76ca\u6807\u51c6\u5dee%<br \/>\n&#8220;m_fBeite varchar(20),\\n&#8221; \/\/float m_fBeite; \/\/ \u03b2\u503c<br \/>\n&#8220;m_dwReserved1 varchar(8),\\n&#8221; \/\/ DWORD m_dwReserved[4];<br \/>\n&#8220;m_dwReserved2 varchar(8),\\n&#8221; \/\/<br \/>\n&#8220;m_dwReserved3 varchar(8),\\n&#8221; \/\/<br \/>\n&#8220;m_dwReserved4 varchar(8),\\n&#8221; \/\/<br \/>\n&#8220;) \\n&#8221;; \/\/<\/p>\n<p>nflase += CnnExecuteSql(sSql, true);<\/p>\n<p>sSql.Format(&#8220;insert into STK_LOG (m_date, m_Updated, m_nCount, m_wMarket, m_szLabel, m_Type)&#8221;<br \/>\n&#8220;select GETDATE(),&#8217;SYSTEM&#8217;, %d, &#8221;,&#8221;,&#8217;\u8fde\u63a5\uff0c\u66f4\u65b0\u6570\u636e\u8868'&#8221;,nflase);<br \/>\nnflase += CnnExecuteSql(sSql,true);<\/p>\n<p>return nflase;<br \/>\n}<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\/\/\u7f16\u5199\u4e86\u51e0\u4e2a\u8fde\u63a5\u6570\u636e\u5e93\u7684\u51fd\u6570\uff0c\u7531\u4e8e\u662f\u516c\u5171\u51fd\u6570\uff0c\u53ef\u4ee5\u72ec\u7acb\u7f16\u5199\u5728\u65b0\u7684\u6587\u4ef6\u4e2d\uff0c\u4f8b\u5982\u6211\u81ea\u5df1\u5efa\u4e86\u4e00\u4e2aStkFuncti<\/p>\n<div class=\"more-link\">\n\t\t\t\t <a href=\"http:\/\/www.inhhh.com\/blog\/?p=19\" class=\"link-btn theme-btn\"><span>Read More <\/span> <i class=\"fa fa-caret-right\"><\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[3],"tags":[10,9,5,7],"class_list":["post-19","post","type-post","status-publish","format-aside","hentry","category-it","tag-sql","tag-tsking","tag-5","tag-7","post_format-post-format-aside"],"_links":{"self":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/19","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19"}],"version-history":[{"count":1,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":21,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions\/21"}],"wp:attachment":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}