public void Add(string stockCode, IStockBonus data)
{
using (var file = StockBonusFile.CreateOrOpen(stockCode))
{
StockBonusDataItem dataItem = data.Convert();
file.Add(dataItem);
}
}
public void Update(string stockCode, IStockBonus stockBonus)
{
StockBonusRepository repository = new StockBonusRepository(DataFiles.GetStockBonusFile(stockCode));
repository.UpdateRange(new IStockBonus[] { stockBonus });
//using (var context = GetContext(stockCode))
//{
// var repository = new Repository<StockBonus>(context);
// repository.Update(stockBonus.ToDataObject());
// repository.UnitOfWork.Commit();
//}
}
public bool Exists(string stockCode, IStockBonus stockBonus)
{
StockBonusRepository repository = new StockBonusRepository(DataFiles.GetStockBonusFile(stockCode));
return repository.Exists(stockBonus);
//// 设置查询条件
//var spec = Specification<StockBonus>.Eval(p => p.DateOfDeclaration.Equals(stockBonus.DateOfDeclaration));
//using (var context = GetContext(stockCode))
//{
// var repository = new Repository<StockBonus>(context);
// return repository.Exists(spec);
//}
}
private void SaveData(string stockCode, IStockBonus 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 StockBonus[{0}] data error.", stockCode), this.ServiceName);
LogHelper.Logger.WriteLine(ex.ToString(), this.ServiceName);
}
}
public bool Exists(IStockBonus stockBonus)
{
bool bExists = false;
string sql =
string.Format("SELECT * FROM {0} WHERE {1}='{2}'",
tableName,
colDateOfDeclaration,
stockBonus.DateOfDeclaration.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;
}
