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); }