/// <summary>更新一条数据 /// /// </summary> public bool Update(WindowsTWStockDownload.Model.Twstock model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [twstock] set "); strSql.Append("[chDate]=@chDate, [ClosePrice]=@ClosePrice, [UpOrDown]=@UpOrDown, [TradeCount]=@TradeCount, [TradeMoney]=@TradeMoney, [OpenPrice]=@OpenPrice, [HightPrice]=@HightPrice, [LowPrice]=@LowPrice, [StockCode]=@StockCode, [CreateDate]=@CreateDate "); strSql.Append(" where Id=@Id "); using (var connection = ConnectionFactory.GetOpenConnection()) { int i = connection.Execute(strSql.ToString(), model); return(i > 0); } }
/// <summary>得到一个对象实体 /// /// </summary> public WindowsTWStockDownload.Model.Twstock GetModel(Guid Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from [twstock] "); strSql.Append(" where Id=@Id "); WindowsTWStockDownload.Model.Twstock model = null; using (var connection = ConnectionFactory.GetOpenConnection()) { model = connection.Query <WindowsTWStockDownload.Model.Twstock>(strSql.ToString(), new { Id = Id }).SingleOrDefault(); } return(model); }
/// <summary>增加一条数据 /// /// </summary> public int Add(WindowsTWStockDownload.Model.Twstock model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [twstock]("); strSql.Append("[chDate], [ClosePrice], [UpOrDown], [TradeCount], [TradeMoney], [OpenPrice], [HightPrice], [LowPrice], [StockCode], [CreateDate] )"); strSql.Append(" values ("); strSql.Append("@chDate, @ClosePrice, @UpOrDown, @TradeCount, @TradeMoney, @OpenPrice, @HightPrice, @LowPrice, @StockCode, @CreateDate );select @@identity;"); using (var connection = ConnectionFactory.GetOpenConnection()) { int i = connection.Query <int>(strSql.ToString(), model).SingleOrDefault();; return(i); } }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public WindowsTWStockDownload.Model.Twstock GetModelByCond(string cond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from [twstock] "); if (!string.IsNullOrEmpty(cond)) { strSql.Append(" where " + cond); } WindowsTWStockDownload.Model.Twstock model = null; using (var connection = ConnectionFactory.GetOpenConnection()) { model = connection.Query <WindowsTWStockDownload.Model.Twstock>(strSql.ToString()).SingleOrDefault(); } return(model); }