public static void LoadMarker()
{
IDBHelper dBHelper = new DBHelperMySQL("", Program.Settings.DNALims);
string marker = "select locus_type,locus_name,national_locus_name,alias,ord from locus_info order by locus_type, ord";
DataTable dtMarker = dBHelper.getDataTable(marker);
if (dtMarker != null && dtMarker.Rows.Count > 0)
{
Marker = dtMarker;
}
dBHelper.closeConn();
}
private static void DBSync(int minId, int maxId)
{
IDBHelper dBHelper = new DBHelperMySQL("", Program.Settings.DNALims);
try
{
string sql = $"SELECT * from comparedatatask where id BETWEEN {minId} and {maxId} and ex8=0 and `type`=0 order by updatetime desc,`level`";
var dtGene = dBHelper.getDataTable(sql);
if (dtGene != null && dtGene.Rows.Count > 0)
{
for (int i = 0; i < dtGene.Rows.Count; i++)
{
var status = Convert.ToInt32(dtGene.Rows[i]["status"]);
var id = dtGene.Rows[i]["id"].ToString();
var geneIndexid = dtGene.Rows[i]["geneindexid"].ToString();
var server = dtGene.Rows[i]["server"].ToString();
if (status == 1)
{
Console.WriteLine($"接收到删除数据 compare:{id} {DateTime.Now}");
DeleteGeno(dBHelper, id, geneIndexid, server);
}
else if (status == 0 || status == 2)
{
Console.WriteLine($"接收到新增数据 compare:{id} {DateTime.Now}");
AddGeno(dBHelper, id, geneIndexid, server);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dBHelper.closeConn();
}
}
