public void Add(IStockProfile data)
{
using (var file = StockProfileFile.CreateOrOpen())
{
StockProfileDataItem dataItem = data.Convert();
file.Add(dataItem);
}
}
public void Update(IStockProfile stockProfile)
{
StockProfileRepository repository = new StockProfileRepository(DataFiles.GetStockProfileFile());
repository.UpdateRange(new IStockProfile[] { stockProfile });
//using (var context = GetContext())
//{
// var repository = new Repository<StockProfile>(context);
// repository.Update(stockProfile.ToDataObject());
// repository.UnitOfWork.Commit();
//}
}
public bool Exists(IStockProfile stockProfile)
{
StockProfileRepository repository = new StockProfileRepository(DataFiles.GetStockProfileFile());
return repository.Exists(stockProfile);
//// 设置查询条件
//var spec = Specification<StockProfile>.Eval(p => p.CodeA.Equals(stockProfile.CodeA));
//using (var context = GetContext())
//{
// var repository = new Repository<StockProfile>(context);
// return repository.Exists(spec);
//}
}
private void SaveData(IStockProfile data)
{
try
{
// 检查是否已经存在记录
if (_saveDataService.Exists(data))
{
// 如果已经存在就更新
_saveDataService.Update(data);
}
else
{
// 不存在就添加
_saveDataService.Add(data);
}
}
catch (Exception ex)
{
LogHelper.Logger.WriteLine(ex.ToString(), this.ServiceName);
}
}
public bool Exists(IStockProfile stockProfile)
{
bool bExists = false;
string sql =
string.Format("SELECT * FROM {0} WHERE {1}='{2}'",
tableName,
colCodeA,
stockProfile.CodeA);
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;
}
