/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SOSOshop.Model.Order.OrderProductCart model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OrderProductCart set ");
strSql.Append("UID=@UID,");
strSql.Append("Name=@Name,");
strSql.Append("Description=@Description,");
strSql.Append("UpdateTime=GETDATE(),");
strSql.Append("State=@State");
strSql.Append(" where CartId=@CartId ");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "CartId", DbType.Int32, model.CartId);
db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID);
db.AddInParameter(dbCommand, "Name", DbType.AnsiString, model.Name);
db.AddInParameter(dbCommand, "Description", DbType.AnsiString, model.Description);
db.AddInParameter(dbCommand, "State", DbType.Int32, model.State);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据([UID],[Name],[Description])
/// </summary>
public int Add(SOSOshop.Model.Order.OrderProductCart model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("declare @now datetime set @now=GETDATE()\n");
strSql.Append("insert into OrderProductCart(");
strSql.Append("[UID],[Name],[Description],[AddTime],[UpdateTime],[State])");
strSql.Append(" values (");
strSql.Append("@UID,@Name,@Description,@now,@now,@State)");
strSql.Append(";SELECT SCOPE_IDENTITY()");
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID);
db.AddInParameter(dbCommand, "Name", DbType.AnsiString, model.Name);
db.AddInParameter(dbCommand, "Description", DbType.AnsiString, model.Description);
db.AddInParameter(dbCommand, "State", DbType.Int32, model.State);
int id = 0; int.TryParse(Convert.ToString(db.ExecuteScalar(dbCommand)), out id);
return(id);
}
