/// <summary>
/// 增加一条数据 返回是否成功
/// </summary>
public bool Add(DSWebService.Model.Data_Centre.Link_Mid model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Link_Mid(");
strSql.Append("id,iden,sum,StockType,PriceType)");
strSql.Append(" values (");
strSql.Append("@id,@iden,@sum,@StockType,@PriceType)");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "id", DbType.Int32, model.id);
db.AddInParameter(dbCommand, "iden", DbType.Int32, model.iden);
db.AddInParameter(dbCommand, "Sum", DbType.Decimal, model.Sum);
db.AddInParameter(dbCommand, "StockType", DbType.Decimal, model.StockType);
db.AddInParameter(dbCommand, "PriceType", DbType.Decimal, model.PriceType);
int x = db.ExecuteNonQuery(dbCommand);
return(x > 0 ? true : false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DSWebService.Model.Data_Centre.Link_Mid model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Link_Mid set ");
strSql.Append("iden=@iden,");
strSql.Append("Sum=@Sum,");
strSql.Append("StockType=@StockType,");
strSql.Append("PriceType=@PriceType,");
strSql.Append("updated=@updated");
strSql.Append(" where id=@id and iden=@iden ");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "id", DbType.Int32, model.id);
db.AddInParameter(dbCommand, "iden", DbType.Int32, model.iden);
db.AddInParameter(dbCommand, "Sum", DbType.Decimal, model.Sum);
db.AddInParameter(dbCommand, "StockType", DbType.Decimal, model.StockType);
db.AddInParameter(dbCommand, "PriceType", DbType.Decimal, model.PriceType);
db.AddInParameter(dbCommand, "updated", DbType.DateTime, model.Updated);
int rows = db.ExecuteNonQuery(dbCommand);
return(rows > 0 ? true : false);
}
