public long InsertOrder(OrderEntity entity)
{
var dbCommand = DB.GetStoredProcCommand("spA_Order_i");
AddInParameter(dbCommand, entity, false);
DB.AddOutParameter(dbCommand, "@OrderId", DbType.Int64, 8);
DB.ExecuteNonQuery(dbCommand);
entity.OrderId = DbHelper.ConvertTo<long>(DB.GetParameterValue(dbCommand, "@OrderId"));
return entity.OrderId;
}
protected void AddInParameter(DbCommand command, OrderEntity entity, bool containsPrimaryKey)
{
DB.AddInParameter(command, "@UserId", DbType.Int64, entity.UserId);
DB.AddInParameter(command, "@Name", DbType.String, entity.Name);
DB.AddInParameter(command, "@Price", DbType.Decimal, entity.Price);
DB.AddInParameter(command, "@ProductId", DbType.Int64, entity.ProductId);
DB.AddInParameter(command, "@CreateTime", DbType.DateTime, entity.CreateTime);
DB.AddInParameter(command, "@UpdateTime", DbType.DateTime, entity.UpdateTime);
if (containsPrimaryKey)
{
DB.AddInParameter(command, "@OrderId", DbType.Int64, entity.OrderId);
}
}
public void DeleteOrder(OrderEntity entity)
{
var command = DB.GetStoredProcCommand("spA_Order_d");
DB.AddInParameter(command, "@OrderId", DbType.Int64, entity.OrderId);
DB.ExecuteNonQuery(command);
}
public bool UpdateOrder(OrderEntity entity)
{
var dbCommand = DB.GetStoredProcCommand("spA_Order_u");
AddInParameter(dbCommand, entity, true);
return DbHelper.ConvertTo<int>(DB.ExecuteScalar(dbCommand)) == 0;
}
public void DeleteOrder(OrderEntity entity)
{
orderInsertDB.DeleteOrder(entity);
}
public bool UpdateOrder(OrderEntity entity)
{
return orderInsertDB.UpdateOrder(entity);
}
public long AddOrder(OrderEntity entity)
{
return orderInsertDB.InsertOrder(entity);
}
