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