public void Update(string stockCode, IStockStructure stockStructure)
{
StockStructureRepository repository = new StockStructureRepository(DataFiles.GetStockStructureFile(stockCode));
repository.UpdateRange(new IStockStructure[] { stockStructure });
//using (var context = GetContext(stockCode))
//{
// var repository = new Repository<StockStructure>(context);
// repository.Update(stockStructure.ToDataObject());
// repository.UnitOfWork.Commit();
//}
}
public bool Exists(string stockCode, IStockStructure stockStructure)
{
StockStructureRepository repository = new StockStructureRepository(DataFiles.GetStockStructureFile(stockCode));
return repository.Exists(stockStructure);
//// 设置查询条件
//var spec = Specification<StockStructure>.Eval(p => p.DateOfChange.Equals(stockStructure.DateOfChange));
//using (var context = GetContext(stockCode))
//{
// var repository = new Repository<StockStructure>(context);
// return repository.Exists(spec);
//}
}
public bool Exists(IStockStructure stockStructure)
{
bool bExists = false;
string sql =
string.Format("SELECT * FROM {0} WHERE {1}='{2}'",
tableName,
colDateOfChange,
stockStructure.DateOfChange.ToString("yyyy-MM-dd HH:mm:ss"));
using (SqlCeConnection conn = new SqlCeConnection(ConnectionString))
{
conn.Open();
using (SqlCeCommand sqlCmd = new SqlCeCommand(sql, conn))
{
Object o = sqlCmd.ExecuteScalar();
bExists = (o != null);
}
conn.Close();
}
return bExists;
}
private void SaveData(string stockCode, IStockStructure data)
{
try
{
// 检查是否已经存在记录
if (_saveDataService.Exists(stockCode, data))
{
// 如果已经存在就更新
_saveDataService.Update(stockCode, data);
}
else
{
// 不存在就添加
_saveDataService.Add(stockCode, data);
}
}
catch (Exception ex)
{
LogHelper.Logger.WriteLine(string.Format("Save StockStructure[{0}] data error.", stockCode), this.ServiceName);
LogHelper.Logger.WriteLine(ex.ToString(), this.ServiceName);
}
}
