static void Main(string[] args)
{
if (args.Length < 1)
{
return;
}
Console.Title = "正在读取数据，请不要手工关闭...";
string sepChar = ",";
if (args[0].ToLower() == "getdata" && args.Length >= 3)
{
string dataType, code, newFileName;
dataType = args[1];
code = args[2];
newFileName = "";
if (args.Length == 4)
{
newFileName = args[3];
}
FinData.FxjData fxj = new FinData.FxjData();
string[,] x = fxj.GetData(dataType, code, newFileName, 0);
if (fxj.Error == 0)
{
for (int ii = 0; ii < x.GetLength(0); ii++)
{
for (int jj = 0; jj < x.GetLength(1); jj++)
{
Console.Write(x[ii, jj]);
if (jj < x.GetLength(1) - 1)
{
Console.Write(sepChar);
}
}
Console.WriteLine();
}
}
}
else if (args[0].ToLower() == "getfields")
{
string dataType;
dataType = args[1];
FinData.FxjData fxj = new FinData.FxjData();
string[,] x = fxj.GetFields(dataType);
if (fxj.Error == 0)
{
for (int ii = 0; ii < x.GetLength(0); ii++)
{
for (int jj = 0; jj < x.GetLength(1); jj++)
{
Console.Write(x[ii, jj]);
if (jj < x.GetLength(1) - 1)
{
Console.Write(sepChar);
}
}
Console.WriteLine();
}
}
}
else if (args[0].ToLower() == "gettabledef")
{
if (args.Length >= 3)
{
string dataType, descDataType;
dataType = args[1];
descDataType = args[2];
FinData.FxjData fxj = new FinData.FxjData();
if (fxj.Error == 0)
{
string x = fxj.GetTableDef(dataType, descDataType, false);
Console.WriteLine(x);
}
}
}
else if (args[0].ToLower() == "gettables")
{
FinData.FxjData fxj = new FinData.FxjData();
string[,] x = fxj.GetTables();
if (fxj.Error == 0)
{
for (int ii = 0; ii < x.GetLength(0); ii++)
{
for (int jj = 0; jj < x.GetLength(1); jj++)
{
Console.Write(x[ii, jj]);
if (jj < x.GetLength(1) - 1)
{
Console.Write(sepChar);
}
}
Console.WriteLine();
}
}
}
else if (args[0].ToLower() == "getmarkets")
{
FinData.FxjData fxj = new FinData.FxjData();
string[,] x = fxj.GetMarkets();
if (fxj.Error == 0)
{
for (int ii = 0; ii < x.GetLength(0); ii++)
{
for (int jj = 0; jj < x.GetLength(1); jj++)
{
Console.Write(x[ii, jj]);
if (jj < x.GetLength(1) - 1)
{
Console.Write(sepChar);
}
}
Console.WriteLine();
}
}
}
else if (args[0].ToLower() == "getcodetype")
{
if (args.Length >= 2)
{
string code;
code = args[1];
FinData.FxjData fxj = new FinData.FxjData();
if (fxj.Error == 0)
{
string x = fxj.GetCodeType(code);
Console.WriteLine(x);
}
}
}
}
static void Main(string[] args)
{
if (args.Length < 1) return;
Console.Title = "���ڶ�ȡ���ݣ��벻Ҫ�ֹ��ر�...";
string sepChar = ",";
if (args[0].ToLower() == "getdata" && args.Length>=3)
{
string dataType,code,newFileName;
dataType=args[1];
code = args[2];
newFileName = "";
if (args.Length == 4) newFileName = args[3];
FinData.FxjData fxj = new FinData.FxjData();
string[,] x = fxj.GetData(dataType, code, newFileName,0);
if (fxj.Error == 0)
{
for (int ii = 0; ii < x.GetLength(0); ii++)
{
for (int jj = 0; jj < x.GetLength(1); jj++)
{
Console.Write(x[ii, jj]);
if (jj < x.GetLength(1) - 1) Console.Write(sepChar);
}
Console.WriteLine();
}
}
}
else if (args[0].ToLower() == "getfields")
{
string dataType;
dataType = args[1];
FinData.FxjData fxj = new FinData.FxjData();
string[,] x = fxj.GetFields(dataType);
if (fxj.Error == 0)
{
for (int ii = 0; ii < x.GetLength(0); ii++)
{
for (int jj = 0; jj < x.GetLength(1); jj++)
{
Console.Write(x[ii, jj]);
if (jj < x.GetLength(1) - 1) Console.Write(sepChar);
}
Console.WriteLine();
}
}
}
else if (args[0].ToLower() == "gettabledef")
{
if (args.Length >= 3)
{
string dataType, descDataType;
dataType = args[1];
descDataType = args[2];
FinData.FxjData fxj = new FinData.FxjData();
if (fxj.Error == 0)
{
string x = fxj.GetTableDef(dataType, descDataType, false);
Console.WriteLine(x);
}
}
}
else if (args[0].ToLower() == "gettables")
{
FinData.FxjData fxj = new FinData.FxjData();
string[,] x = fxj.GetTables();
if (fxj.Error == 0)
{
for (int ii = 0; ii < x.GetLength(0); ii++)
{
for (int jj = 0; jj < x.GetLength(1); jj++)
{
Console.Write(x[ii, jj]);
if (jj < x.GetLength(1) - 1) Console.Write(sepChar);
}
Console.WriteLine();
}
}
}
else if (args[0].ToLower() == "getmarkets")
{
FinData.FxjData fxj = new FinData.FxjData();
string[,] x = fxj.GetMarkets();
if (fxj.Error == 0)
{
for (int ii = 0; ii < x.GetLength(0); ii++)
{
for (int jj = 0; jj < x.GetLength(1); jj++)
{
Console.Write(x[ii, jj]);
if (jj < x.GetLength(1) - 1) Console.Write(sepChar);
}
Console.WriteLine();
}
}
}
else if (args[0].ToLower() == "getcodetype")
{
if (args.Length >= 2)
{
string code;
code = args[1];
FinData.FxjData fxj = new FinData.FxjData();
if (fxj.Error == 0)
{
string x = fxj.GetCodeType(code);
Console.WriteLine(x);
}
}
}
}
private int InsertStockDataToSQLDb(string dataType, string CodeStr, string[,] CodeList, int iRecordCount)
{
//cmd.ExecuteNonQuery();
string[,] dataArray;
string SqlStr = string.Empty;
FinData.FxjData fxj = new FinData.FxjData();
if (CodeStr != "")
{
CodeList[0, 0] = CodeStr;
}
try
{
for (int j=0;j < CodeList.GetLength(1);j++)
{
dataArray = fxj.GetData(dataType, CodeList[0,j],iRecordCount);
if (fxj.Error == 0 && dataArray.GetLength(0) > 0)
{
string[,] colname = fxj.GetFields(dataType);
try
{
SqlConnection con = new SqlConnection(ConStr);
con.Open();
//删除临时表中的原来记录
SqlStr = "Delete T_PRP_StockDataTemp From T_PRP_StockdataTemp";
SqlCommand cmd = new SqlCommand(SqlStr, con);
cmd.ExecuteNonQuery();
//向临时表添加数据
for (int i = 0; i < dataArray.GetLength(0); i++)
{
SqlStr = "Insert Into T_PRP_StockDataTemp(FCode,FDateTime,FOpen,FHigh,FLow,FClose,FVolume,FAmount) values('" +
dataArray[i, 0] + "','" + dataArray[i, 1] + "','" + dataArray[i, 2] + "','" + dataArray[i, 3] + "','"
+ dataArray[i, 4] + "','" + dataArray[i, 5] + "','" + dataArray[i, 6] + "','" + dataArray[i, 7] + "')";
cmd.CommandText = SqlStr;
cmd.ExecuteNonQuery();
}
//从临时表向正式表添加不重复的记录
SqlStr = "Insert Into T_PRP_StockData(FCode,FDateTime,FOpen,FHigh,FLow,FClose,FVolume,FAmount)" +
"Select Distinct FCode,FDateTime,FOpen,FHigh,FLow,FClose,FVolume,FAmount From T_PRP_StockDataTemp " +
"Where not exists(Select * From T_PRP_StockData Where (FDateTime=T_PRP_StockDataTemp.FDateTime And FCode=T_PRP_StockDataTemp.FCode))";
cmd.CommandText = SqlStr;
cmd.ExecuteNonQuery();
if (CodeStr != "")
{
con.Close();
return 0;
}
}
catch
{
//向SQl Server数据库添加数据失败！
MessageBox.Show("向SQl Server数据库添加数据失败！");
return 1;
}
}
else
{
//没有数据或发生错误
//return 2;
}
}
}
catch //(Exception ex)
{
//MessageBox.Show(ex.Message);
return 3;
}
return 0;
}
