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