};//用于保存excel的表头名称，及其位置
/// <summary>
/// 获取持仓状况
/// </summary>
public static void GetBalance(DataGridView dataGridView_warehouse)
{
IntPtr YHWindowHandle = WindowAPI.FindWindow(null, "网上股票交易系统5.0");
IntPtr Handle32770a = WindowAPI.FindWindowEx(YHWindowHandle, IntPtr.Zero, "#32770", null);
IntPtr Handle32770b = WindowAPI.FindWindowEx(YHWindowHandle, Handle32770a, "#32770", null);
IntPtr HandleAvailableFunds = WindowAPI.GetChildrenWindowHandle(Handle32770b, "Static", null, 3);
IntPtr HandleMarketValue = WindowAPI.GetChildrenWindowHandle(Handle32770b, "Static", null, 7);
IntPtr HandleAssets = WindowAPI.GetChildrenWindowHandle(Handle32770b, "Static", null, 9);
StringBuilder sb = new StringBuilder();
StringBuilder sbTemp = new StringBuilder();
WindowAPI.SendMessage(HandleAvailableFunds, WindowsMessage.WM_GETTEXT, 128, sbTemp);
sb.Append("可用资金：").Append(sbTemp.ToString());
WindowAPI.SendMessage(HandleMarketValue, WindowsMessage.WM_GETTEXT, 128, sbTemp);
sb.Append("，市值：").Append(sbTemp.ToString());
WindowAPI.SendMessage(HandleAssets, WindowsMessage.WM_GETTEXT, 128, sbTemp);
sb.Append("，总资产：").Append(sbTemp.ToString());
WindowAPI.SetForegroundWindow(YHWindowHandle); //把窗体置于最前
SendKeys.SendWait("{F4}"); //模拟键盘输入F4查询界面
Thread.Sleep(500);
SendKeys.SendWait("^s"); //Ctrl + S
Thread.Sleep(1000);
IntPtr HandleSaveAs = WindowAPI.FindWindowEx(IntPtr.Zero, IntPtr.Zero, "#32770", "另存为");
IntPtr HandleSaveAsEdit = WindowAPI.FindWindowEx(HandleSaveAs, IntPtr.Zero, "Edit", null);
IntPtr HandleSaveButton = WindowAPI.FindWindowEx(HandleSaveAs, IntPtr.Zero, "Button", "保存(&S)");
if ((int)HandleSaveButton > 0)
{
TimeSpan ts = DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, 0);
string tablesFileName = Application.StartupPath + "\\" + Convert.ToInt64(ts.TotalMilliseconds).ToString() + ".xls";
WindowAPI.SendMessage(HandleSaveAsEdit, WindowsMessage.WM_SETTEXT, 0, tablesFileName);
WindowAPI.SendMessage(HandleSaveButton, WindowsMessage.BM_CLICK, 1, "");
#region 读取excel
MSExcel.Application excelApp = new MSExcel.Application
{
Visible = false//是打开可见
};
MSExcel.Workbooks _workbooks = excelApp.Workbooks;
MSExcel._Workbook _workbook = _workbooks.Add(tablesFileName);
MSExcel._Worksheet worksheet;
worksheet = _workbook.Sheets[1];//获取第一张工作表
worksheet.Activate();
int excelIndex = 2;//第一行是表头，从第二行开始才是数据
while (true)
{
//证券代码 证券名称 当前持仓 可用余额 买入冻结 卖出冻结 参考盈亏 盈亏比例(%) 参考市值 参考成本价 参考市价 股东代码 交易市场 股份实时余额 股份余额
//300096 易联众 1100 1100 0 0 -27 -0.231 11638 10.605 10.58 174788455 深Ａ 1100 1100
MSExcel.Range rangStockCode = (MSExcel.Range)worksheet.Cells[excelIndex, 1];
if (rangStockCode.Value != null)
{
string stockCode = Convert.ToString(rangStockCode.Value);
string stockName = Convert.ToString(((MSExcel.Range)worksheet.Cells[excelIndex, 2]).Value);
string marketType = Convert.ToString(((MSExcel.Range)worksheet.Cells[excelIndex, 13]).Value);
int currentQty = Convert.ToInt32(((MSExcel.Range)worksheet.Cells[excelIndex, 3]).Value);
int availableQty = Convert.ToInt32(((MSExcel.Range)worksheet.Cells[excelIndex, 4]).Value);
double marketValue = Convert.ToDouble(((MSExcel.Range)worksheet.Cells[excelIndex, 9]).Value);
double costPrice = Convert.ToDouble(((MSExcel.Range)worksheet.Cells[excelIndex, 10]).Value);
int index = dataGridView_warehouse.Rows.Add();
dataGridView_warehouse.Rows[index].Cells[0].Value = stockCode;
dataGridView_warehouse.Rows[index].Cells[1].Value = stockName;
dataGridView_warehouse.Rows[index].Cells[2].Value = currentQty;
dataGridView_warehouse.Rows[index].Cells[3].Value = availableQty;
dataGridView_warehouse.Rows[index].Cells[4].Value = 0;
dataGridView_warehouse.Rows[index].Cells[5].Value = marketValue;
dataGridView_warehouse.Rows[index].Cells[6].Value = costPrice;
dataGridView_warehouse.Rows[index].Cells[7].Value = marketType;
}
else
{
break;
}
excelIndex++;
}
File.Delete(tablesFileName);
//关闭Excel对象
Marshal.ReleaseComObject(_workbook);
Marshal.ReleaseComObject(worksheet);
excelApp.Quit();
WindowAPI.Kill(excelApp);//调用方法关闭进程
GC.Collect();
#endregion
}
}
/// <summary>
/// 买入
/// </summary>
/// <param name="StockCode">股票代码</param>
/// <param name="Price">价格，输入0则以最新价买入</param>
/// <param name="QTY">数量</param>
public static bool Buy(string StockCode, double Price, int QTY)
{
IntPtr YHWindowHandle = WindowAPI.FindWindow(null, "网上股票交易系统5.0");
IntPtr AfxMDIFrame42sWindowHandle = WindowAPI.FindWindowEx(YHWindowHandle, IntPtr.Zero, "AfxMDIFrame42s", null);
IntPtr Handle32770 = WindowAPI.GetChildrenWindowHandle(AfxMDIFrame42sWindowHandle, "#32770", null, 4);
IntPtr HandleStockCodeEdit = WindowAPI.FindWindowEx(Handle32770, IntPtr.Zero, "Edit", null); //证券代码编辑框
IntPtr HandlePriceEdit = WindowAPI.FindWindowEx(Handle32770, HandleStockCodeEdit, "Edit", null); //买入价格编辑框
IntPtr HandleQTYEdit = WindowAPI.FindWindowEx(Handle32770, HandlePriceEdit, "Edit", null); //买入数量编辑框
IntPtr HandleBuyButton = WindowAPI.FindWindowEx(Handle32770, IntPtr.Zero, "Button", "买入[B]"); //买入按钮
IntPtr HandleStockName = WindowAPI.FindWindowEx(Handle32770, IntPtr.Zero, "Static", null); //股票名称
IntPtr HandlePriceList = WindowAPI.FindWindowEx(Handle32770, IntPtr.Zero, "#32770", null); //买5卖5
IntPtr HandlePriceSell5 = WindowAPI.FindWindowEx(HandlePriceList, IntPtr.Zero, "Static", null); //卖5
IntPtr HandlePriceSell4 = WindowAPI.FindWindowEx(HandlePriceList, HandlePriceSell5, "Static", null); //卖4
IntPtr HandlePriceSell3 = WindowAPI.FindWindowEx(HandlePriceList, HandlePriceSell4, "Static", null); //卖3
IntPtr HandlePriceSell2 = WindowAPI.FindWindowEx(HandlePriceList, HandlePriceSell3, "Static", null); //卖2
IntPtr HandlePriceSell1 = WindowAPI.FindWindowEx(HandlePriceList, HandlePriceSell2, "Static", null); //卖1
IntPtr HandlePriceNew = WindowAPI.FindWindowEx(HandlePriceList, HandlePriceSell1, "Static", null); //最新价
if (YHWindowHandle.ToString() != "0")
{
WindowAPI.SetForegroundWindow(YHWindowHandle); //把窗体置于最前
SendKeys.SendWait("{F1}"); //模拟键盘输入F1买入界面
//SendKeys.Send("{F2}"); //模拟键盘输入F2卖出界面
Clipboard.SetText(StockCode);
WindowAPI.SendMessage(HandleStockCodeEdit, WindowsMessage.WM_PASTE, 0, "");
while (true)
{
StringBuilder sbStockName = new StringBuilder();
WindowAPI.SendMessage(HandleStockName, WindowsMessage.WM_GETTEXT, 128, sbStockName);//读取股票名称
if (sbStockName.Length > 0)
{
break;
}
}
if (Price > 0)
{
Clipboard.SetText(Convert.ToString(Price));
WindowAPI.SendMessage(HandlePriceEdit, WindowsMessage.WM_PASTE, 0, "");
}
else
{
WindowAPI.SendMessage(HandlePriceNew, WindowsMessage.WM_LBUTTONDOWN, 0, "");
WindowAPI.SendMessage(HandlePriceNew, WindowsMessage.WM_LBUTTONUP, 0, "");
}
Clipboard.SetText(Convert.ToString(QTY));
WindowAPI.SendMessage(HandleQTYEdit, WindowsMessage.WM_PASTE, 0, "");
WindowAPI.SendMessage(HandleQTYEdit, WindowsMessage.WM_PASTE, 0, "");
//SendMessage(HandleBuyButton, BM_CLICK, 1, "0");
//SendMessage(HandleQTYEdit, WindowsMessage.WM_KEYDOWN, WindowsKeyCode.VK_CONTROL, "");
//SendMessage(HandleQTYEdit, WindowsMessage.WM_CHAR, WindowsKeyCode.VK_B, "");
//SendMessage(HandleQTYEdit, WindowsMessage.WM_KEYUP, WindowsKeyCode.VK_CONTROL, "");
SendKeys.SendWait("^b");
SendKeys.SendWait("{ENTER}"); //确认下单
while (true)
{
IntPtr WindowHandleTipForm = WindowAPI.FindWindowEx(IntPtr.Zero, IntPtr.Zero, "#32770", null);
IntPtr WindowHandleTipFormContent = WindowAPI.FindWindowEx(WindowHandleTipForm, IntPtr.Zero, "Static", null);
IntPtr WindowHandleTipFormTitle = WindowAPI.FindWindowEx(WindowHandleTipForm, WindowHandleTipFormContent, "Static", null);
StringBuilder TipTitle = new StringBuilder();
WindowAPI.SendMessage(WindowHandleTipFormTitle, WindowsMessage.WM_GETTEXT, 10, TipTitle);
if (WindowHandleTipFormTitle.ToInt32() > 0 && "提示".Equals(TipTitle.ToString()))
{
StringBuilder TipContent = new StringBuilder();
WindowAPI.SendMessage(WindowHandleTipFormContent, WindowsMessage.WM_GETTEXT, 1024, TipContent);
Console.WriteLine(TipContent);
WindowAPI.SetForegroundWindow(WindowHandleTipForm); //把窗体置于最前
SendKeys.SendWait("{ENTER}");
break;
}
else if (WindowHandleTipFormTitle.ToInt32() == 0)
{
break;
}
}
return(true);
//SendKeys.SendWait("{ENTER}");//Enter
//SendKeys.Send("^{ENTER}");//Ctrl+Enter
}
else
{
Console.WriteLine("木有找到股票交易窗口");
return(false);
}
}