public string UpdateAllGLNumbers(DateTime EndT) { JRGCDBClass jgdb = new JRGCDBClass(); string sql = string.Format("select * from SectorTable where LastModifyDate<'{0}'", EndT.ToShortDateString()); DataSet ds = jgdb.GetDataSet(sql); if (ds == null) { jgdb.Close(); return("无法从本地数据库中获取到概念数据!"); } DataTable dt = ds.Tables[0]; List <GLThreadProcess> threadpool = new List <GLThreadProcess>(); List <MultiTask> datas = new List <MultiTask>(); foreach (DataRow dr in dt.Rows) { datas.Add(new GLTask(dr, 1)); } for (int i = 0; i < 10; i++)//遍历所有概念 dt.Rows.Count { GLThreadProcess glthrdp = new GLThreadProcess(jgdb, EndT); glthrdp.FillPool(datas); threadpool.Add(glthrdp); Thread trd = new Thread(new ThreadStart(glthrdp.Execute)); glthrdp.Trdobj = trd; trd.Start(); } CheckPin = threadpool; return(null); }
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); }