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