private void WriteBack(List <string> list)
{
try
{
LogHandler.Log("开始回写SQLSERVER");
DYJXCEntities db = new DYJXCEntities();
var data = (from d in db.t_HK_PGData
where list.Contains(d.batch_no)
select d).ToList();
data.ForEach(p =>
{
db.t_HK_PGData.Attach(p);
p.IsSync = true;
db.Entry(p).State = System.Data.Entity.EntityState.Modified;
});
db.SaveChanges();
}
catch (Exception ex)
{
LogHandler.Error("回写发生错误：\r\n" + ex.InnerException);
list.ForEach(p =>
{
MySQLWriter db = new MySQLWriter();
db.Delete(p);
});
}
}
private List <t_HK_PGData> Check()
{
LogHandler.Log("检查需要同步的数据");
try
{
DYJXCEntities db = new DYJXCEntities();
var result = db.t_HK_PGData.Where(p => !p.IsSync).ToList();
LogHandler.Log(string.Format("发现待同步数据{0}条", result.Count));
return(result);
}
catch (Exception ex)
{
LogHandler.Error("发生错误：" + ex.InnerException);
}
return(null);
}