private void button2_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
WSSProcess wssp = new WSSProcess();
WindAPI w = new WindAPI();
w.start();
DataTable dt = wssp.getRecods(w, textBox1.Text, textBox2.Text);
this.dataGridView1.DataSource = dt;
this.dataGridView1.Show();
this.Cursor = Cursors.Default;
}
public string UpdateAllGLList(DateTime EndT)
{
JRGCDBClass jgdb = new JRGCDBClass();
DataTable dt = getRecords(null, EndT);
string sql = "select * from SectorTable";
DataSet ds = jgdb.GetDataSet(sql);
if (ds == null)
{
jgdb.Close();
return("无法从本地数据库中获取到概念数据！");
}
DataTable dbdt = ds.Tables[0];
string[] seccodes = new string[dbdt.Rows.Count];
for (int i = 0; i < dbdt.Rows.Count; i++)
{
seccodes[i] = dbdt.Rows[i]["SectorCode"].ToString();
}
string strSecCodes = string.Join("','", seccodes);
string Filtersql = string.Format("wind_code not in ('{0}')", strSecCodes);
DataRow[] drs;
if (strSecCodes.Length == 0)
{
drs = dt.Select();
}
else
{
drs = dt.Select(Filtersql);
}
if (drs.Length == 0)
{
return(null);
}
List <string> sectorList = new List <string>();
for (int i = 0; i < drs.Length; i++)
{
sectorList.Add(drs[i]["wind_code"].ToString());
}
strSecCodes = string.Join(",", sectorList.ToArray());
WSSProcess wss = new WSSProcess();
dt = wss.getRecods(strSecCodes, "windcode,sec_name,launchdate");
if (dt == null || dt.Rows.Count == 0)
{
jgdb.Close();
return("无法从万得数据库中获取到概念其它信息！");
}
DataTable InsertTable = dbdt.Copy();
InsertTable.Rows.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = InsertTable.NewRow();
dr["SectorCode"] = dt.Rows[i]["WINDCODE"];
dr["SectorName"] = dt.Rows[i]["SEC_NAME"];
dr["SectorCreateDate"] = dt.Rows[i]["LAUNCHDATE"];
dr["LastModifyDate"] = dt.Rows[i]["LAUNCHDATE"];
dr["HQModifyDate"] = dt.Rows[i]["LAUNCHDATE"];
InsertTable.Rows.Add(dr);
}
Int64 ret = jgdb.Save(InsertTable, sql);
jgdb.Close();
//if (InsertTable.Rows.Count != ret) return string.Format("计划保存{0}条数据，实际保存{1}条数据！", InsertTable.Rows.Count , ret);
return(null);
}
