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; }