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