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 <string> DataSync(List <t_HK_PGData> list)
{
List <string> result = new List <string>();
MySQLWriter db = new MySQLWriter();
int count = 0;
list.ForEach(p =>
{
var row = db.Insert(p);
if (row > 0)
{
count += row;
result.Add(p.batch_no);
}
});
LogHandler.Log(string.Format("本次共同步{0}条数据", count));
return(result);
}
